Overview
The Data Migration Consultant will play a critical role in a retail business's ERP transformation project, focusing on migrating data from a legacy AS400-based system to Microsoft Dynamics 365 Finance & SCM. Collaborating closely with both business and technical teams, the consultant will analyze, cleanse, and prepare legacy datasets for successful integration into the new system, ensuring data integrity and quality throughout the migration process.
Responsibilities
- Analyze and understand data held within the existing AS400 ERP environment.
- Extract, cleanse, map, and transform legacy data ready for Dynamics 365.
- Use SQL and ETL techniques to manipulate and prepare large datasets.
- Identify data quality issues, inconsistencies, and gaps ahead of migration.
- Work with business and technical stakeholders to define mapping and transformation requirements.
- Support migration testing, reconciliation, and validation to ensure data is complete and accurate.
- Help establish repeatable migration processes ahead of the D365 implementation.
Requirements
- Strong experience with SQL and ETL/data transformation techniques.
- Experience with ERP or large-scale systems migration programs.
- Familiarity with AS400/IBM i data is highly desirable.
- Previous exposure to Dynamics 365 ERP migrations is a plus.
- Ability to work hands-on with complex legacy data and ensure clarity and structure in data preparation.
- Understanding of data mapping and transformation requirements in migration projects.