OAS Developer || OAS+SQL+PLSQL || 4-6Yrs || Hyderabad
WNS Global Services · Hyderabad, TG, India
Apply directly on WNS Global Services’s careers site — no account needed.
About the role
We are seeking a skilled Oracle Analytics Server (OAS) Developer with strong expertise in data modeling, BI reporting, and analytics. The candidate will be responsible for designing, developing, and maintaining scalable BI solutions using OAS, ensuring high performance, data accuracy, and meaningful business insights.
Key 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, etc.
- 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
Required Skills:
- Strong experience in Oracle Analytics Server (OAS) / OBIEE
- Expertise in RPD development and metadata modeling
- Strong knowledge of SQL and PL/SQL (queries, procedures, performance tuning)
- Good understanding of Data Warehousing concepts (Star/Snowflake schema)
- Hands-on experience in logical dimensions, hierarchies, and level-based measures
- Experience in security implementation (session variables, filters)
- Basic knowledge of ETL tools, especially Informatica (workflows, mappings, data flow concepts)
- Experience in KPI development and dashboard reporting
- Strong analytical and problem-solving skills
Preferred Qualifications:
- Bachelor’s degree in Computer Science, IT, or related field
- 3–8 years of experience in BI / OAS / OBIEE development
- Familiarity with Oracle Analytics Cloud (OAC) is a plus
- Exposure to data integration and ETL processes
Key Competencies:
- Strong communication and stakeholder management
- Attention to detail and data accuracy
- Ability to handle multiple priorities and deadlines
- Team collaboration and ownership mindset
B Tec / Degree
Skills
- SQL
Never be applicant #200 again
Every job here is indexed straight from company career pages — often hours after it opens, before it reaches the big boards. Create a free account and get your best matches in a twice-daily digest.
- Your best matches, twice a day
- No duplicates, no ghost jobs, no recruiter spam
- Every job free to browse — pay only when you apply
Free account — no card required
93 111 live jobs · 17 642 companies tracked · 241 added today