Amazon

Heavy on SQL window functions and PySpark joins, with a data modeling discussion from 5 years up.

9 questions

PySpark · 2SQL · 4Python · 3

Status	Title	Technology	Topic	Acceptance	Difficulty
○	1.Deduplicate customers, keep latest record	PySpark	Window functions	0.0%	Medium
○	2.Rolling 7-day active users	SQL	Window functions	—	Medium
○	4.Skew-safe join on order_id	PySpark	Partitioning	—	Hard
○	14.Month-over-month revenue growth	SQL	Window functions	—	Medium
○	19.Cohort retention by signup month	SQL	Data modeling	—	Hard
○	20.Latest price as of each order	SQL	Data modeling	—	Medium
○	23.Chunked aggregation over a large CSV	Python	Aggregation	—	Medium
○	26.Pipeline task execution order	Python	Data modeling	—	Hard
○	53.Sessionize a clickstream in Python	Python	Sessionization	—	Medium

Community-reported interview topics. Not official Amazon questions and no affiliation is implied.