Informatica IDMC Consultant

Programmers.io; Jersey (AR); On-site; USD 100,000 - 140,000; Full time

Job summary

Programmers.io is seeking a Sr. ETL Developer to design, develop, test and deploy ETL solutions using Informatica Cloud Data Integration and IDMC in QA and production.

The role emphasizes adherence to ETL/ELT best practices, strong SQL and database design skills, and seamless collaboration with the SDLC and Agile teams. You will implement mappings, tasks, schedules, and parameter files, ensuring documentation and best practices.

Qualifications

• 8+ years of experience in Informatica with at least 2 years in IDMC.
• Strong experience in ETL and ELT best practices.
• Proficient in database designs and SQL.
• Knowledge of SDLC and Agile methodologies.
• Nice-to-have SAP and Workday integration experience.

Responsibilities

• Requirement analysis and design for ETL solutions.
• Code and unit testing of ETL mappings and workflows.
• Integration Testing and User Acceptance Testing support.
• Hyper care support and transition to the support team.

Skills

Informatica

IDMC

ETL

SQL

Database design

Tools

Informatica Cloud Data Integration

Job description

Required Skills:

8+ years of experience in Informatica, with at least 2 years of experience in IDMC. Strong experience in ETL tools, particularly IDMC as the primary tool and Informatica as secondary. Good understanding of ETL and ELT best practices. Proficient in database designs and SQL.

Sr. ETL Developer.

Design, develop, test and deploy the code in the QA and production environment as per the requirement.

1. Requirement analysis and design
2. Coding and unit testing
3. Integration Testing
4. User acceptance testing support
5. Hyper care support
6. Transition to support team

Key Responsibilities:

Develop ETL processes using Informatica Cloud Data Integration, including constructing mappings, tasks, task flows, schedules, and parameter files. Ensure adherence to ETL and ELT best practices and maintain ETL mapping documentation. Understand and apply database designs and SQL effectively. Familiarize with SDLC and Agile methodologies to enhance project delivery. Good to have experience in SAP and Workday integration Utilize strong problem-solving and analytical skills to conduct root-cause analysis. Communicate effectively in both verbal and written forms to all organizational levels. Collaborate with team members and maintain strong interpersonal relationships. Demonstrate dedication to quality work with strong organizational skills and attention to detail.

Handle support activities, including ticket creation and resolution using Jira and ServiceNow.