Date Migration Engineer - London, United Kingdom - eFinancialCareers

eFinancialCareers

Verified Company

London, United Kingdom

3 weeks ago

Posted by:

Tom O´Connor

beBee Recruiter

Description

The Migration Team has accountability for managing the end-to-end delivery lifecycle for all Migration projects within the firm.

The Data Migration Engineer role requires an individual who can design and implement complex Client-focused data mapping in linewith the firm's Migration SDLC.

The role involves working with big data, designing, developing, maintaining and supporting the Extract, Transform and Load (ETL) process.

Reporting to the Migration Team Lead, you will be an integral part of the team, analysing requirements before designing& implementing solutions.

This role is technical and focused on providing long-term solutions.

The data model and data population routines are a critical part of the migration process, so accuracy and attention to detail are essential characteristics.

THE ROLE:
Data Migration Engineer

Working with Internal and Client SME resources to provide complex data mapping solutions in line with both the client requirements and the company's migration SDLC
Producing technical migration outputs, such as data models, data mapping definitions and data validation rules in line with the target Product and Client Migration requirements
Designing, Creating and maintaining SSIS packages to migrate data to internal databases
Designing and developing ETL workflows conforming to best practices and creating reusable components
Providing solutions and recommendations for the resolution of technical issues that arise, ensuring solutions meet the technical specs, design and nonfunctional requirements
Supporting changes through the testing; resolving data issues, completing unit testing and system documentation for ETL processes
Providing postimplementation support once the migration is complete to support both the project and service & support teams in issue identification and resolution.

SKILLS/

EXPERIENCE REQUIRED:
Data Migration Engineer

Strong Data Mapping and Modelling skills using SQL
Experience in using tools; preferably SSIS or equivalent
Strong relational database design experience working with MS SQL Server
Confident and able to take the initiative given client and deliveryfocused environment
Good team communication skills, confident in dealing with internal and external clients
Highly developed written and oral communication skills
Proficient in data mapping and profiling techniques
Experience in working on Business Intelligence projects
Superior analytical thinking
Able to prioritise own workload and work to aggressive deadlines with mínimal supervision