I applied through university. The process took 2 weeks. I interviewed at Allstate
Interview
1 - On Campus 45 minutes. Mix of both technical and behavioral. Easy questions, but had 3 questions to complete in approx 20 mins.
Next Step- Onsite Interviews. One day 10am to 2pm.
4 Interviews: Each 45 to 50 mins long
1st Behavioral
2nd Data Structure Coding, difficulty increases as we move forward
3rd Lunch Interview: Team fit
4th Data Science Case Study: More about the process of thinking and SQL
Interview questions [1]
Question 1
Start with leetcode easy and increase the difficulty of the same question to medium twice.
SQL part was more like how well you know the concepts.
I applied through university. The process took 4 weeks. I interviewed at Allstate (Chicago, IL) in Sept 2019
Interview
Began with a 30 minute face-to-face interview where the recruiter asked a few questions about my resume, then a few technical questions and a case study. The second round interview was on-site in Chicago, which consisted of a 1-hour behavioral, 1-hour technical, and 1-hour case study, all of which were with 2 recruiters.
Interview questions [2]
Question 1
Given 2 tables of size N with the same primary key, how large would the resulting dataset be after a full join, left-join, right-join, and inner-join?
Case Study - General idea is that you are given a data set of customers and insurance agents and asked:
What fields / other data could you use to pair a customer with the best insurance agent?
Describe how you would use queries to uncover information such as getting the insurance agent with the largest number of online sales.