Oracle Analytics/Oracle Data Warehouse Developer; Government, SC, OAS, ODI, ETL

Rate: £450 per day, Outside IR35. Location: Andover - 2 days per week onsite

Key skills:

• Oracle Analytics Server (OAS)
• RPD repository development
• Oracle Data Integrator (ODI)
• Data warehouse design and data modelling
• ETL development
• OAS reports and dashboards

Responsibilities

• 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.