Business Analyst: What is ETL process for BAs?

ETL — Extract, Transform, Load data process.

Stages:

• Extract — pull from sources.
• Transform — clean, reshape.
• Load — load to target.

Transformations:

• Cleansing (fix errors).
• Deduplication.
• Aggregation.
• Format conversion.

Example:

BA role:

• Mapping rules.
• Quality requirements.
• Validation criteria.