SQL Assessment - MCs and 4 medium- hard level questions
Technical Interview - 3 SQL questions (window function, joins) with 1 LP
Interview Loop - The focus was mainly on LP, they ask in depth question about your projects (have many stories, don't say the same story multiple times), your input in the project specifically. They also want to see how you can handle ambiguity. Had 1 SQL round (lead/lag, rolling avg), analytical round (testing your analytical thinking how you would solve problem), business acumen, stakeholder management and data viz round. Know your stories in STAR method, rehearse it multiple times.
Preguntas de entrevista [1]
Pregunta 1
Tell me about an End-to-End Project - Business needs and etc
Envié una solicitud electrónica. Acudí a una entrevista en Amazon
Entrevista
The interview process was smooth and conversational. The interviewer was calmly asking questions about my previous work experiences and listened patiently. He even gave me ample time to frame my answers.
Preguntas de entrevista [1]
Pregunta 1
1. Tell me about your previous work experience.
2. Asked few SQL questions
few rounds of interviews ranging between technical and conversational. Mostly in the form of " tell a story of time where ..." to show how you relate to amazon LPs
The first interview is a technical phone interview that assesses your skills in SQL and Python, specifically data analysis with python. The interviewer pastes the description of an SQL problem on the code editor and asks you to write your answer while describing your thought process. They give you hints when you're stuck.
Preguntas de entrevista [1]
Pregunta 1
Could you tell me the steps involved in the data analysis process?
