Have an Amazon BIE II tech interview coming up. Recruiter said:
Related Posts
Additional Posts in Data & Analytics Consultants
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site

Scan your QR code to download
Fishbowl app on your mobile

For SQL they are testing speed and ability to explain intuitively more than trying to fool you with complexity. Claim to have 4 years of SQL experience? Great! Pull 3 basic queries and explain your logic for each without getting stumped or tripping up. It should come naturally with that much information experience, right? (Working under pressure and not googling or checking past code is the tough part.)
There will be moderate difficulty extractions and transformations. Expect a series of 2-3 questions that ask you to join about 4 tables together and to use the HAVING and a few window functions, and date functions.
Thanks a lot.