Oracle Data Warehouse

Oracle Data Warehouse

Posted 1 day ago by Qualient Technology Solutions UK Limited

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

Summary: The role of Oracle Data Warehouse involves designing and implementing data solutions using Oracle Analytics and Oracle Data Integrator. Key responsibilities include developing security measures, ETL processes, and reports to support business analytics. The position also requires providing production support and resolving data-related issues to ensure system stability. Performance tuning and documentation of processes are essential components of the job.

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 Oracle Data Integrator.
  • Knowledge of data warehousing concepts and ETL processes.
  • Ability to design and implement security measures in analytics environments.
  • Strong analytical and problem-solving skills.
  • Experience in performance tuning of data processes.
  • Proficient in documentation and maintaining technical standards.

Salary (Rate): undetermined

City: Andover

Country: UK

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: Other

Job Description:

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