Informatica Developer at NTT DATA

Bengaluru, karnataka, India -

Full Time

Start Date

Immediate

Expiry Date

08 Jan, 26

Salary

0.0

Posted On

10 Oct, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Informatica ETL Development, PowerExchange, PowerCenter, IDMC, CDC Setup, Oracle Databases, Data Transformations, SQL Server, Parquet, CSV, JSON, Data Validation, Performance Tuning, Cloud Platforms, Data Quality, Data Governance, Modern ETL Frameworks

Industry

IT Services and IT Consulting

Description

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.

Responsibilities

The Informatica Developer will analyze existing PowerExchange CDC configurations and develop IDMC CMI-DB pipelines for data ingestion from Oracle sources. They will also collaborate with various teams to ensure data quality and operational stability post-migration.