I applied through university. The process took 1 week. I interviewed at MSCI (Mumbai) in July 2024
Interview
The entire hiring process was a very smooth experience , the rounds were as follows:
1. Pre-Placement Talk: Held via Microsoft Teams, where the company introduced MSCI, its values, and culture.
2. Online Test: Conducted on HackerRank with a 75-minute time limit. It included:
2 DSA questions (one involving two-pointer technique, another using unordered_map) and
1 SQL question that involved complex concepts like self-join and group by.
3. Technical Interview 1: Focused on:
Resume discussion, specifically projects and databases.
SQL queries (e.g., join, sum, and order by).
DSA questions like the top-view of a binary tree and choosing a data structure for dynamically balancing students in classrooms.
OOP concepts including inheritance and encapsulation.
4. Technical Interview 2: Involved further project discussion and coding tasks (palindrome check). There was also an emphasis on designing a system (e.g., hospital management using OOP). Some non-technical questions on hobbies and future career plans were also asked.
5. HR Interview: Covered personality-based questions such as self-introduction, future aspirations, and contributions to MSCI. It concluded with queries on the company’s employee engagement and career advice.
Overall, 6 students were offered the internship.
Interview questions [11]
Question 1
How would you design a hospital management system using classes and objects?
SQL Questions:
Find the employees who are either in HR or Engineering Department.
Total salary of employees in each department.
Employee with the second highest salary.