Amazon Business Analyst interview questions

Interviewed for a business analyst position in Seattle. I was very disappointed by the interviewers and the overall process. From the first two interviews, I sensed that the interviews had very big egos, but gave it a chance by going to the in-person interviews. There, I was met with more egotistical people who unfortunately were condescending at times and made it seem as if anyone working for Amazon.com was a genius and that person should count their blessings that Amazon.com thought they were "good enough." I still love the company, but was very, very disappointed by the quality of the people that worked there. Also, when they finally told me no, the recruiter basically was laughing at me since no one else had called me yet and that he was the first one - very professional.

After an online application, a HR person has contacted me per email to ask me to do a homework. There was an Excel table with a lot of data numbers inside and excel sheets. In the end it was a PIVOT table to prepare. Additionally, with sending back the homework I had to state the time spent for doing the homework. 2 weeks later I had an interview with a manager, a girl who was newly promoted ans spoke weird english (i guesss with some Irish or Scottish accent), she asked me a numerical reasoning test on telephone, then a brain teaser followed. 2 weeks later I had another interview with 1 Polish team member, who even tested my Polish (?). She asked if I worked with SQL and Excel. I was one of the last 2 candidates for the position, and they declined without even explaining the reasons why the other candidate was better. I was friendly and asked them per email, but no one ever came back to me. Very unprofessional. In Germany this would be considered as disrespect, and no company does it. THey are very long and slow in desicion making and reacting, which should be no thte case for a distance retailer, especially such as amazon.