extract, transform, load

basically takes data from multiple places and maps it to one large warehouse

usually executed through cron jobs and sql queries

e.g.