I applied online. I interviewed at Microsoft (Redmond, WA) in Sept 2025
Interview
The process was tough but fair. There were two medium/hard sql questions, one easy leetcode style question, and one system design problem. Talked to 3 people in total for the interview.
Interview questions [1]
Question 1
We have a table of daily sales data. Write a query to calculate the 7-day rolling average revenue for each product, but exclude weekends from the calculation and handle gaps in the data.
Coding test and 3 round of interview , Contacted via 3rd party.interview went well.last management round panel said you are good fit.Then they ghosted and didn't give offer.waste of time.
I applied online. I interviewed at Microsoft (Pune) in Oct 2024
Interview
They are used to maintain the integrity of the data, enforce business rules, and automate tasks to certain events in a specific table or view in a database.SQL triggers are stored procedures that automatically