noon Data Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 5 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at noon.
noon
Data Analyst
Entry Average Neutral experience Decline offer 1 round
Interview process
Technical screen
Interview formats
Technical Coding
The interview was heavy on SQL questions, specifically testing window functions and Excel-based queries. They wanted to see how well I could do data analysis, understand functions like RANK and ROW_NUMBER, and use formulas and pivot tables to work with datasets.
Confirmed questions2 questions
- Can you detail the differences between window functions such as ROW_NUMBER(), RANK(), and DENSE_RANK()?
- In practical situations with duplicate data, how would you decide between using ROW_NUMBER(), RANK(), and DENSE_RANK()?
noon
Data Analyst
Senior Difficult Neutral experience No offer 2 rounds
Interview process
Recruiter call Technical screen
Interview formats
Technical Coding
they reached out to me via email to complete a Google Form. Based on that, they asked for several interview time slots and then set up a Google Meet. During the call, they asked me some SQL questions.
Confirmed questions5 questions
- Regarding an inner join on two tables with duplicates and nulls, describe the expected output.
- Can you explain the distinctions among the different types of joins?
- Are you familiar with window functions, and could you differentiate between dense rank and rank?
noon
Data Analyst
Entry Easy Positive experience No offer 1 round
Interview process
Recruiter call Technical screen Onsite
Interview formats
Behavioral Technical Coding Case
I had a really chill interview experience. The interviewer was nice and helped me when I got stuck. We started with introductions, then talked about my background and projects. Next, I had to guess the number of WhatsApp messages sent in Delhi on a Sunday. Then came a coin puzzle, followed by an SQL query question.
Confirmed questions4 questions
- What about your background and projects?
- Can you estimate the number of WhatsApp messages sent in Delhi on a Sunday?
- Here is a coins puzzle for you.
noon Data Analyst Interview Questions
Quoted word for word from noon interview reports.
“Given a table with order ID, order date, and customer ID, please provide a SQL query to find all customer IDs that represent repeat customers, noting that customer IDs are consistent while order IDs vary per purchase.”
Read reports →“How to calculate cumulative sum in G sheet?”
Read reports →“Write an SQL query.”
Read reports →“Can you estimate the number of WhatsApp messages sent in Delhi on a Sunday?”
Read reports →“How to use SUMIF?”
Read report →“How to use TODAY?”
Read report →“Can you detail the differences between window functions such as ROW_NUMBER(), RANK(), and DENSE_RANK()?”
Read report →“In practical situations with duplicate data, how would you decide between using ROW_NUMBER(), RANK(), and DENSE_RANK()?”
Read report →“Can you explain the distinctions among the different types of joins?”
Read report →Formats, difficulty and experience
Across all 5 noon interview reports.