Lead – OCI Data Integration

Company Description

Mattel, Inc.
is a leading global toy and family entertainment company renowned for creating innovative products and experiences that inspire, entertain, and develop children through play. With iconic brands like
Barbie, Hot Wheels, Fisher-Price, American Girl, UNO, and MEGA
, Mattel designs and produces toys, games, films, and digital experiences enjoyed across generations. Headquartered in
El Segundo, California
, Mattel operates in more than
150 countries
and is driven by a mission to empower the next generation to explore the wonder of childhood and reach their full potential.

Role Description

Mattel is seeking a highly experienced and techno-functional Lead – OCI Data Integration professional to architect, lead, and optimize data integration and engineering solutions across the Finance domain. This role plays a critical part in the Next Gen Finance Transformation program, driving data integration across Order-to-Cash (O2C), Record-to-Report (R2R), and Procure-to-Pay (R2P) processes on Oracle Cloud Infrastructure (OCI).

Role Overview

The Lead – OCI Data Integration will be responsible for designing end-to-end data integration architectures, guiding development teams, and ensuring data accuracy and performance across Finance modules. This role requires a unique blend of technical depth in OCI Data Integration (OCI DI), functional understanding of Oracle Cloud ERP Finance modules, and leadership ability to align data engineering practices with business outcomes.

Key Responsibilities

• Architect, design, and manage OCI Data Integration (OCI DI) pipelines supporting O2C, R2R, and R2P processes.

• Lead a team of data integration engineers in developing, testing, and deploying OCI-based ETL/ELT workflows.

• Serve as the techno-functional bridge between Finance stakeholders and technical teams to translate business processes into scalable data solutions.

• Oversee integration of Oracle Cloud ERP, ADW, Object Storage, and Data Flow components for unified data delivery.

• Implement and enforce data governance, lineage, and quality standards across Finance data pipelines.

• Collaborate with Finance, Accounting, and Procurement teams to ensure accurate financial data movement and transformation.

• Define standards for CI/CD automation, version control, and deployment of OCI DI artifacts.

• Establish proactive monitoring and alerting frameworks for production pipelines using OCI Logging and APM.

• Mentor team members, perform technical reviews, and promote reusable design patterns.

• Drive continuous improvement in pipeline performance, scalability, and maintainability.

Required Qualifications

• 10+ years of IT experience, including at least 5+ years in data integration and engineering on Oracle Cloud Infrastructure (OCI).

• Deep expertise in OCI Data Integration (OCI DI), Data Flow (Spark), Object Storage, and Autonomous Data Warehouse (ADW).

• Strong SQL/PLSQL and performance tuning experience for Finance data.
• Demonstrated techno-functional knowledge of Order-to-Cash (O2C), Record-to-Report (R2R), and Procure-to-Pay (R2P) modules.
• Experience leading cross-functional teams in designing and deploying enterprise-scale data integration solutions.

• Proficiency in data modeling, lineage, and reconciliation for Finance processes.

• Familiarity with DevOps and CI/CD for automation of data integration pipelines.

• Excellent analytical, problem-solving, and communication skills.

Preferred Skills

• Oracle Certified Professional – OCI Data Integration or OCI Architect.

• Prior experience integrating Oracle Cloud ERP with OCI for Finance data movement and reporting.

• Understanding of data governance and Finance compliance frameworks (SOX, audit readiness).

• Knowledge of Python or PySpark for advanced data transformations.

• Strong stakeholder management skills with the

We are looking for a Mid-Level Oracle Integration Cloud (OIC) Developer to join our enterprise applications team. The successful candidate will play a key role in designing, developing, and maintaining integrations across our Finance and Manufacturing systems. This role requires a solid technical foundation in Oracle OIC along with a working understanding of business processes in ERP Finance (General Ledger, AP, AR) and Manufacturing modules (Work Orders, Inventory, Procurement, and Supply Chain).

Key Responsibilities
:

• Design, build, and maintain integrations and automations using Oracle Integration Cloud (OIC) for Finance and Manufacturing applications.
• Develop and manage integrations between Oracle ERP Cloud, Manufacturing Execution Systems (MES), and third-party platforms.
• Utilize OIC adapters (ERP Cloud, REST, FTP, DB, File, etc.) to create efficient & reusable integration flows.
• Collaborate with Finance and Manufacturing business stakeholders to analyze integration requirements and translate them into technical solutions.
• Implement data transformations using XSLT, JSON, and XML standards.
• Troubleshoot and resolve integration issues, ensuring data integrity, security, and system performance.
• Monitor and optimize integration processes, including handling errors, retries, and performance tuning.
• Document technical designs, workflows, and deployment processes for all developed integrations.
• Support ongoing upgrades, enhancements, and process automation initiatives.

Required Skills & Qualifications
:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 3–6 years of total IT experience with at least 2 years of hands-on experience in Oracle Integration Cloud (OIC).
• Strong experience integrating Oracle ERP Cloud modules, especially Finance (GL, AP, AR) and Manufacturing (Inventory, Procurement, Supply Chain).
• Expertise in building OIC integrations using REST and SOAP APIs, and working with structured/unstructured data formats (JSON, XML).
• Good understanding of Finance and Manufacturing business flows and related data entities.
• Experience with security configurations, OAuth, and connection management within OIC.
• Familiarity with incident management, issue triaging, and performance optimization in a production environment.
• Excellent analytical, problem-solving, and communication skills.