Ho presentato la mia candidatura tramite un'agenzia di reclutamento personale. Ho sostenuto un colloquio presso Nielsen (Bengaluru) nel mese di mag 2024
Colloquio
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.
Domande di colloquio [1]
Domanda 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
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.
Domande di colloquio [1]
Domanda 1
Q1. Basic Spark, Python, SQL Questions.
Q2. Some Data Modelling Questions.
Ho sostenuto un colloquio presso Nielsen (Edison, NJ)
Colloquio
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
Domande di colloquio [1]
Domanda 1
Introduce yourself and describe a difficult project you've been working on
Ho sostenuto un colloquio presso Nielsen (Bengaluru)
Colloquio
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.
Domande di colloquio [1]
Domanda 1
Anagram detection, addition of Linkedlist nodes values
