Job Title: Production Support Lead - Global Consumer Services
Location: Hyderabad, India
Job Summary: We are seeking an experienced Production Support Lead to own day-to-day production operations for Mattel’s Legacy CRM and retail web applications, the middleware layers that connect them, and integrations to Salesforce Service Cloud and other enterprise services. This role leads to incident and problem management, runbook/DR ownership, and will supervise and deliver small application enhancements and fixes. The ideal candidate combines hands-on troubleshooting skills for legacy stacks (PowerBuilder + Avalara tax integration, MSSQL, IIS/Windows), deep understanding of middleware/ESB-based integrations, and practical experience with Salesforce Service Cloud integration patterns, vendor coordination, and disciplined release/change processes.
Key Responsibilities:
Production Support & Incident Management
- Lead L2/L3 production incident response. Triage, RCA, and drive timely resolution to meet SLAs.
- Own the incident lifecycle: detection, escalation, mitigation, communication, and post-incident review.
- Operate shift/rotation schedules and provide on-call leadership when required.
Application Maintenance, Small Enhancements & Integration Changes
- Supervise, scope and deliver small enhancements and bug fixes for legacy apps and associated integration flows; prioritize work with business stakeholders and BA team.
- Approve and oversee code/configuration changes, including PowerBuilder fixes, SQL scripts, middleware mappings, and Salesforce integration configurations; ensure deployments follow change control and rollback procedures.
- Provide technical guidance and review for integration changes (mapping, transformations, error handling, and retry logic).
Middleware & Integrations
- Own and troubleshoot middleware/ESB layers, API gateways and integration runtimes that connect legacy systems to Salesforce Service Cloud and other enterprise services.
- Monitor integration endpoints, queue depth, latency, and replay/retry behavior; collaborate with middleware and Salesforce teams for performance tuning.
Platform, Integration & Tax Support
- Support integrations between legacy apps and external services — notably Avalara tax services — web services, middleware, and database connections.
- Troubleshoot and maintain web platform components (IIS, app pools, .NET/Tomcat as applicable), SSL/TLS, load balancers and session behavior.
- Coordinate with internal Salesforce architects and external vendors for escalations and larger integration changes.
Database & Batch Job Ownership
- Own MSSQL operational tasks: monitoring, tuning, backup/restore verification, SQL Agent jobs, stored procedures, and ETL (SSIS) oversight.
- Troubleshoot performance issues, long-running queries, blocking and resource contention.
Runbooks, DR & Audit
- Maintain and validate runbooks, TRP/DR documents and application runbooks; lead DR tests and BCP preparedness for service/store applications and integrations.
- Prepare responses for audits and BCP/DR reviews; ensure runbooks reflect current architecture and dependencies, including middleware and Salesforce integration diagrams.
Team Leadership & Vendor Management
- Supervise a small production support team and/or coordinate third-party support vendors (middleware/Salesforce integrators); mentor junior engineers.
- Run daily/weekly prioritization and status calls with business analysts, Consumer Affairs, and Product Owners.
- Drive continuous improvement and knowledge transfer; maintain system and integration documentation and runbooks.
Change & Release Management
- Own release readiness for small enhancements, hotfixes and integration deployments: testing, regression checks, deployment coordination, and post-release validation.
- Ensure changes comply with change management and rollback requirements; minimize production disruption
Qualifications
Qualifications:
- Education: Bachelor’s degree in Computer Science, Information Systems, or related field.
- Experience:
- 10+ years’ experience supporting production enterprise applications and infrastructure; minimum 5+ years in a lead/support ownership role.
- Demonstrated experience with PowerBuilder applications (PowerScript, DataWindow/DataStore) and runtime troubleshooting.
- Strong MSSQL (T-SQL, SQL Agent, performance tuning) experience.
- Practical experience with Windows Server administration (including older versions such as Windows Server 2012R2), IIS management and web application troubleshooting.
- Hands-on experience with integration and tax services — Avalara (or equivalent tax engines) and web service integrations.
- Middleware/ESB experience (MuleSoft, Dell Boomi, IBM MQ, TIBCO, or similar) designing/troubleshooting integration flows, message queues, transformation/mapping logic and retry/compensation patterns.
- Experience with Salesforce Service Cloud integrations — understanding of case/contact synchronization, platform events, REST/SOAP APIs, bulk API and integration change/configuration management.
- Experience authoring runbooks and running DR tests / BCP exercises.
- Technical Skills:
- PowerBuilder, PowerScript, DataWindow familiarity.
- MSSQL Server (T-SQL, stored procs, backup/restore, HA concepts).
- Windows Server & IIS administration.
- Middleware/ESB tooling (MuleSoft/Boome/IBM MQ/TIBCO or experience with API gateways).
- Salesforce integration knowledge (connected apps, OAuth flows, REST/SOAP/Bulk APIs, platform events).
- Scripting (PowerShell, Python or shell) for automation.
- Knowledge of deployment/change management and source control (Git/TFS/SVN).
- Familiarity with ETL/SSIS and scheduled batch job management.
- Behavioral & Leadership Skills
- Strong incident management and customer-facing communication skills.
- Proven ability to lead small teams and supervise delivery of enhancements.
- Stakeholder management: able to liaise with business analysts, Salesforce architects, middleware teams, and external vendors.
- Organized, detail oriented, and comfortable working with legacy systems that require careful change control.
Preferred Qualifications:
- Prior experience supporting retail/commerce sites
- Experience with image pipelines / content publishing flows.
- Prior vendor management experience (managing outsourced integrators/partners).
- Certifications in MuleSoft, Salesforce, Microsoft Server/SQL, or ITIL/ITSM foundation.
About Us: We are a leading organization committed to leveraging technology to drive business success. Our team is dedicated to innovation, collaboration, and delivering exceptional results. Join us and be a part of a dynamic and forward-thinking company.
How to Apply: Interested candidates are invited to submit their resume and cover letter detailing their relevant experience and qualifications.
Skills Required
- Bachelor's degree in Computer Science, Information Systems, or related field
- 10+ years experience supporting production enterprise applications and infrastructure
- Minimum 5+ years in a lead/support ownership role
- Experience with PowerBuilder (PowerScript, DataWindow/DataStore) and runtime troubleshooting
- Strong MSSQL (T-SQL, stored procedures, SQL Agent, performance tuning, backup/restore, HA concepts)
- Windows Server administration including older versions (e.g., Windows Server 2012R2) and IIS management
- Hands-on experience with Avalara or equivalent tax engine integrations and web service integrations
- Middleware/ESB experience (MuleSoft, Dell Boomi, IBM MQ, TIBCO or similar) designing/troubleshooting integration flows and queues
- Salesforce Service Cloud integration experience (case/contact sync, platform events, REST/SOAP/Bulk APIs, integration config/change management)
- Experience authoring runbooks and executing DR tests / BCP exercises
- Scripting for automation (PowerShell, Python, or shell)
- Knowledge of deployment/change management and source control (Git, TFS, SVN)
- Familiarity with ETL/SSIS and scheduled batch job management
- Strong incident management, customer-facing communication, stakeholder management, and team leadership skills
- Ability to supervise/coordinate third-party support vendors and mentor junior engineers
- Prior experience supporting retail/commerce sites
- Experience with image pipelines / content publishing flows
- Prior vendor management experience (managing outsourced integrators/partners)
- Certifications in MuleSoft, Salesforce, Microsoft Server/SQL, or ITIL/ITSM foundation
Mattel Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Mattel and has not been reviewed or approved by Mattel.
-
Leave & Time Off Breadth — Leave & Time Off Breadth: Unlimited paid time off for many salaried roles, generous holiday schedules, and flexibility programs are highlighted across company materials. Practices like half‑day Fridays or end‑of‑year breaks appear in some areas, though specifics vary by team and location.
-
Healthcare Strength — Healthcare Strength: Comprehensive medical, dental, vision, and disability coverage is paired with an Employee Assistance Program, mindfulness tools, and on‑site fitness centers at key locations. Recent updates add a company‑paid at‑home cancer‑screening program for those enrolled in medical plans.
-
Parental & Family Support — Parental & Family Support: Paid leave for new parents, phase‑back‑to‑work options, and global fertility and family‑building resources are emphasized. Select campuses offer on‑site childcare, and adoption assistance and caregiver support are included.
Mattel Insights
What We Do
We are a purpose driven company with a mission to create innovative products and experiences that inspire, entertain, and develop children through play. We treat play as if the future depends on it — because it does. Play is our language, and we speak to our consumers authentically by representing the world as they see and imagine it. Mattel is a leading global toy company and owner of one of the strongest catalogs of children’s and family entertainment franchises in the world. We engage consumers through our portfolio of iconic brands, including Barbie, Hot Wheels, Fisher-Price, American Girl, Thomas & Friends, UNO, Masters of the Universe, Monster High and MEGA, as well as other popular intellectual properties that we own or license in partnership with global entertainment companies. Our offerings include film and television content, gaming and digital experiences, music, and live events. We operate in more than 35 locations and our products are sold in more than 150 countries in collaboration with the world’s leading retail and ecommerce companies. Mattel is recognized for the second year in a row as a Great Place to Work™ and as one of Fast Company’s Best Workplaces for Innovators in 2022.
