ETL Developer: IDMC/Azure Synapse Data Pipelines

MACHINE LEARNING TECHNOLOGIES LLC

Santa Ana (CA)

Presencial

USD 79.000 - 107.000

Jornada completa

Hace 5 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

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

Formación

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

Responsabilidades

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

Conocimientos

Informatica IDMC/IICS
CDI
CAI
Azure Synapse Analytics
SQL
REST APIs
JSON/XML
OAuth 2.0
Data Warehousing
ETL/ELT design

Herramientas

Azure Data Factory

Descripción del empleo

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

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

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
ETL Engineer - IDMC, CAI & Azure Synapse
ETL Engineer - IDMC, CAI & Azure Synapse

Solugenix • Santa Ana (CA)

Presencial
USD 140.000 - 150.000
IDMC/CAI ETL Developer with Azure Synapse
IDMC/CAI ETL Developer with Azure Synapse

Quantum Technologies LLC • Santa Ana (CA)

Presencial
USD 77.000 - 110.000
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
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 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
ETL Developer

MACHINE LEARNING TECHNOLOGIES LLC • Santa Ana (CA)

Presencial
USD 79.000 - 107.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