Informatica IDMC Consultant

Programmers.io; Jersey City (NJ); On-site; USD 110,000 - 150,000; Full time

Job summary

Programmers.io in Jersey City, NJ seeks a Sr. ETL Developer to design, develop, test, and deploy ETL solutions in QA and production environments. Responsibilities include requirement analysis, coding, integration testing, and UAT support, with transition to the support team.

The role emphasizes Informatica Cloud Data Integration, IDMC, SAP/Workday exposure, and strong SQL/database design skills, along with Jira/ServiceNow ticket handling and SDLC/Agile practices.

Qualifications

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

Responsibilities

• Develop ETL processes using Informatica Cloud Data Integration, including 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.

Skills

Informatica IDMC

ETL/ELT best practices

SQL proficiency

SDLC & Agile

Communication skills

Root cause analysis

Jira & ServiceNow

Data integration

Tools

Informatica Cloud Data Integration

SAP

Workday

Jira

ServiceNow

Job description

Location - Jersey City, NJ ( 3 Days WFO)

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

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.