I have an interview with Amazon for business analyst position

MGM Resorts
farheen786

MGM Resorts

PRE
Cognizant, Amazon, Google
farheen786more
Jan 7 27 Comments

I need help to understand what do they ask from technical aspects for business analyst? Do they ask only SQL or do they ask you to create a tableau dashboard upfront and all? And what about behavioral apart from the leadership principles. Can anyone please guide me?

comments

Want to comment? LOG IN or SIGN UP
TOP 27 Comments
  • Amazon / Product
    vmprwrkday

    Amazon Product

    PRE
    Google, Facebook
    vmprwrkdaymore
    I’m going to hate myself for asking this I feel, but I can’t resist: what is the Rule of Stock?
    Jan 7 8
    • Amazon / Product
      vmprwrkday

      Amazon Product

      PRE
      Google, Facebook
      vmprwrkdaymore
      Define “Eurasian” before I answer
      Jan 7
    • Vertivco / Eng
      FastPapuan

      Vertivco Eng

      PRE
      Youtube, American Bureau of Shipping, Facebook
      FastPapuanmore
      I'm guessing you're of South Asian stock, perhaps?
      Jan 7
    • Amazon / Product
      vmprwrkday

      Amazon Product

      PRE
      Google, Facebook
      vmprwrkdaymore
      Oh, not even close. I’m from Eastern European stock.
      Jan 7
    • Vertivco / Eng
      FastPapuan

      Vertivco Eng

      PRE
      Youtube, American Bureau of Shipping, Facebook
      FastPapuanmore
      Good.
      Jan 7
    • Amazon / Product
      vmprwrkday

      Amazon Product

      PRE
      Google, Facebook
      vmprwrkdaymore
      It’s good? That fits the rule of stock?
      Jan 7
  • Amazon / Other amzngap
    Be familiar with window functions, use the sql on the programmer interview website as a guideline for prep. Overall i felt amazon sql is fairly straight forward. Business analyst interviews are dominated by leadership principle questions, be prepared to have responses for questions such as talk about a time you disagreed with your mgr, made a data error, when you distrubed status quo, went above and beyond expectations, where you needed to focus on customer needs
    Jan 7 5
    • Boeing bawannabe
      Are you a BA?
      May 21
    • Amazon / Other amzngy
      I was a BA. I'm a DS now
      May 21
    • Boeing bawannabe
      Do you mind if PM you a couple of questions?
      May 21
    • Amazon / Other amzngy
      Go ahead
      May 21
    • Boeing bawannabe
      Sent one! Thanks
      May 22
  • Amazon MFMS58
    You most likely get one person asking you more technical questions and the rest are all Leadership Principles based. Make sure you spend a lot of time on preparing your stories with a situaion-task-action-result structure.
    Jan 7 0
  • Axtria DesiLaunda
    Leadership principles + SQL. Also prepare details about your current/previous projects.
    Jan 7 0
  • Intuit qbse
    I did this interview before. They will have a shared screen tool where they can see your sql code then they will start explaining a business scenario. I remember one of the scenarios you’ll have to use the HAVING function. After that phase they will ask for some ML questions then high level business questions. My interview was with the homepage team.
    Jan 7 3
    • Amazon / Other -🔥🧀🔥-
      Oh yeah, my boss always tested people by asking the difference between where and having.
      Jan 7
    • Intuit qbse
      Lool do u work in the homepage team?
      Jan 7
    • Amazon / Other -🔥🧀🔥-
      Nope, Worked in FBA
      Jan 9
  • Amazon / Other -🔥🧀🔥-
    I actually went through this a few years ago. Hated amazon business. Really didn’t talk much about sql, mostly leadership principals, problem/solution/value added, and behavioral. But majority of my answers revolved around tableau/sql anyway. Good luck
    Jan 7 2
    • MGM Resorts
      farheen786

      MGM Resorts

      PRE
      Cognizant, Amazon, Google
      farheen786more
      OP
      Thanks for responding. Can you help me with some examples of tableau or SQL questions?
      Jan 7
    • Amazon / Other -🔥🧀🔥-
      Specifically asked what was the most difficult problem I solved with sql. Walk me through how you would get me x from an extremely large dataset, now add in y dimension.

      Tableau wasn’t mentioned, it didn’t exist in my group when I joined and I had to fight to implement. Everyone I ran into that used Tableau always wanted to use live data for reporting. Doesn’t make sense with the way reporting data is stored.

      Be prepared to take over someone else’s queries and WBR.
      Jan 7
  • Amazon synonymos
    Glassdoor question are pretty representative
    Jan 7 0
  • MGM Resorts
    farheen786

    MGM Resorts

    PRE
    Cognizant, Amazon, Google
    farheen786more
    OP
    Thanks all for responding...can anyone help me with some example of SQL or tableau questions asked in Amazon.
    Jan 7 0
  • Vertivco / Eng
    FastPapuan

    Vertivco Eng

    PRE
    Youtube, American Bureau of Shipping, Facebook
    FastPapuanmore
    Same old bull crap and the Rule of Stock. You're welcome.
    Jan 7 0