Responsibilities:
- Requirements gathering sessions with users and data source subject matter experts.
- Analysis of data sources to determine data relationships to pair with the business requirements documentation (BRD).
- Provide feasibility analysis to requested OBIEE deliverables.
- Data source to staging to target mappings (including documentation of such).
- Data warehouse table design and applicable documentation.
- Design and develop Extract Load Transform (ELT) process to 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 Presentation 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 to 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, Information Technology, or related, or a combination of education and experience equating to the U.S. equivalent of a bachelor’s degree in one of the subjects.