Amazon

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

11 questions

PySpark · 4SQL · 3Python · 3Data Modelling · 1

Status	Title	Technology	Topic	Acceptance	Difficulty
○	20.Latest price as of each order	SQL	Data modeling	20.0%	Medium
○	1.Deduplicate customers, keep latest record	PySpark	Window functions	38.1%	Medium
○	14.Month-over-month revenue growth	SQL	Window functions	41.2%	Medium
○	2.Rolling 7-day active users	SQL	Window functions	50.0%	Medium
○	23.Chunked aggregation over a large CSV	Python	Aggregation	100.0%	Medium
○	53.Sessionize a clickstream in Python	Python	Sessionization	100.0%	Medium
○	74.Model returns against orders	Data Modelling	Data modeling	—	Medium
○	80.First and last touch attribution	PySpark	Window functions	—	Medium
○	85.The basket of each order	PySpark	Aggregation	—	Medium
○	90.Day-1 and day-7 retention by cohort	PySpark	Window functions	—	Medium
○	96.Collapse a change feed to current state	Python	Data quality	—	Medium

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