SQL Data Migration Specialist / SQL Data Analyst/Engineer
Please note: This role does NOT allow for Visa sponsorship, now or in the future ***
Our client, a Global Leader in the Medical Device Industry, has an immediate opening for an SQL Data Migration Specialist for an 4-month+ contract. Our client offers results-driven people a place where they can make a difference - every day! You will also have the opportunity to work with other like-minded, self-directed, and detail-oriented Top Talent in a highly collaborative and professional environment.
This role will support a large-scale ERP data migration validation team ensuring data integrity as records move from legacy systems into SAP.
This role can be performed remotely in the Eastern or Central time zone, but does have specific onsite travel requirements later in the program, Candidates unable to travel will NOT be considered. Travel and Lodging expenses will be reimbursed.
During the deployment phase, this position will work onsite in New Jersey just ahead of the 4th of July holiday and will be working through that entire weekend, with overtime hours likely for troubleshooting and last minute problem resolution.
Position Responsibilities
Supporting a large-scale ERP data migration validation team to ensure data integrity as records move from legacy systems into SAP.Writing, troubleshooting, and optimizing SQL queries and stored procedures that reconcile source and target record counts, surface discrepancies, and confirm completeness across migration batches.Performing primary key matching across source, target, and error/reject tables to identify gaps and mismatches.Building and maintaining stored procedures following a layered staging architecture.Optimizing query performance on large datasets through data type tuning, indexing strategies, and managing complex transformations.Materializing validation results into physical tables for Power BI consumption.Performing sampling-based validation when full-query comparison isn't feasible.