ETL Developer

MACHINE LEARNING TECHNOLOGIES LLC; Santa Ana (CA); On-site; USD 79,000 - 107,000; Full time

Job summary

MACHINE LEARNING TECHNOLOGIES LLC in Santa Ana, CA is seeking an ETL Developer with deep expertise in Informatica IDMC/IICS (CDI and CAI) and Azure Synapse Analytics to design and support data pipelines, integration workflows, and data warehouses for enterprise reporting and operations.

You will build and optimize mappings, REST API integrations, and server-side SQL, troubleshoot production issues, and collaborate with analysts and application teams to deliver reliable data solutions for

Qualifications

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

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Informatica CDI for data from databases, apps, 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 auth and orchestration.
• Optimize Azure Synapse SQL queries, stored procedures, and data loading.
• Implement data warehouse models with facts, dims, and slowly changing dimensions.
• Perform source-to-target mapping, data validation, and quality checks.
• Troubleshoot production failures and resolve data discrepancies.
• Collaborate with analysts and reporting teams to translate requirements into solutions.
• Maintain documentation, test plans, and deployment procedures.

Skills

Informatica IDMC/IICS

CDI

CAI

Azure Synapse Analytics

SQL

REST APIs

JSON/XML

OAuth 2.0

Data Warehousing

ETL/ELT design

Tools

Azure Data Factory

Job description

Job Description

• Job ID: J54900
• Job Title: ETL Developer
• Location: Santa Ana, CA
• Duration: 6 Months + Extension
• Domain Exposure: Government
• Client: To Be Discussed Later
• Employment Type: W-2, 1099, C2C
• Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other
• Bill Rate: $68/hour (C2C)

Job Summary

We are seeking an ETL Developer with strong experience in Informatica Intelligent Data Management Cloud (IDMC/IICS), including Cloud Data Integration (CDI) and Cloud Application Integration (CAI), along with Azure Synapse Analytics. This role will develop and support data pipelines, application integrations, and data warehouse solutions for enterprise reporting and business operations.

Qualifications

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

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.

Equal Opportunity Employer

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.