My profile was shortlisted, and I was called for an interview in Gurgaon Cyber City by the HR.

The MSIT team was from Hyderabad, and I had two interview rounds there.

The first round was very technical. The interviewer, Cyrus, appeared very senior. After that, the HR asked me to wait for the second round.

The second round was also technical and conducted by an interviewer named Saskar. Following this, the HR asked me to leave and mentioned they would get back to me by the following week.

First Round.

1. What is fill factor in SQL Server?
2. What does the UPDATE STATISTICS command do?
3. What is a page in SQL Server?
4. What is the difference between Clustered and Non-Clustered indexes? Include pros and cons.
5. What is the difference between the scale-up and scale-out options?
6. Given a limited time frame, describe some steps at each layer for scaling a web application.
7. Discuss some project-related questions, such as security concerns and how to improve authentication.
8. Address questions relating to updating a delta feed using only a full feed between two similar databases.
9. What is TempDB?
10. If there are two websites, one for desktop and another for mobile, and you need to create a service that interacts with both, how would you implement the service?
11. Which is better, WCF or REST? Why? Provide suitable scenarios.

Second Round.

1. Explain your experience in Software Engineering, Coding, and Scalability.
2. What is your expertise? (The answer given was mobile development.)
3. Why do you observe more traffic on mobile sites compared to desktop or apps? (Consider the target audience in non-metro cities.)
4. Where did you use RedisDB in the application? (This question is related to your project.)