Senior Oracle Data Integrator (ODI) ETL Developer

Dicetek LLC; Ajman; On-site; AED 60,000 - 100,000; Full time

Job summary

An innovative company is seeking a skilled data integration specialist with extensive experience in Oracle Data Integrator. You will be responsible for designing and implementing robust ETL processes while ensuring data quality and performance optimization. This role demands a deep understanding of data warehousing concepts and the ability to manage large-scale projects. Join a forward-thinking team that values expertise and offers opportunities for professional growth in a dynamic environment. If you have a passion for data and a proven track record in ETL solutions, this is the perfect opportunity for you.

Qualifications

• 5+ years of experience in ETL/ELT processes using ODI.
• Strong knowledge of data integration solutions and performance optimization.

Responsibilities

• Design and implement data integration solutions using Oracle Data Integrator.
• Manage and optimize ETL processes for large-scale data integration projects.

Skills

Oracle Data Integrator (ODI)

SQL

PL/SQL

Data Warehousing

ETL Processes

Data Cleansing

Tools

ODI 12c

SQL Server

MySQL

PostgreSQL

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).