Amazon·Software Engineer·Technical Phone Screen
- What is the difference between OLTP and OLAP?
“Knew this cold in theory but started rambling about row vs columnar storage and lost the thread a bit.”
FAANG / Big Tech
Most of these Amazon write-ups come from Software Engineers (1,092), then Data Scientists (182) and Product Managers (165). The most reported rounds are the technical phone screen (618), the behavioral / leadership round (309), the online assessment (228) and the system design round (159).
1581 interview notes · updated Oct 2026
“Knew this cold in theory but started rambling about row vs columnar storage and lost the thread a bit.”
“Pretty standard join-and-aggregate question.”
“Classic BFS/DFS problem once you see it.”
“I went straight to 'let's align all the teams and set up a war room' which in hindsight was probably too operational too fast.”
“I started with the single tree stuff which felt fine, splitting on features, stopping criteria, easy.”
“I blanked for a second because every PM story I prepped was about data saving the day.”
“I knew this one but still fumbled the explanation a bit.”
“The interviewer mentioned fewer than 2 out of 100 candidates answer this correctly, which made me feel pretty good about getting it.”
“I got the core DFS part down pretty quickly but fumbled a bit when they asked about large sparse graphs.”
“I knew the two-heap approach going in, max-heap for the lower half and min-heap for the upper half.”