ETL DEVELOPER

Role and Responsibilities

• 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.

Vertical

Technology

Remote Work :

No