Select / specify appropriate data migration methods for Extract, Transform and Load.
Prepare and maintain data migration methods and supporting deliverables.
Prepare and maintain data cleansing activity and data quality reporting metrics.
Liaise with functional teams to ensure full understanding and communication of data designs.
Determine and Test Data Migrations Method for each data object requiring data load.
Document all specifications for any non-standard data loads required.
Prepare data load procedures to guide the use and control of the data load program.
Create Data Mapping Templates.
Create data reconciliation and test procedures templates.
Ensure Changes to Data Designs are encompassed in data load programs and supporting deliverables.
Review (a sample of) data designs to ensure completeness and compliance with quality requirements for their further use.
(Regularly review actual validation table values against workbooks setting out principles for their use to ensure the workbooks and principles for use are up to date.)
Recognise and respond to changes in data designs.
Graduate with experience of 2-4 years in Data Migrations, SQL and SSIS reporting.
Experience in SQL (SQL Server) and SSIS.
Experience in data designing and data migrations.
Experience in data loading, extracting and transforming with data migration method.
Business Analysis skills within specific functional areas
Knowledge of MS Dynamics data load methods
Understanding of Kingswaysoft for MS Dynamics.
Excellent communication skills.
Willingness and ability to consult.
Able to work alone and as part of a team.
Able to build and maintain relationships with functional team members responsible for data design.