Ho sostenuto un colloquio presso American Express (Bengaluru)
Colloquio
complicated from screening to final round not so hard need 6 month guidance only
work on your resume nothing else other work is learning tools all the best thats all
Domande di colloquio [1]
Domanda 1
SQL Question 1: Identify the VIP Customers for American Express
For American Express, a key activity may be the use of an American Express Card for transactions. 'Whale' users or VIP users could be defined as those customers who have a high frequency of transactions above a certain threshold (e.g. $5000). Given a transaction table, write a SQL query to identify these 'Whale' users.
transactions Example Input:
transaction_id customer_id transaction_date transaction_amount
001 C001 08/01/2022 00:00:00 4800
002 C002 08/02/2022 00:00:00 6800
003 C003 08/03/2022 00:00:00 5000
004 C001 08/10/2022 00:00:00 5200
005 C002 08/22/2022 00:00:00 7000
Example Output:
customer_id transaction_count
C001 2
C002 2
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso American Express (Gurgaon, Haryana) nel mese di feb 2026
Colloquio
It was a normal interview, with work experience, SQL , Python and statistics questions. Some times puzzles are also asked in the whole process. Prepare according to the things mentioned in the Job Description
Domande di colloquio [1]
Domanda 1
What is hypothesis testing and confidence intervals?
Ho sostenuto un colloquio presso American Express (Bengaluru)
Colloquio
The hiring process began with an online assessment that had three sections, including logical reasoning and SQL (I don’t clearly remember the third section). After clearing the assessment, I proceeded to two interview rounds. The overall process was smooth, structured, and evaluated different skill areas effectively.
Domande di colloquio [1]
Domanda 1
They asked about Random Forest, Xgboost, Decision Trees.
Ho sostenuto un colloquio presso American Express (Gurgaon, Haryana)
Colloquio
It was good. The panelists were very professional and interactive. They were good at dealing the interview and gave proper feedback. The interview contained 2 rounds and both were technical.