Ho presentato la mia candidatura tramite l'università. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Allstate (Chicago, IL) nel mese di set 2019
Colloquio
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.
Domande di colloquio [2]
Domanda 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.
Ho presentato la mia candidatura tramite l'università. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso Allstate
Colloquio
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
Domande di colloquio [1]
Domanda 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.