Meta interview notes, page 224 of 238

“I knew ROW_NUMBER() was the move but fumbled the partition clause at first, wrote PARTITION BY user_id instead of PARTITION BY event_date and just stared at it for a second before catching myself.” The rest of the author's notes on Data Scientist interview at Meta, Onsite - Coding / Algorithms round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.

“BFS felt like the right call immediately and it was.” The rest of the author's notes on Software Engineer interview at Meta, Technical Phone Screen round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.

“I had a story ready but mid-answer I realized it sounded more like I was venting than actually helping someone grow.” The rest of the author's notes on Software Engineer interview at Meta, Onsite - Behavioral / Leadership round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.

“The core design wasn't too bad to sketch out but the race condition piece is where I got stuck.” The rest of the author's notes on Software Engineer interview at Meta, Onsite - System Design / Architecture round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.

“Merge sort and quicksort, pretty much.” The rest of the author's notes on Software Engineer interview at Meta, Technical Phone Screen round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.

“This one sprawls in every direction if you let it.” The rest of the author's notes on Machine Learning Engineer interview at Meta, Onsite - System Design / Architecture round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.

“This one's deceptively meaty.” The rest of the author's notes on Product Manager interview at Meta, Onsite - Product Sense / Strategy round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.

“This question is basically five questions stapled together and they want you to treat it like one coherent answer.” The rest of the author's notes on Software Engineer interview at Meta, Technical Phone Screen round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.

“This part looked manageable until I remembered the edge cases they listed out loud: userids in notifications that have no match in dim_circle_people should be excluded from person-level counts, and some accounts were created mid-August so you still count them.” The rest of the author's notes on Data Scientist interview at Meta, Technical Phone Screen round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.

“Don't have the exact prompt anymore but it was the warmup of the three.” The rest of the author's notes on Software Engineer interview at Meta, Online Assessment (OA) round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.