ODI Engineer

Job Title:ODI Engineer

Location: Dubai, NONE

Employment Type: 

Contract

We are looking for an experienced ETL/ODI Developer to join our client's team. The ideal candidate will have strong expertise in developing ETL processes, Oracle Data Integrator (ODI), and Oracle PL/SQL. You will play a key role in designing, developing, and maintaining data integration and ETL processes, ensuring seamless data flow across multiple systems.

Key Responsibilities:

• Develop and implement ETL processes, ensuring efficient data flow and integration across multiple platforms.
• Utilize Oracle Data Integrator (ODI) toolset for data extraction, transformation, and loading.
• Design and develop complex mappings, process flows, and ETL scripts.
• Customize and manage Knowledge Modules (KMs) to enhance data processing capabilities.
• Set up and manage topology, build objects in Designer, and monitor ODI operations.
• Perform database operations like aggregate pivot, union, and ensure accurate data transformations.
• Package components and manage error handling, automation, and migration using ODI.
• Perform basic ODI Admin tasks, such as installation in high availability, service management, patching, and security implementation.
• Integrate ODI with various source/target systems, including the use of RESTful services and JSON data.
• Design data quality and reconciliation frameworks, ensuring data integrity throughout the ETL process.
• Develop and manage Load Plans, schedule jobs, and maintain ETL process efficiency.
• Collaborate with cross-functional teams to optimize database performance, including partitioning, indexing, and performance tuning.

Key Requirements:

• Strong experience in ETL process development and Oracle Data Integrator (ODI).
• Proficiency in Oracle PL/SQL and database development for PL/SQL-based applications.
• Knowledge of data modeling, ETL design, and integration best practices.
• Experience with ODI Admin tasks, including installation, patching, and security implementation.
• Strong understanding of ELT/ETL concepts, design, and coding.
• Familiarity with error handling, automation, and migration using ODI.
• Expertise in database performance optimization, including partitioning, indexing, and other optimization techniques.
• Strong verbal and written communication skills in English.
• Ability to work independently in a time-critical environment with minimal guidance.