Oracle Data Integration
Pyramid Global Technologies
Prepare for this role
Job Type
Description
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
This job is found at InterviewStack.io
Skills
About Pyramid Global Technologies
Pyramid Global Technologies is a leading independent, end-to-end IT services company, serving private and public-sector clients from a diverse array of industries across Australia.