Top 14
Prep plan
Updated weekly · Last refresh Oct 17

Select Minds Data Engineer Interview Questions

The questions to prepare for a Select Minds Data Engineer interview. Questions from real interview reports rank first. Updated daily.

14questions
~2htotal time
Track your progressSign up free to work through all 14 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 11 questions · ~97 min
Optimize Skewed Spark JoinMedium

Optimize a Spark join where skewed keys create long-running tasks during a transaction to merchant metadata enrichment step.

JoinsperformancesparkSelect Minds
Design Enterprise Data Lake ArchitectureMedium

Design an AWS data lake architecture handling 12 TB/day batch data and 80K events/sec with governed bronze, silver, and gold layers.

InfrastructureETLData ModelingSelect Minds
Secure AWS Pipeline Access DesignMedium

Approach for applying least privilege and security controls to an AWS-based data pipeline infrastructure.

InfrastructureSecurityQualitySelect Minds
Monitor a Mission Critical PipelineMedium

Design a monitoring and alerting approach for a mission critical pipeline, covering system health, data quality, and operational response.

InfrastructureToolsQualitySelect Minds
Production Pipeline Quality MonitoringMedium

Approach for adding data quality checks, observability, and production monitoring to a data pipeline.

Data QualitymonitoringobservabilitySelect Minds
More Pipelines questions with a free account
2
More topics3 questions · ~27 min
E-Commerce Star Schema DesignHard

Tests dimensional modeling ability for analytics use cases in Select Minds client data projects.

fact tablesstar schemadimensionsSelect Minds
Window Functions for Rolling MetricsHard
Practice

Compute an inclusive rolling average for each reading using a row-specific time window.

Window FunctionsDate Functionscomplex queriesSelect Minds
Recovering from Schema DriftMedium

Tests incident response, root-cause analysis, and preventive engineering practices.

resilienceProblem Solvingschema evolutionSelect Minds

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. 2 drills · ~20 min
The finish line: interview-readyComplete all 14 questions plus 2 hands-on drills to finish this plan.