It was to the point, and really good overall. The interviewer was nice.
we just dived into the interview from the start. I think the interview went wrong from my side, where i panicked and didnt answer the sql questions properly even though I knew the answers to the same. :(
Interview questions [1]
Question 1
Q: how do you query tune? if a query is taking more time then it initially did, what may be the checkpoints and order of things to check to look at the cause
Q: [python] find non duplicate numbers in first list and preserve the order of list
[1,1,3,2,5,6,5] --> [1,3,2,5,6]
Q: [python]flatten a nested list
Q: [sql] Rank, row_number, dense rank questions
I applied online. I interviewed at Amazon (Sydney) in Jul 2026
Interview
Applied online and got a link to SQL assessment and finished Phone screen round of 1 hour. Now requested to schedule a call with HR and also waiting to get to know next steps of the process.
Interview questions [1]
Question 1
SQL question, About my previous experience, little bit of data modelling and 1 behavior question
I applied online. I interviewed at Amazon in Jun 2026
Interview
Applied online. Got an OA. OA was not that difficulty, on the easier side to be honest. Got an email asking for interview availability.
Interview in a week. Will update soon.
Very difficult process it took me a round 1 month to get back what’s the review for the interview so I think overall it’s bad experience and difficult interview process while it has lot of questions I wa able to answer