Senior Oracle Apps EBS Technical Consultant Lead Development

WNS Holdings; Hyderabad, Pune District, Gurugram District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

WNS Holdings is seeking an experienced Oracle Apps EBS Technical Consultant Lead to design, develop, and maintain Oracle EBS customizations and interfaces. The role focuses on D2K Forms & Reports with mandatory Workflow or OAF integration, plus PL/SQL development and BI Publisher.

You will collaborate with functional teams to translate requirements into scalable technical solutions, support upgrades and migrations, and contribute to production support and performance improvements.

Qualifications

• D2K Forms & Reports experience is mandatory.
• Experience with Oracle Workflow or OAF is mandatory.
• Strong PL/SQL development skills.
• Experience with BI Publisher and RICE components preferred.
• Familiarity with Oracle APIs and concurrent programs.
• Ability to tune performance and troubleshoot issues.
• Experience in production support, upgrades and migrations.

Responsibilities

• Design, develop, and maintain Oracle EBS customizations and extensions.
• Develop PL/SQL packages, procedures, functions, forms, reports, and interfaces.
• Build and support OAF, Workflow, and BI Publisher solutions.
• Collaborate with functional teams to translate requirements into technical solutions.
• Develop and support integrations with external applications.
• Perform troubleshooting, root cause analysis, and performance optimization.
• Support Oracle EBS upgrades, patching, migrations, and production activities.
• Prepare technical design documents, test cases, and deployment documentation.

Skills

D2K Forms & Reports

Workflow

OAF

PL/SQL Development

BI Publisher

RICE Components

Oracle APIs & Concurrent Programs

Performance Tuning

Production Support

Tools

BI Publisher

Job description

Job Summary:

We are seeking an experienced Oracle Apps EBS Technical Consultant with strong expertise in Oracle EBS development, customization, and support. The candidate will work closely with functional teams and business stakeholders to deliver scalable and high-quality technical solutions.

Position Details:

Role: Senior Oracle Apps EBS Technical Consultant Lead Development

• Consultant & Senior Consultant: 2 to 8 Years
• Lead / Manager: 8 to 12 Years

Locations: Pune | Hyderabad | Mumbai | Gurgaon

Mandatory Skill Requirements

Candidates must have experience in:

Oracle D2K (Forms & Reports) - Mandatory
AND
Either Oracle Workflow or Oracle Application Framework (OAF) - Mandatory

Required Combination: Along with other required skill as mentioned

• D2K + Workflow, OR
• D2K + OAF

Key Technical Skills

• Oracle E-Business Suite (EBS) Technical Development
• Oracle D2K (Forms & Reports) - Mandatory
• Oracle Workflow or OAF - Mandatory
• PL/SQL Development
• BI Publisher
• RICE Components (Reports, Interfaces, Conversions, Extensions)
• Oracle APIs & Concurrent Programs
• Performance Tuning & Troubleshooting
• Production Support, Upgrades & Migrations

Key Responsibilities

• Design, develop, and maintain Oracle EBS customizations and extensions.
• Develop PL/SQL packages, procedures, functions, Forms, Reports, and Interfaces.
• Build and support OAF, Workflow, and BI Publisher solutions.
• Collaborate with functional consultants and business teams to translate requirements into technical solutions.
• Develop and support integrations with external applications.
• Perform troubleshooting, root cause analysis, and performance optimization.
• Support Oracle EBS upgrades, patching, migrations, and production activities.
• Prepare technical design documents, test cases, and deployment documentation.

Required Experience

• Strong experience in Oracle EBS Technical Development.
• Expertise in D2K Forms & Reports along with Workflow or OAF.
• Experience with PL/SQL, BI Publisher, and RICE components.
• Good understanding of Oracle EBS architecture and modules.
• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management capabilities.