ETL Engineer - IDMC, CAI & Azure Synapse

Solugenix; Santa Ana (CA); Vor Ort; USD 140.000 - 150.000; Vollzeit

Zusammenfassung

Solugenix is seeking an ETL Developer to design, develop, and maintain data pipelines and data warehouse solutions using Informatica CDI, CAI, and Azure Synapse Analytics. You will integrate data from databases, enterprise apps, and APIs to support enterprise reporting and operations.

The role requires strong SQL skills, experience with IDMC/IICS, and ability to troubleshoot production issues while collaborating with business and technical teams.

Qualifikationen

• Hands-on experience developing integrations using Informatica IDMC/IICS, CDI and CAI.
• Strong experience with Azure Synapse Analytics, including dedicated SQL pools and performance tuning.
• Advanced SQL skills including complex joins, window functions, stored procedures, and troubleshooting.
• Experience with REST APIs, JSON/XML, OAuth 2.0, pagination, retries, and exception handling.

Aufgaben

• Design, develop, and maintain ETL/ELT pipelines using Informatica CDI for data integration from databases, applications, APIs, and files.
• Build mappings, mapping tasks, reusable components, and taskflows for full and incremental loads.
• Develop CAI processes, service connectors, and REST API integrations with authentication, orchestration, error handling, and monitoring.

Kenntnisse

Advanced SQL

ETL/ELT design

Data warehousing

Communication

Problem solving

Tools

Informatica IDMC/IICS

Azure Synapse Analytics

SQL

REST APIs

Jobbeschreibung

Solugenix is seeking an ETL Developer to design, develop, and maintain data pipelines and data warehouse solutions using Informatica CDI, CAI, and Azure Synapse Analytics. You will integrate data from databases, enterprise apps, and APIs to support enterprise reporting and operations.

The role requires strong SQL skills, experience with IDMC/IICS, and ability to troubleshoot production issues while collaborating with business and technical teams.