
Senior Azure Data & Integration Engineer (Informatica CDI / CAI)
Quick overview
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.
Similar jobs
- LS

Senior Database EngineerRecently posted
London Stock Exchange Group · St Louis, MO · Hybrid · Posted 17 Nov 2026 🇺🇸
OracleShellAWS+5TechnologySalary not listed - KT

Senior Data EngineerRecently posted
Kforce Technology Staffing · Atlanta, GA · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLETLAirflow+5TechnologySalary not listed - QT

Data Engineer LeadRecently posted
QUANTUM TECHNOLOGIES LLC · United States · Hybrid · Posted 17 Nov 2026 🇺🇸
DockerSQLGit+12Technology$83/hr - TE
Data Engineer - San Antonio, TX, Dallas, TX, Austin, TX, Houston, TXRecently posted
TechniPros, LLC · San Antonio, TX · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLApache SparkETL+2TechnologySalary not listed - SI

Data Engineer - VC Backed StartupsRecently posted Auto Apply
Signalfire · Remote - No Preference · Remote · Posted 17 Nov 2026 🇺🇸
Talent AcquisitionDockerDynamoDB+23TechnologySalary not listed - SI

Data Engineer - VC Backed StartupsRecently posted Auto Apply
Signalfire · NYC - Hybrid · Hybrid · Posted 17 Nov 2026 🇺🇸
Talent AcquisitionDockerDynamoDB+23TechnologySalary not listed - SI

Data Engineer - VC Backed StartupsRecently posted Auto Apply
Signalfire · Bay Area - Hybrid · Hybrid · Posted 17 Nov 2026 🇺🇸
Talent AcquisitionDockerDynamoDB+23TechnologySalary not listed - RS
Senior Azure Data Engineer – Databricks & Microsoft Fabric (only Local candidates from Houston)Recently posted
ResolveTech Solutions Inc. · Houston, TX · On-site · Posted 16 Nov 2026 🇺🇸
OracleSQLGit+13TechnologySalary not listed - DD

Senior Databricks EngineerRecently posted
Dexian DISYS · Plano, TX · Hybrid · Posted 16 Nov 2026 🇺🇸
UnityEngineeringSalary not listed - BC

Data Engineer IV (Customer Experience)Recently posted
BCforward · United States · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLApache SparkETL+6Technology$81 - $85/hr - UC
Data Core SupervisorRecently posted Auto Apply
UCSF · San Francisco · Hybrid · Posted 17 Nov 2026 🇺🇸
RecruitingOnboardingClinical Research+7Salary not listed - SP

Data EngineerRecently posted
SSI People · United States · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLETLScikit-learn+6TechnologySalary not listed