Oracle Technical Consultant

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

Job summary

PwC India invites an experienced Senior Associate to join the Oracle Cloud practice in the Coimbatore region. You will work on Oracle Fusion ERP projects, steering reporting, data integration and security design for clients.

Ideal candidates bring 5–10 years of hands-on Oracle Cloud experience, strong SQL, OTBI and OIC skills, and the ability to mentor juniors while delivering high-quality solutions within client teams.

Qualifications

• Oracle Cloud ERP experience with 5–10 years overall.
• Strong OTBI, BIP and Hyperion reporting skills in Fusion.
• Hands-on with OIC integrations and SQL/PLSQL proficiency.
• Experience with APEX/JCS/VBCS and FBDI/ADFDI templates.
• Knowledge of Oracle Cloud security, user provisioning and roles.

Responsibilities

• Work as a SME to solve complex business issues from strategy to execution.
• Design, develop and maintain Oracle Cloud solutions including OTBI, BIP and Hyperion reporting.
• Lead integrations using OIC and ensure data integrity across systems.
• Write robust SQL/PLSQL and develop interfaces via Web Services.
• Collaborate with clients, mentor juniors and ensure SLA adherence.

Skills

OTBI Reporting

BIP Reporting

Hyperion FRS Reporting

OIC

SQL

PL/SQL

APEX/JCS/VBCS

FBDI

ADFDI

Web Services (SOAP/REST)

Oracle Fusion

Education

CA

MBA

BE/B.Tech

ME/M.Tech

B.SC

B.Com

BBA

Tools

OTBI Reporting

BIP Reporting

Hyperion FRS

OIC

SQL

PL/SQL

Apex/JCS/VBCS

FBDI/ADFDI

Web Services SOAP/REST

Job description

Role / Job TitleSenior Associate TowerOracle Experience5 - 10 years Key SkillsTech BIP_OTBI _OIC Educational QualificationCA/MBA/BE/B.Tech/ME/M.Tech/B.SC/B.Com/BBA As an Experienced 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:

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