First, I was contacted for a Phone interview. During the Phone interview, I was interviewed by three people of the team. The interview was pretty straightforward, with questions from my resume and talking about my previous work experience. Followed by that was a in-person interview, I had a written test for 30min, and 2 interviews with the director and few other team members.

There were 3 phone screens before the onsite (1 with HR and 2 with hiring managers). Onsite had 5 scheduled but 4 rounds were taken. Initial 2 to 3 rounds went well(technical and behavioral with director). Then comes 4rth interviewer who was rude and intimidating. He had 8 pages(back to back) sql questions and expected me to complete in an hour. Although I had practiced , I forgot some syntax in the process but interviewer expected me to write the working query. He explicitly said that he was not convinced by my answers. Interview process is to understand the candidates ability to solve the problems and his approach. The whole interview process was like they were looking for a candidate to give answers as they expect instead of listening to how I solved them.