Data Migration Specialist

Job Description:


Client is looking for Data Migration Specialist to join our engineering team to migrate a legacy database and data into latest sql server environment.. The Data Migration Specialist work closely with stakeholders to identify data needs, assist in designing, planning and managing the data migration process; Manage assigned risks and monitor potential impacts as part of the data migration plan.

Responsibilities (include but are not limited to the following):
• Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements;
• Work independently as a self-starter, and within a team environment;
• Develop best practice, processes, and standards for effectively carrying out data migration activities;
• Perform source system data analysis in order to manage source to target data mapping;
• Perform migration and testing of static data and transaction data from one core system to another;
• Creation of end-user documentation for the new repository, as well as mentoring & training as needed;
• Identification of, or creation of, cost-effective tools that may automate data migration;

Qualifications:
• Degree in Computer Science, Engineering or a related field.
• Experience with Software Development tools: Toad, Golden, SQL Loader, T-SQL, and/or Import/Export tools;
• Some knowledge of SQL Server Migration Assistant (SSMA) tools but not required;
• Experience working in Microsoft SQL Server Databases
• Good problem-solving skills and attention to detail.
• Proficient in data preparation jobs, data analysis and data reporting
• Proficient in SQL authoring and debugging
• Experience in end to end migration is a must.