Data migration consultant - SQL

London, United Kingdom

Contract
£250 - £350 per day

My client is in need of a contract SQL Data migration consultant for an initial 3 months. The role has been deemed outside IR35 and can be worked remotely. They're in the process of migrating data from their old CRM to their new Salesforce CRM solution, and as such need a Data migration consultant to come in and line up timelines and essentially set the company up for the migration.
Experience required:

• Experience of extracting large volumes of data from a Microsoft SQL Server database.
• Experience of extracting data from CRM systems, eg. Salesforce, Microsoft Dynamics 365 - the candidate needs to understand how the CRM models data across multiple tables for the same item. For example, notes on an activity are held in a different table to the main activity information. You need to understand data models so as to know what is relevant and what is not.
• As the new solution is providing templates for populating the data to be migrated and will be performing the upload to the new system, the individual does not necessarily need the Salesforce data import/migration skills specifically but needs to understand the steps involved.
• Able to identify how documents have been stored in the current system (which are in the database) and to be able to extract them and link them to Clients/Services/Projects etc. ready for loading into the new platform in a format defined by the new vendor.
• Ability to analyse existing data usage (tables and columns) and map those to the new system.