What are the responsibilities and job description for the Informatica IICS ETL Developer position at Randstad Digital?
Job Description:
Individual should be able to demonstrate technical and analytical skill in developing complex ETL workflows using Informatica Powercenter. Create data mapping to ingest data from disparate data sources ranging from flat files to RDMS, Hive or REST APIs.
Responsible for developing Unix scripting. Proficiency in MuleSoft tools desired. Must be able to work independently with minimum supervision. Responsible to develop test cases and perform unit testing. Must be able to interact and co-ordinate with distributed team.
Must have good communication skills. Responsible to provide regular task status update to the management. Mandatory skills: Technically strong in Informatica Power center.
Technically strong in performance tuning of targets, sources, mappings and SQL queries. Conceptually good in PL/SQL, Functions, and writing complex SQLs, and creating and exposing views/materialized views. Strong in UNIX commands and Scripting. Good in MuleSoft Integration. Desired skills: Source control repository - SVN/BitBucket, Continuous Build integration tools (IBM UBuild/Jenkins, IBM UDeploy/Ansible).
Expert in PL/SQL programming and Database design, with strong data analysis skills
location: Plano, Texas
job type: Contract
salary: $54.00 - 64.62 per hour
work hours: 9am to 5pm
education: Bachelors
responsibilities:
Individual should be able to demonstrate technical and analytical skill in developing complex ETL workflows using Informatica Powercenter. Create data mapping to ingest data from disparate data sources ranging from flat files to RDMS, Hive or REST APIs.
Responsible for developing Unix scripting. Proficiency in MuleSoft tools desired. Must be able to work independently with minimum supervision. Responsible to develop test cases and perform unit testing. Must be able to interact and co-ordinate with distributed team.
qualifications:
Requirements:
Self-managed and proactive communicator
Unix scripts
Autosys
Informatica for ETL
Previous experience of working in a data warehouse project is a plus
Python programming
Tableau/reporting experience
Experience in working with Mulesoft and other API technologies.
Source control repository - SVN/BitBucket, Continuous Build integration tools (IBM UBuild/Jenkins, IBM UDeploy/Ansible)
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
Salary : $54