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

Univedge Consulting LLC

Santa Ana (CA)

On-site

USD 120,000 - 180,000

Full time

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

Univedge Consulting LLC seeks an experienced Data & Integration Engineer to design and manage data pipelines using Informatica CDI/CAI within an Azure ecosystem. The role focuses on integrating cloud and on-prem data sources with Azure SQL, Synapse, and ADLS, while building automated scripts in Python or PowerShell to enhance pipeline reliability.

The position is onsite in Santa Ana, CA, and requires hands-on expertise in batch and real-time data integration, data quality, and RCA in

Qualifications

  • Strong analytical and problem-solving abilities for data integration tasks.
  • Excellent communication skills to explain technical concepts to stakeholders.
  • Experience with cloud data platforms and ETL/ELT workflows in production environments.

Responsibilities

  • Design, build, deploy, and maintain end-to-end data integration solutions using Informatica CDI and CAI.
  • Integrate cloud and on-prem sources with Azure data platforms (Azure SQL, Synapse, ADLS).
  • Develop automation scripts in Python or PowerShell to streamline pipelines and data operations.

Tools

Informatica CDI
Informatica CAI
Azure
Azure Data Lake Storage
SQL
Python
PowerShell

Job description

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

Santa Ana, California

Fully Onsite

United State

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.

Key Responsibilities
  • 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)

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)

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

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

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

Ethereum Technologies LLC • Santa Ana (CA)

On-site
USD 84,000 - 120,000
ETL Developer
ETL Developer

Intent Design Pvt Ltd • Santa Ana (CA)

On-site
USD 110,000 - 140,000
CDI/CAI Developer
CDI/CAI Developer

TechDigital Group • Burbank (CA)

On-site
USD 100,000 - 130,000