Description

You will design and develop complex data integration solutions using Oracle Data Integrator.

Responsibilities

• Design and develop complex ODI Packages, Mapping, Load Plans, and ETL process flows.
• Configure, set up, and manage ODI environments, Topology, and Model objects.
• Develop ETL Unit Test cases, debug ETL Packages/Mappings, and manage error logging.
• Perform ODI Code-Fix, manage backups, and deploy code across DEV, SIT, UAT, and PROD instances.

Required Skills

• 5+ years of hands-on experience with Oracle Data Integrator (ODI) 12c, 11g, and 10g.
• Expertise in developing complex ETL scripts, data quality checks, and error handling within ODI.
• Proficiency in customizing and using Knowledge Modules (KM) and Fitments in ODI.
• Strong understanding of Data Warehouse concepts (Star, Fact, Dimensions, Lookups).
• Advanced skills in Oracle SQL, PL/SQL, and Oracle RDBMS (Tables, Views, Synonyms).
• Experience with ODI performance tuning for packages and mappings.
• Ability to integrate ODI with multiple source and target systems.
• Knowledge of database indexing, Gather Stats, and database-level performance tuning.
• Any Graduate education.

Key Skills

Education

Any Gradute