About the job Oracle Data Integration
8+ years experience
Strong knowledge of ETL/ELT concepts
Ability to design ETL unit test cases and debug ETL mappings
Knowledge of PL/SQL
Knowledge of data modelling and ETL design
Hands-on with end to end DWH implementation experience using ODI as ETL tool
Knowledge of ODI Master and Work repositories.
Knowledge of OWB
Design and develop complex ODI mappings, packages, procedures etc.
Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
Setting up of topology and Model layer
Building objects in Designer and monitoring Operator
Experience of developing load plans and scheduling jobs.
Experience of performance tuning of ODI mappings
Ability to perform exception handling in ODI
Exposure of working with various source systems such as flat files, excel, XMLs, JSON, Oracle database, SQL server database etc