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.

• Q1. Tell me about your projects?
  Add Answer
• Q2. How do you approach the project if you are using logistic regression model?
  View Answers (1)

• Q1. What are you future goals?
  Add Answer
• Q2. What would you do if your interested field doesnt have any work in the company?
  View Answers (1)

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

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