Agile PLM Data Migration Expert

Wise Skulls LLC; Austin (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Wise Skulls LLC in Austin, TX is seeking a data extraction engineer to design and implement PLM extraction pipelines, handling Item, BOM, Change, AML, and FileVault structures.

You will optimize SQL/PLSQL scripts, validate data quality, support UAT, and collaborate with DBAs, SMEs, and integration teams to deliver clean, ready-for-transformation extracts.

Responsibilities

• Understand Item, BOM, Change, AML, and FileVault structures to design extraction logic.
• Build and optimize SQL/PLSQL/SDK-based extract programs for high-volume objects and revisions.
• Profiling, completeness checks, referential integrity validation, and error triage.
• Implement logic to extract full revision history for PLM+ migration needs.
• Tune queries, indexes, and batch logic to reduce extraction time and improve throughput.
• Extract attachments, manage file paths, metadata, and prepare content for cloud ingestion.
• Deliver clean, structured extract files/tables for downstream transformation and mapping.
• Participate in iterative mock runs, troubleshoot failures, and refine extraction logic.
• Work with PLM+, DBAs, SMEs, and integration teams to align mapping, sequencing, and validation.
• Conceptual design and technical design, Technical Impact Assessments, BRD, and Technical Specifications for RICEFW

Job description

Location: Austin, TX (Onsite: 3 days a week)

JD

Scope of activities and deliverables (not exhaustive list)

Agile Schema Analysis — Understand Item, BOM, Change, AML, and FileVault 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.

FileVault 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)