Data Migration Lead (Prior Aerospace / ITAR experience preferred)

• 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 post-purge.
• Define and lead end-to-end 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 non-production 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.

Data Migration Lead (Prior Aerospace / ITAR experience preferred), Data Migration, Aerospace and Defense, Data Migration, Research & Development (R&D), Aerospace and Defense, Data Analysis, Data Profiling, Reconciliation, Error Handling, Database Extract Transform and Load (ETL), PROLIM (www.prolim.com) is currently seeking Data Migration Lead - R&D Application Separation & Migration (Prior Aerospace / ITAR experience preferred) for one of our top Client for Location:100% Remote, * 12-15+ years in data migration, ETL, database development, or enterprise application migration.

• Proven leadership of data workstreams in large-scale migration, separation, divestiture, or transformation programs.
• Strong hands-on 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.

PROLIM is a leading provider of end-to-end IT, PLM and Engineering Services and Solutions for Global 1000 companies. They understand business as much as technology, and help their customers improve their profitability and efficiency by providing high value technology consulting, staffing, and project management outsourcing services.

Their IT and PLM consulting offerings include; Advisory, PLM Software/Services, Program Management, Solution Architecture Training/Staffing, Cloud Solutions, Servers/Networking, Infrastructure, ERP Practices and QA Services. Engineering services include Data Translation, CAD/CAM/CAE, Process & Product Engineering, Prototyping, and Testing/Validation within a wide range of markets and industries.