Lead Data Engineer (OIC+Python)

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 OICs 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 :

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 :

Dont meet every single requirement At Mattel we are dedicated to an inclusive workplace and a culture of belonging. If youre excited about this role but your past experience doesnt 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 worlds 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.

Mattels award-winning workplace culture has been recognized by Forbes Fast Company Newsweek Great Place to Work TIME and more.

Visit us at  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

Remote Work :

No

Employment Type :

Full-time