Senior Associate - Oracle Technical (OTBI/BIP/OIC)

PwC; Coimbatore District; Hybrid; INR 1,500,000 - 2,100,000; Full time

Job summary

PwC India in Coimbatore district seeks an Oracle ERP SME to lead complex integrations and optimize Fusion modules. You will mentor juniors, ensure SLA adherence, and collaborate with clients across functions.

The role requires strong SQL/PLSQL, security/roles management, web services interfaces, and Oracle Analytics experience. You will engage in incident/change/problem management while delivering robust solutions.

Qualifications

• Experience with Oracle Fusion modules and ERP implementations.
• Strong reporting skills in OTBI, BIP, and Hyperion FRS.
• Proven ability to design, code and document Oracle integrations and interfaces.

Responsibilities

• Handle Oracle Cloud ERP configurations and complex integrations.
• Develop and maintain OTBI/BIP reports and analytics solutions.
• Write efficient SQL/PLSQL queries; support data loads and migrations.
• Work with OIC, Web Services, and Oracle Fox interfaces.
• Guide security/roles, user provisioning and access controls.
• Mentor junior resources; conduct knowledge sharing sessions.
• Ensure adherence to SLAs and participate in incident/change/problem mgmt.
• Collaborate with clients and cross‑functional teams for requirements.
• Document designs, processes, and best practices.

Skills

Oracle Cloud ERP

OTBI & BIP Reporting

Hyperion FRS Reporting

OIC & Integrations

SQL & PLSQL

APEX/JCS/VBCS

FBDI/ADFdi templates

Security & Roles

Web Services (SOAP/REST)

Oracle Analytics

Coding & Debugging

Documentation

Client interaction

Job description

Role & responsibilities

• At least 2 to 5 years of experience of Oracle Cloud applications or ERP.
• Strong technical skills around OTBI Reporting, BIP Reporting, Hyperion FRS Reporting/Smart View in Oracle Fusion.
• Should be well experienced with OIC and orchestrating complex integrations.
• Strong experience in writing SQL Queries and PLSQL Programming.
• Experience in working on APEX/JCS/VBCS is preferable.
• Expertise in using FBDI and ADFDI templates in Oracle.
• Good Knowledge on Security and Roles in Oracle fusion including User Provisioning, Custom Role Creation and identifying privileges.
• Expertise in using Web-Services (SOAP/REST) to build interfaces, load or manage transactions.
• Good knowledge of Oracle Cloud Architecture, Standards, Table structure.
• Should have a good knowledge of Oracle processes - Financials/Procurement/SCM/Projects.
• Should have very good knowledge of Coding, Debugging and Design and Documentation.
• Able to understand and analyze customer business processes and Functional Specification.
• Good communication skills and ability to interact with external teams or clients.
• Good to have knowledge on Oracle Analytics.
• Use feedback and reflection to develop self-awareness, personal strengths and address development areas.
• Proven track record as an SME in chosen domain.
• 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.
• Seek and embrace opportunities which give exposure to different situations, environments and perspectives.
• Able to read situations and modify behavior to build quality relationships.
• Uphold the firm's code of ethics and business conduct.
• Work in a team environment that includes client interactions, workstream management, and cross-team collaboration.