Data Migration Lead - R&D Application Separation & Migration (Prior Aerospace / ITAR experience Preferred)

PROLIM is currently seeking Data Migration Lead - R&D Application Separation & Migration (Prior Aerospace / ITAR experience preferred) for one of our top Client.

Location: 100% Remote

• Lead data discovery and assessment with application owners, R&D/Engineering SMEs, and technical teams to define migration/purging requirements.
• Assess databases, file repositories, document stores, and interfaces to establish inventories for migration, retention, archival, or purging.
• Translate purge/retention requirements into technical rules (filters, exclusions, dependencies, expected results).
• Analyze data dependencies and referential integrity to prevent unintended impacts.
• Conduct data profiling, cleansing, validation, and reconciliation pre and postpurge.
• Define and lead endtoend migration approach (extraction, transformation, loading, validation, reconciliation, exception handling).
• Develop and execute SQL scripts, ETL processes, APIs, stored procedures, and utilities; perform code reviews and nonproduction testing.
• Support SIT/UAT, production cutover, and hypercare, resolving migration and reconciliation issues.
• Provide traceability and reporting on readiness, progress, purge results, risks, and dependencies.

Required Qualifications

• 12–15+ years in data migration, ETL, database development, or enterprise application migration.
• Proven leadership of data workstreams in largescale migration, separation, divestiture, or transformation programs.
• Strong handson expertise with SQL Server, Oracle, PostgreSQL, or equivalent RDBMS.
• Experience developing/executing data migration and purging scripts.
• Knowledge of ETL/ELT concepts, data integration methodologies, and reconciliation frameworks.
• Skilled in handling complex parent/child dependencies and migrating structured/unstructured data.
• Experience with mock migrations, production cutovers, and troubleshooting.
• Ability to translate business purge/retention requirements into executable rules.