1. Phone interview, 2. Assignment, 3. Professional interview about the assignment and more , 4. Professional Interview with a hiring manager - sql queries. 5. Interview with a senior manager 5. HR interview.
Interview questions [1]
Question 1
Talk about your current job, the tools you use in your daily work, and explain every part of the assignment in detail
At first there was a phone interview with a recruiter and then I got a home test which included part of data analysis and part of questions in SQL. The questions were with unequivocal answers, and mostly technical. If in some cases this would have to make assumptions in order to resolve correctly
Interview questions [1]
Question 1
sql question: Application usage data is kept in the following table:
Table sessions: Id, userId, duration, data_timestamp
Write a query that selects userId and average session duration for each “Good User”.
Good User - a user with an average of at least 3 sessions in a week
I applied online. I interviewed at Taboola (New York, NY)
Interview
Straightforward interview process. First round was mostly behavioral questions with interviewer, while later rounds included data analysis projects. Part of the in-person interview was conducted over Skype, which is inconvenient, but is fairly common. Interviewers were all friendly and professional, and the office looked very nice.
