Data Integration Engineer

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.