ETL DEVELOPER (ODI, SQL, FULLY REMOTE)

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

Vertical

Technology