American Express Data Engineer Campus Guide: SQL, PySpark and Python in One OA
Prepare for American Express data engineer interviews with reported assessment patterns, interview questions, and preparation advice.
On this page
Last reviewed November 16, 2026.
For students applying as data engineers.
Built by the Codinzhub team from American Express (Amex) questions and experiences that IIT students shared on Codinzhub between October 26 and November 1, 2026. Each one is one student's memory, so use this as a map, not a promise.
The 30-second version. Amex's data engineering OA at IIT Roorkee on October 26, 2026 had 3 coding questions: one SQL query (PostgreSQL) on credit card transactions, one PySpark task where you complete three UDFs, and one Python problem using a given "Messenger API". It tests whether you can work with real data tools, not just algorithms.
How this guide was built. The OA comes from questions IIT students posted on Codinzhub. Where no student has posted the interview rounds yet, the Codinzhub team researched Amex's earlier campus drives, and those parts are marked.
Other Amex roles: Engineer trainee (SDE) · Technology intern · Engineer II · Data engineer · Data science and analytics · DS and analytics intern · Data analyst · AI engineer
Round-by-round breakdown
Stage 1: Online assessment
At a glance
- Length: timed; plan for 90 minutes
- Questions per round: 3: 1 SQL and 2 Python (one in PySpark)
- What was asked: an annual balance after card fees in SQL, PySpark user-defined functions, a counting problem through an API
- Most common: the annual balance SQL question
What students were asked:
| # | Question (our summary) | How to approach it | Practice |
|---|---|---|---|
| 1 | A transactions table of credits and card payments for one year. Compute the year-end balance, charging a monthly fee in any month without enough card payments | Group by month; count card payments and their total per month; apply the fee where the rule fails; sum | Calculate Annual Balance (SQL), Annual Balance for 2020 (PostgreSQL) |
| 2 | Complete three UDFs in a udfs.py file for a PySpark job, following stated rules | Write plain Python functions that handle nulls, then register them | PySpark: Implement UDF Functions |
| 3 | Using only the methods of a provided Messenger API, find the minimum number of distinct elements after allowed operations | Read the API first; then a greedy with counts (remove the rarest first) | Messenger API: Minimum Distinct Elements |
More questions: Browse American Express questions.
Stage 2: Interviews
What to expect. From our research: Amex campus processes are short, usually two interview rounds mixing technical and HR questions. For data engineering, expect SQL (joins, window functions), Python and pandas, how Spark splits work, and your projects.
More from Codinzhub: every college and every year
These are the other 3 questions and experiences for this role on Codinzhub, from all colleges and drives, newest first.
| Question or experience | College or drive | Type | Posted |
|---|---|---|---|
| largest natural number | IIT Roorkee | OA question | 2026-07-22 |
| EnglandCouncilsJob | IIT Roorkee | OA question | 2026-07-22 |
| De Bruijn sequence | IIT Roorkee | OA question | 2026-07-22 |
The Codinzhub Next-Round Playbook
- Practise month-by-month SQL with conditional counts (
COUNTwithCASE, orFILTER). - Write one or two PySpark UDFs before the test so the setup is familiar.
- In API-based questions, read every method's description before coding.
About this guide
This guide is researched and written by the Codinzhub team from what IIT students shared on Codinzhub, plus research into Amex's campus process where student reports are missing. Questions are our own short summaries; the practice links open the full question on Codinzhub. Sat this OA or the interviews? Share your experience on Codinzhub and we will update the guide.
Keep track of what you’ve learned.