PLM Data Migration Architect — Agile to Cloud

Pentangle Tech Services | P5 Group; Austin (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Pentangle Tech Services | P5 Group in Austin, TX seeks an Agile Data Migration expert—Software engineer with 8+ years’ experience. You will design extraction logic for Item, BOM, Change and File Vault, and build high-volume extract programs using SQL/PLSQL and SDKs.

You will validate data quality, preserve full revision history, and optimize performance while coordinating with PLM, DBAs, SMEs, and integration teams to ensure successful cloud migration readiness.

Qualifications

• Oracle Agile PLM is a required tool/technique.
• Data Migration experience is required.
• Experience with PLM data structures, Item, BOM, Change, AML, and File Vault is expected.
• Demonstrated ability to design extraction logic for high-volume objects and revisions.
• Proficiency in SQL/PLSQL and SDK-based extraction tools.
• Ability to validate data quality and perform error triage.
• Experience with end-to-end data migration and cloud ingestion preparations.
• Ability to collaborate with PLM, DBAs, SMEs and integration teams.
• Ability to produce design documents and technical specifications for RICEFW.

Responsibilities

• Agile Schema Analysis to design extraction logic for PLM data.
• Develop and optimize SQL/PLSQL/SDK extract programs for high-volume data.
• Validate data quality, profiling and referential integrity checks.
• Implement revision-based extraction for full history migration.
• Tune queries, indexes and batch logic to improve throughput.
• Handle File Vault data extraction, including attachments and metadata.
• Deliver staging/transformation files for downstream mapping.
• Participate in dry runs and UAT, troubleshooting failures.
• Collaborate with cross‑team stakeholders to align mapping and validation.
• Produce documentation like BRD, conceptual/technical designs and specs for RICEFW.

Skills

Agile Schema Analysis

Data Migration

Cross‑Team Collaboration

Dry Run & UAT Support

Performance Optimization

File Vault Handling

Staging & Transformation

Revision‑Based Extraction

Extraction Script Development

Tools

Oracle Agile PLM

SQL

PL/SQL

SDK

Job description

Pentangle Tech Services | P5 Group in Austin, TX seeks an Agile Data Migration expert—Software engineer with 8+ years’ experience. You will design extraction logic for Item, BOM, Change and File Vault, and build high-volume extract programs using SQL/PLSQL and SDKs.

You will validate data quality, preserve full revision history, and optimize performance while coordinating with PLM, DBAs, SMEs, and integration teams to ensure successful cloud migration readiness.