First, I was asked for an online technical test, and after clearing that, I was called for a face-to-face interview. Though it was a scheduled interview, many people were called at the same time.

Food was arranged there.

First round was on technical stuff. There were many questions asked on data modeling, SQL queries, and best practices. A real-time scenario was given to me, and I was asked to suggest the model and architecture. They gave me a query with the join of 10 to 12 tables and asked to find the faults and what my approach would be to tune it. Further questions were asked, like which column would be used for partitioning and parallel data load.

After this, I was called for the managerial round. They checked my team handling activities along with technical knowledge.

• How to groom the team.
• What is the best way of putting my solution forward if people are not agreed.
• How to handle the situation if the team is not that technical compatible.
• How to handle conflict management.

After this, a final HR round, in which soft skills were tested, my aspirations were asked, career path was discussed, work culture, and again some questions on behavioral skills. There was no discussion on salary components.

They took my feedback and asked me to leave by saying that I was selected and they would contact me.

After a few days, I got a call for salary discussion, and finally, we agreed on a point.

Scenario-based question on Data Modeling and SQL Query Tuning