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
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.