IDMC ETL Developer - CDI/CAI & Azure Synapse

Valiant Technologies LLC; Santa Ana (CA); On-site; USD 96,000 - 138,000; Full time

Job summary

Valiant Technologies LLC in Santa Ana, CA is seeking an ETL Developer with Informatica IDMC/ IICS experience to design and support cloud data integration for insurance domain. The role focuses on CDI and CAI development, Azure Synapse analytics, and building robust data pipelines, with emphasis on data quality and production support.

Responsibilities include creating mappings, REST API integrations, optimizing queries, and collaborating with analysts and reporting teams to deliver enterprise

Qualifications

• Hands-on experience developing integrations using Informatica IDMC/IICS with CDI and CAI.
• Strong experience with Azure Synapse Analytics, including dedicated SQL pools and performance tuning.
• Advanced SQL skills: complex joins, window functions, stored procedures.
• Experience with REST APIs, JSON/XML, OAuth 2.0, pagination, retries, and error handling.
• Understanding of data warehousing, dimensional modeling, and ETL/ELT design.
• Experience integrating relational databases, cloud storage, flat files, and enterprise applications.
• Ability to investigate production issues independently and communicate with technical and business teams.

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

IDMC CDI CAI

Azure Synapse

Advanced SQL

REST APIs

Data warehousing

Relational databases

ETL/ELT design

Tools

Azure Synapse Analytics

REST API tooling

Job description

Valiant Technologies LLC in Santa Ana, CA is seeking an ETL Developer with Informatica IDMC/ IICS experience to design and support cloud data integration for insurance domain. The role focuses on CDI and CAI development, Azure Synapse analytics, and building robust data pipelines, with emphasis on data quality and production support.

Responsibilities include creating mappings, REST API integrations, optimizing queries, and collaborating with analysts and reporting teams to deliver enterprise