Senior Azure Data & Integration Engineer (Informatica CDI / CAI)

Headway Tek Inc

Santa Ana (CA)

On-site

USD 120,000 - 180,000

Full time

6 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Headway Tek Inc. is seeking a Senior Azure Data & Integration Engineer to design and manage data integration pipelines using Informatica CDI/CAI within an Azure ecosystem. The role focuses on building ETL/ELT workflows, integrating cloud and on-prem sources, and implementing robust RCA and automation.

The ideal candidate has hands-on experience with Informatica CDI/CAI, Azure data services, and advanced SQL, plus scripting in Python or PowerShell to streamline operations.

Qualifications

  • Hands-on experience with Informatica CDI and CAI.
  • Proficiency with Azure data services (ADLS, Synapse).
  • Strong SQL, data profiling, and data quality skills.

Responsibilities

  • Design, build, deploy, and maintain end-to-end data integration solutions using Informatica CDI/CAI.
  • Integrate cloud and on-prem sources with Azure data platforms and optimize pipelines.
  • Develop automation scripts in Python or PowerShell for workflow tasks.

Skills

Informatica CDI/CAI
Azure Cloud
Advanced SQL
Python/PowerShell
RCA

Tools

Informatica IDMC Suite
Azure Data Lake Storage

Job description

Job Title: Senior Azure Data & Integration Engineer (Informatica CDI / CAI)
Location

Santa Ana, California, USA(Onsite)

C2C or W2
Job Overview

We are seeking an experienced Data & Integration Engineer specializing in Informatica Cloud Data Integration (CDI) and Cloud Application Integration (CAI) with a Microsoft Azure ecosystem.

In this role, you will be responsible for building and maintaining robust ETL/ELT pipelines and API integration workflows, writing complex SQL queries, and executing deep root-cause analysis (RCA) on job failures or data anomalies. The ideal candidate combines strong technical troubleshooting skills with scripting expertise in Python or Windows environment (PowerShell/Batch) to automate and optimize enterprise data workflows.

Key Responsibilities
Integration & Data Pipeline Engineering
  • Design, build, deploy, and maintain end-to-end data integration solutions using Informatica CDI (batch/ETL pipelines) and Informatica CAI (real-time/API-driven integrations).
  • Integrate cloud and on-premises sources with Azure data platforms (Azure SQL, Azure Synapse, Azure Data Lake Storage/ADLS).
  • Develop and execute automation scripts using Python or Windows PowerShell/Batch to streamline pipeline execution, file management, and system tasks.
SQL & Data Querying
  • Write, optimize, and debug complex, high-performance SQL queries (joins, CTEs, window functions, procedure logic) to extract, validate, and transform large datasets.
  • Perform data profiling, target-to-source mapping, and dataset reconciliations across diverse source systems.
Monitoring, Production Support & Root Cause Analysis (RCA)
  • Proactively monitor scheduled integration workflows and conduct thorough analysis on job failures to restore operational performance rapidly.
  • Perform detailed Root Cause Analysis (RCA) when data is missing, delayed, corrupted, or not arriving as expected-identifying upstream system issues, logic flaws, or payload drift.
  • Maintain comprehensive RCA documentation and implement preventive controls (e.g., error-handling framework updates, automated alerts, data quality rules).
Qualifications & Skills
Required Experience & Skills
  • Informatica IDMC Suite: (Number Of Year)+ years of hands-on experience developing and troubleshooting with Informatica CDI and Informatica CAI.
  • Azure Cloud Ecosystem: Good working experience with Azure services (Azure Data Lake Storage, Azure SQL / Synapse Analytics).
  • Advanced SQL: Advanced knowledge of SQL query writing, performance tuning, and schema analysis across relational or cloud data warehouses.
  • Production Support & RCA: Proven track record in operational support, job failure analysis, data lineage tracing, and complex RCA in production data environments.
  • Scripting Expertise: Practical scripting experience in Python or Windows Scripting (PowerShell, Batch/Command CLI) for workflow automation and file handling.
Soft Skills & Process Knowledge
  • Strong analytical, problem-solving, and critical thinking skills.
  • Excellent communication skills for explaining technical root causes to both business stakeholders and engineering teams.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Azure Data & Integration Engineer (Informatica CDI / CAI)
Senior Azure Data & Integration Engineer (Informatica CDI / CAI)

Univedge Consulting LLC • Santa Ana (CA)

On-site
USD 120,000 - 180,000
Senior Azure Data & Integration Engineer - CDI/CAI (Onsite)
Senior Azure Data & Integration Engineer - CDI/CAI (Onsite)

Headway Tek Inc • Santa Ana (CA)

On-site
USD 120,000 - 180,000
Senior Azure Data & Integration Engineer - CDI/CAI (Onsite)
Senior Azure Data & Integration Engineer - CDI/CAI (Onsite)

Univedge Consulting LLC • Santa Ana (CA)

On-site
USD 120,000 - 180,000
Imformatica Lead
Imformatica Lead

Diligent Tec, Inc • Santa Ana (CA)

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

Intent Design Pvt Ltd • Santa Ana (CA)

On-site
USD 110,000 - 140,000
Informatica Senior Data Governance Lead - EDC, AXON, Python
Informatica Senior Data Governance Lead - EDC, AXON, Python

HCL Technologies Limited • United States

On-site
USD 120,000 - 160,000
ETL Developer with Informatica Intelligent Data Management Cloud
ETL Developer with Informatica Intelligent Data Management Cloud

Quantum Technologies LLC • Santa Ana (CA)

On-site
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)

On-site
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)

On-site
USD 84,000 - 120,000
CDI/CAI Developer
CDI/CAI Developer

TechDigital Group • Burbank (CA)

On-site
USD 100,000 - 130,000