Amazon Data Scientist interview questions

Interview for L6 Role. First round was Hackerrank OA, pass/fail evaluation. It was 2 SQL coding questions with window functions like RANK/AVG and then 20 SQL multiple choice questions like 'which of the following has valid syntax'. Second Round was Phone Screen for 1hr, 1 leet code medium question on anagrams (25 min), bias and variance, mini-system design questions, 'how to design LLM', 'how to design a DB'. Final Loop was 5 interviews focusing on: 1) A/B testing and traditional ML modeling questions (regularization, bias/variance, overfitting etc) 2) Hiring manager conversation, mostly behavioral and resume deep dive 3) Science Application -- basically 3 Case Study problems somewhat hard on NLP/LLM since it was mentioned in the role 4) Bar Raiser Behavioral, make sure you know your big accomplishments and can answer 'what did you learn' 5) Data Manipulation Coding Interview -- all pandas they wouldn't let me use SQL. Do not waste your time hammering in leet codes for this one, practice common pandas functions for data science