Oracle FIN Reporting Developer (OTBI/BIP/FRS/FAW)

PwC; Coimbatore District; Hybrid; INR 800,000 - 1,400,000; Full time

Job summary

PwC India is seeking an experienced Exp. Sr. Associate to work on Oracle Analytics Cloud platforms, FAW/OTBI/FRS/BIP. You will handle data modeling, reporting, and migration tasks within a high-paced analytics practice.

You will join a team that solves complex business problems, building dashboards and analytics solutions for clients, while mentoring junior staff and ensuring delivery excellence.

Qualifications

• Minimum 2 years of experience on Oracle's Cloud analytics platforms FAW/OTBI/FRS/BIP or FAW.
• Strong hands-on expertise in OAC analytics, visualization, and semantic modeling.
• Experience migrating OBIEE to OAC and between OAC instances.
• Good understanding of Data Warehouse concepts and modeling.
• Hands-on SQL knowledge and ability to troubleshoot report errors.

Responsibilities

• Work as part of a problem-solving team to address complex business issues from strategy to execution.
• Develop and test reports and dashboards in OAC using measures, filters, and calculated items.
• Support migrations between OBIEE/OAC and across OAC instances.
• Model data warehouses and optimize data flows between ERP and data warehouse.
• Mentor junior resources and participate in knowledge sharing.

Skills

FAW/OTBI/FRS/BIP

OAC analytics/visualization

SQL

Data warehouse concepts

OBIEE to OAC migration

RPD modeling

ETL tools

PL/SQL

Essbase/Multidimensional sources

Education

BE / B Tech / ME / M Tech / BSc / BCom / BBA

Tools

OBIEE

OAC

FAW

OTBI

FRS

BIP

SQL

ODI

PL/SQL

ETL Tools

Essbase

Job description

Role / Job Title

Exp. Sr . Associate
Tower
Oracle
Exp : 5 years
Key Skills
FAW/OTBI/FRS/BIP
Educational Qualification
BE / B Tech / ME / M Tech / B.SC / B. Com / BBA
Work Location
India

Job Description

As an Senior Associate, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. PwC Professional skills and responsibilities for this management level include but are not limited to:

• Minimum 2 years of experience on Oracle's Cloud-based analytics platforms including FAW/OTBI/FRS/BIP and/or FAW.
• Strong hands-on expertise in OAC including Analytics, Data Visualization, and Semantic Model Development.
• Very good development experience in OAC-Reports and dashboards using measures, Filters, calculated measures, calculated items etc Must be able to do Report testing process
• Experience migrating from OBIEE to OAC.
• Experience migrating between OAC Instances.
• Very Good Understanding of DatawareHousing Concepts and Data Warehouse modeling.
• Thorough handson experience on SQL(on any RDBMS Source).
• Able to troubleshoot report errors and issues on OAC.
• Hands On knowledge on Building, Analysis and visualizations based on Datasets created using SQL or Excel Data Sources.
• Good Knowledge on RPD Modeling and Usage of Data modelers on OAC.
• Able to troubleshoot report errors and issues on OBIEE/OAC and understand the tool limitations for OAC.
• Should have experience in performance tuning OAC Analysis, this includes analyzing the Explain Plan of the query, tuning the data model as well as making modifications to the tables such as indexing.
• Should have good knowledge of Coding, Debugging and Design and Documentation.
• Understanding of the flow of data between ERP and Data Warehouse.
• Preferable to Model and Build BI Publisher Reports.
• Any knowledge on PLSQL/ODI/Any ETL Tool would be preferable.
• Working on Multidimensional sources (like Essbase) is a plus.
• Any work on OTBI will be a plus.
• Expertise on the Oracle Analytics Cloud Tool Knowledge on BIApps concepts is preferable.
• Familiar with Upgrade activities and Issues encountered during Upgrade from OBIEE to OAC.
• Expertise in SQl/Knowledge of any ETL tool is preferable.
• Knowledge on FAW (ERP and SCM)/ADW/OAC (Classic, Data Visualization, Semantic Model Development)/ODI is plus.
• Use feedback and reflection to develop self-awareness, personal strengths and address development areas.
• Proven track record as an SME in chosen domain.
• Ability to come up with Client POC/POV for integrating/increasing adoption of emerging Tech. like BlockChain, AI et al with the product platform they are associated with.
• Mentor Junior resources within the team, conduct KSS and lessons learnt.
• Flexible to work in stretch opportunities/assignments.
• Demonstrate critical thinking and the ability to bring order to unstructured problems.
• Ticket Quality and deliverables review.

• Adherence to SLAs, experience in incident management, change management and problem management.
• Know how and when to use tools available for a given situation and can explain the reasons for this choice.
• Use straightforward communication, in a structured way, when influencing and connecting with others.
• Able to read situations and modify behavior to build quality relationships.
• Uphold the firm's code of ethics and business conduct..

Managed Services - Application Evolution Services

At PwC we relentlessly focus on working with our clients to bring the power of technology and humans together and create simple, yet powerful solutions. We imagine a day when our clients can simply focus on their business knowing that they have a trusted partner for their IT needs. Everyday we are motivated and passionate about making our clients better.

Within our Managed Services platform, PwC delivers integrated services and solutions that are grounded in deep industry experience and powered by the talent that you would expect from the PwC brand. The PwC Managed Services platform delivers scalable solutions that add greater value to our clients enterprise through technology and human-enabled experiences. Our team of highly-skilled and trained global professionals, combined with the use of the latest advancements in technology and process, allows us to provide effective and efficient outcomes. With PwCs Managed Services our clients are able to focus on accelerating their priorities, including optimizing operations and accelerating outcomes. PwC brings a consultative first approach to operations, leveraging our deep industry insights combined with world class talent and assets to enable transformational journeys that drive sustained client outcomes. Our clients need flexible access to world class business and technology capabilities that keep pace with todays dynamic business environment.

Within our global Managed Services platform, we provide Application Evolution Services (formerly Application Managed Services), where we focus more so on the evolution of our clients applications and cloud portfolio. Our focus is to empower our clients to navigate and capture the value of their application portfolio while cost-effectively operating and protecting their solutions. We do this so that our clients can focus on what matters most to your business: accelerating growth that is dynamic, efficient and cost-effective.

As a member of our Application Evolution Services (AES) team, we are looking for candidates who thrive working in a high-paced work environment capable of working on a mix of critical Application Evolution Service offerings and engagement including help desk support, enhancement and optimization work, as well as strategic roadmap and advisory level work. It will also be key to lend experience and effort in helping win and support customer engagements from not only a technical perspective, but also a relationship perspective.