A method for receiving data from one or more data sources to generate test data, said method comprising: receiving, by a processor of a test data generation and transformation system, a test data query in natural language comprising at least a selection parameter for generation of test data from one or more data sources coupled to the test data generation and transformation system; parsing, by the processor, the received test data query to extract a plurality of domain specific context names; mapping, by the processor, the plurality of domain specific context names with predetermined domain specific meta-data to determine one or more columns, tables, and filter conditions associated with the received test data query, the domain specific meta-data data being associated with each column and table of one or more data sources, wherein the domain specific meta-data is determined by the steps of: extracting one or more tables, one or more columns of each table, and the data type of each column of each table; filtering one or more columns, tables from the one or more extracted tables, columns, and data types; lemmatizing each of the filtered relevant column and table to determine one or more alternative names corresponding to each column and table; and generating domain context specific names for each column and table based on one or more alternative names determined; determining, by the processor, a data source specific executable query comprising one or more columns, tables, and filter conditions associated with the received test data query, based on at least the selection parameter and the mapped plurality of domain specific context names; and executing, by the processor, the data source specific executable query in the one or more data sources to generate the test data. receiving, by a processor of a test data generation and transformation system, a test data query in natural language comprising at least a selection parameter for generation of test data from one or more data sources coupled to the test data generation and transformation system; parsing, by the processor, the received test data query to extract a plurality of domain specific context names; mapping, by the processor, the plurality of domain specific context names with predetermined domain specific meta-data to determine one or more columns, tables, and filter conditions associated with the received test data query, the domain specific meta-data data being associated with each column and table of one or more data sources, wherein the domain specific meta-data is determined by the steps of: extracting one or more tables, one or more columns of each table, and the data type of each column of each table; filtering one or more columns, tables from the one or more extracted tables, columns, and data types; lemmatizing each of the filtered relevant column and table to determine one or more alternative names corresponding to each column and table; and generating domain context specific names for each column and table based on one or more alternative names determined; extracting one or more tables, one or more columns of each table, and the data type of each column of each table; filtering one or more columns, tables from the one or more extracted tables, columns, and data types; lemmatizing each of the filtered relevant column and table to determine one or more alternative names corresponding to each column and table; and generating domain context specific names for each column and table based on one or more alternative names determined; determining, by the processor, a data source specific executable query comprising one or more columns, tables, and filter conditions associated with the received test data query, based on at least the selection parameter and the mapped plurality of domain specific context names; and executing, by the processor, the data source specific executable query in the one or more data sources to generate the test data.