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