I applied online. The process took 2 weeks. I interviewed at Horizon Media (New York, NY) in Sept 2019
Interview
I first had a phone interview where I was asked about my background. Then there were some conceptual Python questions and SQL questions. Everyone was very friendly throughout the whole process and the interview was much easier than I expected. There was no whiteboard coding since the interview was focused more on knowledge of Python data structures and discussion of database technologies.
Interview questions [1]
Question 1
What does it mean that functions are first class in Python.
I applied online. The process took 4 weeks. I interviewed at Horizon Media (New York, NY) in Mar 2021
Interview
1. HR interview 30 min. Asked about prior experience, salary expectation, and answered a few technical question.
2. Hiring manager interview 30 min. Talked about past projects and followed by series of technical questions and live coding.
3. Team interviews 2 hours. Live coding round, technical questions and behavior questions.
Interview questions [3]
Question 1
HR round - Explain what is a Tuple, difference between Hadoop and spark, and what is a parquet file.
Hiring manager round - all fundamental python questions such as explain inheritance, generator vs list comprehension, dunder methods, functions being the first class citizen etc. Few more spark data processing questions. The Live coding round involved writing sql and explain Python function outputs.
Team round - live coding involved writing expected outputs from different functions and also writing functions to generate expected outputs. Conceptual questions on spark data processing, SQL and Airflow. Behavioral questions on past projects and future goals.