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 Answer
• Q2. Higest nth rank and lowest rank if no of employees less than 2
  View Answers (1)
• Q3. Event session data modeling
  Add Answer

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

• Q1. This was hiring manager round. Detailed discussions on project and previous experience
  Add Answer

• Q1. Strength, weakness and why myntra
  Add Answer

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

• Q1. Indexing in dbms
  View Answers (1)
• Q2. Find whether two strings are or not anagrams
  View Answers (1)

• Q1. Inorder traversal without recursion
  View Answers (1)
• Q2. How to make a class final
  View Answers (1)

• Q1. Interviewer asked me basic SQL questions
  Add Answer
• Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
  Add Answer

In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.

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 Answer
• Q2. Some APIS were given. It was case study. You had to show the dishes to a customer according to his preferences.
  Add Answer

• Q1. Basic details about work ex, reason to switch, salary expectations
  Add Answer

2 SQL questions asked

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

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 Answer

• Q1. EXPECTED INCOME , RELOCATION PREFERENCE
  Add Answer