Sr Software Engineer - WMS Oracle
Mattel, Inc.
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
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
- 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.
- 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.
- Identify recurring issues and recommend permanent solutions.
- Support operational improvement initiatives and system enhancements.
- Contribute to process automation and support efficiency improvements.
Strong understanding of warehouse management and supply chain processes, including
Inventory Management
- Inventory adjustments
- Cycle counting
- Inventory reconciliation
- Inventory transfers
- ASN processing
- Receiving
- Putaway
- Quality holds
- Order management
- Picking
- Packing
- Shipping
- Manifest processing
- Replenishment
- Slotting concepts
- Label printing
- RF device operations
- Exception management
- ERP to WMS interfaces
- Shipment and carrier integrations
- Inventory synchronization processes
- 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
- 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
- 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.
- 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.
- Oracle Database
- Oracle PL/SQL
- Delphi (Optional)
- SQR Reporting & Label Printing
- Unix/Linux Shell Scripting
- Warehouse Management Systems
- ServiceNow