– AGWMS Production Support Analyst Position Summary We are seeking an experienced Production Support Analyst to support and maintain the AGWMS (Automated Global Warehouse Management System) platform. The role will be responsible for application support, incident management, root cause analysis, operational troubleshooting, and business support for warehouse operations. The ideal candidate should possess a strong combination of technical expertise and warehouse functional knowledge to effectively support business-critical supply chain operations.

AGWMS consists of: Oracle PL/SQL backend Delphi front-end application (preferred but not mandatory) SQR reporting and label printing Unix/Linux shell scripts and daemon jobs Warehouse operational interfaces and integrations Key Responsibilities Production & Application Support Provide L2/L3 production support for AGWMS applications. Investigate and resolve production incidents and operational issues. Perform root cause analysis and implement corrective actions.

Monitor batch jobs, interfaces, and daemon processes. Support warehouse operations during business-critical incidents and escalations. Coordinate with business users, infrastructure teams, and vendors.

Oracle PL/SQL development and code fixes AGWMS custom program, interface, report, and label enhancements Unix shell script and daemon job modifications Testing, deployment, and performance improvements Functional Warehouse Support Support daily warehouse operations and troubleshoot process-related issues. Analyze inventory discrepancies, shipment issues, receiving exceptions, and order processing problems.



Work closely with warehouse supervisors and business SMEs to resolve operational issues.

Understand and support warehouse execution processes and business workflows. Provide guidance on system functionality and operational best practices. Oracle & Technical Support Troubleshoot Oracle PL/SQL packages, procedures, functions, and triggers.

Perform data analysis and support data correction activities. Investigate interface failures and integration issues. Support deployment and release activities.

Troubleshoot

Unix shell scripts and daemon jobs.

Continuous Improvement

Identify recurring issues and recommend permanent solutions. Support operational improvement initiatives and system enhancements. Contribute to process automation and support efficiency improvements.

Functional Knowledge Required

Robust understanding of warehouse management and supply chain processes, including:



Inventory Management Inventory adjustments Cycle counting Inventory reconciliation Inventory transfers Inbound Operations ASN processing Receiving Putaway Quality holds Outbound Operations Order management Picking Packing Shipping Manifest processing Warehouse Operations Replenishment Slotting concepts Label printing RF device operations Exception management Integrations ERP to WMS interfaces Shipment and carrier integrations Inventory synchronization processes Required Technical Skills Strong Oracle SQL and PL/SQL experience Oracle database troubleshooting and support Unix/Linux shell scripting Batch job monitoring and support Incident management and production support experience Data analysis and troubleshooting skills Preferred Skills Delphi application support experience (preferred but not mandatory) SQR reporting and label generation experience Warehouse Management System (WMS) support experience ServiceNow or similar ticketing tools Supply Chain or Logistics domain experience Qualifications

Qualifications Bachelor's degree in Computer Science, Information Systems, Supply Chain, or related field. 6+ years of application production support experience. 5+ years of Oracle PL/SQL development/support experience.

Experience supporting warehouse, logistics, or supply chain applications.

Key Success Factors

Strong technical troubleshooting skills. Strong understanding of warehouse business processes. Ability to bridge technical and operational teams. Excellent communication and stakeholder management. Ability to support business-critical warehouse operations in a fast-paced environment.

Technology Stack Oracle Database

Oracle PL/SQL Delphi (Optional) SQR Reporting & Label Printing Unix/Linux Shell Scripting Warehouse Management Systems ServiceNow Location: India - Hyderabad

Company: Mattel Global Business Services

📌 Sr Software Engineer - WMS Oracle (Hyderabad)
🏢 Mattel
📍 Hyderabad