Neenopal Interview Experience for Data Scientist (On-Campus)

Recently, Neenopal visited our campus at the start of August, and here is the interview experience.

First Round(Resume Shortlisting): 

The first round was resume shortlisting, the company’s basic criteria were having a CGPA greater than 9, and the projects and internships that you did during your college journey.

Out of 100+ students, 5 students were selected for the second round of Data scientist and I was one of them, and 7 students were selected for Data Analyst second round.

Second Round(Online Assessment):

A test link was given to us, which was more like an assignment, where you were given 3 questions, and 24 hours to submit them. The first question was on SQL, where a data set was given to us in Excel, and we needed to write the output by using SQL queries, i.e. a number and the explanation of it. The second question, was about Python, where you have another data set, and you need to tell the memory difference before and after changing the data types of a column, using numpy and pandas, in KB, MB, or bytes, and dumping into sql database using numpy and pandas, we need to submit the jupyter notebook link or the code of it. The third question was very hard and included developing the code in Tableau showcasing the YTD sales, and YoY growth, and making charts corresponding to them.

Out of 5 students, 3 students were selected for the interview of Data Scientist.

Third Round(Technical + HR Round):

The interview was scheduled for 45 minutes. I was asked to introduce myself, and then she asked about the ML models that you had worked in. Then, she switched to Python, asking multiple questions regarding it, about the syntax, and how would you create a set of size 1, with its syntax. Then, she asked about the SQL, Union and intersect operators, switch case statements, inserts statements, and all types of joins, and asked me to write 4 to 5 queries, on the table she had provided. I was successfully able to answer them all, then, we had a general discussion on DBMS. The interviewer again, asked about Python, and some OOP concepts.
Then, she moved to the DSA portion, a list of numbers was given, and we wanted to remove duplicates in them, without using any extra space, as well as in a single for loop, it was simple to do with extra space, and with 2 loops, but I was not able to come to the single for loop. After, the interview I searched and then found that we had to use not in operator to achieve it in a single loop. At last, she asked me an aptitude question, which I was not able to solve, but was satisfied seeing my thought process as I was pretty close to the solution.
At last, I asked them about the company and the tech stack that the company works in. She told me that I had good knowledge of SQL, but needed to work more on Python skills, so she asked me if I was comfortable with working as a data analyst intern for the next 6 months, and then she would look for a scientist position after 6 months, I was ready for it, as it was a remote job. But, then after discussion, I told them our college does not allow students to do an internship in the 7th semester, hearing this, they ended the interview in a strange tone, but it was a good experience for me.

No one was selected for either the data analyst or data scientist position. I guess they had canceled the drive listening that the college not allowing students to intern in the 7th semester, as this was the same discussion that was held when I talked to my friends who gave the interview.

Some tips:

Give your best, and rest leave it to krishna, he is always there for you.

All the best….!