Description

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

Responsibilities

• Independently design and develop complex Packages, Mappings, Process Flows, and ETL scripts.
• Customize Knowledge Modules and Fitments within the ODI framework.
• Execute Unit Test and System Integration Testing through to Production Go-Live.
• Manage ODI Code-Fix, backups, and code deployments across DEV, SIT, UAT, and PROD instances.
• Perform ODI Performance Tuning on packages, mappings, and data flows.

Required Skills

• 5+ years experience with Oracle Data Integrator (ODI) versions 12c, 11g, or 10g.
• Hands-on development experience creating complex ODI Packages, Mapping, Load Plans, and ETL processes.
• Proficiency in setting up and configuring ODI environments, Topology, and Model objects.
• Expertise in customizing and using Knowledge Modules (KM) within ODI.
• Strong knowledge of ETL concepts, including data quality, error logging, and auditing.
• Experience integrating ODI with various Source and Target systems.
• Proficiency in Oracle RDBMS, including Tables, Views, and Synonyms.
• Advanced SQL skills, including analytical functions, and PL/SQL development.
• Experience with Data Warehouse concepts (Star Schema, Fact, Dimensions, Lookups).

Key Skills

Education

Any Gradute