Data Engineering Concepts
Filed under Amazon
The question
The interviewer asked for differences between physical joins, hash joins, and broadcast nested loop joins; GROUP BY vs Window functions; SCD types; Star vs Snowflake schema; Data Warehouse vs Data Lake vs Lakehouse; batch vs event-driven ingestion; and concepts of idempotency and CDC.
No write-up yet. Related questions below have one.
Related Amazon questions
Collected from public candidate posts and coding forums. Updated Nov 2026.