IDMC/CAI ETL Developer with Azure Synapse

Quantum Technologies LLC

Santa Ana (CA)

Presencial

USD 77.000 - 110.000

Jornada completa

Hace 6 días
Sé de los primeros/as/es en solicitar esta vacante

Una candidatura completa en un minuto

Currículum y carta de presentación personalizados, listos para enviar.

Supera los filtros ATS

Descripción de la vacante

Quantum Technologies. LLC is seeking an ETL Developer in Santa Ana, CA to design, build, and optimize data pipelines and integrations using Informatica IDMC/CDI/CAI and Azure Synapse.

You will develop data warehousing solutions and support enterprise reporting and operations. The role requires strong SQL skills, REST API experience, and the ability to troubleshoot production issues while collaborating with analysts and application teams.

Formación

  • Hands-on experience with Informatica IDMC/IICS CDI and CAI.
  • Strong Azure Synapse Analytics experience, including dedicated SQL pools and tuning.
  • Advanced SQL skills with complex joins, window functions, procedures.
  • Experience with REST APIs, JSON/XML, OAuth 2.0 and pagination.
  • Knowledge of data warehousing, dimensional modeling, incremental loads.
  • Experience integrating relational databases, cloud storage, files.
  • Ability to investigate production issues independently and communicate clearly.

Responsabilidades

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

Conocimientos

Informatica IDMC
Azure Synapse
Advanced SQL
REST APIs
Data warehousing
ETL/ELT design
Issue resolution

Herramientas

Informatica IDMC
Azure Synapse
SQL tooling

Descripción del empleo

Quantum Technologies. LLC is seeking an ETL Developer in Santa Ana, CA to design, build, and optimize data pipelines and integrations using Informatica IDMC/CDI/CAI and Azure Synapse.

You will develop data warehousing solutions and support enterprise reporting and operations. The role requires strong SQL skills, REST API experience, and the ability to troubleshoot production issues while collaborating with analysts and application teams.

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Senior ETL Engineer: Informatica IDMC + Azure Synapse
Senior ETL Engineer: Informatica IDMC + Azure Synapse

Quantum Technologies. LLC • Santa Ana (CA)

Presencial
USD 84.000 - 120.000
ETL Developer: IDMC/Azure Synapse Data Pipelines
ETL Developer: IDMC/Azure Synapse Data Pipelines

MACHINE LEARNING TECHNOLOGIES LLC • Santa Ana (CA)

Presencial
USD 79.000 - 107.000
ETL Developer — Informatica IDMC + Azure Synapse
ETL Developer — Informatica IDMC + Azure Synapse

Ethereum Technologies • Santa Ana (CA)

Presencial
USD 84.000 - 120.000
ETL Developer: IDMC/CDI & Azure Synapse
ETL Developer: IDMC/CDI & Azure Synapse

Valiant Technologies LLC • Santa Ana (CA)

Presencial
USD 77.000 - 110.000
IDMC ETL Developer - CDI/CAI & Azure Synapse
IDMC ETL Developer - CDI/CAI & Azure Synapse

Valiant Technologies LLC • Santa Ana (CA)

Presencial
USD 96.000 - 138.000
ETL Engineer - IDMC, CAI & Azure Synapse
ETL Engineer - IDMC, CAI & Azure Synapse

Solugenix • Santa Ana (CA)

Presencial
USD 140.000 - 150.000
ETL Developer
ETL Developer

Intent Design Pvt Ltd • Santa Ana (CA)

Presencial
USD 110.000 - 140.000
ETL Developer with Informatica Intelligent Data Management Cloud
ETL Developer with Informatica Intelligent Data Management Cloud

Quantum Technologies LLC • Santa Ana (CA)

Presencial
USD 84.000 - 120.000
ETL Developer with Informatica Intelligent Data Management Cloud
ETL Developer with Informatica Intelligent Data Management Cloud

Valiant Technologies LLC • Santa Ana (CA)

Presencial
USD 96.000 - 138.000
ETL Developer with Informatica Intelligent Data Management Cloud
ETL Developer with Informatica Intelligent Data Management Cloud

Ethereum Technologies LLC • Santa Ana (CA)

Presencial
USD 84.000 - 120.000