ODI Developer

We are seeking a talented ODI Developer with IDMC knowledge to design, build, and optimize enterprise data integration solutions. The role involves migrating ODI-based ETL pipelines to Informatica IDMC for modern cloud-native data integration, governance, and quality initiatives.

Key Responsibilities:

• Analyse business requirements and translate them into technical solutions.

• Re-engineer legacy ETL processes for cloud-native execution.

• Analyse current ODI mappings, packages, and procedures for ETL workflows.

• Build and optimize data integration pipelines using Informatica IDMC (Cloud Data Integration, Data Quality, Governance).

• Migrate and modernize ODI-based ETL processes into IDMC cloud solutions.

• Collaborate with data architects, analysts, and business stakeholders to gather requirements and deliver scalable solutions.

• Implement data quality, lineage, and governance frameworks across ODI and IDMC environments.

• Troubleshoot, monitor, and enhance performance of ETL jobs and workflows.

• Document technical designs, maintain version control, and support production deployments.

• Integrate IDMC with cloud platforms like Azure, and Snowflake and other data warehouses.

• Automate data flows, task scheduling, and workflows within the platform.

• Implement data cataloguing and metadata management for improved data discovery

• Monitor and optimize data pipelines for scalability, efficiency, and cost-effectiveness.

• Troubleshoot performance bottlenecks and implement tuning strategies.

• Ensure compliance with organizational data governance and security policies.

• Conduct data reconciliation between Teradata and Snowflake post-migration.

• Implement validation frameworks to ensure consistency and accuracy.

• Ensure compliance with data governance and security policies.

• Document migration processes, best practices, and technical solutions.

Technical Skills:

• Strong expertise in Oracle Data Integrator (ODI) — mappings, packages, procedures, and performance tuning.

• Knowledge of Informatica IDMC (Cloud Data Integration, Data Quality, Governance).

• Proficiency in SQL, PL/SQL, and RDBMS (Oracle, SQL Server, Teradata, Snowflake, etc.).

• Knowledge of data warehousing concepts, ETL design patterns, and BI integration.

• Familiarity with cloud platforms (AWS, Azure, GCP) and hybrid architectures.

• Strong experience in ETL/ELT concepts, data modelling, and design and building data pipelines and transformation logic.

• Experience with metadata ingestion, data lineage, and classification.

• Knowledge of DevOps and CI/CD practices for data workflows and version control (Git, Jenkins).

• Basic scripting in Python, Shell, or PowerShell for automation tasks.

• Experience in different batch processing and data loading/transformation strategies.

• Understanding of data profiling, cleansing, and metadata management.

• Strong problem-solving and communication skills.

• Experience in banking and financial services will be preferred.