Filter interviews by
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
Use SQL query with ORDER BY and LIMIT to find the nth highest salary of an employee.
Use ORDER BY clause to sort salaries in descending order
Use LIMIT to specify the nth highest salary
Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT n-1, 1
Types of joins in SQL include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN: Returns rows when there is at least one match in both tables.
LEFT JOIN: Returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table.
FULL JOIN: Returns rows when there is a match in one of the tables.
BinarySearch algorithm using Recursion finds the target element in a sorted array by dividing the array in half at each step.
Divide the array in half and compare the target element with the middle element
If the target element is smaller, search the left half recursively
If the target element is larger, search the right half recursively
Repeat until the target element is found or the array is empty
Check if string s is a subsequence of string t.
Iterate through both strings using two pointers.
Compare characters of s and t, moving pointer in t only if characters match.
If all characters of s are found in t in order, return true.
Example: s = 'abc', t = 'ahbgdc' => true
I applied via Referral and was interviewed in May 2024. There were 3 interview rounds.
I was asked to write SQL queries for 3rd highest salary of the employee, some name filtering, group by tasks.
Python code to find the index of the maximum number without using numpy.
Answering questions related to data science concepts and techniques.
Recall is the ratio of correctly predicted positive observations to the total actual positives. Precision is the ratio of correctly predicted positive observations to the total predicted positives.
To reduce variance in an ensemble model, techniques like bagging, boosting, and stacking can be used. Bagging involves training multiple models on different ...
I applied via Approached by Company and was interviewed in Aug 2024. There was 1 interview round.
A Pure component is a component in React that does not have any state or lifecycle methods, resulting in improved performance.
Pure components are used to prevent unnecessary re-renders in React applications.
Pure components implement shouldComponentUpdate method with shallow comparison of props and state.
Examples of Pure components include functional components and class components that extend PureComponent class.
Nielsen interview questions for popular designations
Get interview-ready with Top Nielsen Interview Questions
I applied via LinkedIn and was interviewed in Sep 2024. There were 3 interview rounds.
2 online test where given where I need to complete 50 MCQ (tech) in 20min and 30MCQ in 12min.
Situtation based question and technical knowledge and skills
Calculate average user login time based on clickstream data with 30 min session in Spark
Filter clickstream data to include only login events
Calculate session duration by grouping events within 30 min window
Calculate average session duration per user
Design a data pipeline for an e-commerce website.
Extract data from website databases, such as product information, customer details, and order history.
Transform the data by cleaning, filtering, and aggregating it to make it usable for analysis.
Load the processed data into a data warehouse or data lake for storage and further analysis.
Implement data pipelines using tools like Apache Kafka, Apache Spark, or AWS Glue.
Moni...
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
Design ETL process to ensure high data quality by implementing data validation, cleansing, and transformation steps.
Identify data sources and define data extraction methods
Implement data validation checks to ensure accuracy and completeness
Perform data cleansing to remove duplicates, errors, and inconsistencies
Transform data into a consistent format for analysis and reporting
Utilize tools like Apache NiFi, Talend, or I
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 3 interview rounds.
I applied via LinkedIn and was interviewed in May 2024. There were 2 interview rounds.
Code to convert number into string
Use a built-in function like str() in Python to convert a number into a string
In JavaScript, you can use the toString() method to convert a number into a string
In Java, you can use Integer.toString() to convert an integer into a string
Top trending discussions
Some of the top questions asked at the Nielsen interview -
The duration of Nielsen interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 100 interviews
Interview experience
based on 919 reviews
Rating in categories
Hyderabad / Secunderabad,
Gurgaon / Gurugram
+16-11 Yrs
Not Disclosed
Data Analyst
211
salaries
| ₹2 L/yr - ₹9 L/yr |
Analyst
191
salaries
| ₹1.8 L/yr - ₹9.4 L/yr |
Manager
165
salaries
| ₹8.9 L/yr - ₹23 L/yr |
Senior Research Executive
165
salaries
| ₹7 L/yr - ₹12.6 L/yr |
Research Executive
145
salaries
| ₹5.2 L/yr - ₹9 L/yr |
Kantar
GfK MODE
Euromonitor International
Dun & Bradstreet