Persistent Data Engineer Interview Questions

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

30questions

~5htotal time

Track your progressSign up free to work through all 30 questions and resume where you left off.

SQL & Data ManipulationStart here. 8 questions + 1 drill · ~82 min

Use a window function to find each customer's second-highest transaction amount for a specified month.

Third Highest Salary Window FunctionMedium

Practice

Return the third highest distinct salary using a window function.

Window Functionsanalytics toolscomplex queries

Persistent

Optimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.

More SQL & Data Manipulation questions with a free account

Pipelines10 questions · ~90 min

Design an Azure Data Factory copy pattern that moves many files in parallel while controlling throughput, retries, and sink consistency.

Handle Inconsistent Document DataMedium

Assesses your data quality strategies for semi-structured inputs in pipelines.

Persistent

More Pipelines questions with a free account

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

Coding5 questions · ~45 min

PySpark, Python, and SQL CodingMedium

Tests your ability to implement end-to-end data transformations across Python, PySpark, and SQL.

pysparksqlpython

Persistent

Create a DataFrame from ScratchMedium

Tests your practical PySpark skills for constructing DataFrames.

pyspark

Persistent

More Coding questions with a free account

Behavioral & Leadership5 questions · ~45 min

More Behavioral & Leadership questions with a free account