Role: Oracle Analytics Server Developer.
Exp: Mid-level
Onsite, India, Hyderabad location
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 environments.
- 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)
