Oracle Consultant

WNS; Pune District; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

WNS is seeking an experienced Senior Oracle Apps Technical Consultant in Pune to design, develop, and support Oracle E-Business Suite applications. You will work with cross‑functional teams to translate business needs into robust technical solutions and ensure high-quality deliverables.

The role focuses on PL/SQL, Oracle Forms, Reports, OAF, Workflow, and BI Publisher, along with RICE components. Strong debugging, issue resolution, and production support are essential, as is clear communication

Qualifications

• Strong experience in Oracle E-Business Suite Technical Development.
• Expertise in PL/SQL, Forms, Reports, OAF, Workflow, and BI Publisher.
• Experience with RICE components and Oracle EBS architecture.
• Ability to convert functional requirements into technical specifications.
• Strong debugging, problem-solving, and production support skills.
• Excellent communication and ability to collaborate with cross-functional teams.

Responsibilities

• Develop, customize, and maintain Oracle EBS applications using PL/SQL, Reports, Interfaces, Conversions, Extensions (RICE).
• Work with functional consultants and business users to understand requirements and prepare technical solutions.
• Design, develop, and support Oracle Forms, OAF, Workflows, and BI Publisher reports.
• Implement inbound/outbound interfaces with external systems and perform performance tuning, troubleshooting, root cause analysis, and bug fixing.
• Provide technical support for patches, migrations, and production support.
• Prepare and maintain technical documentation including unit test cases.

Skills

Oracle EBS Technical Development

PL/SQL

Oracle Forms

Oracle Reports

OAF

Workflow

BI Publisher

RICE components

Job description

We are looking for an experienced Senior Oracle Apps Technical Consultant with strong technical skills and a good understanding of Oracle Applications (Oracle E-Business Suite). The candidate should have excellent communication skills and the ability to collaborate effectively with functional teams, technical teams, and business users to deliver reliable and high-quality solutions.

Key Responsibilities

• Develop, customize, and maintain Oracle E-Business Suite (EBS) applications using:
• PL/SQL
• Oracle Reports
• Interfaces
• Conversions
• Extensions (RICE components)
• Work closely with functional consultants and business users to:
• Understand business requirements
• Prepare technical solutions
• Convert functional requirements into technical specifications
• Provide technical support and solutions for various Oracle Application modules.
• Design, develop, and support:
• Oracle Forms
• Oracle Application Framework (OAF)
• Oracle Workflows
• BI Publisher Reports
• Inbound and outbound interfaces with external systems
• Perform:
• Performance tuning
• Root cause analysis
• Troubleshooting
• Bug fixing for existing customizations
• Support Oracle EBS:
• Patches
• Migration activities
• Production support
• Prepare and maintain technical documentation, including:
• Unit test cases

Required Skills

• Strong experience in Oracle E-Business Suite Technical Development
• Excellent knowledge of PL/SQL, Forms, Reports, OAF, Workflow, and BI Publisher
• Experience with RICE components
• Good understanding of Oracle EBS architecture and modules
• Strong debugging and problem-solving skills
• Ability to work independently and collaborate with cross-functional teams
• Good verbal and written communication skills