Job Description

Job Summary

Design and develop scalable data integration solutions using Informatica IDMC (Cloud Data Integration - CDI)

Build, enhance, and maintain mappings, mapplets, and taskflows for enterprise data pipelines

Implement end-to-end ETL/ELT processes for data ingestion, transformation, and loading

Develop complex transformation logic using expression, lookup, joiner, aggregator, and router

Process and transform JSON, XML, and flat file data within CDI mappings

Implement parameterization and reusable frameworks to support dynamic processing

Design and develop file-based ingestion frameworks handling multiple file formats and patterns

Implement robust error handling, logging, and restart mechanisms in taskflows and mappings

Optimize performance using pushdown optimization, partitioning, and caching techniques

Work with relational databases and write optimized SQL queries for data processing

Implement incremental load strategies, CDC patterns, and data validation rules

Troubleshoot and resolve issues in mappings, taskflows, and production jobs

Collaborate with business and technical teams to gather requirements and design solutions

Develop and support real-time and API integrations using CAI (Cloud Application Integration)

Implement and maintain B2B/EDI integrations using Informatica B2B Gateway

Key Responsibilities

null

Skill Requirements

null

Other Requirements

null