BOLD Technology Systems Data Engineer Interview Questions and Answers

I was hiring drive. First round was coding test with medium to advanced SQL, data modelling and python questions

Q1. Data model e commerce application
Add your answer
Q2. Higest nth rank and lowest rank if no of employees less than 2
Ans. 
If number of employees is less than 2, highest and lowest rank will be the same.
• If there are less than 2 employees, both highest and lowest rank will be the same.

• For example, if there is only 1 employee, their rank will be 1 which is both the highest and lowest rank.
Answered by AI
Add your answer
Q3. Event session data modeling
Add your answer

Q1. Sql-self join, non equi join, window funtion, consecutive seats, data modeling, stock market maximum profit sql question
Add your answer

Q1. This was hiring manager round. Detailed discussions on project and previous experience
Add your answer

Q1. Strength, weakness and why myntra
Add your answer

Test contains 26 questions for me 13 are java based 13 are c++ based

Q1. Indexing in dbms
Ans. 
Indexing in DBMS is a technique to improve the performance of queries by creating a data structure that allows for faster retrieval of data.
• Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition.

• Types of indexes include clustered, non-clustered, unique, and composite indexes.

• Examples of indexing techniques include B-tree, hash, and bitmap indexes.

• Indexing can...read more
Answered by AI
Add your answer
Q2. Find whether two strings are or not anagrams
Ans. 
Check if two strings are anagrams by comparing the sorted characters in each string.
• Sort the characters in both strings and compare if they are equal.

• Ignore spaces and punctuation when comparing the strings.

• Example: 'listen' and 'silent' are anagrams.

• Example: 'hello' and 'world' are not anagrams.
Answered by AI
View 1 more answer

Q1. Inorder traversal without recursion
Ans. 
Use a stack to simulate the recursive inorder traversal process
• Create an empty stack to store nodes

• Start with the root node and push it onto the stack

• While the stack is not empty, keep traversing left and pushing nodes onto the stack

• Once you reach a leaf node, pop it from the stack, print its value, and move to its right child

• Repeat the process until all nodes have been visited
Answered by AI
Add your answer
Q2. How to make a class final
Ans. 
To make a class final, use the 'final' keyword in the class declaration.
• Use the 'final' keyword before the 'class' keyword in the class declaration

• A final class cannot be subclassed or extended

• Final classes are often used for utility classes or classes that should not be modified
Answered by AI
Add your answer

It was an online assessment. Some coding questions. Some cs fundamental mcqs. SQL query, Rest Api question.

An assignment to create a game using nodejs/ go lang/ java.

Q1. Discussion related to Assignment. Told some changes and told to add some more functionalities.
Add your answer
Q2. Some APIS were given. It was case study. You had to show the dishes to a customer according to his preferences.
Add your answer

Implement your own state management in React and integrate it into a React application.

It was a coding round, online assessment. Medium level DSA questions

Q1. The discussion was based on system design, was asked to design parking lot system
Add your answer

Q1. Hiring manager round, he asked about the problems that I solved
Add your answer

Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing

1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day

GD COMMON TOPIC WAS DISCUSSED

Q1. TELL ABOUT YOURSELF , SKILLSETS YOU BRING TO THE TABLE
Add your answer

Q1. EXPECTED INCOME , RELOCATION PREFERENCE
Add your answer

Determine an individual's skill or propensity to succeed in a given activity. Aptitude tests assume that individuals have inherent strengths and weaknesses and have a natural inclination toward success or failure in specific areas based on their innate characteristics.

Q1. Tell me about yourself. · 2. Why do you want to work for our company? · 3. What are your greatest strengths
Add your answer