Oracle ODI Developer

About the Job:
The Oracle ODI Developer will be responsible for designing, developing, and implementing complex ETL processes using Oracle Data Integrator (ODI) to extract data from various Oracle source systems. The role involves transforming raw data into a structured format suitable for the Oracle Data Warehouse while ensuring data quality, consistency, and integrity.

Key Responsibilities:

• Design, develop, and implement ETL processes using Oracle Data Integrator (ODI).
• Transform raw data into structured formats for the Oracle Data Warehouse.
• Develop and optimize ODI mappings, interfaces, packages, and scenarios for efficient data loading.

Required Skills and Qualifications:

• Proven expertise in designing and developing ETL solutions using Oracle Data Integrator (ODI).
• Strong proficiency in SQL and PL/SQL for data manipulation, querying, and performance tuning within an Oracle environment.
• In-depth understanding of Oracle database architecture and concepts.
• Solid experience with Oracle as a source data system.
• Experience in loading data into Oracle Data Warehouses (DW) with knowledge of star schema, snowflake schema, and dimensional modeling concepts.
• Familiarity with data warehousing principles and methodologies (e.g., Kimball, Inmon).
• Experience in performance tuning of ODI mappings and Oracle SQL queries.
• Strong analytical and problem-solving skills with attention to detail.

Preferred Skills and Qualifications (Nice-to-Have):

• Experience with other ETL tools (e.g., Informatica, DataStage).
• Knowledge of other Oracle technologies (e.g., GoldenGate).
• Experience with cloud platforms (e.g., OCI) and cloud data warehousing solutions.
• Familiarity with version control systems (e.g., Git).
• Experience with scripting languages (e.g., Python, Shell Scripting).

Work Conditions:
On-site, Full-time
Location:
Riyadh Region

Language Requirements:
Not specified.