买它onsite data eng 回报社会

这次多亏了地里的面经，虽然说面试内容还是有些些许不同，但是也给了我充足的expectation和准备。由于签了nda不能直接发真题，但是以下是我的面试准备资料，我个人认为对面试非常有帮助分享给大家。求大米
另外，顺便表扬一下脸书的recruiter，真的敬业，走心，给我的prep call事无巨细。面试体验极好。给recruiter点个大赞

Overview
1. ETL Interview 1: Real-time stream system (1 hr)
2. Data modeling  (1 hr)
3. ETL Interview 2: Batch system
4. Behavioral and ownership
All the technical ETL design, assume big data context

Main qualities Interviewers look for
Code needs to be written but it will not get tested throughout the interview
1. Python
2. SQL (Postgres)
3. Product sense
4. Data modeling
5. ETL
6. Data visualization (more on data presentation --> will appear in stream system ETL question)

Interview 1: ETL in Real time stream system  (Photo upload stream process)
Focus on designing important metrics and E2E ETL process
Q1: (a product sense question) What metrics would you use to evaluate if a feature in the photo upload application is effective or not? What data would you collect? --> Photo upload APP?
Q2: On a high level, design the schema/columns for data modeling for both the source data and the target (output) data.
Q3: The schema of the table will be provided. A set of SQL/ python questions will be asked to answer some questions. --> It will be mainly focused on how to build ETL from source to target and

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

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

rview 4: Behavioral (Follow the STAR framework)
1. What draws you to Meta DE?
2. What is DE?
3. Projects you've worked on --> try to relate the experience to the FB products
4. Leadership questions
  a. Describe a time when you complete a project from end to end
  b. What have you done in a cross functional, collaborative environment
  c. What is the impact of your projects?
  d. What trade offs did you have to make
  e. What characteristics and attributes do you think is important as a leader
5. Questions about autonomy/ prioritization
6. Describe a situation where you influenced/or being influenced by others using data
7. How do you handle conflict?
8. How do you plan to succeed in FB in the first year

您好！
本帖隐藏的内容需要积分高于 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

感谢LZ分享，加油

感谢LZ，请问是否会要求设计etl 呢？

rhubarbhwy 发表于 2022-02-12 15:49:38
感谢LZ，请问是否会要求设计etl 呢？

不太需要，就给题解题就行。

Marco Mai 发表于 2022-02-12 23:16:45
不太需要，就给题解题就行。

谢谢楼主 楼主好人一定大发！我试试看加米，请问楼主python题目相对于面经变化大吗

楼主， 请问你提到的photo upload streaming和Uber/doordash这两题是面试中的题吗？还是只是recruiter给你的准备材料？已加米，感谢！！

楼主有被考到leetcode算法题吗？

Erinnnnn 发表于 2022-02-15 20:49:13
楼主， 请问你提到的photo upload streaming和Uber/doordash这两题是面试中的题吗？还是只是recruiter给你的准备材料？已加米，感谢！！

那两题是我地里搜到的，和面试原题挺像的但是不完全一样！解题思路是一样的

请问楼主面的哪个组呀

你好，请问一下meta de岗必须要求python做题吗？ java不可以吗？