Two Technical Rounds
1st Round is of Pyspark code
2nd Round is based on project
Last round is HR discussion
Interviewer mainly focus on the spark code in dataframe
and sql
Interview questions [1]
Question 1
Split the file words and count frequency in PySpark
Dept wise highest salary in Pyspark
General Introduction.
Discussed my previous tech stack.
Questions around data volume I’ve worked with, nature of my work, and the impact it had.
Coding Problems:
Q1. Longest Substring with Unique Characters
Q2. Check if Two Strings are Anagrams (O(n), no sorting allowed)
SQL Question: From a product pricing table, find product names where the prices are strictly increasing over months.
Interview questions [1]
Question 1
Q1. Basic Spark, Python, SQL Questions.
Q2. Some Data Modelling Questions.
The hiring manager directly reached out to me, give me a take home assessment, it is a web IP related question. Just one question, no time limit. The next step is talk with other coworkers
Interview questions [1]
Question 1
Introduce yourself and describe a difficult project you've been working on
Without even the introduction, three back2back questions of DSA. Anagrams detection, linked list addition and one on tree traversal.
Questions around working of master, worker nodes and data pipelines creation.
Interview questions [1]
Question 1
Anagram detection, addition of Linkedlist nodes values
Data Engineer applicants have rated the interview process at Nielsen with 2.7 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 100% positive. To compare, the company-average is 64.6% positive. This is according to Glassdoor user ratings.
Candidates applying for Data Engineer roles take an average of 30 days to get hired, when considering 3 user submitted interviews for this role. To compare, the hiring process at Nielsen overall takes an average of 24 days.
Common stages of the interview process at Nielsen as a Data Engineer according to 3 Glassdoor interviews include:
One on one interview: 33%
Group panel interview: 17%
Skills test: 17%
Background check: 17%
Phone interview: 17%
Here are the most commonly searched roles for interview reports -