Intuit Data Engineer Interview Guide

The Intuit data engineer loop, round by round: what each stage tests, example questions with the guidance interviewers actually score, the mistakes that sink strong candidates, and how to prepare.

Last updated: Proudly published by: Jeff Wahl

What the Intuit loop tests: domains and difficulty

Our prediction of the question mix by domain and difficulty for this company's data engineer loop, from live listings and interview reports.

By domain
SQL
36%
5
Python
64%
9
By difficulty
Easy
50%
7
Medium
21%
3
Hard
29%
4

The domain and difficulty mix we predict for a Intuit data engineer loop, across 14 problems. It updates as more Intuit data lands.

Updated 14 predicted Intuit problems

Recent Intuit interview reports

Candidate accounts of the loop, each with its date, level, difficulty, and outcome. Scroll the feed.

1 candidate interview report

real candidate submissions

· seniorMay 2022
Current experience: 5 years Total rounds: 1 + 4 Round 1: Initial screening of 1 hour. Previous projects for 10 mins Concepts of Data warehousing, Data modelling, SCD 2 -3 Medium difficulty SQL questions (Not able to recall exactly what all but the focus was on joins & case statements) Leetcode 2 sum in python Post this, the HR informed that the next round would be a 4hour session & asked to prepare 2 things for the next rounds: 1. A small portfolio of projects in my career I\'m proud of. 2. 2 problem statements that had to be solved with Spark I made a ppt for 2 of my projects(flow diagram of…

Try a Intuit-style SQL round

Find every user active on 3 or more CONSECUTIVE days. This gaps-and-islands shape shows up in nearly every DE SQL round. Edit the query and run it against the seed data.

/* Users active on 3+ consecutive days. */
/* Hint: date minus a per-user ROW_NUMBER is constant within a streak. */
WITH streaks AS (
SELECT
user_id,
activity_date,
activity_date - CAST(
(ROW_NUMBER() OVER (
PARTITION BY user_id
ORDER BY activity_date
))
AS INT
) AS grp
FROM user_sessions
)
SELECT
user_id
FROM streaks
GROUP BY user_id, grp
HAVING COUNT(*) >= 3

Practice the Intuit loop

The problems our model expects in this company's interview, grouped by round. Work the shapes that come up, not the ones that read well on a list.

Intuit is hiring data engineers now

The roles behind this loop. Prep against the levels and locations they are actually filling.

Intuit
Hiring now
Intuit data engineer · live from career pages
4
open roles
Intuit

Lead the design, analysis, and interpretation of experiments Proactively perform data exploration on engagement behaviors to discover future opportunities

L6Mountain View21d ago
Intuit

Build GenAI based solutions to solve for customers/Experts benefit or internal productivity gains.

L6Mountain View41d ago
Intuit

Design, build, and maintain high-throughput, low-latency data frameworks used across Credit Karma's engineering organization, including ETL templates, persistence libraries, and streaming data pipelines

L6Charlotte56d ago
New postings per week
5
6/1
10
6/15
10
7/6
week beginning · ~5 weeks of data
Where they hire
San Francisco Bay Area
2
Levels hiring
L63
Updated 4 open listings across 1 city

Intuit compensation and culture

The numbers, tech stack, and team structure live on the company overview.

Data engineering at Intuit→

The role, comp by level, tech stack, teams, and culture signals.

Intuit data engineer roles by level

Level-specific pages: the comp, the bar, and what the loop tests at each seniority.

Intuit Junior Data Engineer→

Comp, level expectations, and role-specific prep.

Intuit Data Engineer→

Comp, level expectations, and role-specific prep.

Intuit Senior Data Engineer→

Comp, level expectations, and role-specific prep.

Intuit Staff Data Engineer→

Comp, level expectations, and role-specific prep.

Intuit Principal Data Engineer→

Comp, level expectations, and role-specific prep.

Compare Intuit with other data engineering employers

How the role, pay, and loop stack up against peer companies.

Data engineering at Airbnb→

Compare the role, comp, and interview loop.

Data engineering at Amazon→

Compare the role, comp, and interview loop.

Data engineering at Apple→

Compare the role, comp, and interview loop.

Data engineering at Databricks→

Compare the role, comp, and interview loop.

02 / Why practice

Prepare at Intuit interview difficulty

  1. 01

    Reading a solution is not the same as writing one

    Every engineer who has frozen on a query they had read a dozen times knows the gap. The only preparation that closes it is producing the answer yourself, under time, before the interview does it for you

  2. 02

    76% of hiring managers reject on the coding task, not the resume

    From HackerRank's 2024 Developer Skills Report. Candidates who look strong on paper still fail the live screen if they haven't done timed, executable practice

  3. 03

    5 problem shapes cover 80% of data engineer loops

    Dedup, sessionization, top-N-per-group, slowly-changing dimensions, partition tricks. Writing the shapes by hand turns the unfamiliar into pattern recognition

Practice Intuit-level SQL

Related Guides

Data Engineering at Intuit→

The Intuit DE role, comp, tech stack, and culture.

DE Interview Prep Guide→

Complete preparation framework for data engineering interviews.

Data Modeling Questions→

Star schema, SCD, grain definition, and normalization.

Interview Prep

Data Engineer Interview Prep Guide→

50+ guides covering every round, company, and role

Interview Questions
SQLPythonData ModelingData PipelinePySparkAI Coding
Practice Problems
SQLPythonData ModelingData PipelinePySparkAI Coding
Guides & Tools
Data Engineer ResumeData Engineer RoadmapTop 100 QuestionsDE vs Data AnalystKafka vs KinesisData Mesh
By Company
NetflixAirbnbLyftUberTeslaSnowflake