- Design, develop and maintain end-to-end data warehouse integrations using Oracle Data Integrator (ODI).
- Build and monitor ODI mappings, packages, procedures, load plans and schedules; tune performance and handle exceptions.
- Work with ETL/ELT concepts, data modelling, PL/SQL, repositories and varied data sources including Oracle, SQL Server, files, XML and JSON.
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
We vet all employer accounts and do our best to keep job ads safe, but scams can still occur. Be cautious when sharing personal information — never provide financial details or make payments during the application process. For extra security, use the Apply button on our site when proceeding.
Skills
0 of 23 matchedPyramid Global Technologies
