一亩三分地论坛

 找回密码
 获取更多干货,去instant注册!

扫码关注一亩三分地公众号
查看: 2608|回复: 13
收起左侧

[找工就业] 有人面过Uber的非码农Data Analysis方面的职位吗?

[复制链接] |试试Instant~ |关注本帖
brentlin 发表于 2016-2-21 06:08:06 | 显示全部楼层 |阅读模式

2016(1-3月)-[]DataScience/Analytics本科+3个月-1年 - 网上海投| Other全职@Uber在职跳槽

注册一亩三分地论坛,查看更多干货!

您需要 登录 才可以下载或查看,没有帐号?获取更多干货,去instant注册!

x
大家好!
本人已经在opt工作。最近申了U家的Data Analysis方向的职位。论坛里关于U家的面经帖子基本都是码农类的职位,找不到相关的面经。不知道有没有人面过类似的职位。lz现在过了一个SQL take home exercise那轮,接下来是hiring manager的电面。不知道这种职位电面和onsite都是怎么样的?

评分

1

查看全部评分

本帖被以下淘专辑推荐:

 楼主| brentlin 发表于 2016-2-27 10:32:14 | 显示全部楼层
ACL 发表于 2016-2-25 13:25
可以分享一下考題嗎? 我對於data analysis的職位也是很感興趣 謝謝!

Given the below subset of Uber’s schema, write executable SQL queries to answer the questions below.
Please answer in a single query and assume read-only access to the database (i.e. do not use CREATE
TABLE).
Assume a PostgreSQL database, server timezone is UTC.. from: 1point3acres.com/bbs

Table Name: trips
Column Name: Datatype:-google 1point3acres
id                    integer
client_id           integer (Foreign keyed to users.user_id)
driver_id          integer (Foreign keyed to users.user_id)
city_id             integer
client_rating     integer.1point3acres缃
driver_rating     integer
status              Enum(‘completed’, ‘cancelled_by_driver’, ‘cancelled_by_client’)
actual_eta        integer
request_at       timestamp with timezone
distance           float
fare                 float

Table Name: cities
Column Name: Datatype:
city_id             integer
name              character varying (varchar)
created_at       timestamp with timezone
launched_at     timestamp with timezone
status             Enum(‘active’, ‘launching’, ‘closed’)
. from: 1point3acres.com/bbs country          character varying (varchar). Waral 鍗氬鏈夋洿澶氭枃绔,

Table Name: users
Column Name: Datatype:. 鐗涗汉浜戦泦,涓浜╀笁鍒嗗湴
user_id             integer. more info on 1point3acres.com
first_name        character varying (varchar)
last_name        character varying (varchar)
email               character varying (varchar)
signup_city_id   integer
banned            Boolean
role                 Enum(‘client’, ‘driver’, ‘partner’)
created_at       timestamp with timezone
updated_at      timestamp with timezone
referral_code   character varying (varchar)
referred_by     integer (Foreign keyed to users.user_id)
deleted_at      timestamp with timezone


QUESTIONS
1) In October 2014, how many $15 dollar trips were completed in the United States by day?. 涓浜-涓夊垎-鍦帮紝鐙鍙戝竷
What percentage of trips were completed by client who signed up during October 2014?
2) Identify the 15 most frequent last names for Uber ‘clients’?
3) For city_ids 22, 23, and 35, list the top three clients by average fare per trip (min. 25
completed trips) for the first half of 2012. January 1st - June 30th. Assume the minimum fare is
$12 in all markets.
4) Identify the client and driver/partner with the most referrals in 2013. The query’s output
should display contact information along with the signup_date of their last referral. 鏉ユ簮涓浜.涓夊垎鍦拌鍧.
5) What is the average client_rating for completed trips in London for early morning (2am -
5am) trips?
6) Provide the distribution of drivers by the number of completed trips in 2015. Group these
drivers in the follow three buckets: less than 100 trips, between 100 and 300 trips, more than
300 trips.
7) Of referred clients, what percentage of them completed a trip?
回复 支持 2 反对 0

使用道具 举报

 楼主| brentlin 发表于 2016-2-27 10:32:34 | 显示全部楼层
LuckyBamboo 发表于 2016-2-23 22:04
请问,可以说下SQL 的题吗? 如果能发我邮件最好了。非常感谢

Given the below subset of Uber’s schema, write executable SQL queries to answer the questions below.-google 1point3acres
Please answer in a single query and assume read-only access to the database (i.e. do not use CREATE
TABLE).
Assume a PostgreSQL database, server timezone is UTC. 鏉ユ簮涓浜.涓夊垎鍦拌鍧.

Table Name: trips
Column Name: Datatype:
id                    integer
client_id           integer (Foreign keyed to users.user_id). From 1point 3acres bbs
driver_id          integer (Foreign keyed to users.user_id) 鏉ユ簮涓浜.涓夊垎鍦拌鍧.
city_id             integer
client_rating     integer
driver_rating     integer
status              Enum(‘completed’, ‘cancelled_by_driver’, ‘cancelled_by_client’)
actual_eta        integer
鏉ユ簮涓浜.涓夊垎鍦拌鍧. request_at       timestamp with timezone
distance           float
fare                 float-google 1point3acres

