IDMC Data Integration Engineer - Cloud-First ETL & Pipelines (Ciudad de México)

IDMC Data Integration Engineer - Cloud-First ETL & Pipelines (Ciudad de México)

18 sep
|
Pyramid Consulting
|
Ciudad de México

18 sep

Pyramid Consulting

Ciudad de México

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

📌 IDMC Data Integration Engineer - Cloud-First ETL & Pipelines (Ciudad de México)
🏢 Pyramid Consulting
📍 Ciudad de México

Postulate a este anuncio

Muestra tus habilidades a la empresa, rellenar el formulario y deja un toque personal en la carta, ayudará el reclutador en la elección del candidato.

Suscribete a esta alerta:

Recibe por email las nuevas ofertas de trabajo para: idmc data integration engineer - cloud-first etl & pipelines (ciudad de méxico) / ciudad de méxico

Suscribete a esta alerta:

Recibe por email las nuevas ofertas de trabajo para: idmc data integration engineer - cloud-first etl & pipelines (ciudad de méxico) / ciudad de méxico