Amazon (Business Analyst) interview questions

I went through two phone interviews. The first began with asking me about my greatest accomplishment. Then some logic problems and a finance question. Finally there were several questions about writing SQL. Overall the fist interview went well. The second interview happened a week later. Prior in the week, I was told by the recruiter that the second interview would focus on Amazon's Leadership Principles.. The phone connection was not good. I had to ask several times to repeat the questions. The interview started the same. I was asked about my greatest accomplishment. I gave a different answer from my first interview to show that I have had several major accomplishments. The interviewer then told me that he didn't know anything about the position other than it was for a Business Analyst. I then was asked several questions about SQL. Several times I asked to repeat the question and had difficulty answering the questions. I have over 20 years experience writing SQL using several different tools. I think I am really good at it. A few days after the second interview, I got the email from the recruiter that I would no longer be moving on in the process. I have to say that this process is a joke. I've been in the tech industry for over 25 years and this has to be the most ridiculous process I have ever been through. I think that Amazon is losing a lot of talent through this process. I've hired many people over the years and I have always done my own phone screens. To leave this in the hands of those who don't even know what the position is, is a disservice to the team and to the company. Given the bad press they have had lately, it would seem like they would try harder. It just seems like they are going through the motions and don't really care about what they are doing. Given the poor hiring process, I have to question their business acumen. If you are considering a job at Amazon, think again. You would do better to keep looking.

The process took more than a month. I was interviewed at over the phone with a HR representative. Three one-hour interviews over the phone with technical people (developers and a manager).