2025 Meta Data Engineer Onsite

楼主你好，关于netflix python问题。请问 “Python (2 Questions): Given a list of movies and categories, map movies to categories and return top 3 movies per category.”的意思是 （1）还是（2）呢？ 谢谢
（1） 这个题是两道python中的其中一道？
（2） 两个highlight分别是一道题？ 第一道python是map movies to categories，第二道是return top 3 movies per category.

匿名用户 发表于 2025-4-3 09:49
Thank you for sharing!

When you interviewed for the Meta DE role, was the E4 level determined be ...

I was interviewing for E4. I don't think I can pass for E5  (need 5 years exp)

Meta is infamous for down leveling people.

匿名用户 发表于 2025-5-16 16:52
can you share the extra question asking during Product sense followup and Data Modelling follouwp

...

I dont remember getting any significant follow up questions.

There are most asking you to explain your thinking or want you to dive deeper based on the answer you provided. If you provided the main metrics that they are looking for, they wont be any follow up questions.

匿名用户 发表于 2025-5-20 21:24
Followup on this: do you know what the table looks like? Thank you!
"SQL (2 Questions): Update a  ...

I don't remember, But trust me, it's not hard, you will know how to solve it when you see it.

Notsage 发表于 2025-5-6 16:42
Is this a typo or do you mean 3NF for ride-sharing?
(rice added)

No, 3NF is used for OLTP - transactional databases that power apps.

You will be designing a data model for OLAP - data warehouse to handel huge amount of data that will be used to support analysis.

匿名用户 发表于 2025-5-20 21:25
Followup on this. Could you please share whats the input looks like for the stream question? Thank ...

No fancy data structure (deque) is needed.

It just looping through a list of dictonary and process each one:
- Check the condition of the dictonary
- If condition pass, add it to the result_stack
- If result_stack = size of buffer, print it out. and reset result_stack

匿名用户 发表于 2025-5-20 21:25
Followup on this. Could you please share whats the input looks like for the stream question? Thank ...

input_list = [
{post_id: xxx, duration: xxx, engagement_cnt: xxx, test: False},
{post_id: xxx, duration: xxx, engagement_cnt: xxx, test: True},
{post_id: xxx, duration: xxx, engagement_cnt: xxx, test: False},
{post_id: xxx, duration: xxx, engagement_cnt: xxx, test: False}
]

Expected output:
"for post_id: {post_id}, the average duration is {avg_duration} and total engagement count is {total_engagement_cnt}”

Thank you for sharing! QQ for the carpooling question. "Scenario: Ride-sharing company introducing a carpooling feature.
Discuss value proposition and Meta’s mission alignment." Do we discuss if Meta is going to launch the similar carpooling feature and how would Meta's mission align? If the carpooling feature is launched in a ride sharing company, why do we need to discuss Meta's mission? Thank you again!

https://hw123.gumroad.com/l/pcigko  i use this to prepare

近期要vo，有人愿意一起准备吗？可以相互mock。