We required DW Admin with Autonomous Data Warehouse background. Data Engineer / Data Scientist profiles are not considered for this position.
Key Duties/Responsibilities:
- Performs data warehouse administration for the Enterprise Data Warehouse in the Oracle Cloud Infrastructure, Oracle Autonomous Data Warehouse Environment
- Reviews existing architecture and provides solution recommendations where applicable.
- Develops, tests, and implements scripts/jobs for data Extract Transform and Load (ETL) from data source(s) to target(s) in the data warehouse using ODI.
- Visualizes and designs the enterprise data management framework specifies processes used to plan, acquire, maintain, use, archive, retrieve, control, and purge data.
- Develops physical data model and/or works with data modeler to develop physical data model.
- Develops Testing Approach, Plan, Scripts and Documentation of Results
- Develops and maintains a data catalogue for the enterprise data warehouse.
- Develops and maintains a data dictionary for the enterprise data warehouse.
- Develops Requirements Specifications
- Develops Design Specifications
- Evaluates and monitors databases to resolve performance issues.
- Monitors the EDW and responds to incidents.
- Provides documentation to support the Kimball Dimensional Data Modelling Framework
- Mentors and educates team members on best practices and industry standards.
Qualifications:
Mandatory:
- Staff resource must have a minimum of seven (7) years of verifiable experience in database design and warehouse architecture supportive of key duties/responsibilities identified above.
- Excellent communication and collaboration skills to work effectively with stakeholders and team members.
Desired:
- Certified for "Oracle Autonomous Database Cloud 2021 Certified Specialist" and/or "Oracle Machine Learning using Autonomous Database 2021 Certified Specialist".
- Certified on Oracle Cloud infrastructure 2021 certified architect professional.
- Certified for Oracle data integrator 12C certified implementation specialist.