Software Engineer

Mattel, Inc.; Hyderabad; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Mattel, Inc. is seeking a detail-oriented Agile PLM Developer to support Agile PLM and Windchill CAD apps. You will transition responsibilities from a previous SME, handle PLM data requests, backlog items, and provide tech support for product GRS and integrations.

The role requires on-site work four days a week in Hyderabad, aligned with US EST time zone, and interaction across PLM data models, workflows, and configurations.

Qualifications

• Minimum 3+ years of hands-on experience in SQL and related tools.
• Experience with Oracle SQL and Oracle PL/SQL including stored procedures.
• Familiarity with Windchill/PDM environments and data modeling.
• Ability to read existing documentation and create user-friendly docs.

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 techniques.
• Collaborate with cross-functional teams to translate requirements into technical solutions.
• Utilize and contribute to existing documentation; create clear documentation for future reference.
• Work with Oracle Agile PLM software, including UI and backend data models, workflows, and configurations.

Skills

Data analysis

Data extraction

SQL scripting

Documentation

Tools

Oracle SQL

Oracle PL/SQL

MS SQL Server SQL

Java

Thingworx

PTC Windchill

PDM Link

Job description

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 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
• Ability to read and work with existing documentation
• Ability to create comprehensive and user-friendly documentation

Preferred Experience:

• 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