The first round was an hour-long online test that consisted of questions based on logical, quantitative, and verbal aptitude. It also consisted of technical questions based on DBMS and OS concepts and one question on analysis of dashboards used in business intelligence tools like PowerBI and Tableau. The test results came out on the same day, with 15/19 students shortlisted for the interviews.
The second round was the technical interview that lasted for 25-30 minutes. I was first asked to introduce myself and talk about my technical background. The interviewer asked about my projects in which I mentioned my ongoing final year project and 2 others that I had completed in my previous semesters. Next, the interviewer proceeded with asking questions on SQL, for around 10-15 mins, covering almost all possible topics such as types of keys, aggregate functions, joins, schemas, etc. A few graphs were shared and I was asked to analyze the various statistics. Finally, I was asked to give a detailed analysis of the dashboard that was in the online test.
The final round was an HR discussion that focussed mainly on my resume. The interviewer was quite friendly and asked why I chose ECE as my major. I was asked to introduce myself, again, this time including my family background and hobbies along with technical skills. I was asked about my projects again and about my experience in my research internship. I was asked the reason for my low CGPA compared to my school scores. The interviewer asked about my views and experiences on working with a team. Finally, I was asked whether I had any questions for the, where I asked about the day-to-day responsibilities as a BI consultant.
Confidence is the key to acing any interview. In a technical round, if you don't know the answer to a particular question, say it instead of stuttering or showing your nervousness. During the HR interview, a smile goes a long way since it's a very friendly discussion and you have to prove that you are worthy of the role. Most importantly, don't run out of stuff to speak about yourself and your experiences, mention as many details as you can but in a simple manner, especially during the HR round where there is not much focus on the technical details.