Should have experience in developing ETL processes.
Knowledge in the Oracle ODI toolset and Oracle PL/SQL
Knowledge of data modelling and ETL design
Basic knowledge of ODI Admin, ODI Installation in High Availability, Start and Stop the services and agents, Patching Activities and Security Implementation.
Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc
Packaging components, database operations like Aggregate pivot, union etc.
Using ODI mappings, error handling, automation using ODI, Migration of Objects
Design and develop complex mappings, Process Flows and ETL scripts.
Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
Expertise in developing Load Plans, Scheduling Jobs
Ability to design data quality and reconciliation framework using ODI.
Integrate ODI with multiple Source / Target.Â
Experience in Working with Restful Services, JSON Data
Experience on Error recycling / management using ODI, PL/SQL
Other Skills:
Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
Good knowledge of DB performance terminologies like partitioning, indexing, hints etc.
Strong knowledge of ELT/ETL concepts, design and coding
Must have good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
Ability to work with minimal guidance or supervision in a time critical environment.
