HR scheduled two rounds of interviews on the same day.

The first round interviewer had 20 years of experience. She was a good listener, understanding, and created a very comfortable environment, which allowed me to give my best. She asked basic questions, one DSA, and two SQL questions, and requested I convert SQL into PySpark.

The second round had two interviewers. One had 3 years of experience, which is less than my 5 years, and the second had 10 years of experience. The second interviewer grilled me as if he wanted to prove his supremacy to the other interviewer (a woman). He asked questions about what he knew and was proficient in, rather than asking about what I knew. There were no wrong answers, as most questions were scenario-based with multiple approaches. Still, he acted as though he wanted a perfect candidate. At last, he gave me an SQL question to solve, which I did correctly, but I was still rejected. I believe he had already decided to reject me, which is why he wasted an hour.

Lastly, the HR from the third-party vendor was the worst. She rescheduled the second interview without informing me and then called me to join only because the interviewers had already joined. She also ghosted me without providing feedback, despite my follow-up for two weeks.

I would say TCS has better interview processes compared to Microsoft. At least their interviewers and HR are humble, well-behaved, and respectful.

Given Dataset (using SQL and convert the same into PySpark):

1. Filter out the records where data is missing or null.
2. Extract the top 5 users with the highest activity per day.

What is normalization/denormalization?

What is Z-Ordering?

How to do incremental load in ADF?