Amazon·Software Engineer·Technical Phone Screen
- Given an EMPLOYEE table and a DEPARTMENT table, write a SQL query to return all employees whose department ID does not exist in the DEPARTMENT table.
“Classic orphaned-record problem.”
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
“Classic orphaned-record problem.”
“This took longer than I expected.”
“I started with self-attention because I knew it well, explained the query-key-value thing, then talked about multi-head attention letting the model attend to multiple representation subspaces at once.”
“This one tripped me up a little because my first instinct was to pick a story where I looked good at the end.”
“My first instinct was to just use a random number and check if it was already drawn, which the interviewer let me finish before pointing out that gets slow as the deck empties.”
“This one went smoothly.”
“This one is deceptively layered.”
“I started with data parallelism because it's the easiest to explain and bought myself time to think.”
“The setup sounds like a greedy problem and it basically is, but I kept second-guessing myself on the i==j case and whether that changes the counting.”
“This one sprawled fast.”