Informatica Developer

1. Analysis & Migration Support Analyze existing PowerExchange CDC configurations with Oracle - extraction definitions, groups, and logs. * Understand and document Oracle redo/archive log processing and its equivalent configuration within IDMC CMI-DB. * Work with the Architect to design and implement CDC workflows in IDMC (CMI-DB and CDI). * Identify technical dependencies and data flow impacts across systems. 2. Development & Implementation Develop and deploy IDMC CMI-DB pipelines for incremental and CDC ingestion from Oracle sources. * Create CDI mappings and tasks for data transformations, joins, and loading into targets (SQL Server, Parquet, Oracle, etc.). * Configure runtime environments, agents, and connections in IDMC. * Perform data validation, troubleshooting, and performance tuning of CDC jobs. * Support integration testing and cutover during PowerExchange to IDMC transition. 3. Administration & Collaboration Work with Informatica Admin and DBA teams to enable secure and efficient source/target connectivity. * Monitor CDC pipelines, address failures, and support operational stability post-migration. * Collaborate closely with business, data engineering, and QA teams to ensure data quality and reliability. 4. Document technical configurations, workflows, and migration steps. * Create reference guides for CDC setup and troubleshooting in IDMC. * Participate in knowledge-sharing sessions and provide peer training as required. 5 - 8 years of experience in Informatica ETL development using PowerExchange, PowerCenter and IDMC. * Strong hands-on experience with: - PowerExchange CDC setup for Oracle databases. - Oracle redo/archive log interpretation and integration with Informatica. - IDMC (CMI-DB and CDI) - creating ingestion and transformation pipelines. * Experience in Oracle and MS SQL Server as source/target systems. * Working knowledge of file formats - Parquet, CSV, JSON, and integration into data pipelines. * Familiarity with data ingestion, replication, real-time ingestion, and error handling mechanisms. * Exposure to cloud platforms (AWS, Azure, GCP) for IDMC deployments. * Understanding of Data Quality (IDQ) and Data Governance concepts. * Experience in modern ETL frameworks and migration projects.