Sr Software Engineer WMS Oracle

Mattel


Job Location:

Hyderabad - India

Monthly Salary: Not Disclosed
Posted on: 3 days ago
Vacancies: 1 Vacancy

Job Summary

Job Description 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 

Strong 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 

  • Bachelors 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 


Remote Work :

No


Employment Type :

Full-time

Job Description 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 a...

About Company

CREATIVITY IS OUR SUPERPOWER. It’s our heritage and it’s also our future. Because we don’t just make toys. We create innovative products and experiences that inspire fans, entertain audiences and develop children through play. Mattel is at its best when every member of our team feels ... View more

View Profile View Profile