Title: PLSQL Developer
Area(s) of responsibility
About the Role:
We are seeking an experienced Oracle SCM Technical Consultant with deep expertise in Oracle Cloud SCM, Warehouse Management System (WMS) and Oracle EBS Inventory module. The candidate will primarily focus on developing and maintaining robust PL/SQL-based interfaces and integrations between legacy and modern WMS applications.
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.
- Work in rotational shifts including Night Shift or extended hours as per business needs, including nights and weekends when necessary, staggered weekly offs.