I was interviewed here recently. It was three rounds:

First, HR reached out to me through LinkedIn. Once I was okay with the 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 were good to proceed further and scheduled a call with the Hiring Manager. But apparently the manager was busy, and a software developer called me and asked some technical questions and about my background.

3. They said they liked my profile and want to schedule an in-person interview. This was for 3 1/2 hours. Five people interviewed me:

1 hr: This went very well. The person knew what they were asking and asked no stupid/bookish questions.

30 mins: This went very well too. The person knew what they were asking and it was mostly like a discussion.

1 hr: Now, this person asked me a few technical questions and some related to the scrum process (as I mentioned that I was a scrum master before). They were mostly interested in pointing out that I was wrong or just saying they didn't know the process we follow at our company. And they were interested in giving explanations for incorrect answers. One interesting thing was they asked me about the scrum process. When I mentioned that we do retrospectives every sprint, they were surprised and asked, "Why do you do retrospectives?" My answer was "to get better at the sprint as we were not 100% successful." Their response was "Why do you have to be 100% successful? That's 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 them this question: "What is your sprint goal?" but I couldn't, as they left without giving me a chance to ask them any questions. They asked me if I had a good experience in SQL. I told them no, and I told them I can learn if it's required in this role. Their immediate response was "Anyone can learn and write SQL queries, it's 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 questions and it went well.

How do you design the tables for a dog show event?

SQL queries related to this.

REST methods.

Find a first non-duplicate object in an array.

Biggest challenge you faced.

What do you like the most in your recent job?

What do you like the most in your recent job?