New Yorker logo

New Yorker Data Engineer Interview Questions
& Process

Real candidates share what happened, how many rounds they had,
and how the experience turned out.

Based on 5 interview experiences · FREE TO READ

3 Rounds average
Average Typical difficulty
20% Positive experience

Candidate interview experiences

First-hand accounts from people who interviewed at New Yorker.

Showing 3 of 5
New Yorker logo
New Yorker

Data Engineer

Engineering · nearly a year ago

Senior Average Negative experience No offer 3 rounds
Interview process
Recruiter call Technical screen Take home Offer
Interview formats
Behavioral Technical Coding

First, HR called me and asked some basic questions and very simple technical questions about distributed systems. About a week later, the technical interview took place. After the interview, I was told that a case study would follow, but after more than a week, I received no further feedback and was ultimately rejected.

Confirmed questions6 questions
  • Tell me about yourself.
  • Do you have any technical experience with distributed systems?
  • Are you proficient in Python?
New Yorker logo
New Yorker

Senior Data Engineer

Engineering · a year ago

Senior Average Positive experience Decline offer 4 rounds
Interview process
Recruiter call Technical screen Take home Presentation
Interview formats
Behavioral Technical Coding Presentation

The interview process started with a first interview focused on communication skills and problem-solving approach. This was followed by a take-home task and then a review of that task. It's important to be good at approaching problems and explaining your methodology clearly.

Confirmed questions1 question
  • Can you explain file formats in big data, specifically mentioning Parquet?
New Yorker logo
New Yorker

ETL Developer

Engineering · more than a year ago

Mid Average Negative experience No offer 2 rounds
Interview process
Take home Technical screen
Interview formats
Technical Coding

I was sent a technical assessment with SQL queries based on a dataset. After that, I had a technical interview to go over my submitted solution. They also asked me some other things about the company, if I was open to relocating, and if I was willing to learn the language. I never got any feedback after the interview, so I guess they didn't move forward with me, which is a bit disappointing as I think communication would have been better.

Confirmed questions5 questions
  • Discuss the queries in the technical assessment and any other technical questions.
  • Tell me about your solution to the technical assessment.
  • What do you know about our company?

New Yorker Data Engineer Interview Questions

Quoted word for word from New Yorker interview reports.

How can you view a 10% sample of a file's data without needing extra storage?

Read reports

Can you explain Hadoop Block Size and how it differs from a distributed file system?

Read reports

Given a 5TB file and a 10GB file, how would you join them on a specific column?

Read reports

What is Airflow, and how does a DAG function within it?

Read report

Can you explain file formats in big data, specifically mentioning Parquet?

Read report

Formats, difficulty and experience

Across all 5 New Yorker interview reports.

Interview formats

Technical 38.5%
Coding 30.8%
Behavioral 23.1%
Presentation 7.7%

Interview difficulty

Easy 0%
Average 100%
Difficult 0%

Candidate experience

Negative 60%
Positive 20%
Neutral 20%