Me postulé a través de una facultad o universidad. El proceso tomó 4 semanas. Acudí a una entrevista en Allstate (Chicago, IL) en sep 2019
Entrevista
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.
Preguntas de entrevista [2]
Pregunta 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.
Me postulé a través de una facultad o universidad. El proceso tomó 2 semanas. Acudí a una entrevista en Allstate
Entrevista
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
Preguntas de entrevista [1]
Pregunta 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.