Technical Consultant (Tech - OIC, ATP, PLSQL, APEX)

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

Job summary

PwC India is seeking an Experienced Associate to join our Oracle Cloud and ERP practice in Coimbatore. You will leverage your 5-8 years of experience to design and implement Oracle Cloud solutions, including OTBI, BIP reports, and Hyperion components.

You will collaborate with teams to translate business requirements into technical solutions, develop SQL/PLSQL, and support integration using OIC. The role also involves client interaction and mentoring junior team members.

Qualifications

• Experience in Oracle Cloud applications or ERP.
• Strong knowledge of OTBI, BIP Reporting and Hyperion FRS/Smart View.

Responsibilities

• Work as part of a team to solve complex business issues from strategy to execution.
• Proficiency in SQL/PLSQL, ATP programming and data integration.
• Experience with Oracle Fusion security, user provisioning, and role management.
• Ability to engage with clients and cross-functional teams while delivering quality outputs.
• Mentor junior resources and support knowledge sharing.

Skills

SQL

ATP

APEX

OIC

BIP

Education

BE / BTech / ME / MTech / BSc

Tools

OTBI Reporting

BIP Reporting

Hyperion FRS Reporting/Smart View

Oracle Fusion

OIC

Job description

Role / Job Title

Exp Associate

Tower Oracle

Experience 5 - 8 years

Key Skills SQL, ATP, APEX, OIC, BIP

Educational Qualification BE / B Tech / ME / M Tech / BSc

Work Location India

Job Description

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, ATP 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.

Managed Services - Application Evolution Services

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.