Typical Job Duties
Develop and maintain OAS dashboards, reports, analyses, and KPIs.
Design and maintain the RPD (Repository), including:
o Physical layer
o Business Model and Mapping (BMM) layer
o Presentation layer
Create and manage subject areas, hierarchies, logical dimensions, and measures.
Write and optimize SQL and PL/SQL queries for reporting.
Develop BI Publisher reports and pixel-perfect reports where required.
Build data visualizations using Oracle Data Visualization (DV).
Implement security such as application roles, row-level security, and session variables.
Optimize report performance through query tuning, caching, and aggregate tables.
Perform deployment and migration across Development, UAT, and Production settings.
Troubleshoot report failures, performance issues, and data discrepancies.
Collaborate with business stakeholders to gather reporting requirements
Work Location: Hybrid remote in Hyderabad, Telangana (Hyderabad, Hyderabad District)