Agile PLM Developer

Technogen, Inc.; Hyderabad; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Technogen, Inc. is seeking a detail-oriented Agile PLM Developer to support Agile PLM and Windchill CAD integrations. The role involves taking over from a previous SME, handling data requests, backlog items, and providing technical support for product GRS and related integrations.

You will work on-site in Hyderabad four days a week, align with US EST time, perform data analysis, SQL development, and document processes. Prior Oracle Agile PLM experience is preferred.

Qualifications

• Perform data analysis and extraction from large databases.
• Write, optimize, and troubleshoot complex SQL queries.
• Interpret Explain Plans and optimize with indexes.
• Collaborate with cross-functional teams to translate requirements into technical solutions.
• Create and maintain clear, user-friendly documentation.
• Work with Oracle Agile PLM UI, data models, workflows, and configurations.

Responsibilities

• Perform advanced data analysis and extraction from large databases.
• Write, optimize, and troubleshoot complex SQL queries.
• Interpret Explain Plans using indexes and various SQL techniques.
• Collaborate with cross-functional teams to translate requirements into solutions.
• Utilize and contribute to existing documentation; create clear documentation.
• Work with Oracle Agile PLM software, including UI and backend data models, workflows, data configurations, and process extensions.

Skills

SQL

Oracle SQL

Oracle PL/SQL

Explain Plans

Data analysis

Documentation

Tools

MS SQL Server

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,

• 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