Dropbox Data Engineer Interview Case Study

Dropbox data engineer interview case study from a recent sqlpad customer.

Overall it took 5 weeks.

TLDR

Candidate: N/A

How it gets started: Recruiter reached out on LinkedIn

Job level: IC2 (mid-level)

Year of Experience: 5

Degree: M.S & B.S. in CS

Offer: Yes

TC: ~250K USD

Location: Remote

Interview process: 5 weeks

Preparation: 2 months

Has a job: yes

Decide to join: No

Round 1: HR call

Why are you interested in leaving your current job? What do you know about Dropbox? Have you used our product in the past? Do you want to work remotely or relocate to San Francisco, CA?

Round 2: SQL Coding Interview

Sample dropbox sql coding questions

Interviewed by a data engineer from the same team. Very nice guy.

1. Categorize data into different groups with CASE WHEN statement;

2. Ranking with window functions;

Round 3: Virtual Onsite Interview 

1. Data Structures and Algorithm: reverse print a matrix with your preferred programming language;

2. Data modeling (design a database);

3. Behavioral questions/ leadership questions;

4. Deep dive into a recent project (based on the resume)

5. Questions for dropbox (chat with HR)

Final Offer

Total about 240k, 

~160k base salary

~50k from RSU (4-year vesting, 25% each year)

~20k sign-on bonus