Openingloading the content…

Loadingone moment…

Finance, Payments & Fintech

Intuit

Fintech / SaaS (TurboTax, QuickBooks) · Data Engineering interview

Expert SQL + advanced Python + Spark internals, plus a signature multi-day "craft demonstration" pipeline you present.

Cloud / platform

AWS-heavy; Spark, Kafka, Delta Lake, Snowflake

Reported difficulty

Not reported

SQLPythonSparkKafkaDelta LakeSnowflake

Hiring process

Recruiter

Technical phone (SQL + Python)

Craft demo + 3 technical

Managerial

Offer

Round-by-round breakdown

SQL

High confidence

Given events + sessions tables, compute sessionized KPIs with runtime/cost constraints
Window functions; cost-aware queries

Python

High confidence

Write a Python job for reversible PII masking before publishing to analytics zones

PySpark / Spark

High confidence

Repartition vs Coalesce
Broadcast join
Spark architecture; deploy modes in Spark

Craft demonstration

· 2–3 days, then presentHigh confidence

Build + present a batch+streaming pipeline (Kafka, Spark, Delta, Snowflake)
Layered models (staging/raw/transformed/analytics)
Defend decisions; data quality + monitoring (not just happy path)

System & pipeline design prompts

Batch + streaming pipeline with layered models and data quality/monitoring

Prep — high priority

Craft-demo pipeline (Kafka/Spark/Delta/Snowflake) with layered models + data quality
Expert SQL (sessionization, cost-aware)
Spark internals (repartition vs coalesce, broadcast, deploy modes)

Prep — medium priority

Warehousing/modeling
Managerial decision-explanation

Rejection patterns

Designing only the happy path (no data quality/monitoring/alerting)
Weak craft-demo decisions/communication
Shaky Spark internals

Reported experiences

Data Engineer 2 (~3.5 YoE)

ReportedFirst-hand

Recruiter → SQL+Python phone → technical (sessionized KPIs w/ cost constraints; reversible PII masking; PySpark repartition vs coalesce, broadcast, deploy modes) → craft demo (batch+streaming w/ Kafka/Spark/Delta/Snowflake) → managerial.

Rehearse for Intuit

Answered questions on what Intuit actually asks — each with the short answer, the answer that gets you rejected, and the follow-up.

Then build one and have it reviewed: design a daily orders pipeline or model a marketplace. No account.

All interview experiences

Openingloading the content…

Finance, Payments & Fintech

Intuit

Fintech / SaaS (TurboTax, QuickBooks) · Data Engineering interview

Expert SQL + advanced Python + Spark internals, plus a signature multi-day "craft demonstration" pipeline you present.

Cloud / platform

AWS-heavy; Spark, Kafka, Delta Lake, Snowflake

Reported difficulty

Not reported

SQLPythonSparkKafkaDelta LakeSnowflake

Hiring process

Recruiter

Technical phone (SQL + Python)

Craft demo + 3 technical

Managerial

Offer

Round-by-round breakdown

SQL

High confidence

Given events + sessions tables, compute sessionized KPIs with runtime/cost constraints
Window functions; cost-aware queries

Python

High confidence

Write a Python job for reversible PII masking before publishing to analytics zones

PySpark / Spark

High confidence

Repartition vs Coalesce
Broadcast join
Spark architecture; deploy modes in Spark

Craft demonstration

· 2–3 days, then presentHigh confidence

Build + present a batch+streaming pipeline (Kafka, Spark, Delta, Snowflake)
Layered models (staging/raw/transformed/analytics)
Defend decisions; data quality + monitoring (not just happy path)

System & pipeline design prompts

Batch + streaming pipeline with layered models and data quality/monitoring

Prep — high priority

Craft-demo pipeline (Kafka/Spark/Delta/Snowflake) with layered models + data quality
Expert SQL (sessionization, cost-aware)
Spark internals (repartition vs coalesce, broadcast, deploy modes)

Prep — medium priority

Warehousing/modeling
Managerial decision-explanation

Rejection patterns

Designing only the happy path (no data quality/monitoring/alerting)
Weak craft-demo decisions/communication
Shaky Spark internals

Reported experiences

Data Engineer 2 (~3.5 YoE)

ReportedFirst-hand

Rehearse for Intuit

Answered questions on what Intuit actually asks — each with the short answer, the answer that gets you rejected, and the follow-up.

Then build one and have it reviewed: design a daily orders pipeline or model a marketplace. No account.

All interview experiences