Oracle SCM PL/SQL Technical Lead Consultant

PLSQL Developer

Area(s) of responsibility

Job Title: Technical Lead Consultant - Applications

Location: Noida/Pune/Hyderabad

Experience: 8–10 years

Employment Type: Full-time

 

About the Role:

We are seeking an experienced Oracle SCM Technical Consultant with deep expertise in Oracle Cloud SCM i.e Warehouse Management System (WMS) and Oracle EBS Inventory module or Fusion Cloud Applications modules Procurement, Inventory, Order Management, Warehouse Management. The candidate will primarily focus on developing and maintaining robust PL/SQL-based interfaces and integrations between legacy and modern WMS applications.

PL/SQL Lead Development role including Functional knowledge of Inventory Management, Supply Chain Management i.e Warehouse Management etc.

NOTE: - There is no expectation from candidates to perform EBS forms, reports, UI customizations, or front-end development.

 

Key Responsibilities:

• Develop, enhance, and maintain PL/SQL packages, procedures, and interfaces for data exchange between applications.
• Design and implement efficient SQL queries and scripts to support reporting, data validation, and reconciliation between systems.
• Collaborate with functional teams to understand business requirements related to warehouse operations, inventory management, and integration touchpoints.
• Monitor and troubleshoot interface errors, ensuring timely resolution to minimize operational impact.
• Optimize PL/SQL code and SQL queries for performance and scalability.
• Maintain technical documentation related to interfaces, data mappings, and business rules.
• Willingness and ability to work in rotational shifts including Night Shift or extended hours as per business needs, including nights and weekends when necessary. Its include staggered weekly offs working also.

 

Required Skills & Qualifications:

• Hands-on experience with Oracle E-Business Suite (R12 or latest) Inventory module or Fusion Cloud Applications modules Procurement, Inventory, Order Management, Warehouse Management.
• Strong expertise in PL/SQL and SQL development, including packages, procedures, functions, and complex query optimization.
• In-depth knowledge of Oracle Cloud SCM Warehouse Management System (WMS) processes and integration.
• Experience developing and supporting interfaces between Oracle EBS or Fusion Cloud and Oracle SCM WMS Cloud applications.
• Solid understanding of warehouse operations and inventory management workflows.
• Excellent problem-solving and communication skills.
• Bachelor’s Degree in Computer Science, Information Technology, or related field.

 

Must have Skills (Must have all mentioned below):

• Oracle EBS Inventory or Fusion Cloud Inventory, Order Management, Warehouse Management
• Strong in SQL/PLSQL Development and Support

 

Experience Level

Senior Level