Anyone have insight into the SQL dialect used for Amazon interviews? Do I have the ability to use CTEs and Window functions easily? LeetCode MySQL version does not allow WITH or Window functions which I have used for a while. This would help gauge expectations. Much appreciated. TC: $180k in ATL at WarnerMedia as a W-2 Contractor. Tech interviewing for BI engineer (L5 or L6) at Amazon and Data Engineer: DS for LinkedIn. Positions in SEA and Sunnyvale. Thanks! #Amazon #sqlinterview #dataengineer #businessintelligence #sql #dataengineerinterview
Yeah it shouldn’t be a problem. I was asked questions on recursive Cte’s and lead/lag functions. So amazon editors does support these.
Confirming for following: Had the interview today. They didn’t actually run the code just talked through it. I asked if I could use CTEs or Window and they said go for it. Great interview.
What level leetcode? Medium? Hard?
Which syntax are preferred for the phone interview? MySQL?
2024 Presidential Election
Yesterday
629
Heartwarming peaceful protests
Tech Industry
Yesterday
1380
The end of Backdoor Roth?!
Tech Industry
Yesterday
1132
Which large tech companies you think will last 20+ years?
India
Yesterday
642
Who are these retards asking for dictatorship in India?
India
Yesterday
579
Modi is a legend, will be remembered for centuries to come
Following