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 . <EOS>