Agile PLM Data Migration

Compunnel Inc.; Austin (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Compunnel, Inc. in Austin, TX, is seeking an Agile PLM Data Migration Software Engineer to lead end-to-end migration of PLM data into Oracle Cloud PLM+.

The role focuses on accurate data extraction, transformation, validation, and loading, including delta migrations and coexistence with legacy PLM. You will collaborate with PLM, DBA, SME, and integration teams; design extraction logic; optimize performance; and prepare technical documentation.

Qualifications

• Hands-on Agile PLM data migration and extraction experience.
• Understand Agile PLM data structures (Item, BOM, Change, AML, FileVault).
• Experience developing SQL/PLSQL-based extraction programs.
• Experience with Agile PLM SDK or similar extraction technologies.
• Experience with revision-based data extraction and full revision history.
• Experience performing data quality validation, profiling, completeness checks, and referential integrity validation.
• Experience handling high-volume data extraction and performance optimization.
• Experience staging, transformation, and downstream mapping of PLM data.
• Experience collaborating with PLM, database, integration teams.
• Strong technical documentation skills (designs, BRDs, specs).

Responsibilities

• Analyze Agile PLM schemas to design accurate data extraction logic.
• Develop and optimize SQL, PL/SQL, and SDK-based extraction programs for high-volume objects and revisions.
• Perform data profiling, completeness checks, referential integrity validation, and error triage.
• Implement revision-based extraction logic to capture complete revision history.
• Optimize queries, indexes, and batch processing to reduce extraction time and improve throughput.
• Extract and manage FileVault attachments, including file paths and metadata.
• Support staging and transformation activities by delivering clean extract files and tables.
• Participate in dry runs and UAT, troubleshoot migration failures, refine extraction logic.
• Collaborate with PLM+, DBA, SME, and integration teams to align data mapping and validation.
• Support base and delta migration activities to facilitate coexistence between legacy Agile PLM and NextGen PLM+.
• Prepare and maintain technical documentation and project artifacts.
• Develop conceptual and technical design documentation.
• Prepare Technical Impact Assessments.
• Review and finalize BRDs.
• Prepare Technical Specifications for RICEFW components.

Skills

Agile PLM data migration

Data extraction

SQL/PLSQL

PLM SDK

Data quality validation

High-volume processing

Cross-functional collaboration

Technical documentation

Tools

SQL

PLM SDK

Oracle Cloud PLM+

Job description

Job Summary

The Agile PLM Data Migration Software Engineer will support the end-to-end migration of Item, BOM, Change, AML, and FileVault data from Agile PLM into the cloud-based Oracle Cloud PLM+ platform. The role will support both base migration for full data loads and delta migration for incremental changes, with a focus on accurate data extraction, transformation, validation, and loading. The resource will also support coexistence between legacy Agile PLM and NextGen PLM+ through full cutover.

Key Responsibilities

• Analyze Agile PLM schemas, including Item, BOM, Change, AML, and FileVault structures, to design accurate data extraction logic
• Develop and optimize SQL, PL/SQL, and SDK-based extraction programs for high-volume objects and revisions
• Perform data profiling, completeness checks, referential integrity validation, and error triage
• Implement revision-based extraction logic to capture complete revision history rather than only the latest revision
• Optimize queries, indexes, and batch processing logic to reduce extraction time and improve data migration throughput
• Extract and manage FileVault attachments, including file paths and metadata, and prepare content for cloud ingestion
• Support staging and transformation activities by delivering clean, structured extract files and tables for downstream transformation and data mapping
• Participate in dry runs and UAT activities, troubleshoot migration failures, and refine extraction logic
• Collaborate with PLM+, DBA, SME, and integration teams to align data mapping, sequencing, extraction, and validation activities
• Support base and delta migration activities to facilitate coexistence between legacy Agile PLM and NextGen PLM+
• Prepare and maintain technical documentation and project artifacts
• Develop conceptual and technical design documentation
• Prepare Technical Impact Assessments
• Review and finalize Business Requirements Documents (BRDs)
• Prepare Technical Specifications for RICEFW components, including reports, integrations, customizations, extensions, forms, and workflows

Required Qualifications

• Hands-on experience with Agile PLM data migration and data extraction
• Strong understanding of Agile PLM data structures, including Item, BOM, Change, AML, and FileVault
• Experience developing SQL and PL/SQL-based extraction programs
• Experience with Agile PLM SDK or comparable extraction technologies
• Experience with revision-based data extraction and full revision history
• Experience performing data quality validation, profiling, completeness checks, and referential integrity validation
• Experience handling high-volume data extraction and performance optimization
• Experience working with PLM data migration, staging, transformation, and downstream mapping processes
• Experience handling FileVault attachments, file paths, and metadata for migration
• Experience supporting mock migration runs, UAT, troubleshooting, and production readiness activities
• Ability to collaborate effectively with PLM, database, integration, and business teams
• Strong technical documentation skills, including conceptual and technical designs, impact assessments, BRDs, and technical specifications