Description
Main Responsibilities:
Check overnight ETL, and investigate and fix any failures
Maintain ETL Schedules and Execution Plans
Monitor availability of all OBIEE services (presentation and BI Servers) and work with DBAs to resolve any issues
Monitor user requests (via RPD, Session Manager) and work with DBAs and users to resolve any issues (failures and performance issues)
Monitor Serena Incident inbox, investigate any problems that arise, resolve and inform users where appropriate. Create a plan to fix problem where there is a real issue.
Investigate and fix corrupt OBIEE data as identified by the customer via Serena Incident or highlighted during ETL processing.
Develop and Unit Test fixes to problems. This may involve corrections/upgrades in Informatica, DAC, Database, RPD and Webcat and document as appropriate.
Independently test other team members' development work and document as appropriate.
Maintain the OBIEE configuration. Raising appropriate change documents and ensuring the Dimensions Baseline is maintained with the current version of all configurable items.
Documentation - Create and update release documentation as appropriate. Create and update work instructions as required.
Resolve any defects identified in Testing phases - either raised within the team or by the System Test, Regression Test or Performance Test Teams
Create and submit implementation documentation - gaining all necessary permissions and ensuring relevant Dimensions work has been complete for specific release.
Candidates must hold live SC Clearance