Sr. Technical Consultant - Oracle Supply Chain - WMS/MSCA

Job Role: Sr. Technical Consultant - Oracle Supply Chain - WMS/MSCA
Shift: Rotational/24x7 support, including on-call, weekend, and release coverage as required
Work Mode: Hybrid
Relevant Exp: 9+ Years

Job Description:

Role Summary
We are seeking an Oracle EBS WMS Technical Consultant to design, develop, customize, and support robust Oracle WMS solutions. The role requires strong Oracle EBS technical expertise, hands-on MSCA customization experience, and the ability to translate functional requirements into scalable, secure, and supportable technical components.

Key Responsibilities
Analyze existing Oracle WMS custom programs, interfaces, and integrations; modify or develop new components as required.
Design, develop, test, deploy, and support RICEW components using PL/SQL, BI Publisher, Oracle Forms, Reports, and Workflow.
Develop and support MSCA customizations, mobile transactions, Oracle APIs, concurrent programs, and external-system interfaces.
Translate functional requirements into technical designs and maintain technical specifications, unit-test evidence, migration scripts, and support documentation.
Perform debugging, defect resolution, root-cause analysis, code review, and SQL or PL/SQL performance tuning.
Support deployments, version control, production incidents, enhancements, and application maintenance activities.
Collaborate with functional consultants, business stakeholders, DBAs, middleware teams, and other technical teams.

Must-Have Skills and Qualifications
Strong hands-on technical experience with Oracle EBS WMS, preferably R12.
Advanced proficiency in SQL and PL/SQL, including packages, procedures, functions, triggers, and performance tuning.
Hands-on experience with BI Publisher or XML Publisher, Oracle Forms, Oracle Reports, and Oracle Workflow.
Experience developing and supporting RICEW components, Oracle APIs, interfaces, and data conversions.
Strong understanding of MSCA architecture, mobile or handheld workflows, and related customizations.
Solid understanding of WMS, Inventory, Order Management, and end-to-end Order-to-Cash processes.
Proficiency with Git or an equivalent version-control system.
Experience troubleshooting complex production defects and integrations.

Good-to-Have Skills
Experience with Oracle Application Framework, web services, integration middleware, or third-party logistics interfaces.
Knowledge of Oracle application performance diagnostic tools and database optimization.
Experience with upgrades, patch-impact analysis, deployment automation, and CI/CD practices.
Exposure to additional Oracle SCM modules and Agile delivery models.
Shift: Rotational/24x7 support, including on-call, weekend, and release coverage as required
Soft Skills: Strong communication, ownership, collaboration, and problem-solving.