Obiee/oac- Staff/senior Job in Acz Global Pvt Ltd

Roles and Responsibilities

The candidate should have:

• Expertise in Oracle's 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 Oracle's 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/OBIEEand 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 configuringOBIEE/OACS security (Authentication and Authorization Objectlevel 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.

Experience

• 3-8 years of Data warehousing and Business Intelligence projects experience.

Education-

UG:Any Graduate in Any Specialization

PG:Post Graduation Not Required

Doctorate:Doctorate Not Required