NielsenIQ Senior Engineer Product Development Interview Questions and Answers

Q1. OOPS concepts, function overload, override,interface,string, string builder
Add your answer

Q1. Company profile,salary discussion
Add your answer

1 easy sql and 1 easy python for 55 min

1 easy python and very hard sql for 1 hr 50 min

Q1. Mainly they focused on the answers you have written on round 2 and basic sql and pandas in python
Add your answer
Q2. 1) write a join 2) implement left join using pandas
Ans. 
Answering a question on writing a join and implementing left join using pandas for Data Analyst role.
• To write a join, we need to identify the common column(s) between two tables and use the JOIN keyword in SQL.

• Example: SELECT * FROM table1 JOIN table2 ON table1.common_column = table2.common_column

• To implement left join using pandas, we can use the merge() function with how='left' parameter.

• Example: pd.merge(table1, tab
Answered by AI
Add your answer

Basic aptitude questions of quant and reasoning and general english

Case study of varies products asked around 15-20 which were easy to attempt

Q1. About yourself, practical knowledge, family, data related,etc.
Add your answer
Q2. What is sql. Excel formulas
Ans. 
SQL is a programming language used for managing and manipulating relational databases. Excel formulas are used for performing calculations and data analysis in Microsoft Excel.
• SQL is used to retrieve, insert, update, and delete data from databases.

• Excel formulas are written using functions and operators to perform calculations and manipulate data.

• SQL example: SELECT * FROM customers WHERE age > 30;

• Excel formula example...read more
Answered by AI
Add your answer

Normal aptitude questions

Q1. Interview with manager
Add your answer

There will be MCQ Questions. They will ask you to use internet and answer the questions.
They want to check your research skills.

Q1. If you are a fresher then you can easily clear the interview, Hr will ask normal questions about yourself and about your education background.
Add your answer

Aptitude test of 30 min is conducted

General questions related to reasoning. Not much hard to crack.