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 handson 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 problemsolving abilities.
Ability to work with minimal guidance or supervision in a time critical environment.
Disclaimer: Drjobs.ae is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.