Data Marts and Data Warehouses are fast becoming an integral part of the critical reporting infrastructure in organizations. As a result, the ETL processes that load data into these systems become very important. They need to be robust, reliable and dependent and easily manageable. As a result, your ETL processes need proper mechanisms to handle process failures and restart, rollback, manage dependencies as well as perform data consistency check. Many of these repeatable processes for loading dimensions and fact tables can be implemented in templates to ensure consistent process and management across the entire ETL process. This session will cover the common ETL scenarios and concerns, review common processes and finally show how to implement these repeatable processes in templates that allow consistent process management across all packages and improve developer productivity.