Wonder Werkz Data Engineer Interview Questions and Answers for Freshers

Q1. Duplicate in list
Ans. 
Find duplicates in a list of elements.
• Iterate through the list and keep track of elements seen so far

• If an element is already in the seen elements, it is a duplicate

• Use a hash set to efficiently check for duplicates
Answered by AI
Add your answer
Q2. Anagram in list
Ans. 
Check if any two strings in the list are anagrams of each other
• Iterate through the list and for each string, sort the characters and check if it already exists in a hashmap

• If it exists, then the current string is an anagram of the existing string

• Return true if anagrams are found, false otherwise
Answered by AI
Add your answer

Coding round with a python question and SQL query

Q1. Technical question and a coding question in python, medium level
Add your answer

I was asked 2 questions about numpy and 1 question about python coding along with some questions on data analysis as well as python

Merge Sort, FIFO based question

An App was given to design in given tim eframe

Medium level array question was asked on hackerrank.

Q1. Simple string question was asked which required a little thinking and simple implementation.
Add your answer

Q1. This was a coding round. I was given a screenshot which has dropdowns in it and I had to make the UI of it using react.js
Add your answer

This aptitude + technical MCQ test was of 120 minutes in duration. Had MCQs on quantitative ability, logical ability, Language, and technical MCQs consisted of questions on DBMS, OS, Networks, DSA. There were two coding questions as well. One on Bit Manipulating, and the other on DFS.

Q1. A question on BFS very similar to Leetcode 924. Was given one hour to discuss and come to an optimized solution with the interviewer.
Add your answer

Q1. Search an element in a sorted and rotated array
Ans. 
Search an element in a sorted and rotated array
• Find the pivot point where the array is rotated

• Divide the array into two sub-arrays based on pivot point

• Perform binary search on the appropriate sub-array
Answered by AI
Add your answer
Q2. SQL query on left join
Add your answer
Q3. Questions on CPP memory management
Add your answer
Q4. Questions related to projects done
Add your answer

Q1. Propose a system for a popular media stream service
Ans. 
Proposed system for a popular media stream service
• Implement a recommendation engine to suggest content based on user preferences and viewing history

• Integrate with social media platforms to allow users to share and discuss content

• Provide multiple subscription options with varying levels of access and features

• Ensure high-quality streaming with minimal buffering through the use of content delivery networks

• Implement robust...read more
Answered by AI
Add your answer
Q2. Questions related to Fullstack Tech Stacks
Add your answer

Guesstimate on number of Reddit users in India. No starting input was given. Gave solution by using bottom to top approach. Tried to focus on quantifying teenagers with internet access and a particular interest about internet. Gave a figure around ~1 million in a year.

Q1. Where do you see yourself at McKinsey?
Add your answer

Coding round with 3 problem statements

Q1. Questions related to project you have mentioned on resume
Add your answer
Q2. Questions related to technologies you have mentioned
Add your answer
Q3. Questions related to the coding test
Add your answer
Q4. Nothing discussed everything as I know
Add your answer
Q5. All the best those who are trying their best
Add your answer

3 three-question assignment was given to be done and submitted in 2 hours.

Design music player, implement shuffle feature