Data ware housing has been a buzz word in the industry since mid 90’s, but it was not wide spread due to be complex timing and maintenance. Business and technologies are now wider and wider so in modern technologies we cannot think in any organization without data warehouse. Data warehouse helps us to analyze and reporting data for decision making purpose. Online transactional processing (OLTP) can’t store data for a long time.For reason the Online Analytical Processing (OLAP) is now become popular. We develop an architectural model for data ware house ETL tools, which help us to Extract, Transform and Load in an efficient and time consuming way.