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 (Xico)
🏢 Pyramid Consulting
📍 Xico