Analyst IT

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.

The Opportunity: 

Oracle Integration Cloud (OIC) Technical Production Support Analyst

Exp – 4 - 5 Years

Job Summary:

We are seeking a skilled and detail-oriented Oracle Integration Cloud (OIC) Technical Production Support Analyst with at least 3 years of experience in supporting and maintaining Oracle Cloud integrations. The ideal candidate will have strong technical expertise in developing, monitoring, and troubleshooting OIC integrations including REST/SOAP APIs, scheduled orchestration flows, file-based integrations, and connectivity with Oracle SaaS and third-party systems.

This role is critical to ensuring stability, scalability, and performance of integrations across ERP, HCM, EPM, and external systems. The candidate will work closely with functional teams, solution architects, and support teams to resolve integration issues, optimize performance, and maintain compliance with internal controls.

Key Responsibilities:

• Provide L2/L3 production support for Oracle Integration Cloud (OIC) integrations across ERP, EPM, and other systems.
• Monitor OIC integration health, ESS jobs, file transmissions, error queues, and exception reports.
• Troubleshoot technical issues related to OIC integrations including payload errors, mapping failures, connectivity issues, authentication, and token expiration.
• Perform code-level debugging of OIC orchestrations, adapters (FTP, SOAP, REST, File, ERP, HCM, DB), and transformation mappings (XSLT, JSON, XML).
• Support integration jobs that load and extract data using FBDI, HDL, UCM, and other Oracle-delivered interfaces.
• Collaborate with Oracle Support to raise SRs and ensure timely resolution of platform-related issues.
• Ensure all changes to integrations are properly documented and follow internal SDLC, change control, and SOX audit guidelines.
• Analyze root cause of recurring issues and work on long-term solutions and automation opportunities.
• Build and maintain technical documentation, flow diagrams, interface control documents (ICDs), and error resolution guides.
• Participate in deployments, patch validations, regression testing, and cutover activities.
• Manage access tokens, key stores, connectivity agents, and certificates used in integrations.
• Work with business teams to validate data flows and ensure successful E2E transactions across systems.

What We’re Looking For: 

• Experience & Skills Requirements:

• Minimum 3 years of hands-on experience with Oracle Integration Cloud (OIC) in a production support or technical development role.
• Strong experience in building and troubleshooting OIC integrations using REST, SOAP, and file-based orchestrations.
• Proficient in transformation logic using XSLT, XPath, JSON, and XML schemas.
• Experience with Oracle Cloud ERP and HCM integration adapters (ERP Adapter, HCM Adapter, FTP Adapter, REST/SOAP Adapter, DB Adapter, etc.).
• Hands-on experience with FBDI, HDL, UCM, and Oracle-delivered web services.
• Experience with OAuth2 tokens, connectivity agents, SSH key management, and certificate renewals.
• Familiarity with OIC agent installations and upgrades for on-prem/cloud hybrid integrations.
• Strong understanding of error handling framework, retry logic, and fault policies within OIC.
• Ability to monitor and manage integrations using OIC dashboard, activity streams, and logging tools.
• Experience in tools such as Postman, SOAP UI, Putty, and WinSCP for testing and troubleshooting.
• Basic understanding of Oracle ERP data models, chart of accounts, and master data flows is a plus.
• Experience working with ServiceNow, JIRA, or other ticketing systems to manage support queues.
• Familiarity with ITGC/SOX controls, documentation, and audit trail maintenance for integration changes.

•  

  Preferred Qualifications:

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or equivalent technical discipline.
• Oracle OIC or Oracle Cloud Platform certification is a plus.
• Experience working in large-scale Oracle Cloud ERP/HCM/EPM implementations or upgrades.
• Exposure to CI/CD concepts and tools such as GitHub, Jenkins, or DevOps pipelines for integrations.
• Experience in Agile/Scrum environments with knowledge of sprints, stories, and release management.

• Work Environment & Tools:

• Oracle Integration Cloud (OIC) , DBCS, PL/SQL
• Oracle Cloud ERP, HCM, EPM SaaS
• FBDI, HDL, UCM, BIP, OTBI
• Tools: Postman, SOAP UI, WinSCP, Putty, SQL Developer
• ITSM: ServiceNow, JIRA, Confluence
• DevOps/Versioning: GitHub, Jenkins, Release Pipelines
• Monitoring & Documentation: Excel, PowerPoint, Visio, Lucidchart

•  

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:
The Culture at Mattel
Corporate Philanthropy