Tech IndustrySep 15, 2019
Newde29

Amazon Data Engineer/BIE interview tips

Hey Blinders, I have a interview call from Amazon for BIE, which is initially phone interview round for now. But I am looking for tips to study for DE interview in FANG. I have completed all the levels of SQL question on leetcode so far. Anything else you recommend for SQL? What all do you suggest to prepare for coding round? What topics and resources should I refer? Any tips would be very helpful, thanks in advance! P.S looking to make a next move in FAANG

Add a comment
Chase PartyBoat Sep 15, 2019

You have python exp too?

Amazon syrbskcb Sep 15, 2019

SQL. Find the top x in list.

New
_cmp_ Sep 15, 2019

Anything else? Like CUBE ROLL UP write procedure, Quote and sort of?

Amazon syrbskcb Sep 15, 2019

Window functions are popular if the interviewer is extra cranky that day. Haven't seen a roll up question Inna while. You'll get a few basic questions on db optimization (index, different types of joins). Olap vs oltp

New
xlkE73 Sep 15, 2019

Have you checked Glassdoor Qs and rooftopslushie.com?

New
de29 OP Sep 15, 2019

I did check GQ.. Never used rooftopslushie.com

BlackRock Ikqf10 Sep 15, 2019

Does someone have a good resource to practice the Sql questions there are likely asked for these kind of role by companies ?

New
_cmp_ Sep 15, 2019

Sqlzoo

Noodle.ai oUdj28 Sep 15, 2019

Practice Gaps and Islands SQL problem

New
de29 OP Sep 15, 2019

Thanks! Any other problems?

Flagged by the community.