Junior Software Engineer(Data Engineer) at Boston Consulting Group

How it went

What they would tell you

How to prepare

Round by round

1. 1

   Technical & Analytical Discussion45 min

   This round was based on core technology knowledge, academic/internship projects, logical reasoning, guesstimates, and puzzle-solving skills.

   • Firstly i was asked to introduce myself
   • There were puzzles asked(3 Bulbs and 3 Switches and There are 8 pills. They are all of the same size and colour. One pill weighs slightly more and is poisonous. You have a balanced scale and can only use it twice. How can you find the poisonous pill? )
   • Then i was asked which data structure will be used to create an undo button
   • Difference between arrays and linked list
   • 4 pillars of OOPs and explain them
   • 10000 packets were sent and every 10th packet was dropped, how many packets recieved
   • Design architecture of movie ticket booking system (each theatre has multiple screens and there are multiple theatres ). tell features and all the databases, also give high level architecture of modules, what will be potential edge cases.
2. 2

   Coding Assessment45 min

   • Was grilled on my projects(they really try to know you have made the projects from scratch or not)
   • Then 2 tables were given and was asked to perform 3 SQL queries on them.
   • Was also asked that in which order the query will be executed
   • Difference between MongoDB and MySQL
   • Was given 2 arrays had to create a hashmap which in which keys are the elements from the first array and value will be the sum of elements from the 2nd array.
   • What's a HashMap
   • Advantages of SQL databases. Questions: 2 arrays are given 1st is 1-D array and 2nd is 2-D array. Create a hashmap where keys are the elements from the 1st array and their corresponding values are the sum of elements in the 2d array present at the same index. table student columns - roll no, f_name, l_name table score columns - roll-n0, subject, marks. sql query to write full name of student whose marks in english greater than 80 sql query of full name of students whose total marks greater than 300 ignore english marks in total
3. 3

   Managerial Interview (with Technical Elements)60 min

   • again grilled on my projects my contribution and how data preprocessing was integrated etc
   • 1 coding question was asked to explain Questions: Three strings were given s1,s2 & s3. Replace the occurrence of s2 in s1 with s3 without using the replace() function

What came up