Sr Oracle Support Analyst
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 respected, included, and heard-when everyone can show up as themselves and do their best work every day. We value and share an infinite range of ideas and voices that evolve and broaden our perspectives with a reach that extends into all our brands, partners, and suppliers.
Job Description - Oracle ERP Production Support Analyst
Position Summary
We are seeking an experienced Oracle ERP Production Support Analyst to provide production support, operational troubleshooting, incident management, and application support for a highly customized Oracle ERP environment.
The ideal candidate should have strong Oracle ERP functional knowledge, excellent Oracle SQL/PLSQL skills, and experience supporting business-critical ERP applications. The environment includes significant custom development built on top of Oracle E-Business Suite (11i/R12), requiring both technical troubleshooting and business process understanding.
Key Responsibilities
Production Support
Provide L2/L3 production support for Oracle ERP applications.
Investigate and resolve application, data, and interface issues.
Perform root cause analysis and implement corrective actions.
Support business users during critical incidents and escalations.
Monitor application health, concurrent programs, interfaces, and batch processes.
Coordinate with business users, infrastructure teams, vendors, and development teams.
ERP Functional Support
Support day-to-day ERP operations across Order-to-Cash, Procurement, Inventory, and Finance processes.
Analyze business process issues and system impacts.
Troubleshoot transactional issues and data discrepancies.
Work closely with business SMEs and functional teams to resolve production issues.
Provide guidance on ERP functionality and process flows.
Technical Support/Development
Develop and troubleshoot Oracle SQL and PL/SQL programs.
Support custom interfaces, reports, conversions, and enhancements.
Investigate data issues and perform approved data corrections.
Analyze performance issues and optimize SQL queries where required.
Support deployment and migration activities.
Defect fixes, performance tuning, and automation initiatives
Testing, deployment, and release support
Functional Knowledge Required
Strong Functional Knowledge
Order-to-Cash (O2C)
Customer Orders
Shipping Execution
Inventory Transactions
Invoicing
Order Fulfillment Lifecycle
Procurement
Requisitions
Purchase Orders
Receiving
Supplier Management
Procurement Workflows
Inventory Management
Inventory Transactions
Item Master
Cycle Counting
Inventory Reconciliation
Material Movements
Finance & Accounting
General Ledger (GL)
Accounts Payable (AP)
Accounts Receivable (AR)
Financial Period Close
Accounting and Financial Reporting
Receiving
Receipt Processing
Receipt Corrections
Inventory Receiving Transactions
Required Technical Skills
Oracle E-Business Suite 11i, R12, or higher
Strong Oracle SQL and PL/SQL development skills
Experience supporting highly customized Oracle ERP environments
Oracle Forms, Reports, Interfaces, and Concurrent Programs
Data analysis and troubleshooting
Incident and production support management
Preferred Skills
Oracle Workflow knowledge
XML Publisher / BI Publisher
Unix/Linux shell scripting
Oracle ERP integrations and interfaces
ITIL / Production Support processes
ServiceNow or similar ticketing tools
Qualifications
Bachelor's degree in Computer Science, Information Systems, Accounting, Finance, Supply Chain, or related field.
6+ years of Oracle ERP production support experience.
Strong Oracle ERP functional and technical troubleshooting experience.
Experience supporting business-critical ERP applications in a production environment.
Key Success Factors
Strong understanding of Oracle ERP business processes.
Excellent Oracle SQL and PL/SQL troubleshooting skills.
Ability to diagnose both functional and technical issues.
Strong analytical and problem-solving capabilities.
Effective communication with business users and technical teams.
Ability to support critical production environments with minimal supervision.
Technology Stack
Oracle E-Business Suite (11i / R12 or higher)
Oracle SQL
Oracle PL/SQL
Oracle Forms & Reports
XML Publisher / BI Publisher
Unix/Linux
ServiceNow
Don’t meet every single requirement? At Mattel, we are dedicated to an inclusive workplace and a culture of belonging. If you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we still encourage you to apply. You may be just the right candidate for this or other roles.
How We Work:
We are a purpose driven company aiming to empower generations to explore the wonder of childhood and reach their full potential. We live up to our purpose employing the following behaviors:
- We collaborate: Being a part of Mattel means being part of one team with shared values and common goals. Every person counts and working closely together always brings better results. Partnership is our process and our collective capabilities is our superpower.
- We innovate: At Mattel we always aim to find new and better ways to create innovative products and experiences. No matter where you work in the organization, you can always make a difference and have real impact. We welcome new ideas and value new initiatives that challenge conventional thinking.
- We execute: We are a performance-driven company. We strive for excellence and are focused on pursuing best-in-class outcomes. We believe in accountability and ownership and know that our people are at their best when they are empowered to create and deliver results.
Our Approach to Flexible Work:
We embrace a flexible work model designed to empower a culture of growth, optimism, and wellbeing, where every employee can reach their full potential. Combining purposeful in-person collaboration with flexibility, our focus is to optimize performance and drive connection for moments that matter.
Who We Are:
Mattel is a leading global toy and family entertainment company and owner of one of the most iconic brand portfolios in the world. We engage consumers and fans through our franchise brands, including Barbie, Hot Wheels, Fisher-Price, American Girl, Thomas & Friends, UNO, Masters of the Universe, Matchbox, Monster High, MEGA and Polly Pocket, as well as other popular properties that we own or license in partnership with global entertainment companies. Our offerings include toys, content, consumer products, digital and live experiences. Our products are sold in collaboration with the world’s leading retail and ecommerce companies. Since its founding in 1945, Mattel is proud to be a trusted partner in empowering generations to explore the wonder of childhood and reach their full potential.
Mattel’s award-winning workplace culture has been recognized by Forbes, Fast Company, Newsweek, Great Place to Work, TIME, and more.
Visit us at https://jobs.mattel.com/ and www.instagram.com/MattelCareers.
Mattel is an Equal Opportunity Employer where we want you to bring your authentic self to work every day. We welcome all job seekers, and all applicants will receive consideration for employment.
Videos to watch: