Amazon Business Intelligence Engineer | May 2020
Position: Business Intelligence Engineer
Location: San Francisco Bay Area, CA
Outcome: Accepted Offer
How was the interview process? What was it like?
Amazon underscores on your past experience (a lot). And, talking about it generally is not acceptable. You must connect your past projects and make a story that shows that you possess one of their leadership principles.
What technical questions were asked?
SQL / Pandas, Statistics & AB Testing, Product Metrics and Measurement, Behavioral Questions
What was one of your solutions?
select customer_id, count(distinct(month(date))) unique_months
where year(date) = year(now())
group by cutomer_id
having unique_months = month(now())