Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Nielsen
Colloquio
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
Domande di colloquio [1]
Domanda 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.
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
