I applied through a staffing agency. I interviewed at Nielsen (Bengaluru) in May 2024
Interview
Got call from a consutency of Nielsen.
1st round was screening round and they asked about technicals of spark, sql and python.
later Interview was taken by Nielsen.
1st round was just introduction round.
2nd round was HR round surprisingly.
Interview questions [1]
Question 1
how spark application works?
hadoop architecture?
partition and bucketing?
colasce and repartition ?
spark-submit?
client mode vs cluster mode?
optimizations in sprk?
aqe, repartition, salting
how to handle data skewness? how to identify?
replace 2nd occurance of char with #
count no/. occurance of element in list
rank and dense rank
window functions
emp_id Department Salary
1 A 10
2 B 30
3 C 40
4 C 60
5 B 70
6 C 90
7 A 100
8 A 30
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
I applied through a recruiter. The process took 4 weeks. I interviewed at Nielsen (Tampa, FL) in Jul 2021
Interview
It was for a new grad role. Interview process was not that tough. Gone through resume and digged on Python and SQL.
It would added advantage of you knowledge on any cloud technology.