Ecc Migration Engineer

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

For applications and inquiries,