Buy this book. Better yet, get your employer to buy it for the team.
Read chapters 6, 8, and 9.
Revel in the fact that you now know more than 80% of data warehouse engineers and ETL developers.