I applied online. The process took 2 weeks. I interviewed at Amazon (Dubai) in May 2024
Interview
We get to select the interview time upon selecting the interview ad will come. The basic interview questions introduce yourself, SQL questions related to joins ,difference between create, drop and truncate
Interview questions [1]
Question 1
difference between create, drop and truncate , what is rank and dense rank
I applied online. The process took 4 weeks. I interviewed at Amazon in Mar 2024
Interview
4 rounds. screening-technical-behavioral-panel. But was rejecteed at the end due to sponsorship reasons. the panel interview was mainly case based. Screening was with recruiter. Technical was with a business data analyst
The interview process started with a recruiter email, followed by a behavioral assessment. A screening call focused on medium-level SQL questions, follow up questions such as the difference between DENSE_RANK and RANK. The final step was a 15-minute case study question. Overall, the process was thorough and well-structured, with clear communication and relevant questions.