Description

You will design and maintain end-to-end data warehouse solutions within the Oracle BI Tool stack.

Responsibilities

• Design, develop, and implement data warehouse solutions to integrate historical and current data from multiple sources.
• Develop physical data models and implement dimensional modelling using Star and Snowflake schemas.
• Optimize database and ETL performance through SQL performance tuning and efficient processing techniques.
• Automate ETL jobs, failure notifications, and implement maintenance, monitoring, and backup procedures.
• Manage data migrations, troubleshooting, and data verification testing to ensure compatibility across sources.

Required Skills

• 5+ years of experience in Data Warehousing, Data Modelling, and ETL development.
• Proficiency in OBIA using ODI within a BIAPPS environment.
• Strong expertise in SQL and performance tuning.
• Hands-on experience with Data Modelling, including SCDs, Aggregation, and Hierarchy.
• Deep understanding of database concepts such as Partitioning and Materialized views.
• Ability to draft High Level and Low Level DWH design documentation.
• Experience with ETL automation and data acquisition strategies.
• Any Graduate degree.

Preferred Skills

• Exposure to ETL tools such as SSIS or Synapse.

Key Skills

Education

Any Graduate