1. A data warehouse test automation framework system comprising: a processing unit coupled to a memory, the processing unit configured to execute the following computer-executable modules stored in the memory: a data generation module that is operable to generate source data comprising data scenarios that ensure specific logic is being validated against a data warehouse, at least one data scenario comprising valid and invalid data inserted into source data, the data generation module further operable to pre-process the data inserted into the source data by marking data as either valid or invalid; and a data validation module with one or more query templates that are operable to provide specifications for checking destination data in the data warehouse to ensure that the destination data is being properly populated from the generated source data by comparing an expected behavior based on the marked data against an actual warehouse behavior.