Data Migration Consultant - ROA - Commercial CE

Boardroom Appointments; City Of London; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading recruitment firm is seeking an experienced Data Migration Consultant to join their team in London. You will be responsible for data mapping and migration, focusing on the Customer Experience Module. The ideal candidate will have over 5 years of experience in IT and strong knowledge of SQL, NoSQL, and data modeling. This role offers an opportunity to work closely with technology development teams.

Qualifications

• Minimum of 5 years' experience in an IT-related environment.
• Experience in data migration/data modeling required.
• Knowledge of SQL, NoSQL databases and Big Data is desired.

Responsibilities

• Responsible for Data Mapping and Migration of the Customer Master.
• Manage and drive extraction criteria and data cleansing.
• Engage with business resources to resolve data queries.

Skills

Data Mapping

Customer Experience Module

Kingswaysoft application

SQL

Data Modeling

ETL processes

Data Cleansing

Education

Bachelor's degree in Computer Information Systems

Tools

SQL databases

NoSQL databases

Big Data technologies

Job description

About the job Data Migration Consultant - ROA - Commercial CE

Key purpose:

The Data Migration Consultant is an experienced data migration specialist with the ability to understand integration solutions and drive results for the company. This role will be based in our London office, working closely with the Head of Technology Development. The position requires a minimum of 5 years' experience in an IT-related environment.

Duties and responsibilities:

• Responsible for the Data Mapping and Migration of the Customer Master into the Customer Experience Module (CE)
• Must have experience in the Customer Experience Module as well as the Kingswaysoft application which is used to import the data via SSIS package into the Customer Experience module
• Experience in the Customer Master in F&O to understand the integration via the DualWrite interface
• Manage, facilitate, and drive the extraction criteria, data cleansing, object mapping, field mapping and value mapping for the ETL process
• Manage, facilitate, and drive the filling in of the templates by the Business for the Construct process Facilitate Issue resolution where there are load errors (Defects logged in DevOps)
• Status reporting per functional area as and when needed
• Engage with business resources per stream to resolve data queries

Qualifications and experience:

• Bachelors degree in Computer Information Systems or a related field required
• Experience in data migration/data modeling required
• Knowledge of SQL, NoSQL databases and other technologies such as Big Data and analytics is desired
• Experience developing data marts and ETL processes for multiple platforms