Where can I find Allstate interview experiences by job title?

Claims Adjuster (498) ; Licensed Sales Producer (424) ; Insurance Agent (380) ; Customer Service Representative (325) ; Sales Representative (194) ; Sales Associate (160) ; Insurance Sales Agent (121) ; Sales (118) ; Claims Specialist (117) ; Licensed Insurance Agent (106) ; Consultant (102) ; Software Engineer (88) ; Senior Consultant (87) ; Claims Service Specialist (86) ; Agency Owner (85)

Skip to content Skip to footer

Notifications

Allstate

Allstate Data Engineering interview questions

based on 2 ratings - Updated 2 Feb 2020

Average interview difficulty

Very positive interview experience

How others got an interview

100%
Campus recruiting
Campus recruiting

Interview search

2 interviews

Data Engineering Interview

2 Feb 2020

Anonymous interview candidate

Declined offer

Positive experience

Average interview

Application

I applied through university. The process took 2 weeks. I interviewed at Allstate

Interview

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

Interview questions [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.

Answer question

Data Engineering Interview

10 Oct 2019

Anonymous interview candidate

No offer

Neutral experience

Average interview

Application

I applied through university. The process took 4 weeks. I interviewed at Allstate (Chicago, IL) in Sept 2019

Interview

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.

Interview questions [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?

Answer question

Question 2

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.

Answer question

Top companies for "Compensation and Benefits" near you

Aon

3.5★Compensation and benefits

Marsh

3.5★Compensation and benefits

Marsh Risk

3.5★Compensation and benefits

Swiss Re

3.8★Compensation and benefits

Jobs at Allstate

Business Architect Senior Manager

United States

US$120K - US$194K /yr

(Employer provided)

View job

AI Governance Lead Consultant

Software Engineer (AI/GenAI Platforms) -

Product Engineer – Java Spring Boot w/ Full Stack Option

Lead AI & Technology Risk Auditor

Allstate interviews FAQs

Allstate interviews Allstate Data Engineering interviews

Allstate

Allstate Data Engineering interview questions

Average interview difficulty

Very positive interview experience

How others got an interview

Interview search

Data Engineering Interview

Data Engineering Interview

Top companies for "Compensation and Benefits" near you

Jobs at Allstate

Allstate interviews FAQs

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches

Data Engineering Interview

Data Engineering Interview

Top companies for "Compensation and Benefits" near you

Jobs at Allstate