ETL DEVELOPER (ODI, SQL, FULLY REMOTE)

Duncan & Ross Consulting


Date: 3 hours ago
City: Dubai
Contract type: Full time
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

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

NRI Vice President

Click and Connect Jobs, Dubai
AED 10,000 - AED 20,000 per month
3 hours ago
Role: NRI Vice PresidentLocation: Dubai, UAEAbout Our Client:Our client is an innovative wealth management firm based in Dubai, offering a comprehensive 360-degree range of services and products to their esteemed clients. Their mission is to provide personalized financial solutions that cater to the unique needs of each client, ensuring their financial well-being and growth.Role Overview:Our client is seeking an NRI...

Manager, Sales & Event

One&Only Resorts, Dubai
4 hours ago
( 13777 )At One&Only, we exist to create joy for our guests through anticipation, creativity, precision, empathy and warmth. We tailor every aspect of our guests’ stay to bring their dreams and desires to life. With an atmosphere that’s chic but wonderfully unstuffy, and a team who are meticulous but warm, we seek to exceed our guests’ expectations at every...

Procurement Officer - Subcontracting

Otis Elevator Co., Dubai
4 hours ago
Date Posted:2024-10-08Country: United Arab EmiratesLocation: Otis L.L.C, 37th floor, The One Tower, Sheikh Zayed Road, Dubai, United Arab EmiratesStrategic Responsibilities:Develop and implement sub-contractor’s category strategy. Lead and coordinate sub-contracting activities in collaboration with Field Operations, Finance and other internal and external stakeholders.Active research trends within sub-contracting category incl. how external factors impact the category e.g., workforce supply, pricing, investments etc.Take...