IDMC ETL Developer: CDI/CAI + Azure Synapse

Artifintech; Santa Ana (CA); On-site; USD 87,000 - 117,000; Full time

Job summary

Artifintech is seeking an ETL Developer with strong Informatica IDMC/IICS expertise to design and support data pipelines for enterprise reporting and operations. The role covers CDI/CAI, Azure Synapse integration, and data warehouse development in a cloud-first environment.

The incumbent will build and optimize ETL/ELT pipelines, implement data quality checks, and collaborate with analytics, application, and reporting teams to translate requirements into robust technical solutions.

Qualifications

• Hands-on experience developing integrations using Informatica IDMC/IICS, with CDI and CAI.
• Advanced SQL skills and query performance tuning in Azure Synapse.
• Experience with REST APIs, JSON/XML, OAuth 2.0, pagination, retries, and exception handling.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Informatica CDI to integrate data from databases, enterprise applications, APIs, and files.
• Build mappings, mapping tasks, reusable components, and taskflows for full and incremental data loads.
• Develop CAI processes, service connectors, and REST API integrations, including authentication, orchestration, error handling, and monitoring.
• Develop and optimize Azure Synapse SQL queries, stored procedures, and data loading processes.
• Implement data warehouse solutions, including fact and dimension tables, slowly changing dimensions, deduplication, and deletion handling.
• Perform source-to-target mapping, data validation, reconciliation, and data quality checks.
• Troubleshoot production failures, resolve data discrepancies, and improve integration performance.
• Collaborate with business analysts, application teams, and reporting teams to translate requirements into technical solutions.
• Maintain technical documentation, test plans, deployment instructions, and operational support procedures.

Skills

ETL/ELT design

SQL scripting

REST API integration

JSON/XML handling

Informatica CDI/IDMC

Tools

Informatica IDMC/IICS

Informatica CAI

Azure Synapse Analytics

Job description

Artifintech is seeking an ETL Developer with strong Informatica IDMC/IICS expertise to design and support data pipelines for enterprise reporting and operations. The role covers CDI/CAI, Azure Synapse integration, and data warehouse development in a cloud-first environment.

The incumbent will build and optimize ETL/ELT pipelines, implement data quality checks, and collaborate with analytics, application, and reporting teams to translate requirements into robust technical solutions.