About this role
Job title: Software Engineer-PLM Developer
About the Role Mattel is seeking a detail-oriented and technically proficient Agile PLM Developer to support development, configuration, and support of the Agile 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.
What You'll Do
- 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
What We're Looking For
- Minimum 3+ years of hands-on experience in SQL, including expertise in: PDM Link, Java, ThingWorx, PTC Windchill, Tables, Indexes, Explain Plans
- Oracle SQL – Required
- Oracle PL/SQL – Required; experience with Stored Procedures and Functions
- MS SQL Server SQL – Nice to have
- Strong data analysis skills
- Ability to read and work with existing documentation
- Ability to create comprehensive and user-friendly documentation
Nice to Have
- Prior experience with Oracle Agile PLM, including UI interaction and working knowledge of its backend data model
- Experience with process configurations, workflows, and custom extensions within the PLM environment
Compensation & Benefits
- Salary not disclosed in posting.