OAS Developer || OAS+SQL+PLSQL || 4-6Yrs || Hyderabad
Core
Designing, developing, and maintaining scalable BI solutions using Oracle Analytics Server (OAS) to ensure high performance and meaningful business insights.
Role type
Senior IC Oracle Analytics Server (OAS) Developer
Builds
Semantic models (RPD), reports, dashboards, and visualizations for business stakeholders
Domain
Data Warehousing and Business Intelligence
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Oracle Analytics Server (OAS) / OBIEE development, RPD development and metadata modeling, SQL and PL/SQL, Data Warehousing concepts (Star/Snowflake schema), logical dimensions and hierarchies, data security implementation (session variables, filters), ETL tool basics (Informatica), KPI development
Preferred skills
Oracle Analytics Cloud (OAC) familiarity, advanced ETL process exposure
Technologies
Oracle Analytics Server, Oracle BI, Informatica, SQL Server, Oracle DB
Responsibilities
Design and develop semantic models (RPD) including Physical, Business Model, and Presentation layers; Create and maintain subject areas, hierarchies, logical dimensions, and KPIs; Develop reports, dashboards, and visualizations using OAS / Oracle BI tools; Implement data security (row-level, object-level, data filters) using session variables; Perform query optimization and performance tuning in OAS; Work on data integration from multiple sources such as Oracle DB, SQL Server, flat files; Manage fact and dimension tables, joins, and ensure proper star schema design; Develop and maintain logical calculations, aggregations, and KPIs; Design and implement security configurations and application roles; Troubleshoot and resolve data, performance, and reporting issues; Collaborate with stakeholders to gather and translate business requirements; Support UAT, deployments, and production issues