Can anyone shed some light on the the types of SQL questions presented during the SQL phone screen and ‘on-site’ technical interview for Amazon BA roles? I’ve been using SQL for years but I don’t have experience with these types of interviews. Any resources or references are welcomed. Edit: Passed the phone screen. What should I expect the full loop SQL tech interview to look like? From the insights shared so far it seems to vary depending on the team. What is most likely in everyone’s experience: more live SQL, case studies, case studies with SQL or mostly LPs focusing on the analytics? #interview #interviewquestions #laidoff
It varies from joins, to basic SQL questions, and window functions You should be fine if you know the basics and have used SQL brush up on window functions tho and lots of LPs
What about onsite?
Thanks for the details. Any resources out there I can use to test my basic SQL skills in interview format? I know SQL but I get ‘test anxiety’ due to feeling ill prepared despite my skills. Thus my question, how can I prepare most effectively for SQL interviews. To be clear, I’m fine with standard work stress, I love and live for it.
Hackerrank and leetcode
Agree with the guy above. Just had an interview for a product analyst role at a well known food delivery company. The way I prepped was I did as many sql questions on leetcode as I could. Felt confident just because of the sheer repetition I practiced pre-interview
Can you delete or manipulate the Data that is being inserted into a table?
No, Because transaction locks
I haven’t delete data irl but yes I can in Leetcode.
The recruiter should give you some resources. They’ll probably ask some data warehousing questions around scd type 2 and such. For Sql, expect some subqueries, aggregations, joins and window functions. Probably something around performance to see if you’re scanning tables more than u should. They could also ask around administration stuff. Partitioning of tables. How you d perform deletes of partitions or tables. Delete vs truncate. Backups, replication, mirroring. It depends on interviewer and bar raiser.
Where to study this from? Leetcode only focusses on the first part
Do focus on the leadership principles and have good technical examples of interesting problems you solved. That weighs probably more than the sql...
The tech/sql phone screen is prior to the the real interview loop. You have to pass it to move forward.
Yes, that one is going to be sql and data warehousing principles...
If you know joins well and window functions you should be fine on sql end. The only ones to brush up on are maybe when you have to join on <> not =. Maybe take a look at how to get a window function return running totals after u do the other aggregations. Counts over different partitions as well. Or like a sum(case when this 1 else 0) with partitioning type of conditional aggregations
Try to solve Leetcode medium problems, in less than 5 minutes. I interviewed for BIE (and got the offer), and people say BIE SQL is the toughest, but as long as you know fundamentals of Groupby, Joins, Window functions such as rank, dense rank, row number, and CTEs, you'll be fine with questions
How many questions did you answer during the 45 min phone screen, if it only takes you 5 min to do a sql leetcode?
Team introduction: 3 mins My introduction: 5 mins Project details: 10 mins Leadership principle question and follow up question: 5 mins SQL: 25 mins (4 to 5 questions) Time left for any questions: 10 mins
Being an ex-amazonian, I can say that SQL would be your primary bread & butter for the BA roles, so the expectation from u to actually convert the non-technical requirements into technical would make you stand out from the crowd apart from the usual joins,sub-query, window function shit. It doesn't matter what's your knowledge when u can show them during the interview that you have what it takes to get things done. LP plays a huge role, so if i were u i would incorporate them into my answers, perhaps the usual shitty star format answers. All the previous comments are true,practice hackerrank & leetcode & shit, that will give u the hang of it fsho but at the end of day be ready to get screwed. Obviously the usual advise of having great sense of humor goes a long way P.S : I was fired from Amazon apparently because i was asking too many questions, was too curious, had bias for action (these are Amazon LP & got this as one of the feedback )& kinda got into an argument with my manager, so not sure if u wanna take my advice as apparently according to some people out there me getting fired was just my own fault & not anyone else 's
Even the smartest people on earth could get fired. The way you have formatted your answer, I can see your attention to detail and curiosity at the same time. It’s good that you left Amazon and I am hoping that you’re doing some amazing things at your current job.
Thanks dude and i'm doing well at my current job,its a startup but backed by Siemens & i'm getting to do what i love, so absolutely no complaints & no demands DM me if u or anyone need any help with Amazon interview, I can try to help u as best as i can 😊😇✌🤟
You’re likely going to be given an example set(s) of data, and asked to write SQL to give certain output. Know up to what a window function is, and you’re fine. Don’t ever write a fucking Cartesian join, that is the biggest red flag. You likely won’t have to know most DML, just SELECTs, since you’re applying for BA
I was apart of the EG mass layoffs at the end of February. Any help or tips and tricks to help me land this job would be very helpful.. thanks.
Leetcode SQL should help
If you are able to solve every leetcode SQL, you will be solid