Table Name: cities
Column Name: Datatype:. more info on 1point3acres.com
city_id             integer
name              character varying (varchar)
created_at       timestamp with timezone. 鐗涗汉浜戦泦,涓浜╀笁鍒嗗湴
launched_at     timestamp with timezone
status             Enum(‘active’, ‘launching’, ‘closed’)
country          character varying (varchar)

Table Name: users
Column Name: Datatype:
user_id             integer
first_name        character varying (varchar)
last_name        character varying (varchar)
email               character varying (varchar)
signup_city_id   integer
banned            Boolean
role                 Enum(‘client’, ‘driver’, ‘partner’)
created_at       timestamp with timezone
updated_at      timestamp with timezone. visit 1point3acres.com for more.
referral_code   character varying (varchar)
referred_by     integer (Foreign keyed to users.user_id)
deleted_at      timestamp with timezone


QUESTIONS
1) In October 2014, how many $15 dollar trips were completed in the United States by day?
What percentage of trips were completed by client who signed up during October 2014?
2) Identify the 15 most frequent last names for Uber ‘clients’?. 鐗涗汉浜戦泦,涓浜╀笁鍒嗗湴
3) For city_ids 22, 23, and 35, list the top three clients by average fare per trip (min. 25
completed trips) for the first half of 2012. January 1st - June 30th. Assume the minimum fare is
$12 in all markets.
4) Identify the client and driver/partner with the most referrals in 2013. The query’s output
should display contact information along with the signup_date of their last referral.
5) What is the average client_rating for completed trips in London for early morning (2am -
5am) trips?
6) Provide the distribution of drivers by the number of completed trips in 2015. Group these
drivers in the follow three buckets: less than 100 trips, between 100 and 300 trips, more than
300 trips.
7) Of referred clients, what percentage of them completed a trip?

评分

1

查看全部评分

回复 支持 1 反对 0

使用道具 举报

cindy4ever 发表于 2016-2-21 12:09:12 | 显示全部楼层
求面筋。没有面过U家,不过根据经验应该会问做过的project,祝好运!
回复 支持 反对

使用道具 举报

 楼主| brentlin 发表于 2016-2-21 12:48:29 | 显示全部楼层
cindy4ever 发表于 2016-2-20 20:09
求面筋。没有面过U家,不过根据经验应该会问做过的project,祝好运!
鏉ユ簮涓浜.涓夊垎鍦拌鍧.
好的,谢谢!
回复 支持 反对

使用道具 举报

小K 发表于 2016-2-21 14:10:30 | 显示全部楼层
不同组的要求完全不同
回复 支持 反对

使用道具 举报

LuckyBamboo 发表于 2016-2-24 14:04:37 | 显示全部楼层
请问,可以说下SQL 的题吗? 如果能发我邮件最好了。非常感谢
回复 支持 反对

使用道具 举报

lha_1313 发表于 2016-2-25 17:06:24 | 显示全部楼层
面过marketplace组ds 一轮hr电话 一轮take home(math, coding) 一轮纯coding 没有拿到onsite
回复 支持 反对

使用道具 举报

ACL 发表于 2016-2-26 05:25:44 | 显示全部楼层
lha_1313 发表于 2016-2-25 17:06
面过marketplace组ds 一轮hr电话 一轮take home(math, coding) 一轮纯coding 没有拿到onsite
. from: 1point3acres.com/bbs
可以分享一下考題嗎? 我對於data analysis的職位也是很感興趣 謝謝!
回复 支持 反对

使用道具 举报

LuckyBamboo 发表于 2016-2-28 03:26:37 | 显示全部楼层
brentlin 发表于 2016-2-27 10:32
Given the below subset of Uber’s schema, write executable SQL queries to answer the questions bel ...

非常感谢哈
回复 支持 反对

使用道具 举报

claire0716 发表于 2016-3-13 11:09:08 | 显示全部楼层
还要做考题,先收藏了。
回复 支持 反对

使用道具 举报

hjh1011 发表于 2016-3-25 13:31:02 | 显示全部楼层
LZ之后面得怎么样了?
回复 支持 反对

使用道具 举报

damai_xy 发表于 2016-4-17 09:58:10 | 显示全部楼层
非常感谢,我也对 data analysis很感兴趣
回复 支持 反对

使用道具 举报

justinlee 发表于 2016-4-17 21:49:26 | 显示全部楼层
Uber不是一般都叫Data Science而不叫Data Analysis吗?
回复 支持 反对

使用道具 举报

本版积分规则

请点这里访问我们的新网站:一亩三分地Instant.

Instant搜索更强大,不扣积分,内容组织的更好更整洁!目前仍在beta版本,努力完善中!反馈请点这里

关闭

一亩三分地推荐上一条 /5 下一条

手机版|小黑屋|一亩三分地论坛声明 ( 沪ICP备11015994号 )

custom counter

GMT+8, 2016-12-9 08:18

Powered by Discuz! X3

© 2001-2013 Comsenz Inc. Design By HUXTeam

快速回复 返回顶部 返回列表