Solicité el puesto a través de la escuela superior o la universidad. El proceso duró 4 semanas. Acudí a una entrevista en Allstate (Chicago, IL) en sept 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.
Solicité el puesto a través de la escuela superior o la universidad. El proceso duró 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.