Senior Oracle Data Integrator (ODI) ETL Developer

Dicetek LLC; Ajman; On-site; AED 120,000 - 180,000; Full time

Job summary

A leading company is seeking a skilled ETL Developer with expertise in Oracle Data Integrator (ODI) to design and implement data integration solutions. The role demands strong SQL and PL/SQL skills, along with extensive experience in developing and managing ETL/ELT processes. You will be responsible for optimizing performance and ensuring data quality in a dynamic work environment, contributing to large-scale data integration projects.

Qualifications

• 5+ years of experience in ETL/ELT processes using ODI.
• Strong understanding of dimensional modeling.
• Familiarity with SQL Server, MySQL, or PostgreSQL is advantageous.

Responsibilities

• Design and implement data integration solutions using ODI.
• Manage end-to-end data integration projects.
• Optimize performance of ODI processes.

Skills

Data Integration

Oracle Data Integrator (ODI)

SQL

PL/SQL

Data Warehousing

Job description

Technical Expertise

Core Expertise In Oracle Data Integrator (ODI)

• Proficiency in designing and implementing data integration solutions using ODI 12c or later versions.
• Strong knowledge of:
• Knowledge Modules (KM): Creating and customizing reusable components for data integration processes.
• Mappings, Packages, and Scenarios: Designing complex data flows, workflows, and automating ETL processes.
• Topology Configuration: Configuring physical and logical schemas, data servers, and agents.
• Expertise in ODI's ELT framework and knowledge of performance optimization techniques.
• Experience in error handling, reconciliation frameworks, and debugging ODI processes.
  
  

Database Skills

• Strong SQL and PL/SQL skills for querying, transforming, and managing data.
• Deep knowledge of Oracle Database concepts, including:
• Indexing, partitioning, and materialized views.
• Query optimization techniques.
  
  

Familiarity with other databases like SQL Server, MySQL, or PostgreSQL is advantageous

Data Warehousing And ETL Concepts

• In-depth understanding of:
• Dimensional modeling (Star and Snowflake schemas).
• Fact and dimension tables, surrogate keys, slowly changing dimensions (SCDs), and hierarchies.
• Data profiling, data cleansing, and data validation practices.
• Hands-on experience in building and maintaining data warehouses and data lakes.
  
  

Experience And Professional Expertise

• 5+ years of hands-on experience in developing and managing ETL/ELT processes using ODI.
• Proven experience in implementing large-scale, end-to-end data integration projects, including:
• Requirements gathering
• Data modeling
• Designing scalable ETL/ELT solutions.
• Experience in upgrading or migrating ODI environments (e.g., from ODI 11g to 12c).