What are the responsibilities and job description for the Oracle Agile PLM Data Migration expert - Software engineer position at Exl Neo Technologies?
Position: Oracle Agile PLM Data Migration expert - Software engineer
Location: Austin, TX/Sunnyvale, CA (onsite)
Job Description:
NextGen PLM Data Migration is the endtoend process of moving Item, BOM, Change, and File Vault data from Agile PLM into the new cloudbased 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 oneliner for leadership.
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/SDKbased extract programs for highvolume objects and revisions.
- Data Quality Validation Perform profiling, completeness checks, referential integrity validation, and error triage.
- RevisionBased 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.
- CrossTeam 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)