EY Jobs

Job Information

EY EA-Oracle Analytics Cloud- Senior in Bangalore, India

EA-Oracle Analytics Cloud- Senior


Requisition # BLR00B2M

Post Date May 31, 2021

Oracle Analytics Cloud Job Description

The candidate should have:

  • Expertise in Oracles analytics offerings: Oracle Analytics Cloud, Data Visualization, Machine Learning, Essbase, OBIEE, Fusion Analytics for Warehouse

  • Have solution design skills to provide expertise and guide customers for specific needs.

  • Be extremely hands on with Analytics and Data Warehousing report/solution development.

  • Deliver PoCs tailored to customers needs.

  • Run and Deliver Customer Hands on Workshops.

  • Interact with all roles at customer, including Executives, Architects, technical staff and business representatives.

  • Building Effective Relationships, Customer Focus, Effective Communication and Coaching

Key Skills

  • Primary focus on developing customer solutions using Oracles analytics offerings: Oracle Analytics Cloud, Oracle Data Visualization, Fusion Analytics for Warehouse, OBIEE, OBIA, Machine Learning and Autonomous Data warehouse (ADW).

  • Experience in requirement gathering, solution blueprint, performing fit gap analysis, Business process design.

  • Experience to translate business analyst requirements into analytics metadata.

  • Must have extensive hands on/end to end implementation experience using OAC/OBIEE and BI Publisher.

  • Must possess solid knowledge on OBIEE RPD design, development & deployment

  • Must have experience in designing customized interactive dashboards and reports in OBIEE using drill down, prompts, filters, and variables.

  • Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the use experience.

  • Experience in configuring OBIEE /OACS security (Authentication and Authorization – Object level and Data level security).

  • Experience in working with session and repository variable and initialization blocks to streamline administrative tasks and modify metadata content dynamically.

  • Experience on working with report performance optimization.

  • Experience in developing Dimensional Hierarchies and adding multiple sources to business model objects.

  • Possess skills to creating and scheduling iBots and Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.

  • Expertise in developing Logical Data Model (Business Model), Metadata and reports including logical columns, aliases, hierarchies, and subject areas.

  • Experience in writing complex queries, Stored Procedures in Oracle SQL and Oracle PL/SQL

  • Determine requirements for aggregate tables, hierarchies, level-based measures etc

  • Deep understanding of dimensional data modelling techniques

  • Good Knowledge of data warehouse concepts, Dimensions and fact tables, Slowly changing Dimensions (Type1,Type2,type3 etc.)

  • Experience on OBIEE rpd deployment and report migration.

  • Good knowledge of Oracle Applications – Oracle E-business Suite or Oracle ERP, Oracle HCM (the Oracle cloud SaaS offering) is preferable.

  • Deep knowledge of Database, Cloud Concepts, Autonomous Data warehouse (ADW), Data Integration tools such as ODI, Informatica etc is an added advantage.

  • Knowledge or awareness of Power BI/Tableau/ML is a plus.


6-12 years of Data warehousing and Business Intelligence projects experience.