I applied online. I interviewed at Dropbox in Dec 2019
Interview
Standard and logical. Just take it with an eagle eye. Review SQL questions, stored pros, data models, snowflake, airflow code, python data structures. Kafka and Py-spark questions may be asked if the current project involves spark.
first round is sql, followed by second round with system design and then leetcode question. I solved both of the system design and leetcode question, communicated with interviewers what's my logic behind the code or data model I created. But got a rejection the next day. Guess there're too many people in the market right now and they raise the bar much higher than previous years.
I applied online. The process took 3 weeks. I interviewed at Dropbox (San Francisco, CA) in June 2018
Interview
Had couple of telephonic rounds initially and then was called onsite for 6rounds back to back. The onsite interview was interesting; more of white board session and discussion than asking questions and expecting theoretical answers.
Interview questions [1]
Question 1
One of the interviewees asked me unexpected questions which were totally unrelated to the technology. He put me in a situation that would require some analysis and articulation.