Oracle Data Warehouse Consultant - Active SC Mandatory

Oracle Data Warehouse Consultant - Active SC Mandatory

Posted Today by Infoplus Technologies UK Ltd

Apply
Negotiable
Outside
Undetermined
London, UK
Apply
Business Analytics Data Warehousing Extract Transform Load (ETL) File Servers Performance Tuning

Summary: The Oracle Data Warehouse Consultant role involves designing and implementing Oracle Analytics and Data Warehouse solutions, with a focus on security, ETL processes, and performance tuning. The position requires providing production support and resolving data-related issues to ensure system stability. The consultant will also maintain documentation of standard processes and procedures. This role is classified as outside IR35.

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

Key Skills:

  • Experience with Oracle Analytics and Data Warehouse solutions.
  • Proficiency in ODI (Oracle Data Integrator) for ETL processes.
  • Knowledge of RPD (Repository) design and security implementation.
  • Ability to perform performance tuning of data processes.
  • Strong analytical skills for resolving data and reporting issues.
  • Experience in maintaining technical documentation.

Salary (Rate): undetermined

City: London

Country: UK

Working Arrangements: undetermined

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Job spec - Outside IR35

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.
Apply
Similar Jobs
Loading data...