Microsoft·Software Engineer·Technical Phone Screen
- Write a SQL query to rank employees by salary within each department.
“Pretty standard window function territory.”
FAANG / Big Tech
Most of these Microsoft write-ups come from Software Engineers (372), then Product Managers (124) and Machine Learning Engineers (53). The most reported rounds are the technical phone screen (255), the product sense round (111), the system design round (93) and the behavioral / leadership round (49).
597 interview notes · updated Oct 2026
“Pretty standard window function territory.”
“I started with the obvious hashmap approach, message to last-printed timestamp, and they seemed fine with that.”
“This is the core question and it took up most of the session.”
“This was the whole interview basically.”
“I started with the obvious stuff: Task Manager, then moved to Process Explorer for more detail on parent-child relationships and unsigned binaries.”
“My first instinct was to treat it like a generic tree and do some kind of recursive scan, which would've worked but completely missed the point.”
“My first instinct was binary search and that was wrong.”
“I started with CRUD on items and variants, which felt like the obvious entry point, but I should've gotten to the stock concurrency piece faster.”
“This is the kind of question that sounds scoped until you actually start answering it and realize it branches everywhere.”
“I knew the basic fix (divide by length) but fumbled when they pushed on the alpha parameter.”