Amazon Business Intelligence Engineer interview questions

First Interview (With the recruiter): - Ask to pass through my resume. - How I get requirements, with which frequency, and what I ask for. - Size of the data I'm used to work. - Estathistical knowledge I used and scripting language (Python, R) - How to use lead and lag function and aggregations functions. - A time when I worked with a business area, who are they, what was the problem, what was the solution, and which was the quantitative result. - A time when I had to dive deep to discover the root cause of a problem. Second Interview (SQL + Leadership Principles): - When I reached a goal, and exceed it. -When I delivered a project under a tight timeline. - When I got negative feedback and what I did with it - Three things that I do to improve my overall effectiveness. - Amazon wants to flag clients who bought Alexas and Books to send them campaigns to the next Kindle version. What I expected to find in terms of data (which tables and which fields). Then I had to use those tables and create a query to bring the client_id of those clients.