System and method for automating data warehousing processes

A computer-implemented method for automating one or more data warehousing processes, via program instructions stored in a memory and executed by a processor, the computer-implemented method comprising:

• generating codes that facilitate one or more Extract, Transform and Load (ETL) tools to extract, transform, and load data read from one or more data sources, wherein the codes are generated by a code generator connected to the one or more ETL tools using adapters and connectors, wherein the code generator is connected to the one or more Extract, Transform and Load (ETL) tools based on one or more connection parameters received from one or more users;
• reviewing and analyzing the generated codes, wherein the review and analysis of the generated codes comprises identifying unused variables in the generated codes that clog the memory;
• migrating the data read from the one or more data sources to one or more data warehouses, wherein the reviewed generate codes facilitate in migrating the read data to the one or more data warehouses;
• masking the data read from the one or more data sources to generate processed data for testing;
• testing at least one of:
• the read data and the processed data;
• and
• providing one or more status reports on the one or more data warehousing processes, wherein a dictionary matcher facilitates the reporting module in generating a report on outliers in the read data by identifying and highlighting outliers in the read data.

A computer program product for automating one or more data warehousing processes, the computer program product comprising:

• a non-transitory computer-readable medium having computer-readable program code stored thereon, the computer-readable program code comprising instructions that when executed by a processor, cause the processor to;
• generate codes that facilitate one or more Extract, Transform and Load (ETL) tools to extract, transform, and load data read from one or more data sources, wherein the codes are generated by a code generator connected to the one or more ETL tools using adapters and connectors, wherein the code generator is connected to the one or more Extract, Transform and Load (ETL) tools based on one or more connection parameters received from one or more users;
• review and analyze the generated codes, wherein the review and analysis of the generated codes comprises identifying unused variables in the generated codes that clog the memory;
• migrate the data read from the one or more data sources to one or more data warehouses, wherein the reviewed generate codes facilitate in migrating the read data to the one or more data warehouses;
• mask the data read from the one or more data sources to generate processed data for testing;
• test at least one of:
• the read data and the processed data;
• and
• provide one or more status reports on the one or more data warehousing processes, wherein a dictionary matcher facilitates the reporting module in generating a report on outliers in the read data by identifying and highlighting outliers in the read data.