Zoox - Data Engineer 挂经

SQL (1hr)
--transactions
-- ---------------------------------------------------------------------------------------------
-- column name              | data type | description
-- ---------------------------------------------------------------------------------------------
-- transaction_id           | int       | unique id for each transaction
-- vendor_id                | int       | id of the vendor
-- amount_charged           | int       | amount charged in this transaction
-- transaction_type         | varchar   | 'purchase' or 'refund'
-- refund_transaction_id    | int       | original transaction id if this is a refund, else null
-- timestamp                | datetime  | time when transaction happened

--sample data:
-- transaction_id | vendor_id | amount_char

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

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

ve location of the robotaxis, view the realtime video of the surroundings
and take control of the robotaxi in case there is a stuck event

* The functional flow looks something like:
Robot requests teleoperators for help -> the request is put in queue -> The request is serviced by a Tele operator.

The robot to tactician ratio is 1:N, that is there are always more robots active than the number of Teleops Tacticians,
(i.e. One tacticians supports more than 1 robot at a time).

Design a Data Model to monitor the efficiency and effectiveness of teleops function.

Data Architecture (1hr)
Design a data pipeline to measure vehicle stability

Hiring manager interview + project deep dive (1hr)