Job Title: Oracle Datawarehouse Consultant
Location: Andover, UK (Hybrid – 2 days in a week to Onsite)
Job Type: Contract - Outside IR35
Note: Active SC Clearance required
Job Description
- Designed subject areas using RPD (Repository) design in Oracle Analytics.
- Designed, developed, and implemented Oracle Analytics Server (OAS) security including users, roles, and data-level security.
- Designed, developed, and implemented ODI (Oracle Data Integrator) mappings for ETL processes.
- Designed, developed, and implemented Data Warehouse solutions including data modelling and integration.
- Developed and implemented OAS reports and dashboards to support business analytics and reporting needs.
- Provided production support for existing live OAS, ODI, data warehouse objects.
- Analysed and resolved data, ETL, and reporting issues to ensure system stability.
- Performed performance tuning of RPD objects, ODI mappings, queries, and reports.
- Maintained and documented standard processes, procedures, and technical documentation.