Data Integration Engineer specialized in designing, developing, and operating enterprise data pipelines using ETL tools, with Informatica IDMC (Intelligent Data Management Cloud / IICS) as the primary platform.
Able to work across cloud-agnostic environments , including Azure, AWS, and GCP .
REQUIRED TECHNICAL SKILLS Mapping Designer
SQL ELT with pushdown optimization (full/source/target)
Taskflows
Dynamic Mappings
Parameterization
File listeners
Performance tuning
Experience with batch and near-real-time ingestion from heterogeneous sources across:
Mass Ingestion Databases (CDC)
Files
Applications
Streaming
Process Designer
Service connectors
Guides
Business processes
API and microservices integration
PowerCenter to IDMC Migration and modernization of on-premises pipelines
Structured migration methodology
CDI-PC
Platform Operations Administration of Secure Agents
Secure Agent Groups
Monitoring
SLA management
AI-Assisted Development – CLAIRE CLAIRE GPT / CLAIRE Copilot: Assisted generation of mappings, debugging of transformations, and automated pipeline documentation through natural language within IDMC.
Awareness of new agentic capabilities (CLAIRE Agents, Fall 2025 release) for headless ingestion and transformation flows.
Platform FinOps Understanding of the IPU (Informatica Processing Units) consumption model.




Cloud-Agnostic Technologies AWS — Core to the Role AWS Glue
Amazon S3
AWS Step Functions
Amazon Athena
Infrastructure as Code & CI/CD Terraform
CloudFormation
Jenkins
Databases & Platforms Advanced SQL: Oracle, SQL Server, PostgreSQL, Amazon Redshift, Databricks SQL
Data Warehouse architecture patterns
Data Lake architecture patterns
Lakehouse architecture patterns
CERTIFICATIONS Core Relevant Complementary KEY RESPONSIBILITIES Design and implement ingestion, transformation, and distribution pipelines using CDI and Cloud Mass Ingestion.
Develop data pipelines using the following AWS cloud services:
AWS Glue
Amazon S3
AWS Step Functions
Amazon Athena
Extract and process data from heterogeneous sources using AWS services.
Provide support for incidents related to data pipelines and data publishing , ensuring the quality and reliability of services provided to data users.
EC2 Linux and Windows machines
S3 buckets
SNS
EventBridge
Operate and maintain integration infrastructure , including Secure Agents and runtime environments, across Azure and AWS while meeting SLA standards.
Apply CLAIRE GPT / CLAIRE Copilot to optimize the mapping development lifecycle and improve development efficiency.

#J-18808-Ljbffr

📌 Data Integration Engineer (Ciudad de México)
🏢 Pyramid Consulting
📍 Ciudad de México