ETL Developer: IDMC/IICS CDI/CAI + Azure Synapse

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

Job summary

Robotics Technologies LLC seeks an ETL Developer with Informatica Intelligent Data Management Cloud (IDMC/IICS) to design and support data pipelines, CAI processes, and Azure Synapse analytics for enterprise reporting and operations.

The role emphasizes CDI/CAI development, modern data integration techniques, and collaboration with analysts and IT teams to deliver robust data solutions in a fast-paced environment.

Qualifications

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

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Informatica CDI for data from databases, ERP systems, APIs, and files.
• Build mappings, mapping tasks, and reusable components for full and incremental loads.
• Develop CAI processes, service connectors, and REST API integrations with authentication and monitoring.
• Develop and optimize Azure Synapse SQL queries, stored procedures, and data loading processes.
• Implement data warehouse solutions with fact and dimension tables, slowly changing dimensions, and deduplication.
• 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 and reporting teams to translate requirements into solutions.
• Maintain documentation, test plans, deployment instructions, and operational procedures.

Skills

Informatica IDMC/IICS CDI CAI

Azure Synapse Analytics

SQL

REST APIs

Data warehousing

Dimensional modeling

ETL/ELT design

Data integration

Job description

Robotics Technologies LLC seeks an ETL Developer with Informatica Intelligent Data Management Cloud (IDMC/IICS) to design and support data pipelines, CAI processes, and Azure Synapse analytics for enterprise reporting and operations.

The role emphasizes CDI/CAI development, modern data integration techniques, and collaboration with analysts and IT teams to deliver robust data solutions in a fast-paced environment.