Oracle Data Integrator Consultant

Role Overview

We are looking for an experienced Oracle Data Integrator (ODI) Consultant with 5+ years of experience in implementing Batch/Real-time integrations using ODI 11g. The ideal candidate will have strong expertise in ODI toolset, PL/SQL, and designing robust ETL processes. You will be responsible for designing, developing, and optimizing data integrations, with a focus on performance tuning and reusability.

Key Responsibilities

• Design and develop ODI Interfaces, Packages, Load Plans, and user functions.
• Customize ODI knowledge modules as per project requirements.
• Develop ETL processes with error logging, auditing, and data quality checks.
• Implement reusability, parameterization, and workflow design in ODI.
• Perform performance tuning for ODI mappings and design ETL unit test cases.
• Integrate ODI with multiple source and target systems.
• Knowledge of ODI Master and Work repository, data modeling, and ETL design.
• Troubleshoot and debug ODI mappings and optimize processes for better performance.
  
  

Key Skills :

• 5+ years of experience in Oracle Data Integrator (ODI) implementation.
• Strong proficiency in ODI 11g, Oracle PL/SQL, and data modeling.
• Expertise in ODI mappings, error handling, and automation.
• Experience in performance tuning and optimizing ODI processes.
• Knowledge of ETL processes, control tables, and data quality mechanisms.
• Familiarity with ODI Master and Work repositories.
  
  

(ref:hirist.tech)