Oracle ODI Consultant

Job description / Role

Key responsibilities:

Design, develop, and implement complex ETL processes using Oracle Data Integrator (ODI) to extract data from various Oracle source systems.
Transform raw data into a structured format suitable for the Oracle Data Warehouse, ensuring data quality, consistency, and integrity.
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), including knowledge of various ODI components (Designer, Operator, Topology, Security, etc.).
• 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, concepts, and best practices.
• Solid experience with Oracle as a source data system.
• Experience in loading data into Oracle Data Warehouses (DW), including an understanding of star schema, snowflake schema, and dimensional modeling concepts.
• Familiarity with data warehousing principles, concepts, and methodologies (e.g., Kimball, Inmon).
• Experience with 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) is a plus.
• 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).

About the company:

The company engineers modern businesses. It helps clients modernize technology, reimagine processes, and transform experiences so they can stay ahead in a fast-changing world. Together, they are improving everyday life.