Oracle Reports Software Engineer

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.

Oracle Reports Developer

Job Title: Oracle Fusion Technical Consultant - Support

Job Summary

The Oracle Fusion Technical Consultant - Support is a dedicated professional responsible for the ongoing technical support, maintenance, and enhancement of the Oracle Fusion Cloud applications. This role is a critical part of the support team, focusing on resolving technical issues, troubleshooting integrations and reports, and performing routine maintenance tasks. The consultant will serve as a technical expert for the business, ensuring the stability, performance, and integrity of the Oracle Fusion environment.

Key Responsibilities

• Technical Support & Incident Resolution:
  • Serve as a second or third-line technical support for Oracle Fusion applications, responding to and resolving technical incidents and service requests from end-users and other IT teams.
  • Diagnose and troubleshoot technical issues related to integrations, custom reports, data conversions, and system performance.
  • Perform root cause analysis (RCA) on recurring technical issues and work to implement permanent solutions.
  • Log and manage Service Requests (SRs) with Oracle Support, providing necessary logs and information to facilitate resolution.
• Development & Maintenance:
  • Provide ongoing technical support for custom reports built with BI Publisher, OTBI (Oracle Transactional Business Intelligence), and Financial Reporting Studio (FRS), including debugging and modifying existing reports.
  • Maintain and troubleshoot existing integrations built with Oracle Integration Cloud (OIC), File-Based Data Import (FBDI), and other integration methods.
  • Perform minor technical enhancements and customizations to meet new business requirements.
  • Execute data corrections and data uploads using standard Oracle tools.
• System Administration & Release Management:
  • Monitor and manage scheduled jobs and concurrent programs to ensure successful completion.
  • Assist in the planning and execution of technical tasks for quarterly Oracle Cloud updates, including impact analysis of new features on existing custom solutions.
  • Perform regression testing of technical components (reports, integrations, customizations) after updates or patches.
  • Maintain and update technical documentation for all custom objects, including integration specifications, report layouts, and code changes.
• Communication & Collaboration:
  • Collaborate closely with functional consultants to understand and resolve end-to-end business process issues with a technical component.
  • Work with cross-functional IT teams to support integrations and maintain system integrity.
  • Communicate technical resolutions clearly and effectively to non-technical users and business stakeholders.

Required Qualifications

• Experience:
  • 4 to 6years of hands-on technical experience with Oracle Fusion.
  • Proven experience troubleshooting and maintaining technical components in Oracle Fusion Financials Modules.
• Technical Skills:
  • Strong proficiency in Oracle's technical toolset, including BI Publisher and OTBI.
  • Hands-on experience with Oracle Integration Cloud (OIC) for building and maintaining integrations.
  • Solid understanding of the Oracle Fusion data model and a strong command of SQL and PL/SQL.
  • Experience with data loaders like FBDI.

Preferred Qualifications

• Oracle Cloud certifications (e.g., Oracle Integration Cloud, Oracle Cloud Infrastructure).
• Experience with Groovy script for custom page development.
• Familiarity with a ticketing system like ServiceNow or Jira.

Key Skills & Competencies

• Technical Acumen: Deep technical knowledge and the ability to quickly diagnose and solve complex technical problems.
• Problem-Solving: Strong analytical and debugging skills, with a methodical and logical approach to troubleshooting.
• Communication: Excellent verbal and written communication skills to articulate technical solutions to both technical and non-technical audiences.
• Attention to Detail: Meticulous in documenting issues, resolutions, and technical specifications.
• Proactive & Self-Motivated: The ability to work independently, manage multiple priorities, and proactively identify opportunities for system improvement

.

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