J'ai postulé via un établissement d'enseignement supérieur ou universitaire. Le processus a pris 4 semaines. J'ai passé un entretien chez Allstate (Chicago, IL) en sept. 2019
Entretien
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.
Questions d'entretien [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.
J'ai postulé via un établissement d'enseignement supérieur ou universitaire. Le processus a pris 2 semaines. J'ai passé un entretien chez Allstate
Entretien
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
Questions d'entretien [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.