Data migration factory

A system for migrating data from a legacy system to one or more target systems, the system comprising:

• a memory storing instructions;
• and
• at least one processor configured to execute the instructions to:
• request data from the legacy system via a data request feature, the data being requested by the one or more target systems;
• package and move the requested data to a first landing zone specific to the legacy system via a data packaging feature;
• receive a copy of the packaged data in the first landing zone at a second landing zone specific to the one or more target systems;
• generate control counts and balances related to the packaged data at the second landing zone;
• ingest the packaged data from the second landing zone in a staging layer;
• map the packaged data received from the second landing zone in the staging layer to data expected to be migrated to the one or more target systems;
• establish data transformation rules in the staging layer for transforming the packaged data into data that is compliant with the data requirements of the one or more target systems;
• load general enterprise reference data and reference data specific to the one or more target systems in the staging layer to facilitate the data transformation process;
• perform a completeness check in the staging layer against the originally requested data to confirm all requested data remains present;
• if determined to be complete, transform the packaged data in a transformation layer to data that is compliant with the data requirements of the one or more target systems;
• run data quality and identification rules in the transformation layer to identify any data gaps that arise during transformation;
• if no data gaps are identified, load the transformed data via a first loading feature into applications specific to the one or more target systems;
• validate the loaded data via a validation feature to confirm the loaded data is both complete and accurate;
• if determined to be complete and accurate, load the data via a second loading feature to such downstream systems as an enterprise data storeroom or advanced analytical systems;
• and
• publish the status of the data via a migration reconciliation dashboard as it is migrated from the legacy system to the one or more target systems;
• wherein the data is migrated via a customized path that bypasses one or more features of the system and is subjected to specific controls.