Top 19
Prep plan
Updated weekly · Last refresh Aug 30

Oak St. Health Data Engineer Interview Questions

The questions to prepare for a Oak St. Health Data Engineer interview. Questions from real interview reports rank first. Updated weekly.

19questions
~3htotal time
Track your progressSign up free to work through all 19 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 7 questions · ~57 min
Data Quality and Schema EvolutionMedium

Approach for handling schema changes and data quality checks in a high-volume data lake pipeline.

schema evolutionData ModelingQualityOak St. Health
Handle PySpark Data SkewMedium

Approach for detecting and mitigating skew in PySpark pipelines using partitioning, join strategies, and runtime monitoring.

Data Qualitypysparkdata skewnessOak St. Health
Troubleshooting PySpark OOMHard

Tests your Spark internals knowledge and practical debugging skills for memory-related failures.

memory managementperformancesparkOak St. Health
More Pipelines questions with a free account
2
Behavioral & Leadership8 questions · ~66 min
Resolving Data Quality Under PressureMedium

Tests ownership of data quality issues, risk communication to leadership, and stakeholder management under business pressure.

Data QualityCommunicationLeadershipOak St. Health
More Behavioral & Leadership questions with a free account
3
More topics4 questions · ~33 min
Flatten Nested JSON to ParquetMedium

Tests your PySpark skills for schema handling, transformation, and efficient Parquet partitioning.

parquetjson parsingpythonOak St. Health
Direct Joins vs Fuzzy LogicMedium

Evaluates your understanding of SQL techniques for matching and joining data accurately.

JoinsOak St. Health
Broadcast vs Shuffle JoinsMedium

Tests your understanding of join strategies and performance implications in distributed Spark workloads.

JoinsperformancesparkOak St. Health
Indexes and Incremental LoadsMedium

Assesses your ability to make performance and evolution tradeoffs in SQL and pipeline design.

indexingOak St. Health

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
The finish line: interview-readyComplete all 19 questions plus 3 hands-on drills to finish this plan.