Systems and methods for distributed data validation

A system for validating a target data table of a target data store based on a source data table of a source data store remote from the target data store, each of the target data table and the source data table including one or more rows and one or more columns for storing data elements, the system comprising:

• a distributed memory comprising a plurality of computing systems, each computing system in data communication with at least one of the source data store or the target data store to receive at least a portion of the source data table and the target data table and configured to store the portion in a local random access memory such that the distributed memory includes the entirety of the source data table and the target data table;
• a checksum comparison engine in data communication with the distributed memory and configured to respond to a checksum request by computing a checksum result indicating whether one or more source checksums computed based on the source data table match one or more target checksums computed based on the target data table;
• a data aggregation engine in data communication with the distributed memory and configured to respond to a data aggregation request by computing a data aggregation summary for one or more columns of the source data store and one or more columns of the target data store;
• a rule generation engine in data communication with the distributed memory and configured to respond to a rule generation request by computing one or more validation rules based on the source data table;
• a validation engine in data communication with the distributed memory and configured to respond to a validation request by evaluating each row of the target data table based on the one or more validation rules to produce a validation report;
• and
• a user interface configured to generate an output based on the checksum result, the aggregation summary, and the validation report.