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
