Apps Associates (I) Private Limited Hiring For ODI developer at Gurgaon , Gurugram Full Time

Location: Gurgaon

SUMMARY:

Oracle Data Integrator is responsible for developing medium to complex ODI interfaces by using various transformation packages and knowledge modules. Should be able to diagnose and debug data reconciliation issues and identify the fixes. The incumbent should be able to deploy code to multiple environments. Working knowledge of out-of-box OBIA ODI ETL packages/interfaces and KMs is preferable.

ESSENTIAL FUNCTIONS ON BELOW ODI TASKS:

5 years of proven experience in design and development of Data Warehouse solutions, ETL, Software Development and system Integration projects.
Minimum 2 years of strong experience in Oracle Data Integrator (ODI) with knowledge of data modeling and ETL design.
Must have worked on end to end implementation of DW and BI projects.
Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure.
Design and develop mappings, Process Flows and ETL scripts.
Experience of performance tuning of mappings.
Ability to tune mappings at ETL level and provide suggestion of tuning at database level.
Ability to design ETL unit test cases and debug ETL Mappings.