SFETLD

Systems for Extracting, Transforming and Loading Data

Present the terminology and general concepts related to the domain of data warehouse populating systems.
Know how to justify the implementation of a data warehouse populating system.
Study the basic principles and concepts of data gathering and other advanced techniques for acquiring information in homogeneous and heterogeneous data systems.
Acquire knowledge and expertise in the design and implementation of applications for extracting, transforming and loading data into a data warehousing system.
Know how to conceptually and logically modulate a populating system for a data warehouse, following a standard methodology.
Know the different models and architectures to support the implementation of a populating system.

Introduction to data warehouse populating systems.
Design and implementation of data warehouse populating systems.
Models and services for extracting, transforming and loading data into data warehouses.
Design and implementation of staging areas for settlement systems.
Process workflowing for populating processes.
Models and services for recovery of populating processes
Applications and tools for the development and implementation of populating systems.

Golfarelli, M., Rizzi, S., Data Warehouse Design: Modern Principles and Methodologies, McGraw-Hill Osborne Media; 1st Edition, May 26, 2009.
Kimball, R., Caserta, J., The Data Warehouse ETL Toolkit - Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data, John Wiley & Sons, 2004. ISBN-10: 0764567578. ISBN-13: 978-0764567575.
Densmore, J., Data Pipelines Pocket Reference: Moving and Processing Data for Analytics, O’Reilly Media; 1st edition, March 16, 2021. ISBN-10 ‏ : ‎ 1492087831, ISBN-13 ‏ : ‎ 978-1492087830
Kimball, R., Reeves, L., Ross, M., Thornthwait, W., The Data Warehouse Lifecycle Toolkit - Pratical Techiniques for Building Data Warehouse and Business Intelligence Systems, John Wiley & Sons, 2ª Edição, 2008. ISBN-10: 0470149779. ISBN-13: 978-0470149775.