1. A data warehouse test automation framework system comprising: a data generation module that is operable to generate data scenarios that ensure specific logic is being validated against a data warehouse; 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 source data.