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.