I was interviewed here recently. It was three rounds:
First HR reached out to me through linkedin and once I was okay with job description
1) HR called me and asked me about my background. I told them specifically that I have some requirements in order to proceed further and told them the requirements.
2) They said they are good to proceed further and scheduled a call with the Hiring Manager. But apparently the manager was busy and software developer called me and asked some technical questions and my background.
3) They said they like my profile and want to schedule an in-person interview. This was for 3 1/2 hrs. Five people interviewed me:
1 hr : This went very well. The person knew what he was asking and no stupid/bookish questions.
30 mins: This went very well too. The person knew what he was asking and it was mostly like a discussion.
1 hr: Now, this person asked me few technical quuestions and some related to scrum process(as I mentioned that I was a scrum master before). He was mostly interested in pointing out that I am wrong or he just says he doesn't the process we follow at our company. And he was interested in giving the explanation for incorrect answers. One interesting thing was he asked me about the scrum process, when I mentioned that we do retrospectives every sprint, he was surprised and he was like why do you retrospectives. And my answer was "to get better at sprint as we were not 100% success". His response was "why do you have to be 100% success, thats like pressurizing the team". I did not understand how they plan the sprint if they do not aim for 100% success, I really wanted to ask him this question "what is your sprint goal", but I couldn't as he left without giving me a chance to ask him any quetsions. He asked me if I had a good experience in SQL. I told him no, and I told him I can learn if its required in this role. His immediate resposne was "Anyone can learn and write SQL queries, its not a big deal".
30 mins: This was a technical round, and this person asked only one question. I gave the answer but maybe not the optimized solution. This person wrote the answer with some implementation and wanted me to give the exact same answer.
30 mins: Two hiring managers were there in this interview. They asked some behavioral quetsions and it went well.