They gave me a basic Sql test
Intelligence Interview Questions
6,937 intelligence interview questions shared by candidates
15tech + 30 bq tech: SQL + ab testing bq all about lp 2 rounds, each b2b 15tech + 30 bq tech: SQL + ab testing bq all about lp 2 rounds, each b2b
Many questions were connected with the Amazon values and you had to create answers to align to those values.
Projects I have worked on, SQL, behavioral
SQL window functions, self joins
What are the different types of functions in SQL?
sql in not in, window function
ML concepts, Advanced SQL, Python
What is your top 3 technical skills? How would you rate your SQL skills out of 5?
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.
Viewing 2101 - 2110 interview questions