With every iteration of data migration, you need to get progressively better. To achieve this, data validation needs to be a well-documented repeatable process and needs to start early on. Do not wait until the deployment stage to engage the business. Here are a few tips to make this process smoother:
Define validation test cases for both the business and IT validation.