IDMC ETL Engineer - CDI/CAI & Azure Synapse

Machine Learning Technologies, LLC; Santa Ana (CA); On-site; USD 84,000 - 120,000; Full time

Job summary

Machine Learning Technologies, LLC in Santa Ana, CA seeks an ETL Developer with strong Informatica IDMC/IICS experience, including CDI and CAI, plus Azure Synapse analytics. You will design and maintain ETL/ELT pipelines and data warehouses for enterprise reporting and operations.

Responsibilities include building mappings, CAI processes, and REST API integrations, optimizing SQL queries, and ensuring data quality.

Qualifications

• Hands-on experience with Informatica IDMC/IICS CDI/CAI implementations.
• Strong Azure Synapse Analytics experience, including dedicated SQL pools and performance tuning.
• Advanced SQL skills with joins, window functions, procedures, and debugging.
• Experience with REST APIs, JSON/XML, OAuth 2.0, pagination, retries, and error handling.
• Solid understanding of data warehousing, dimensional modeling, and ETL/ELT design.
• Experience integrating relational DBs, cloud storage, files, and enterprise apps.
• Ability to troubleshoot production issues and clearly communicate with teams.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Informatica CDI to integrate diverse data sources.
• Build mappings, tasks, reusable components, and workflows for full and incremental loads.
• Develop CAI processes, connectors, and REST API integrations with authentication and monitoring.
• Optimize Azure Synapse SQL queries, stored procedures, and data loading processes.
• Implement data warehouse structures with facts/dimensions and slowly changing dimensions.
• Perform source-to-target mapping, data validation, reconciliation, and quality checks.
• Troubleshoot production issues, resolve data discrepancies, and improve performance.
• Collaborate with analysts, application teams, and reporting teams to translate requirements.
• Maintain technical docs, test plans, deployment instructions, and support procedures.

Skills

Informatica IDMC/IICS

Azure Synapse Analytics

Advanced SQL

REST APIs & JSON/XML

Data warehousing concepts

Tools

Informatica CDI

Informatica CAI

Azure Synapse SQL Pools

Job description

Machine Learning Technologies, LLC in Santa Ana, CA seeks an ETL Developer with strong Informatica IDMC/IICS experience, including CDI and CAI, plus Azure Synapse analytics. You will design and maintain ETL/ELT pipelines and data warehouses for enterprise reporting and operations.

Responsibilities include building mappings, CAI processes, and REST API integrations, optimizing SQL queries, and ensuring data quality.