2025 Meta Data Engineer Onsite

Backgound:

I am writing this in English because I moved to Canada from China at a young age and only have a third-grade level of Chinese proficiency.

• 4 years of experience in Data Engineering
• Graduated from a Canadian Unversity
• Currently working at a ride-sharing company
• Prepared around 25 hours total (on weekends and after work)
  

Timeline:

• 10/24/2024: Referral via a friend
• 11/1/2024: HR Call
• 12/5/2024: Technical Phone Screen
• 1/31/2025: Onsite Day 1
• 2/5/2025: Onsite Day 2
• 2/11/2025: Verbal Offer for E4
  

Technical Phone Screen:

I have a detailed post on this here:
SQL Topics: GROUP BY HAVING, sub-queries, SUM(CASE WHEN), self-joins
If you work with SQL regularly, this should be straightforward. I was able to complete all 5/5 questions.
Focus on fundamentals: Lists, Strings, Tuples, Dictionaries.
The challenge isn't the questions themselves but the speed required—aim for max 8 minutes per question

Onsite Interviews:

Very similar to this .

Behavioral Round (Indian Interviewer)

您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

y reading from a daily aggregated table instead of the raw fact table.



Best of Luck. 加油!!

补充内容 (2025-02-14 22:25 +08:00):

Data Modeling: Handle posts shared 10,000+ times (Hint: Use an array to store shares).

Standard newsfeed data model, but the follow up question was "How does your data model handle multiple layers of sharing, and efficietly count how many shares each post has and who the original poster and posted time is?"

For example:
user_1 shares, then user_2 sees user_1's post and shares, this is considered 2 layers of sharing.
Imaginge there is 1000+ layers

补充内容 (2025-05-28 03:24 +08:00):

I don't check this site anymore. If you have questions, send me a message on linkedin

您好！
本帖隐藏的内容需要积分高于 100 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 100 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

您好！
本帖隐藏的内容需要积分高于 100 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 100 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

您好！
本帖隐藏的内容需要积分高于 100 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 100 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

🙏

您好！
本帖隐藏的内容需要积分高于 100 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 100 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

您好！
本帖隐藏的内容需要积分高于 100 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 100 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

thanks bro

Thank you! Very helpful. Already add rice.

Quick question: for the SQL part, is it based on the previous schema u created, or the schema will be provided?

您好！
本帖隐藏的内容需要积分高于 100 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 100 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies