Back to jobs

OIC - Lead Data Engineer

Pay
Pay not listed
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Full-time — employment source
1804, 18th Floor, Gowra Palladium, Hyderabad, India Full-time Location: India - Hyderabad
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Design and build integrations in OIC, including data mappings and business process orchestration

  • Create, manage and optimize APIs for secure, reliable data exchange

  • Monitor integrations, resolve technical issues and support deployed integrations

  • Document integration designs, processes and workflows

From the employer’s posting
Designing and building integrations using OIC's visual interface
Creating, managing, and optimizing APIs (Application Programming Interfaces)
Monitoring integration performance, identifying and resolving technical issues
Maintaining comprehensive documentation of all integration designs, processes, and workflows

What you’ll bring

All qualifications

Core experience

  • 10-13 years of experience
  • Hands-on experience developing OIC integrations
  • Oracle Database skills (SQL, PL/SQL)

Preferred experience

  • Knowledge of cloud technologies and Oracle Cloud Infrastructure (OCI) or Oracle Goldengate is a plus.
  • Knowledge of DevOps practices, including version control (e.g., Git), CI/CD pipelines, and automated testing.
  • Familiarity with Agile or Scrum project management methodologies.
  • Familiarity with OpenAI prompt engineering and Machine Learning / LLM concepts
Qualification wording
10-13 years of experience is required
Proven experience with OIC: Hands-on experience developing integrations is essential.
Proficiency in Oracle Database (SQL, PL/SQL) and related tools (e.g., SQL Developer).
Knowledge of cloud technologies and Oracle Cloud Infrastructure (OCI) or Oracle Goldengate is a plus.
Knowledge of DevOps practices, including version control (e.g., Git), CI/CD pipelines, and automated testing.
Familiarity with Agile or Scrum project management methodologies.
Familiarity with OpenAI prompt engineering and Machine Learning / LLM concepts

About Mattel

Mattel is a leading global toy and family entertainment company and owner of one of the most iconic brand portfolios in the world.

In the employer’s words · Read in context

Apply at Mattel

Posting record

Report an error
Status in our records
Live
First seen by us
Oct 4, 202648 days ago
Recorded sightings
229
Last seen by us
Nov 22, 2026
Employer says posted
Oct 1, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 48

Similar jobs usually come down between day 6 and day 56.

Well past Mattel’s usual: its jobs come down by about day 13.

From 14,767 similar postings that came down, and 132 of Mattel’s. Coming down is not always a hire.

Mattel is hiring

11 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Data Engineer hiring has slowed
  • Takes jobs down quickly
  • 27% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • PL/SQL
  • Python
  • SQL
  • BigQuery
  • dbt
  • GCP
  • GoldenGate
  • Oracle
  • Airflow
Where the posting names them
- Experience with Apache Airflow / GCP Cloud Composer / OCP Scheduler - Database skills: Familiarity with SQL and PL/SQL. - Deployment and testing: Experience with the full software development lifecycle, including testing and deployment processes.
- 10-13 years of experience is required. - Proficiency in Oracle Database (SQL, PL/SQL) and related tools (e.g., SQL Developer). - Strong knowledge of at least one of the Oracle ERP module, i.e. Financials, Procurement, Inventory, Order Management.
- Strong Data Modeling skills (conceptual, logical, physical) - Proficiency in SQL and Python - Experience with Google BigQuery (GBQ) or Oracle 23ai
- Proficiency in SQL and Python - Experience with Google BigQuery (GBQ) or Oracle 23ai - Experience with Apache Airflow / GCP Cloud Composer / OCP Scheduler
- Familiarity with OpenAI prompt engineering and Machine Learning / LLM concepts - Knowledge of DBT Additional Information
Job Description We are seeking an experienced Data Engineer/Lead Data Engineer/Data Engineering Specialist for Oracle + GCP to design, build, and optimize scalable, high-performance data platforms. The ideal candidate will have strong expertise in ETL/ELT frameworks, OIC, and Google Cloud Platform (GCP), and will work closely with business and technical teams to deliver reliable, secure, and analytics-ready data solutions. A typical day for a Data Engineer involves a mix of technical and collaborative tasks. The main responsibilities include:
- Experience with Google BigQuery (GBQ) or Oracle 23ai - Experience with Apache Airflow / GCP Cloud Composer / OCP Scheduler - Database skills: Familiarity with SQL and PL/SQL.
- Strong knowledge of at least one of the Oracle ERP module, i.e. Financials, Procurement, Inventory, Order Management. - Knowledge of cloud technologies and Oracle Cloud Infrastructure (OCI) or Oracle Goldengate is a plus. - Strong analytical and problem-solving skills to address complex business and technical challenges.
- Proficiency in Oracle Database (SQL, PL/SQL) and related tools (e.g., SQL Developer). - Strong knowledge of at least one of the Oracle ERP module, i.e. Financials, Procurement, Inventory, Order Management. - Knowledge of cloud technologies and Oracle Cloud Infrastructure (OCI) or Oracle Goldengate is a plus.

Your next step

Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.

Applying through SmartRecruiters

  • Uploading your resume fills in the application form for you, so check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

Job Description

Job Description

We are seeking an experienced Data Engineer/Lead Data Engineer/Data Engineering Specialist for Oracle + GCP to design, build, and optimize scalable, high-performance data platforms. The ideal candidate will have strong expertise in ETL/ELT frameworks, OIC, and Google Cloud Platform (GCP), and will work closely with business and technical teams to deliver reliable, secure, and analytics-ready data solutions.

A typical day for a Data Engineer involves a mix of technical and collaborative tasks. The main responsibilities include:

  • Integration Development: Designing and building integrations using OIC's visual interface. This involves configuring connections, defining data mappings, and orchestrating complex business processes.
  • API Management: Creating, managing, and optimizing APIs (Application Programming Interfaces) to facilitate secure and reliable data exchange.
  • Troubleshooting and Support: Monitoring integration performance, identifying and resolving technical issues, and providing ongoing support for deployed integrations to ensure data integrity.
  • Collaboration: Working with business analysts and architects to gather requirements, translating them into technical specifications, and collaborating with cross-functional teams to deliver effective solutions.
  • Documentation: Maintaining comprehensive documentation of all integration designs, processes, and workflows for future reference and maintenance.
  • Best Practices: Adhering to industry standards and best practices for integration development and security.
  • Implement data validation, data cleansing, and data quality controls to ensure accurate and reliable datasets.

 

Qualifications

Qualifications

Technical Skills:

  • Proven experience with OIC: Hands-on experience developing integrations is essential.
  • Strong Data Modeling skills (conceptual, logical, physical)
  • Proficiency in SQL and Python
  • Experience with Google BigQuery (GBQ) or Oracle 23ai
  • Experience with Apache Airflow / GCP Cloud Composer / OCP Scheduler
  • Database skills: Familiarity with SQL and PL/SQL.
  • Deployment and testing: Experience with the full software development lifecycle, including testing and deployment processes.

Qualifications and Soft Skills:

  • 10-13 years of experience is required. 
  • Proficiency in Oracle Database (SQL, PL/SQL) and related tools (e.g., SQL Developer). 
  • Strong knowledge of at least one of the Oracle ERP module, i.e. Financials, Procurement, Inventory, Order Management. 
  • Knowledge of cloud technologies and Oracle Cloud Infrastructure (OCI) or Oracle Goldengate is a plus. 
  • Strong analytical and problem-solving skills to address complex business and technical challenges.  
  • Excellent communication and interpersonal skills to collaborate with cross-functional teams and stakeholders.  
  • Ability to work independently and manage multiple priorities in a fast-paced environment.  
  • Detail-oriented with a focus on delivering high-quality, error-free solutions. 
  • Problem-Solving: Strong analytical and problem-solving abilities, with a proactive approach to addressing challenges. 
  • Cultural Awareness: Ability to work effectively in a multicultural environment and manage teams across different time zones. 

Preferred Qualifications: 

  • Oracle certifications, i.e. Oracle Certified Professional (OCP)
  • Knowledge of DevOps practices, including version control (e.g., Git), CI/CD pipelines, and automated testing.  
  • Familiarity with Agile or Scrum project management methodologies.  
  • Familiarity with OpenAI prompt engineering and Machine Learning / LLM concepts
  • Knowledge of DBT

 

Additional Information

Additional Information

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:

Company Description

Lead Data Engineer (OIC)

  • 1804, 18th Floor, Gowra Palladium, Hyderabad, India
  • Full-time
  • Location: India - Hyderabad
  • Company: Mattel Global Business Services

Company Description

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.

 

About Mattel

People
About 31,000 in 2025, down 9% from the year before.Annual report (SEC Form 10-K)
Company
Listed as MAT.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Hyderabad, India

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.