Oracle Data Integration

Pyramid Global Technologies · VIC · Full time
+60d ago

Oracle Data Integration

Pyramid Global Technologies
VIC

·

Full time

~$163k - $344k(Estimated)
Pyramid Global Technologies Logo
KEY POINTS WE FOUND
  • Design and develop complex ODI mappings, packages, and procedures.
  • Hands-on experience with end-to-end DWH implementation using ODI as ETL tool.
  • Strong knowledge of ETL/ELT concepts and performance tuning of ODI mappings.

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

Stay Safe While Job Hunting

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 11 matched
Data modellingData warehousesEltEtlException handling in odiKnowledge modules (km)OdiPerformance tuningPl/sqlSource system integrationTopology and model layer setup

Pyramid Global Technologies

Pyramid Global Technologies Logo
Oracle Data Integration | Pyramid Global Technologies | The Shout