Microsoft Data Engineer interview questions

HR Scheduled 2 rounds of interviews on the same day. 1st round interviewer has 20 years of experience she is a good listener, understanding, and makes a very comfortable environment which makes me give my best, she asked basic questions + 1 DSA + 2 SQL and asked to convert SQL into PySpark. 2nd round had 2 interviewers one had 3 years of experience which is less than me (5yrs), and the second had 10 years of experience. The second interviewer is grilling me like he wants to prove his supremacy to the other interviewer (girl). He asked questions about what he knew and was proficient rather than asking what I knew. There are no wrong answers because it was mostly scenario-based questions that had many approaches; still, he was like he wanted a perfect candidate. At last, he gave me an SQL question to solve and I solved it correctly but still got rejected. I know he made up his mind to reject me that's why he was doing timepass for one hour. Lastly, HR from 3rd party vendors is the worst; they rescheduled the 2nd interview without informing me and called me to join just because interviewers had joined earlier. Also ghosted me without giving me feedback, I did follow up with her for 2 weeks. I'd say TCS has better interview processes as compared to Microsoft at least interviewers/HR are humble, well-behaved, and respect you.