Data Migration Lead - R&D Application Separation & Migration

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.