Match score not available

ETL DEVELOPER (ODI, SQL, FULLY REMOTE)

Remote:

Full Remote

Contract:

Full time

Experience:

Mid-level (2-5 years)

Work from:

United Arab Emirates

Offer summary

Qualifications:

Experience in developing ETL processes, Knowledge of Oracle ODI and PL/SQL, Familiarity with data modeling and ETL design, Skills in error handling and automated processes, Expertise in database development using SQL/PLSQL.

Key responsabilities:

Set up topology and build design objects
Develop complex mappings and ETL scripts
Integrate ODI with multiple source and targets
Monitor operations and manage errors effectively
Create a data quality and reconciliation framework

Duncan & Ross Consulting Information Technology & Services Scaleup https://www.duncan-ross.com/

201 - 500 Employees

See more Duncan & Ross Consulting offers

Job description

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