American Express Data Analyst interview questions

Round 1: Online Test comprising of 60 MCQ's(1 mark each with 0.25 negative marking) in 45 mins and 2 coding question of 15 marks each in 30 mins. You can't switch between coding and MCQ portions. In this round I was able to solve around 50+ MCQ's and 1 coding question completely. Round 2: 1. Tell me something about yourself. 2. What do you understand by Interpersonal Skills. 3. Explain your projects(one by one he asked about both my major projects). 4. Then he gave me a series (of prime numbers) and asked to find the next number.(easy enough) 5. Then he asked me find 3 digit numbers which are multiple of both 3 and 4. 6. Then 3 puzzles (available on gfg) — The 4 and 7 min hour glass puzzle, The candle and 45 mins puzzle and one more (you have 10 boxes each having 10 items of 10kg each but one of the boxes is contaminated and has each item of 9 kg . how can you find the defective box in only one measure.) 7. Further He asked to rate myself in programming languages I had mentioned in my resume and asked basics questions on that -: why c++,difference between structure and class,references and pointers, in sql union and union all, acid properties etc. He also gave me a query and asked me tell him output for the same. 8. Finally he asked me how amex generates revenue.