Description

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

This role is on-site.

Responsibilities

• 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 Database 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.

Key Skills

Education

Any Graduate