JPMorgan Chase Data Engineer Interview Guide
The JPMorgan Chase data engineer loop, round by round: what each stage tests, example questions with the guidance interviewers actually score, the mistakes that sink strong candidates, and how to prepare.
10 real JPMorgan Chase interview questions
Reported by candidates from real loops, tagged by domain, round, level, and year. Expand for what the round is scoring.
SQLL5 · 2024Write a SQL query to find the difference between the highest and lowest monthly issuance amounts for each credit card name, using the monthly_cards_issued table (columns: card_name, issued_amount, issue_month, issue_year)Onsite · sql+
Expected approach: SELECT card_name, MAX(issued_amount) - MIN(issued_amount) AS issuance_difference FROM monthly_cards_issued GROUP BY card_name ORDER BY card_name. The schema is explicitly provided: monthly_cards_issued(card_name VARCHAR, issued_amount INT, issue_month INT, issue_year INT). Follow-up may ask about handling NULL issued_amount values. Part of the coding assessment for Senior Data Engineer onsite loop.
SQLL4Write a query that outputs the name of each credit card and the difference in the number of issued cards between the month with the highest issuance and the lowest issuance; arrange results by largest disparity first; schema: monthly_cards_issued(card_name VARCHAR, issued_amount INTEGER, issue_month INTEGER, issue_year INTEGER)Phone screen · screen sql+
PythonL6 · 20261. Write a code in python to print only duplicates in the list,Phone screen · screen sql+
PythonL6 · 20262. How do I use pandas to filter rows by ID, sort by order number, and reshape the amounts into separate columns like amount_1, amount_2, amount_3 in a single output row?”Phone screen · screen sql+
PythonL5 · 2025Write a function replace_words to stem words in a sentence by replacing each word with its shortest matching root from a given dictionaryOnsite · python+
JPMorgan Chase Data Engineer coding round. Given a sentence string and a list of root words, replace every word in the sentence with the shortest root that is a prefix of that word. If no root matches, keep the original word. Example: roots=["cat","bat","rat"], sentence="the cattle was rattled by the battery" returns "the cat was rat by the bat". Expected approach: build a set or trie from roots, split sentence into words, for each word check all prefixes against root set. Follow-up: optimize for large dictionaries using a trie structure.
PythonL3 · 2025Write a function find_bigrams that takes a string and returns a list of all sequential two-word pairsOnline assessment+
JPMorgan Chase Data Engineer online assessment (CodeSignal). Given a string, split into words and return a list of tuples where each tuple contains two consecutive words. Example: "the quick brown fox" returns [("the","quick"), ("quick","brown"), ("brown","fox")]. Expected approach: split string, iterate with range(len(words)-1), build list of adjacent pairs. Edge cases: single word returns empty list, extra whitespace handling. Listed as Easy difficulty.
PythonL61. Write a code in python to print only duplicates in the list,Technical · screen+
PythonL62. How do I use pandas to filter rows by ID, sort by order number, and reshape the amounts into separate columns like amount_1, amount_2, amount_3 in a single output row?”Technical · screen+
Data modelingL6 · 20263. Question oin SCD type 2 logic in SQLPhone screen · screen sql+
Data modelingL63. Question oin SCD type 2 logic in SQLTechnical · screen+
The phone screen focuses on Python: expect live coding with data transformations and aggregations where edge cases matter. The full loop centers on pipeline architecture, and the working stack is AWS, CI/CD and Databricks with Python, SQL and PySpark. At JPMorgan Chase, strong pipeline answers connect design choices to constraints the bank actually faces. That means audit retention windows, cross-system reconciliation, and what keeps a downstream risk report trustworthy after an upstream delay. PySpark fluency carries real weight; prepare to talk through partitioning strategy, shuffle cost, and how you'd design a batch job to be safely rerunnable after a partial failure. Databricks appears in current listings consistently, so practice writing parameterized jobs and handling schema evolution in notebook workflows rather than ad hoc exploration code.
Walk into Jpmorgan Chase knowing the SQL pattern they'll test.
Strong candidates who've done solid work at tech companies often lose offers here because they design for speed rather than governance. The tell shows up in pipeline scoping: they skip idempotency, treat reruns as edge cases, and describe monitoring purely in terms of job success or failure, with no mention of data quality checks that would satisfy a downstream audit. JPMorgan Chase interviewers also watch how you handle ambiguity. The bank's internal data systems are large and org-siloed, and requirements rarely arrive fully specified. Candidates who wait for a complete problem statement before engaging tend to read as junior regardless of experience level. On the behavioral side, stories about moving fast or shipping something imperfect land poorly here. The hire describes a pipeline built to a standard someone else can audit, maintain, or recover from without them in the room.
Try a JPMorgan Chase-style SQL round
Find every user active on 3 or more CONSECUTIVE days. This gaps-and-islands shape shows up in nearly every DE SQL round. Edit the query and run it against the seed data.
JPMorgan Chase's data engineering loop is designed to surface precision under constraint. The firm runs financial infrastructure where a broken pipeline can delay settlement for millions of accounts, trigger regulatory flags, or cascade into a compliance incident. Interviewers are calibrating for whether you design data systems that are auditable, recoverable, and aligned with risk controls. The process rewards engineers who proactively build for failure, document lineage clearly, and reason about what happens when data arrives late or dirty. Engineers from pure-tech backgrounds sometimes underestimate how much behavioral questions carry here. At JPMorgan Chase, how you describe ownership and escalation matters as much as pipeline design. Building something that can't survive a compliance review reads as a gap, even if the pipeline itself is technically sound.
JPMorgan Chase is hiring data engineers now
The roles behind this loop. Prep against the levels and locations they are actually filling.
Start with Python: the screen filters on it, and the loop's architecture rounds build from it. Sharpen your pandas and PySpark fundamentals first, then shift prep time to pipeline architecture, which carries the most weight in the full loop. A useful frame: work through a financial data pipeline end to end, building in schema validation, idempotency, and a manual recovery path. Those 3 design elements come up repeatedly in JPMorgan Chase system design conversations. AWS and Databricks are the primary platforms; if you haven't written a parameterized Databricks job recently, do that before your loop. On leveling: mid sits at $162K, and $347K at L7 reflects a bar where cross-team architecture ownership and delivery history carry more weight than individual pipeline depth. Prepare your delivery history in detail: dates, scope, measurable impact.
Build and operate batch and streaming data pipelines with strong scalability, performance, and fault tolerance
Build and optimize batch and streaming data pipelines with strong performance, fault tolerance, and observability
As a Lead Software Engineer at JPMorganChase within the Corporate - Risk Technology, you are an integral part of an agile Data Platform and Strategy Team driving the design, development, and delivery of advanced data engineering solutions and market-leading technology products.
As a Lead Software Engineer at JPMorgan Chase within the Commercial & Investment Bank – Digital and Platform Services line of business, you are an integral part of an agile team that works to enhance, build, and deliver trusted market-leading technology products in a secure, stable, and scalable way.
As a Lead Software Engineer at JPMorgan Chase, within the Commercial & Investment Banking – Data Analytics – Payments Technology team, you are an integral part of an agile team that works to enhance, build, and deliver trusted market-leading technology products in a secure, stable, and scalable way.
JPMorgan Chase compensation and culture
The numbers, tech stack, and team structure live on the company overview.
Compare JPMorgan Chase with other data engineering employers
How the role, pay, and loop stack up against peer companies.
Prepare at JPMorgan Chase interview difficulty
- 01
Reading a solution is not the same as writing one
Every engineer who has frozen on a query they had read a dozen times knows the gap. The only preparation that closes it is producing the answer yourself, under time, before the interview does it for you
- 02
76% of hiring managers reject on the coding task, not the resume
From HackerRank's 2024 Developer Skills Report. Candidates who look strong on paper still fail the live screen if they haven't done timed, executable practice
- 03
5 problem shapes cover 80% of data engineer loops
Dedup, sessionization, top-N-per-group, slowly-changing dimensions, partition tricks. Writing the shapes by hand turns the unfamiliar into pattern recognition