Lead Data Engineer (OIC+Python)
Mattel, Inc.3 months ago
Hyderābād, IndiaStaff+
Responsibilities
- Design and build integrations using Oracle Integration Cloud’s visual interface, including connections, data mappings, and business-process orchestration.
- Create, manage, and optimize APIs for secure and reliable data exchange.
- Monitor integration performance, troubleshoot technical issues, and provide ongoing support for deployed integrations.
- Gather requirements with business analysts and architects and translate them into technical specifications.
- Maintain documentation for integration designs, processes, and workflows.
- Implement data validation, data cleansing, and data quality controls.
- Design, build, and optimize scalable, high-performance, secure, and analytics-ready data platforms.
- Follow integration development, security, testing, deployment, and software development lifecycle best practices.
- Collaborate with cross-functional stakeholders and manage work across different time zones.
Requirements
- 10–13 years of professional experience is required.
- Hands-on experience developing Oracle Integration Cloud integrations.
- Strong conceptual, logical, and physical data modeling skills.
- Proficiency in SQL and Python.
- Experience with Google BigQuery or Oracle 23ai.
- Experience with Apache Airflow, Google Cloud Composer, or OCP Scheduler.
- Proficiency with Oracle Database, SQL, PL/SQL, and related tools such as SQL Developer.
- Knowledge of at least one Oracle ERP module, including Financials, Procurement, Inventory, or Order Management.
- Experience with software development lifecycle, testing, and deployment processes.
- Knowledge of cloud technologies and Oracle Cloud Infrastructure or Oracle GoldenGate is a plus.
- Strong analytical, problem-solving, communication, collaboration, prioritization, and independent-working skills.
- Oracle certifications, including Oracle Certified Professional, are preferred.
- Knowledge of DevOps practices, Git, CI/CD pipelines, and automated testing is preferred.
- Familiarity with Agile or Scrum project management methodologies is preferred.
- Familiarity with OpenAI prompt engineering, machine learning, and large language model concepts is preferred.
- Knowledge of DBT is preferred.
Benefits
- Mattel offers a flexible work model combining purposeful in-person collaboration with flexibility.
- The company promotes an inclusive workplace and culture of belonging as an Equal Opportunity Employer.
- The role offers collaboration in a purpose-driven, globally distributed organization focused on growth, wellbeing, innovation, and employee impact.
Tech Stack
Categories
Data Engineering
About Mattel, Inc.
Mattel, Inc. is a global toy and family entertainment company that designs, manufactures, and licenses products under brands such as Barbie, Hot Wheels, Fisher-Price, American Girl, UNO, and Thomas & Friends. It sells through major retailers, e-commerce, and direct channels, and extends its franchises into content, consumer products, and live/digital experiences via licensing partnerships. Founded in 1945 and headquartered in El Segundo, California, the company operates worldwide.