Amazon Finance Analyst interview questions

1) A first phone call with an HR manager, she wanted to know how my previous experiences could fit into the job. No traditional behavioral (principles) questions were asked. But I answered giving some hints on them. Always try to create your answers matching one of their principles. 2) An Excel - Sql test. Excel: mainly pivot tables, IF and Vlookup functions. However there are different ways to solve the questions but the ones I mentioned are the quickest. Example: I had to find how many companies have "software in their names", given a column of +300 different companies. SQL part is fairly easy. I had to crate some queries, merging two different tables in order to gather the proper information.