2025 Meta Data Engineer Onsite

匿名用户 发表于 2025-3-13 01:54
Thanks for sharing, for Ride-sharing design, are we supposed to design a data model for OLTP or OLAP

You can assume that it's for OLTP.

匿名用户 发表于 2025-3-12 18:14
thanks for sharing ! added rice
My HR told me that for three product interview,  there will be two  ...

Correct.

收藏一下谢谢分享

Thank you for sharing!

When you interviewed for the Meta DE role, was the E4 level determined beforehand, or did you find out your level only after passing the interview? thanks

can you please tell the input and output  looks like and how did u implement this . using deque ?

Q)Python (1 Question) : Process a stream of input data (list of dictionaries), checking conditions, buffering output, and handling edge cases.

Hi , Did you have to type put the SQL fro below question or just explan  ? can you tell more on how the SQL looks

SQL (2 Questions): Update a daily aggregate table from a user activity fact table.

andy3545 发表于 2025-3-17 11:13
You can assume that it's for OLTP.

Is this a typo or do you mean 3NF for ride-sharing?
(rice added)

can you share the extra question asking during Product sense followup and Data Modelling follouwp

Thanks much

匿名用户 发表于 2025-4-5 00:46
Hi , Did you have to type put the SQL fro below question or just explan  ? can you tell more on how  ...

Followup on this: do you know what the table looks like? Thank you!
"SQL (2 Questions): Update a daily aggregate table from a user activity fact table."

匿名用户 发表于 2025-4-4 16:01
can you please tell the input and output  looks like and how did u implement this . using deque ?
...

Followup on this. Could you please share whats the input looks like for the stream question? Thank you!