Oracle Bi Lead Job in Sam Manpower And Career Services Llp

Your Key Responsibilities:

Deep expertise in Oracle BI & analytics offerings: Fusion Analytics Warehouse (FAW), Oracle Analytics Cloud (OAC), Oracle Data Integrator Market Place(ODICS), Oracle Autonomous Datawarehouse(ADW) , BI Publisher , Oracle Transactional BI (OTBI) etc.

Deliver high quality client solutions that meet and exceed client and organization s expectations and are delivered on-time and on-budget.

Manage client solution delivery, including defining project approach, leading and motivating project teams, monitoring and managing project risks, managing client and HCL key stakeholders, and successfully delivering client solutions.

Identifying new business opportunities, including building strong client relations, understanding client needs and HCL solution offerings, communicating client opportunities to HCL leadership, and helping develop client opportunities.

Skills And Attributes For Success:

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

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.

Experience on OBIEE rpd deployment and report migration.

Experience on ETL tools like Oracle Data Integrator.

To qualify for the role, you must have:

Minimum of 5 years of consulting experience in OBIEE/OACS/FAW/ODI and SQL.

Overall, 5-7 years of industry experiences with sound knowledge of Business Intelligence & Data warehousing.