ETL Developer: IDMC/CDI & Azure Synapse

Valiant Technologies LLC

Santa Ana (CA)

On-site

USD 77,000 - 110,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Valiant Technologies LLC in Santa Ana, CA is seeking an ETL Developer skilled in Informatica IDMC/IICS CDI and CAI, plus Azure Synapse Analytics. You will design, develop, and support data pipelines, and integrate data from databases, applications, APIs, and files for enterprise reporting.

The role emphasizes building scalable mappings, CAI service connectors, and optimized SQL queries; you will collaborate with business analysts and reporting teams to deliver reliable data warehousing solutions

Qualifications

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

Responsibilities

  • Design and maintain ETL/ELT pipelines using Informatica CDI.
  • Build mappings and tasks for full and incremental loads.
  • Develop CAI processes and REST API integrations with auth and monitoring.
  • Optimize Azure Synapse SQL queries and data loading.
  • Implement data warehouse structures with facts, dimensions, and SCD.
  • Perform source-to-target mapping and data quality checks.
  • Troubleshoot production issues and resolve data discrepancies.
  • Collaborate with analysts and reporting teams to translate requirements.
  • Maintain documentation and deployment procedures.

Skills

IDMC/IICS
Azure Synapse
SQL
REST APIs
JSON/XML
OAuth 2.0
ETL/ELT design
Data warehousing
Incremental loading
Data quality

Tools

Informatica CDI
Azure Synapse Analytics

Job description

Valiant Technologies LLC in Santa Ana, CA is seeking an ETL Developer skilled in Informatica IDMC/IICS CDI and CAI, plus Azure Synapse Analytics. You will design, develop, and support data pipelines, and integrate data from databases, applications, APIs, and files for enterprise reporting.

The role emphasizes building scalable mappings, CAI service connectors, and optimized SQL queries; you will collaborate with business analysts and reporting teams to deliver reliable data warehousing solutions

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

IDMC ETL Developer - CDI/CAI & Azure Synapse
IDMC ETL Developer - CDI/CAI & Azure Synapse

Valiant Technologies LLC • Santa Ana (CA)

On-site
USD 96,000 - 138,000
ETL Developer: IDMC/Azure Synapse Data Pipelines
ETL Developer: IDMC/Azure Synapse Data Pipelines

MACHINE LEARNING TECHNOLOGIES LLC • Santa Ana (CA)

On-site
USD 79,000 - 107,000
ETL Developer — Informatica IDMC + Azure Synapse
ETL Developer — Informatica IDMC + Azure Synapse

Ethereum Technologies • Santa Ana (CA)

On-site
USD 84,000 - 120,000
IDMC/CAI ETL Developer with Azure Synapse
IDMC/CAI ETL Developer with Azure Synapse

Quantum Technologies LLC • Santa Ana (CA)

On-site
USD 77,000 - 110,000
ETL Engineer - IDMC, CAI & Azure Synapse
ETL Engineer - IDMC, CAI & Azure Synapse

Solugenix • Santa Ana (CA)

On-site
USD 140,000 - 150,000
Senior ETL Engineer: Informatica IDMC + Azure Synapse
Senior ETL Engineer: Informatica IDMC + Azure Synapse

Quantum Technologies. LLC • Santa Ana (CA)

On-site
USD 84,000 - 120,000
ETL Developer
ETL Developer

Intent Design Pvt Ltd • Santa Ana (CA)

On-site
USD 110,000 - 140,000
ETL/ELT Data Integration Engineer
ETL/ELT Data Integration Engineer

Intent Design Pvt. Ltd. • Santa Ana (CA)

On-site
USD 110,000 - 140,000
ETL Developer
ETL Developer

MACHINE LEARNING TECHNOLOGIES LLC • Santa Ana (CA)

On-site
USD 79,000 - 107,000
ETL Developer
ETL Developer

Valiant Technologies LLC • Santa Ana (CA)

On-site
USD 77,000 - 110,000