ETL DEVELOPER

Duncan & Ross
Dubai
AED 50,000 - 200,000
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 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

Get a free, confidential resume review.
Select file or drag and drop it
Avatar
Free online coaching
Improve your chances of getting that interview invitation!
Be the first to explore new ETL DEVELOPER jobs in Dubai