Agile PLM Data Migration Architect

TechDigital Group; Austin (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

TechDigital Group is seeking an experienced PLM data migration professional to lead end‑to‑end extraction from Agile PLM to the cloud‑based PLM+ platform. The role focuses on data mapping, transformation, validation, and loading, ensuring coexistence between legacy Agile and NextGen PLM+ until full cutover.

The candidate will design extraction logic, develop high‑volume scripts, validate data quality, and collaborate with DBAs and SMEs to align mappings and validation processes.

Qualifications

• 8+ years experience
• Oracle Agile PLM - Required
• Data Migration - Required

Responsibilities

• Agile Schema Analysis — Understand Item, BOM, Change, AML, and File Vault structures to design accurate extraction logic.
• Extraction Script Development — Build and optimize SQL/PLSQL/SDK‑based extract programs for high‑volume objects and revisions.
• Data Quality Validation — Perform profiling, completeness checks, referential integrity validation, and error triage.
• Revision‑Based Extraction — Implement logic to extract full revision history, not just latest rev, for PLM+ migration needs.
• Performance Optimization — Tune queries, indexes, and batch logic to reduce extraction time and improve throughput.
• File Vault Handling — Extract attachments, manage file paths, metadata, and prepare content for cloud ingestion.
• Staging & Transformation Support — Deliver clean, structured extract files/tables for downstream transformation and mapping.
• Dry Run & UAT Support — Participate in iterative mock runs, troubleshoot failures, and refine extraction logic.
• Cross‑Team Collaboration — Work with PLM+, DBAs, SMEs, and integration teams to align mapping, sequencing, and validation.
• Documentation artifacts, including but not limited to: — Conceptual design and technical design — Technical Impact Assessments — BRD reviews — Technical Specifications for RICEFW

Job description

TechDigital Group is seeking an experienced PLM data migration professional to lead end‑to‑end extraction from Agile PLM to the cloud‑based PLM+ platform. The role focuses on data mapping, transformation, validation, and loading, ensuring coexistence between legacy Agile and NextGen PLM+ until full cutover.

The candidate will design extraction logic, develop high‑volume scripts, validate data quality, and collaborate with DBAs and SMEs to align mappings and validation processes.