TELECOMMUTE Data Migration Lead - R&D Application Separation & Migration

PROLIM Global Corporation

United States

10 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Application Programming Interfaces (APIs) Data Analysis Code Review Databases Data Discovery Data Integration Data Integrity Extract Transform Load (ETL) Data Migration Data Profiling Relational Databases Database Development

+7 more

PostgreSQL Microsoft SQL Server Oracle (Applications) SQL Stored Procedures SQL Databases Unstructured Data Enterprise Software Applications

Job description

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.

Requirements

PROLIM is currently seeking Data Migration Lead - R&D Application Separation & Migration (Prior Aerospace / ITAR experience preferred) for one of our top Client., * 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.