ETL Developer

Intent Design Pvt. Ltd.; Santa Ana (CA); On-site; USD 110,000 - 140,000; Full time

Job summary

Intent Design Pvt. Ltd. is seeking an ETL Developer to design, develop, and maintain data integration solutions using Informatica CDI/CAI and Azure Synapse.

You will build mappings, CAI processes, and REST API integrations while optimizing queries and maintaining data quality. The role requires strong SQL skills, experience with data warehousing, and collaboration with analysts and other teams to translate requirements into scalable technical solutions.

Qualifications

• Hands-on ETL/ELT development experience with Informatica CDI and CAI.
• Strong Azure Synapse Analytics and performance tuning skills.
• Expertise in data warehousing, dimensional modeling and incremental loading.

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

Informatica CDI/CAI

Informatica IDMC/IICS

Azure Synapse

Advanced SQL

REST APIs

Data warehousing

Job description

Job Title: ETL Developer [Job Code: 261145]

Job Description

• 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.

Minimum Requirements

• Hands-on experience developing integrations using Informatica IDMC/IICS, with strong expertise in both CDI and CAI.
• Strong experience with Azure Synapse Analytics, particularly dedicated SQL pools, distributed tables and query 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.
• 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.

Work Location: Santa Ana, CA