Hi, This is the first time I am interviewing for FAANG and I am in the final round for the DE position. I have been told that there will be 2 ETL rounds 1 ownership and 1 DM round . Can someone please help me with this and shed some light ? It would be extremely helpful if you could share examples or use cases from your past interview exp for this position for the final round #dataengineer #facebook #DE #tech
know SQL group by, self join, rank() partition(), fact & dimensions, granularity of fact, which table to put what column, what end to end ETL pipelines look like, questions about ur experience in different parts of ETL process, open ended questions where u have to drive the discussion.
@shoMeDMony, what sort of python questions to expect in ETL round ? Am a bit confused around that. Can you please help with that ? Or some examples maybe ?
@mystery, read in a CSV file and then do some operations on it
Thanks a lot shoMe for the response- DM meaning data modeling
OP, can I DM you regarding phone screening experience?
Sure
What happens under the hood when you enter select * from table;
Good luck OP! Can I DM you? Having some QQ on phone screening preparation
Sure.
Hi Can you help me with preparation. I have interview in 2.5 weeks.
How did the interview go ?
Hey OP, could you please shed some light on the types of questions you were asked?
Hi. Did you go through the interview process? Can you share what kind of questions were asked?
AMA
Yesterday
3351
I have worked at TikTok US core tech for 3 years. AMA.
Tech Industry
11h
535
How’s capitalism going?
2024 Presidential Election
19h
1378
Uh oh: President Trump leads Biden 49% to 43% in a two-way race.
India
18h
3259
Why is it so G*damn difficult to move money out of India
Health & Wellness
16h
956
Issues with sleep
Following