ETL is the short form of extract, transform and load. Data from one or more sources is extracted and then copied to the data warehouse. When dealing with large volumes of data and multiple source systems, the data need to be consolidated. ETL is used to migrate data from one database to another, and is often the specific process required to load data to and from data marts and data warehouses. ETL is employed in the specification of data sources and the various rules employed in the extraction of processing of such data and after this, execute the process for you. In an ETL Software, the procedures and codes are not coded but instead you work in an environment graphical interface in which you are stating rules and employing the use of drag and drop interface to indicate the flows of data in a process. ETL software is employed for use by data oriented developers and DBAs. ETL software are perfect for transferring and loading of huge amounts of data. ETL tools seamlessly and reliably extract, transform and load your data from all of your data sources into one repository.