Oracle Data Warehouse

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.