Data Scientists Interview Questions

54,225 data scientists interview questions shared by candidates

3 questions, two sql+ 1 python (though can be also easily solved with sql). The sql question is about finding the most popular track and for each track, the day it had most popularity. the python question is about adding certain advs. seconds on every 3,5,15 stream a user had. The interviewer appears having limited experience with sql, as both interviewers had moments first doubting my code, then admit they made mistake. As one example, when doing an inner joining of two tables I had 'From tableA a, tableB b where a.metric=b.metric, the interviewer first asked me where's my inner joining of the two tables, as in her mind it should be written as 'From TableA a inner join TableB b on a.metric=b.metric'. After I explained, she realized both ways writing are equivalent. Though I got all three questions right and well explained, I did not pass the tech interview and there was no feedback.
avatar

Data Scientist

Interviewed at Spotify

4
Feb 10, 2020

3 questions, two sql+ 1 python (though can be also easily solved with sql). The sql question is about finding the most popular track and for each track, the day it had most popularity. the python question is about adding certain advs. seconds on every 3,5,15 stream a user had. The interviewer appears having limited experience with sql, as both interviewers had moments first doubting my code, then admit they made mistake. As one example, when doing an inner joining of two tables I had 'From tableA a, tableB b where a.metric=b.metric, the interviewer first asked me where's my inner joining of the two tables, as in her mind it should be written as 'From TableA a inner join TableB b on a.metric=b.metric'. After I explained, she realized both ways writing are equivalent. Though I got all three questions right and well explained, I did not pass the tech interview and there was no feedback.

Viewing 151 - 160 interview questions

Glassdoor has 54,225 interview questions and reports from Data scientists interviews. Prepare for your interview. Get hired. Love your job.