SoftwareEngineer-AgilePLMDeveloper

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. We are seeking a detail-oriented and technically proficient Agile PLM Developer to support the ongoing development, configuration, and support of the Agile Product Lifecycle Management (PLM) and Windchill CAD applications. This role will take over responsibilities transitioning from a previous SME , including handling PLM data requests, backlog items, and providing technical support for product GRS and related integrations. The candidate must be willing to work on site 4 days a week in Hyderabad, during US EST time zone. Key Responsibilities: * Perform advanced data analysis and data extraction from large databases * Write, optimize, and troubleshoot complex SQL queries * Interpret and leverage Explain Plans using indexes and various SQL coding techniques (ANSI and non-ANSI) * Collaborate with cross-functional teams to understand requirements and translate them into technical solutions * Utilize and contribute to existing documentation; create clear and concise documentation for future reference * Work with Oracle Agile PLM software, including UI and backend data models, workflows, data configurations, and process extensions Required Skills & Experience: * Minimum 8 years of hands-on experience in SQL, including expertise in: * Tables, indexes, Explain Plans * ANSI and non-ANSI SQL coding techniques * Oracle SQL – Required * Oracle PL/SQL – Required; experience with Stored Procedures and Functions * Google BigQuery S