Microsoft Sr. Software Engineer interview questions

It started of well with basic questions without even an Intro, deep dived into more of database systems and much looking for a candidate who knows everything with 10+ years of experience but the job role says 4+ YOE where the interviewer feels 4+ YOE is Junior role. The role expectations are straight away join the team, do the POC's within 2 months of joining who knows all about Azure Cloud, All Databases with well experienced in. solved a sql query at the end while last 10 mins was how to make a person feel low on confidence with free tips. the questions are from LAST CHAPTER of DATABASE SYSTEMS book. The interviewer doesn't know anything when cross questioned or explained. Got for Next round but I refused as the interviewer was giving free life advices and tried to made me feel that I'm not well experienced. toxic manager though!!!

The recruiters were nice and well prepared, they would be efficient in communication and also give valid hints and tips on how you could get the job. There is a test with 3 Codility tasks which eliminates you from the process if you do under 60% if I remember correctly. Unfortunately despite passing they had a hiring freeze so they just cancelled my technical interview that was supposed to follow the process