Yahhoo Sr. Data Scientist 详细面经 求大米

9月初就开始面的了 on-site 已经面完了 没有给offer
第一轮 Hiring Manager 聊得很愉快
第二轮 Technical Screening 如下的sql 非常简单
第三轮 Product Director 聊了下过去的projects 聊了下yahoo
第四轮 Engineering VP 聊了下AI对工作的帮助
第五轮 Product VP 聊了下yahoo 的产品

-- Table 1: feed_events_daily
-- This is the audience traffic for Yahoo -- One row per (date × module × content_id × platform)
Table: feed_events_daily
+--------------------------------------------------+--------------------------------------------------+--------------------------------------------------+--------------------------------------------------+--------------------------------------------------+--------------------------------------------------+--------------------------------------------------+
| date | module | content_id | publisher_id | impressions | clicks | platform
+--------------------------------------------------+--------------------------------------------------+--------------------------------------------------+--------------------------------------------------+--------------------------------------------------+--------------------------------------------------+-------------------------------------

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

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

e time period as Question 1 (2026-03-25 to 2026-03-31)
--Sort by module and rank accordingly

--QUESTION 3 - Publisher Level Metrics
--From a publisher level, pull the number of articles, total impressions, total clicks and publisher ctr
--Also break out CTR separately for App (ios_app and android_app) vs Web (desktop_web and mobile_web)
--Only include US publishers for audience traffic engagement for March 2026.
-- Order by publisher CTR descending.

QUESTION 4 - Publisher CTR vs Average Across All

--Now compare each publisher's CTR against the simple average CTR across all publishers (treat each publisher as one row — not weighted by impression volume).
--Order by ctr_vs_avg ascending (worst performers first).

之前面过Yahoo，天啊！全部都是烙印。

有给具体的feedback么

这个公司还存在？？