Oak Street Health Data Engineer Interview Questions
The questions to prepare for a Oak Street Health Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Covers frequent pipeline design mistakes, especially around ETL, orchestration, idempotency, and data quality.
Oak Street HealthDiscuss practical experience using a data warehouse for analytics, including loading, transformation, orchestration, and data quality.
Oak Street HealthDiscuss preferred container orchestration tools for running pipelines, and explain the trade-offs behind the choice.
Oak Street HealthOptimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.
Oak Street HealthEvaluates your understanding of SQL techniques for matching and joining data accurately.
Oak Street HealthEvaluates your indexing strategy and how you manage schema evolution and incremental ingestion.
Oak Street HealthRewrite a slow PostgreSQL loan payment query to reduce scanned rows while preserving the required aggregated results.
AmeripriseEEltro Cyberchrome Private
EnergyHubRank Oak Street Health patients by visit count and return the top 10 with deterministic tie-breaking.
Oak Street HealthSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests core algorithmic implementation skills and attention to correctness.
Oak Street HealthRemove duplicate patient IDs with a set while preserving the order of first appearance.
Oak Street Health