I had to solve 2 sql questions on live code. Around easy-medium level. Think of edge cases and talk through your process. Some behavioral questions about my internships and projects too.
1. entretien avec une senior BIE (SQL et python )
2. entretien sur les leadership principles (questions classiques avec la methode STAR)
3. entretien sur les leadership principles avec une BIE
I applied online. I interviewed at Amazon (London, England)
Interview
Applied with CV and they asked for one technical interview focusing on SQL and python, two loop interviews back to back on the same day. The interviews weren't too difficult with basic SQL and window functions. And I had optional Python questions. The loop interviews focus on the LP's so I recommend learning those and having stories for them - they dig deep into your answers so make sure you know them well.
Interview questions [1]
Question 1
1. Window Functions
2. Tell me a time you did Learn and Be Curious
