Oracle Fusion Hcm Technical Consultant

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

Job summary

PwC in Coimbatore is seeking a skilled Oracle Cloud ERP professional with 2-5 years of hands-on experience to join our delivery team. You will work on Oracle Cloud ERP implementations, build OTBI/BIP reports, and develop integrations using OIC, SQL/PLSQL, and Fusion security configurations.

You will collaborate with clients, document functional specs, and mentor junior team members while delivering high-quality solutions within SLAs. Prior experience with Oracle Analytics is a plus.

Qualifications

• Experience with Oracle Cloud ERP implementations and integrations.
• Strong SQL and PL/SQL development skills.
• Experience with Oracle Fusion security, provisioning, and role management.
• Proficient in OTBI, BIP, Hyperion FRS and Smart View.
• Knowledge of OIC and integrating complex flows.
• Familiarity with APEX/JCS/VBCS is a plus.
• Experience with FBDI and ADFDI templates.
• Web services (SOAP/REST) experience for interfaces.
• Knowledge of Oracle Analytics is beneficial.
• Strong analytical, design, documentation and client interaction skills.

Responsibilities

• Implement and support Oracle Cloud ERP solutions for clients.
• Develop and optimize OTBI/BIP reports and Hyperion FRS/Smart View artifacts.
• Configure OIC integrations and monitor data loads.
• Write efficient SQL/PLSQL to support processes.
• Engage with clients to understand business requirements and produce functional specs.
• Mentor junior resources and participate in knowledge sharing.
• Ensure quality of deliverables and adherence to SLAs.

Skills

Oracle ERP

OTBI Reporting

BIP Reporting

Hyperion FRS

Smart View

OIC

SQL

PL/SQL

APEX

JCS

VBCS

FBDI

ADFDI

Security Roles

Web Services

Oracle Analytics

Design & Documentation

Requirements Analysis

Stakeholder Communication

Mentoring

Job description

Job Location: Coimbatore

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