IDMC ETL Developer: CDI/CAI, Azure Synapse Expert

MACHINE LEARNING TECHNOLOGIES LLC; Santa Ana (CA); On-site; USD 84,000 - 120,000; Full time

Job summary

Machine Learning Technologies LLC is seeking an ETL Developer with strong IDMC/IICS experience in Santa Ana, CA. Role focuses on CDI/CAI, Azure Synapse, and data warehouse solutions for enterprise reporting and operations.

You will design and optimize ETL/ELT pipelines, build mappings, and integrate REST APIs, while collaborating with business and reporting teams to deliver robust data solutions.

Qualifications

• Hands-on experience with Informatica IDMC/IICS CDI and CAI.
• Experience with Azure Synapse Analytics and performance tuning.
• Advanced SQL skills and complex joins, window functions, and stored procedures.
• Experience with REST APIs, JSON/XML, OAuth 2.0 and error handling.
• Strong understanding of data warehousing, dimensional modeling, and ETL/ELT design.
• Experience integrating relational databases, cloud storage, and enterprise applications.
• Ability to troubleshoot production issues and communicate with technical and business teams.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Informatica CDI.
• Build mappings, tasks, and job flows for full and incremental loads.
• Develop CAI processes, service connectors, and REST API integrations.
• Develop and optimize Azure Synapse SQL queries and data loads.
• Implement data warehouse solutions including fact/dimensions and SCDs.
• Perform source-to-target mapping, data quality checks, and validation.
• Troubleshoot production issues and resolve data discrepancies.
• Collaborate with analysts and teams to translate requirements into solutions.
• Maintain technical docs, test plans, and deployment instructions.

Skills

Informatica IDMC/IICS

Azure Synapse Analytics

Advanced SQL

REST APIs

ETL/ELT design

Data warehousing concepts

Relational databases

Tools

Informatica CDI/CAI

Azure Synapse

Cloud Data Integration (CDI)

CAI

Job description

Machine Learning Technologies LLC is seeking an ETL Developer with strong IDMC/IICS experience in Santa Ana, CA. Role focuses on CDI/CAI, Azure Synapse, and data warehouse solutions for enterprise reporting and operations.

You will design and optimize ETL/ELT pipelines, build mappings, and integrate REST APIs, while collaborating with business and reporting teams to deliver robust data solutions.