โ† Amazon questions

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.