Senior IDMC & Snowflake ETL Engineer

Programmers.io; New Jersey; On-site; USD 110,000 - 160,000; Full time

Job summary

Programmers.io is seeking a Senior ETL Developer to design, develop, test, and deploy IDMC-based ETL solutions across QA and production environments. The role emphasizes strong SQL skills, data modeling, and adherence to ETL/ELT best practices.

The candidate will build mappings and task flows in Informatica Cloud Data Integration, document mappings, and collaborate across teams. Experience with SDLC/Agile and familiarity with SAP or Workday integrations is a plus.

Qualifications

• 8+ years of experience with Informatica, including IDMC.
• Strong ETL/ELT experience with Informatica and IDMC as primary tools.
• Solid SQL and database design knowledge.
• Experience with SDLC and Agile methodologies.

Responsibilities

• Design, develop, test and deploy ETL/IDMC solutions across QA and production.
• Develop ETL mappings, tasks, schedules, and parameter files in IDMC.
• Ensure adherence to ETL/ELT best practices and maintain documentation.
• Perform unit testing, integration testing, and user acceptance support.
• Handle tickets and collaborate with cross-functional teams using Jira and ServiceNow.
• Transition to support team and provide knowledge transfer.

Skills

Informatica

SQL

ETL/ELT best practices

SDLC & Agile

Tools

Informatica Cloud Data Integration

IDMC

Jira

ServiceNow

SAP

Workday

Job description

Programmers.io is seeking a Senior ETL Developer to design, develop, test, and deploy IDMC-based ETL solutions across QA and production environments. The role emphasizes strong SQL skills, data modeling, and adherence to ETL/ELT best practices.

The candidate will build mappings and task flows in Informatica Cloud Data Integration, document mappings, and collaborate across teams. Experience with SDLC/Agile and familiarity with SAP or Workday integrations is a plus.