Skip to content
×

Senior Azure Data & Integration Engineer; Informatica CDI​/CAI

Listing for: Headway Tek Inc
Contract position Listed on 2026-11-21
Job specializations:
Salary/Wage Range or Industry Benchmark: 120000 - 180000 USD Yearly USD 120000.00 180000.00 YEAR

Job Description & How to Apply Below

Position: Senior Azure Data & Integration Engineer (Informatica CDI / CAI)
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 (Power Shell/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 Power Shell/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 (Power Shell, 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.

Position Requirements

10+ Years work experience
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction

Search for further Jobs Here:

SEARCH JOBS: 10+ Million Listings
(Try combinations for better Results! Or enter less keywords for broader Results)
Education Level
Experience Level (years)
Posted in last:
Salary