It 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.
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.
The following metrics were computed from 1 interview experience for the Allstate Data Engineering role in Chicago, Illinois.
Allstate's interview process for their Data Engineering roles in Chicago, Illinois is extremely selective, failing the vast majority of engineers.
Candidates reported having mixed feelings for Allstate's Data Engineering interview process in Chicago, Illinois.