AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Nielsen Softwaretest Engineer Interview Questions and Answers for Experienced
Nielsen Softwaretest Engineer Interview Experiences for Experienced
1 interview found
Anonymous
I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. What is a bloom filter in hbase ?
- Ans.
A bloom filter in HBase is a data structure used to test whether a given element is a member of a set.
Bloom filters are used to reduce the number of disk reads in HBase by quickly determining if a row may exist in a table.
They are implemented as a compact array of bits, with multiple hash functions used to map elements to bits.
Bloom filters can produce false positives but not false negatives, making them useful for pre...
- Q2. Write a query to remove duplicate rows in pyspark based on primary key.
- Ans.
Use dropDuplicates() function in pyspark to remove duplicate rows based on primary key.
Use dropDuplicates() function on the DataFrame with the primary key column specified.
Specify the subset parameter in dropDuplicates() to specify the primary key column.
Example: df.dropDuplicates(['primary_key_column'])
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
Selected
I applied via Approached by Company and was interviewed before May 2023. There were 2 interview rounds.
(2 Questions)
- Q1. What is Sql?, and performance tuneing
- Ans.
SQL is a domain-specific language used for managing and manipulating relational databases.
SQL stands for Structured Query Language
It is used to communicate with databases to perform tasks such as querying data, updating data, and creating databases
Performance tuning in SQL involves optimizing queries, indexes, and database design to improve speed and efficiency
Examples of performance tuning techniques include using ind...
- Q2. About power bi dax filter and dashboard
(2 Questions)
- Q1. About your technical skills
- Q2. About your previous work profile
Interview Preparation Tips
Skills evaluated in this interview
I was interviewed in Jul 2017.
Interview Questionnaire
3 Questions
- Q1. Tell me about yourself?
- Ans.
I am a data analyst with a strong background in statistics and programming.
I have a Bachelor's degree in Statistics and have completed several courses in programming languages like Python and SQL.
I have experience working with large datasets and conducting data analysis using statistical techniques.
I am proficient in data visualization tools like Tableau and have created interactive dashboards to present insights.
I hav...
- Q2. Why this company?
- Ans.
I am interested in this company because of its strong reputation in the data analytics industry and its commitment to innovation.
The company has a proven track record of success in the data analytics industry.
It has a strong reputation for delivering high-quality insights and solutions.
The company values innovation and encourages employees to think creatively.
There are opportunities for professional growth and developm...
- Q3. Why do you want to make a career in this field inspite being an engineer?
- Ans.
I am passionate about using data to solve complex problems and make informed decisions.
Data analysis allows me to apply my analytical skills and engineering background to extract valuable insights from data.
I enjoy working with numbers, statistics, and programming, which are all essential skills in the field of data analysis.
Data analysis offers a wide range of opportunities to work on diverse projects and industries, ...
Interview Preparation Tips
Experience: The written test consists of 2 sections. First section is of verbal reasoning which is very easy. And second section consists of data interpretation, quant questions.
Tips: Speed and accuracy are important in this test. Daily practicing of aptitude can get you through the exam.
Duration: 45 minutes
Total Questions: 40
Round: Technical + HR Interview
Experience: After entering the interview room, the first question asked to me was "Walk me through your CV ".After that, I was asked some puzzle questions, one math question and a case study question which was bit difficult. The interviewer was trying to make me stressed by picking one of my strengths and saying that he considers it as my weakness. He was not convinced with whatever I said but in order to overcome above stress be clam and cool. Say what you know without hesitation, be strong, and be yourself. Last but not the least, don't bluff because he will eventually figure it out, even if you bluff say it convincingly.
Tips: Be perfect about what you have written in your CV and just be yourself.
Round: HR Interview
Experience: HR round was very cool . Actually the panel was friendly with me. They asked some common HR questions. That's it about this round.
Tips: Be fluent and develop good communication skills.
College Name: NIT Bhopal
Santhosh M S
Interview Preparation Tips
Experience: Each intern was assigned a individual project and mentor.
In the last week of internship there was project presentation and interview.
interview was easy .For me 50% of the questions were about project and some questions about algorithms and DBMS.
More emphasis was given to the quality of work on project.
General Tips: Working in company is complete different from working on course project. learning many new frameworks required for the project was really challenging.
Programming : Tree, Btree, Tries ..
Operating System: Memory Management
Networks: OSI model
DBMS : basics. they dint ask me any. Show case your interest in big data, servers and passion for technology
Skill Tips: Be confident, even if you don't know the exact answer don't give up tell your approaches to interviewer. some times they will also help you. Software Developer some question s you can ask are: what technologies do your company works on. how are freshers will be selected to different teams in the company.
Skills:
College Name: NIT Surathkal
Interview Preparation Tips
Experience: Didn't read any material saw resumes of my friends who pass out last year to see how to organize my points. Prepare my resume and refine it with the help of my friends several times
Round: HR Interview
Experience: Saw common HR questions from the websites and prepare answers for that .worked in groups in which one person acted as an interviewer.
Round: Case Study Interview
Experience: For the case studies, I referred many e-books available to learn the basic procedure to solve case studies. Sample case studies are also available on sites of these companies (Mckinsey.com, BCG.com or Bain.com)
Round: Puzzle Interview
Experience: Some companies asked puzzles. Common puzzles can be found on internet (pagalguy.com, brainvista.com , or orkut)
College Name: IIT BOMBAY
Interview Questionnaire
6 Questions
- Q1. Resume-based questions
- Q2. What is the color of door from which you entered?
- Ans.
The door from which I entered was brown.
The door was made of wood.
The color was a dark shade of brown.
There were no decorations or patterns on the door.
- Q3. Did you attend the ppt? What did you like the most about ppt?
- Ans.
Yes, I attended the ppt and found the case studies presented to be the most interesting.
Attended the ppt
Found the case studies to be the most interesting
Impressed by the data presented
Liked the interactive nature of the presentation
- Q4. Intern-based questions
- Q5. If you start a startup of selling books to IITK students through e-commerce what will be the annual demand you can expect from IITK students?
- Ans.
The annual demand for selling books to IITK students through e-commerce depends on various factors such as the number of students, their course curriculum, and their reading habits.
The demand can be estimated by conducting a survey among the students to understand their reading habits and preferences.
The demand can also be influenced by the availability of books in the campus library and bookstores.
The demand may vary ...
- Q6. In your hostel every girl plays badminton atleast once a month. The probability of one playing badminton in 1st week is a, probability that if one doesn’t play in 1st week than she will play in 2nd week is...
- Ans.
Calculating the probability of two friends playing badminton in the same week given certain probabilities.
Calculate the probability of both playing in the first week (a*a)
Calculate the probability of both playing in the second week ((1-a)*b*(1-c))
Calculate the probability of both playing in the third week ((1-a)*(1-b)*c)
Calculate the probability of both playing in the last week ((1-a-b-c)*(1-a-b-c))
Add up all the proba
Interview Preparation Tips
Experience: 1. Number of Questions: 30 (10 each from mathematics, English and DI).
2. Type of questions and details Questions of Mathematics and DI were mainly from previous years CAT papers.
3. The time was very limited and so speed was very important while solving the questions.
4. Moreover there was cut off for individual sections so keeping that in mind one had give time to each section.
Duration: 30-40 minutes
Total Questions: 10+10+10
Round: HR Interview
Experience: Most of the questions were resume based. The interviewer also tried to confuse me sometimes. While I was answering he looked at the ceiling and here and there but I ensured that I was still answering everything very confidently not diverting my attention.
Round: Case Study Interview
Experience: It was a HR + puzzle + casestudy interview and lasted for 20-25 minutes and had a panel of only one.
General Tips: 1. Don’t leave everything for the end. As December approaches it becomes more and more hectic with end sems, project deadlines, BTP, ppts to attend, test of companies etc. Start preparing early.
2. Do attend ppt and write down points whatever they mention in the ppt. generally one can prepare the questions like why this sector or why this company from the points they mention in ppt.
3. They generally mention that they are looking for in the candidates in the ppt so this helps in preparing the answers in interview. Moreover do spend some time in preparing for HR.
4. At least think and write down few basic points of the questions that are generally asked in the interviews.
Skill Tips: Do solve all previous year question papers of CAT and try to increase speed of solving.
Do practice some case studies and puzzles.
Skills:
College Name: IIT KANPUR
Interview Questionnaire
2 Questions
- Q1. Basic HR based questions
- Q2. Basic guesstimate questions were asked
Interview Preparation Tips
Experience: This round went pretty well in my opinion.
Round: Guesstimate Interview
Experience: I had prepared for guesstimates. So, this round went rather well.
General Tips: 1. I had a CPI of 8.6 and my resume didn't have any co-curricular activities as such. I had an intern in Pidilite Industry and i had given my CAT exam.
2. I had joined CL for CAT which helped me for aptitude tests .
3. Also, I prepared for puzzles and guesstimates, took part in the diamond case study competition though I didn't win it.
4. I had also prepared for core companies as well.
College Name: IIT KANPUR
Interview Preparation Tips
Experience: Firstly, I was kept on waitlist for EXL but, was later shifted to the main list. The first round was HR and it went well.
Round: Interview
Experience: After subsequently acing the the first round. The second round was technical in nature and involved a case study. In my view , I was able to perform decently in it.
Round: Interview
Experience: The third interview was a puzzle interview that tested the mental abilities. I had done one of the puzzles before so answered it properly .
Tips: 1. I had joined CL just after 4th year for my aptitude only and took a lot of time to prepare my resume. then I have been in habit of conducting discussions with my wingmates.
2. Moreover before the interviews I prepared thoroughly for HR questions.
General Tips: 1. Although I had a low CPI, I have been involved in various co-curricular activities.
2. I have been involved in M club as a vocalist
3. I have played football,
4. I was the Festival coordinator of Antaragni.
5. Apart from that, I have been involved in Techkriti in my first and second year in hospitality and in my third year in PR.
6. I have also been a STF in Udghosh.
7. I have a habit of reading books and newspapers regularly.
8. My internships included an online project for BSE after my second year, a one month internship in RBI after my third year.
9. I had an internship with a London based consultancy firm after my fourth year.
10. My MSc project is on GREEN CAFEs and purchasing power of people and their desire to spend money on them.
College Name: IIT KANPUR
Interview Questionnaire
6 Questions
- Q1. Talk about yourself?
- Ans.
I am a driven and creative individual with a passion for problem-solving and innovation.
I have a degree in computer science and have worked in the tech industry for 5 years.
I enjoy collaborating with others and thrive in team environments.
In my free time, I enjoy hiking and photography.
- Q2. What gets you frustrated/bored?
- Ans.
I get frustrated when things are disorganized or unclear.
Disorganization
Unclear instructions
Lack of structure
Repetitive tasks
Lack of challenge
- Q3. What competitions did you participate in?
- Ans.
I participated in various coding competitions.
Participated in Code Jam organized by Google
Competed in ACM ICPC regional rounds
Took part in Hackathons organized by various tech companies
- Q4. Resume and Intern based questions
- Q5. If your friends wants to open up a barber shop in the area you live, what are the prospects?
- Ans.
Prospects for opening a barber shop in the area
Check the competition in the area
Analyze the demand for barber services
Consider the location and accessibility of the shop
Evaluate the cost of setting up and running the business
Assess the potential profitability of the business
- Q6. A general puzzle question
Interview Preparation Tips
Experience: 1. Quantitative questions (10), Verbal Ability (10) and Data Interpretation (10).
2. It was long as the DI questions were time consuming.
Tips: Attempt each section because there are sectional cut offs as well. Many people didn't consider this and attempted some sections completely and left out some completely.
Duration: 45 minutes
Total Questions: 30
Round: HR Interview
Experience: It lasted for 15-20 minutes.
Round: Case Study Interview
Experience: The panel was of one person. It lasted for 20 minutes. He asked the place I belonged too. I answered Delhi and then he went straight on to the case that if my friends wants to open up a barber shop in the area I live, what are the prospects. It was pretty open ended and could be taken anywhere. Was trying to see if I can bring in all factors or not. Then regarding one of the competitions I participated in, he asked me to list three and just 3 factors which can summarize my solutions. This king of bullet-ed answering is generally expected from consultants and maybe that’s why he asked such a question.
Round: Stress Interview
Experience: The panel was of one person. He asked me a puzzle and said if I know it already I should tell him. I didn’t know it so he proceeded. Then he went out of the room saying he doesn’t want an answer, he just wants to discuss the puzzle with me and will be back in 5 mins. He came 5 mins later and started circling around me in the interview room and asked what I had to say regarding the question. I told him what I could figure out and then he started helping me in where I was stuck. He constantly kept circling around me. Probably was trying to build up stress. Finally together we arrived at the answer and he was happy after that and let me go.
General Tips: 1. Keep yourself calm in the interview even if you don’t know something. Smile and say that you don’t know is the best way.
2. Stress interviews might be there, you panic and you are out. That’s something not expected from you under pressure.
3. Participating in competitions held at the time of placements is a good idea to know about the company as well about your preference regarding the company. The problem statements are a good insight into the actual problems companies deal with.
4. Be focused on the kind of companies you want to go for. Even at the stage of application, it's good to remove some companies from your wishlist based on your interest and capability to avoid confusion and disappointment in the end.
Skill Tips: If you have done some data processing project before, that gives something to talk about in your interview.
Skills: Probability and Statistics
College Name: IIT KANPUR
I applied via Job Portal and was interviewed before Nov 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. I was asked about SQL,java excel and tableau questions
Interview Preparation Tips
Nielsen Interview FAQs
Tell us how to improve this page.
Nielsen Interviews By Designations
- Nielsen Analyst Interview Questions
- Nielsen Software Engineer Interview Questions
- Nielsen Software Developer Interview Questions
- Nielsen Data Engineer Interview Questions
- Nielsen Project Manager Interview Questions
- Nielsen Data Scientist Interview Questions
- Nielsen Senior Software Engineer Interview Questions
- Nielsen Research Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Software Engineer Trainee Interview Questions
- Software Developer Intern Interview Questions
- Software Development Engineer Interview Questions
- Software Developer Interview Questions
- Junior Software Developer Interview Questions
- Show more
Nielsen Softwaretest Engineer Interview Process for Experienced
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Data Analyst
207
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Analyst
189
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Manager
165
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Research Executive
165
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Research Executive
145
salaries
| ₹0 L/yr - ₹0 L/yr |
Kantar
GfK MODE
Euromonitor International
Dun & Bradstreet
- Home >
- Interviews >
- Nielsen Interview Questions >
- Nielsen Softwaretest Engineer Interview Questions for Experienced
