Top 50

Prep plan

Updated weekly · Last refresh Oct 17

American Express Data Analyst Interview Questions

The questions to prepare for a American Express Data Analyst interview. Questions from real interview reports rank first. Updated daily.

50questions

~8htotal time

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

Start practicing free →

SQL & Data ManipulationStart here. 20 questions · ~197 min

Window FunctionsMedium

Practice

Demonstrate window functions by numbering and totaling transactions independently within each cardholder partition.

Data Manipulationdatabase queryingAggregations

American Express

Current Time in SQLEasy

Practice

What command is used to get the current time in SQL? Asked in the data analyst panel stage. Provide a PostgreSQL query that returns the current time at ex...

Date Functionsdatabase querying

American Express

More SQL & Data Manipulation questions with a free account

A/B Testing & Experimentation5 questions · ~49 min

Probability Over TimeHard

Derive the one-hour shooting-star probability from a known 15-minute probability and state the assumptions required.

experiment designMDEprimary metrics

American Express

More A/B Testing & Experimentation questions with a free account

Statistics & Probability11 questions · ~108 min

Estimate People in White ShirtsMedium

Recently asked

Design a statistically defensible sampling approach to estimate how many people at Amex are wearing white shirts today.

EstimationSamplingprobability

American Express

More Statistics & Probability questions with a free account

Behavioral & Leadership9 questions · ~89 min

More Behavioral & Leadership questions with a free account

More topics5 questions · ~49 min

Quantifying Delhi Tennis BallsMedium

Build a defensible, assumption-driven estimate of the number of tennis balls currently in Delhi.

analyticsdata pointsoperational metrics

American Express

Data Profiling DefinitionHard

Recently asked

Explain a data profile and demonstrate how to generate profiling metrics for an ETL pipeline.

Data Qualitydata pipelinesETL

American Express

Guesstimate Cars in GurugramHard

Recently asked

Evaluates structured estimation approach and assumptions for a real-world guesstimate.

Estimationcase study

American Express

Phishy Invoice HandlingHard

Define metrics and a response framework for identifying, validating, and escalating a potentially fraudulent high-value invoice.

operational metricsdiagnostic processactionable insights

American Express

Sign up to see every question

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

Get my prep plan

The finish line: interview-readyComplete all 50 questions to finish this plan.