I applied online. I interviewed at Amazon (Dallas, TX) in Mar 2021
Interview
The interview felt like it should have been for a data engineering role, not a BIE role. I know theres obvious overlap, but every question was focused on data modeling / data engineering concepts when I was told to expect case studies, analytics, or SQL/python coding questions. There was one very simple SQL question and no python question.
Interview questions [1]
Question 1
Row Level Security vs Column Level Security in Tableau?
When to use ELT vs ETL?
Snowflake vs Star?
Interview focused on analytical thinking and case studies. Main focus was on the leadership principles. First interview was a phone interview that covered a few basic questions and SQL coding. The loop had 4 rounds.
Interview questions [1]
Question 1
What is the difference between inner and left join?
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.
Interview questions [1]
Question 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