- Analyze data sources and determine data relationships to pair with the business requirements documentation (BRD).
- Provide feasibility analysis to requested OBIEE deliverables.
- Design Data warehouse table and applicable documentation.
- Develop table creation scripts and execute the scripts for the Database Administrator (DBA)
- Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI).
- Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis.
- Design and develop the Physical, Business Model & Mapping (BMM) and Present layers of the OBIEE repository (RPD).
- Design and develop Reports and Dashboards as outlined in the Business Requirements Document.
- Design and develop reports utilizing materialized views and facilitate acceptable performance of navigation and drill down capabilities within reports.
- Provide applicable knowledge transfer to both business users and technical support staff as applicable throughout the life of the engagement (Including documentation for the knowledge transfers).
- Provide weekly status updates to the project management.
Degree Requirement: Bachelor’s degree in computer science, computer information systems, information technology, a closely related field, or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.