I applied through a staffing agency. I interviewed at Nielsen
Interview
First round:
Pyspark
Second:
Dsa
Third: sql and system design
They ghosted me in the end, after rushing through the rounds. I found them extremely unprofessional in terms of their HR.
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