Senior Data Migration & Cleansing Analyst

Lead Business Analyst with at least 6 years of relevant experience.
Excellent communication and customer facing skills
Experienced in working in onshore/offshore model
Experienced in Agile program execution A MUST

Analysis of source system in support of the collection of cleansing requirements for each source system with the technical and business system owners
Document data cleansing process and rules for cleansing source systems
Monitor cleansing activity for each in scope source migration system based on the data object supported and business requirements.
Support/Facilitate the source to target mapping of legacy data.
Take ownership of the source to target mapping file and maintain it in conjunction with the functional consultants and general target requirements.
Identify any additional requirements on the source side to support a load to SV such as data enrichment, harmonization, rationalization etc.
Help the source system owners define the active data set required for the migration by providing extraction rules that are documents and kept up to date.
Review the final data extract and verify that it is complete and fit for purpose.
Additional related tasks as required to support the delivery of source data for the migration.

Transform:
Ensure the delivery of extracted data onto the identified data migration staging area based on the agreed data extraction rules.
Work with markets and functional experts to ensure mapping rules and logic are documented, current and complete for each object in scope of the migration.
Ensure that each transformed file is accurate and complete based on the target structure and data design required to be loaded.
Take ownership of transformation issues, ensuring they are resolved.
Work with the technical migration resource to develop, maintain and make updates to the ETL transformation code/load files as required.
Define any transformation requirement that needs to be performed on the active migration data set as required to support the load to the target model.
Ensure ETL unit testing is complete
Maintain and update mapping documents are required.
Provide migration issue resolution based on Unit, SIT, E2E, UAT testing cycles
Additional related tasks as required to support the delivery of transformed data for the migration.
Support teams with load issues as a result of load testing.
Ensure the delivery of target data based on data migration plan.
Act as SPOC on any data related issues that require business input or decision to be made.
Review load error logs and provide triage and resolution/fix to support any load errors.
Provide source system data support where required across data cleansing activity impacting the data load.
Coordinate and facilitate the inclusion of data owners in the data validation exercise.
Support data validation activity where required and drive the process.
Additional related tasks as required to support the delivery remediation off load data for the migration.