Data Migration - Agile/PLM

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

Job summary

Pentangle Tech Services | P5 Group in Austin, TX seeks an Agile Data Migration expert with 8+ years of experience to drive end‑to‑end migration from Oracle Agile PLM to the cloud PLM+ platform. You will design extractions, ensure data quality, and coordinate cross‑team validation to achieve a smooth coexistence and eventual cutover.

The role emphasizes deep PLM data structures, high‑volume extraction, and robust validation, collaborating with PLM+, DBAs, and SMEs to deliver reliable migration

Qualifications

• 8+ years of experience in data migration or PLM environments.
• Strong knowledge of Oracle Agile PLM and cloud migration.
• Experience with extraction, transformation, and loading (ETL) processes.
• Ability to write SQL/PLSQL and SDK-based extraction scripts.
• Experience with file vaults and attachments handling.
• Familiarity with end-to-end migration, delta migrations, and validation.

Responsibilities

• Analyze Agile Schema: understand Item, BOM, Change, AML, and File Vault structures for extraction design.
• Develop Extraction Scripts: build SQL/PLSQL/SDK-based extract programs for high-volume objects and revisions.
• Perform Data Quality Validation: profiling, completeness checks, referential integrity validation, and error triage.
• Implement Revision‑Based Extraction: extract full revision history for PLM+ migration needs.
• Tune Performance: optimize queries, indexes, and batch logic to reduce extraction time.
• Handle File Vault: extract attachments, manage file paths and metadata for cloud ingestion.
• Support Dry Run & UAT: assist in mock runs, troubleshoot failures, refine extraction logic.
• Collaborate Across Teams: align mapping, sequencing, and validation with PLM+, DBAs, SMEs.

Skills

Oracle Agile PLM

Data Migration

SQL

PL/SQL

SDK

Data Quality

File Vault

ETL

Tools

SDK

SQL

Job description

Role

Agile Data Migration expert - Software engineer

Location

Austin, TX

Years of Exp

8+ Years

Oracle Agile PLM - Required

Data Migration - Required

JD:

NextGen PLM+ Data Migration is the end‑to‑end process of moving Item, BOM, Change, and File Vault data from Agile PLM into the new cloud‑based PLM+ platform. It covers base migration for full data load and delta migration for incremental changes. The project ensures accurate data mapping, transformation, validation, and seamless loading into Oracle Cloud PLM+.

It enables coexistence between legacy Agile and NextGen PLM+ until full cutover.

Scope of activities and deliverables (not exhaustive list)

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
• Review and finalized Business Requirements Documents (BRD)
• Technical Specifications for RICEFW (reports, integrations, customizations, extensions, forms, workflows)