Nice Job interview Experience
pic
Apurva Umredkar
Profile
Business Analyst
CTC/Stipend
Login to view this
Criteria
Login to view this
Session
2021-22
Status
Accepted Offer
Round 1

Computer Based Test Interview

Time
60 mins
Difficulty
Easy
Interview Experience

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.

Round 2

Technical Interview

Time
30 mins
Difficulty
Medium
Interview Experience

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.

Round 3

HR Interview

Time
20 mins
Difficulty
Easy
Interview Experience

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.

Additional

Other comments

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.