I applied online. The process took 3 weeks. I interviewed at Microsoft (Noida) in Jan 2022
Interview
Interviewer does not gave look to my resume & even does not introduced himself. Busy with mobile during video call.
Look like he is not interested to take interview or confused with something.
Precisely interview took 57:30 Min (as joined 2:30 min late) and 21 questions were asked.
Majorly they will ask SQL, although in my case , interviewer itself confused with his own examples. Mixing OLAP and OLTP in same questions and forcing his own solution over candidate solutions.
Interview questions [1]
Question 1
Why Azure synapse ? Pro and cons
Different File Storage format with pro and cons ? which to use & when
Factors applicable while selecting a storage type ?
If sudden slowness between two different system what can be root cause ?
Partition , why to use and how to use
what is data skewness , effect of same in synapse and query processing with example
Integration Runtime
Factors to be considered for injection or set of answers you are looking for.
4-5 SQL questions
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 (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.
Good process highly technical but skilled staff will gently guide you towards the correct thinking to arrive at the conclusion you think is most applicable. All digital, no in-person for early stages (though this might be different later).
