ETL and ELT

ABBREVIATION

E - Extract
T - Transform
L - Load

Data cleaning

• Format
  
  
  
  Or adresses
  
  

Data validation and checks

Validate age, and data type. Best to fix it as the source.
Deduplication.
Having good data governance rules can reduce the ammount.