Date of interview at MSCI was 6/08/2024.

It was an on-campus opportunity I had an online test where two coding questions were easy-moderate and one SQL question. In my interview, there were three rounds in total, the first two of which were technical and the last one being an HR round. In the technical round, there were questions related to OOPs, DBMS and OS and a coding question (DSA). In my second round, I had to answer some questions related to my project and the technologies used in them. Third round was behavioural. They asked general HR questions.

They give me a table and told me to normalise it.

Also after normalisation, they told me to write a basic SQL query to fetch data from multiple tables.