Jobra
🐞Step 1 of Jobra:AI Debugging Rounds
DSA+AIPreparing you for both.
JOBRA · AI DEBUG ROUND (PREVIEW)sum.cpp
// buggy snippet
int total(vector<int>& a, int n) {
    int sum = 0;
    for (int i = 0; i <= n; i++) { // 🐞        sum += a[i];
    }
    return sum;
}
A real codebase. A real bug. You + AI.

Jobra drops you into a broken repo. Find it, fix it, ship it. AI helps you debug like on the job.

Prompt:Correct the loop condition
Tap 'Let Jobra fix it' below to simulate AI debugging...

American Express Data Engineer Campus Guide: SQL, PySpark and Python in One OA

3 min read

Prepare for American Express data engineer interviews with reported assessment patterns, interview questions, and preparation advice.

In this article
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 itPractice
1A 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 paymentsGroup by month; count card payments and their total per month; apply the fee where the rule fails; sumCalculate Annual Balance (SQL), Annual Balance for 2020 (PostgreSQL)
2Complete three UDFs in a udfs.py file for a PySpark job, following stated rulesWrite plain Python functions that handle nulls, then register themPySpark: Implement UDF Functions
3Using only the methods of a provided Messenger API, find the minimum number of distinct elements after allowed operationsRead 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 experienceCollege or driveTypePosted
largest natural numberIIT RoorkeeOA question2026-07-22
EnglandCouncilsJobIIT RoorkeeOA question2026-07-22
De Bruijn sequenceIIT RoorkeeOA question2026-07-22

The Codinzhub Next-Round Playbook

  • Practise month-by-month SQL with conditional counts (COUNT with CASE, or FILTER).
  • 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.

Ready for the next topic?

Keep track of what you’ve learned.