Abstract: A method and device for automatically generating Extract Transform Load (ETL) codes includes a code generation device that automatically detects one or more ETL patterns based on the received predefined ETL codes. The code generation device scans pattern database which comprises one or more ETL patterns to determine the presence of the one or more detected ETL patterns. Upon selecting the detected one or more ETL patterns by the user, the code generation device retrieves the selected one or more ETL patterns from the pattern database. User inputs are received for each of the one or more ETL patterns retrieved from the pattern database. The code generation device automatically identifies one or more ETL mappings from the primary data source to the secondary data source for each of the one or more ETL patterns and automatically generates ETL codes based on the one or more ETL mappings.