About the Role :

We are seeking an experienced Oracle SCM Technical Consultant with strong expertise in Oracle Cloud SCM, Warehouse Management System (WMS), and the Oracle EBS Inventory module.

The role focuses on PL/SQL-based interface development and integrations between legacy and modern WMS applications.

This is a lead PL/SQL development role that also requires functional knowledge of Supply Chain Management, Inventory Management, and Warehouse Management.

Note : There is no requirement for EBS forms, reports, UI customizations, or front-end development.

Key Responsibilities :

- Develop, enhance, and maintain PL/SQL packages, procedures, and interfaces for seamless data exchange between applications.

- Design and implement efficient SQL queries and scripts for reporting, data validation, and reconciliation.

- Collaborate with functional teams to understand 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 including interface designs, data mappings, and business rules.

- Be willing and able to work in rotational shifts, including night shifts or extended hours as required by business operations.

Required Skills & Qualifications :

- Hands-on experience with Oracle E-Business Suite (R12 or later) or Fusion Cloud Applications in modules such as Procurement, Inventory, Order Management, and 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 integrations.

- Proven experience in developing and supporting interfaces between Oracle EBS/Fusion Cloud and Oracle SCM WMS Cloud applications.

- Solid understanding of warehouse operations and inventory workflows.

- Excellent problem-solving and communication skills.

- Bachelors Degree in Computer Science, Information Technology, or a related field.

Must-Have Skills :

- Oracle EBS Inventory or Fusion Cloud Inventory, Order Management, Warehouse Management

- Strong SQL/PLSQL development and support expertise