Description

You will manage the Enterprise Data Warehouse within Oracle Cloud Infrastructure and Oracle Autonomous Data Warehouse environments.

Responsibilities

• Administer the Enterprise Data Warehouse in Oracle Cloud Infrastructure and Oracle Autonomous Data Warehouse environments.
• Develop, test, and implement ETL scripts and jobs using ODI to move data from sources to targets.
• Design and maintain the enterprise data management framework, including data catalogs and data dictionaries.
• Develop physical data models and create testing approaches, plans, and result documentation.
• Monitor databases to resolve performance issues and respond to EDW incidents.
• Provide documentation supporting the Kimball Dimensional Data Modeling Framework and mentor team members on industry standards.

Required Skills

• 7+ years of verifiable experience in database design and warehouse architecture.
• Expertise in Oracle and Oracle Data Integrator (ODI).
• Strong proficiency in Data Architecture and Data Modeling.
• Hands-on experience with Database Design.
• Knowledge of the Kimball Dimensional Data Modeling Framework.
• Ability to develop requirements and design specifications.
• Effective communication skills for stakeholder collaboration.

Preferred Skills

• Oracle Autonomous Database Cloud 2021 Certified Specialist.
• Oracle Machine Learning using Autonomous Database 2021 Certified Specialist.
• Oracle Cloud Infrastructure 2021 Certified Architect Professional.
• Oracle Data Integrator 12C Certified Implementation Specialist.

Key Skills

Education

Any Graduate