PLM+ Data Migration

SheJobs-Diversity Focused Organization; Austin (TX); Presencial; USD 120 000 - 180 000; Tempo integral

Resumo da oferta

SheJobs-Diversity Focused Organization is seeking an Agile Data Migration expert for an end-to-end migration of Item, BOM, Change, and File Vault data into the PLM+ platform. You will design extraction logic, develop high-volume scripts, and ensure data quality and full revision history during the migration.

The role involves performance tuning, file vault handling, and collaboration with DBAs and integration teams to deliver clean, structured data for downstream transformation and cloud loading.

Qualificações

• Understand Item, BOM, Change, AML, and FileVault structures to design accurate extraction logic.
• Extract full revision history, not just latest revision, for migration needs.
• Build and optimize SQL/PLSQL/SDK-based extract programs for high-volume objects.

Responsabilidades

• Analyze Agile schemas to map data for extraction.
• Develop and optimize extraction scripts for PLM+ migration.
• Validate data quality: profiling, completeness, referential integrity, error triage.
• Implement revision-based extraction to capture full history.

Conhecimentos

Agile data migration

Schema analysis

Extraction development

Data quality validation

Revision history handling

Performance tuning

FileVault handling

Staging & transformation

Dry run & UAT support

Cross-team collaboration

Ferramentas

SQL/PLSQL/SDK

Descrição da oferta de emprego

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. Let me know if you want a crisp one‑liner for leadership.

This RFR is for below resources

• Agile Data Migration expert - Software engineer

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)