Description

Key Skills: SQL, Oracle PL/SQL, Data Analysis, Windchill, Oracle Agile PLM, Database Management, Technical Documentation, Process Configuration, Workflow Management, BigQuery

Good to Have Skills: Google BigQuery Studio and Google Cloud Storage buckets experience, MS SQL Server SQL knowledge, ANSI and non-ANSI SQL coding techniques, experience with Explain Plans using indexes, custom extensions within PLM environment, cross-functional team collaboration skills.

Roles & Responsibilities:

• Perform advanced data analysis and data extraction from large databases to support business requirements.
• Write, optimize, and troubleshoot complex SQL queries for efficient data processing and retrieval.
• Interpret and leverage Explain Plans using indexes and various SQL coding techniques including ANSI and non-ANSI methods.
• Collaborate with cross-functional teams to understand requirements and translate them into technical solutions.
• Utilize and contribute to existing documentation while creating 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.
• Support ongoing development, configuration, and support of Agile Product Lifecycle Management and Windchill CAD applications.
• Handle PLM data requests, backlog items, and provide technical support for product GRS and related integrations.

Experience Required: Minimum 8 years of hands-on experience in SQL with expertise in tables, indexes, Explain Plans, Oracle SQL and Oracle PL/SQL including stored procedures and functions. Strong data analysis skills and ability to work with existing documentation required

Key Skills

Education

Any Graduate