Agile Data Migration expert - Software engineer

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. Years of Exp : 8+ Years Oracle Agile PLM - Required Data Migration - Required 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) Omni Inclusive