Top 15
Prep plan
Updated weekly · Last refresh Oct 17

Shift Technology Data Engineer Interview Questions

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

15questions
~3htotal time
Track your progressSign up free to work through all 15 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 9 questions · ~91 min
Compute H-Index from IteratorHard

Evaluates algorithm design and correctness for computing h-index from streaming input.

AlgorithmsShift Technology
Standardize Data with NumPyMedium

Tests implementing data standardization with correct NumPy array operations.

numpyData ManipulationShift Technology
Medium-Level Coding PracticeMedium

Tests general coding problem-solving approach and communication on mid-level tasks.

leetcodeAlgorithmsShift Technology
Optimize Array ManipulationMedium

Tests algorithmic thinking and complexity optimization for data transformations.

time complexityArray ManipulationAlgorithmsShift Technology
More Coding questions with a free account
2
Behavioral & Leadership3 questions · ~30 min
Deadline Pressure With Incomplete DataMedium

Tests prioritization under pressure, judgment with incomplete data, and ownership in delivering a decision despite ambiguity.

time managementDealing With AmbiguityPrioritizationShift Technology
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~30 min
Handle New Query Types in PipelineMedium

Assesses pipeline extensibility, backward compatibility, and change management.

pipeline managementquery handlingShift Technology
Overlapping Policy Coverage SQLHard
Practice

Identify overlapping insurance coverage periods for one claimant, including chained overlaps, with PostgreSQL window functions.

Window FunctionsDate Functionsdata anomalyShift Technology
Optimize Join for ClaimsHard

Tests query optimization skills for large-scale insurance claims and policy joins.

Performance TuningJoinsindexesShift Technology

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 15 questions plus 2 hands-on drills to finish this plan.