Top 34
Prep plan
Updated weekly · Last refresh Oct 17

Jpmorgan Chase & Data Engineer Interview Questions

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

34questions
~7htotal time
Track your progressSign up free to work through all 34 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions · ~92 min
Salary Analytics in SQL/PySparkEasy
Practice

Return employees whose salary is greater than the company average salary.

database queryingAggregationsJpmorgan Chase &
SQL And Spark QueryingMedium
Practice

Find all employees tied for the maximum salary using a PostgreSQL CTE and explain equivalent DataFrame and RDD transformations.

Data Analysissql queriesJpmorgan Chase &
More SQL & Data Manipulation questions with a free account
2
System Design10 questions · ~132 min
Spark Cluster Design for 100 GBHard

Design a Spark cluster for 100 GB of data, including node count, partitions, stages, and execution flow.

Jpmorgan Chase &
End-to-End ETL ArchitectureHard

Design a scalable ETL architecture with reliable data flow, optimization, and monitoring for JPMorgan Chase data pipelines.

Feature Storedistributed systemsdata ingestionJpmorgan Chase &
More System Design questions with a free account

Sign up to see every question

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

Get my prep plan
3
Coding7 questions · ~92 min
BST to Skewed TreeMedium
Practice

Convert a BST into an increasing or decreasing right-skewed tree using an in-order traversal.

bstdfsAlgorithmsJpmorgan Chase &
List Processing with PythonEasy
Practice

Replace every list element except a chosen character using a single linear pass.

ArraysJpmorgan Chase &
More Coding questions with a free account
4
Pipelines3 questions · ~40 min
PySpark Transformations and ETLHard
Recently asked

Explain how you applied repartitioning, coalescing, explode, and broadcast joins in a complete PySpark pipeline.

pysparkdistributed computingETL optimizationJpmorgan Chase &
SQL SCD Type 2 and Data ReshapingHard
Recently asked

Implement SCD Type 2 history in SQL and reshape filtered order amounts into one pandas output row.

Data QualitypandasETLJpmorgan Chase &
More Pipelines questions with a free account
5
Behavioral & Leadership7 questions · ~92 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 34 questions to finish this plan.