Job Overview

job responsibilities

• design develop and implement oracle analytics dashboards reports and data visualization.
• develop and maintain the rpd model, ensuring efficient query performance and scalability.
• optimize query performance by applying best practices in data modelling and report development.
• work closely with business stakeholder to gather and analyse reporting requirements.
• implement security configuration (object-level, row level and role-based security.
• integrate oas/oac with multiple data sources and ensure seamless data flow.
• develop and enhance data preparation, transformation and analytics workflows.
• support troubleshooting and performance tuning of oas/oac report and dashboard.

mandatory skills:

• 7+ years of experience in oas
• strong expertise in oracle analytics server (oas) or oracle analytics cloud (oac)
• proficiency in obiee (oracle business intelligence enterprise edition)
• experience in developing interactive dashboards, report and data visualizations.
• strong understanding of building rpd (repository development)- physical, business model and presentation layers.
• expertise in data modelling, performance tuning and metadata management.
• experience in working with oracle sql, pl/sql and database optimization techniques.
• hands-on experience in data blending and data preparation.
• knowledge of security and access control (row level security, object level security)
• experience integrating oas/oac with various data sources such as oracle databases, cloud data sources and api's
• proficiency in bi publisher for developing pixel-perfect reports.
• preferable to have experience in banking and financial services industry.