BCG -X Junior Engineer(SWE/Data) Interview Experience
Summary
I interviewed for the Junior Engineer (SWE/Data) role at BCG, which involved three rounds covering data structures, algorithms, system design, web technologies, and behavioral aspects.
Full Experience
BCG takes 3 rounds for the Junior Engineer Role and had two channels for SWE and Data Engineering (Please note this is Data Engineering not Data Science Channel)
Round 1:
Discussion about projects mainly I was given a short missing number from 1..n numbers. Solved it with arithematic progression equation.I was also given a list of dictionaries
wherein I needed to find the aggregate of the particular user id
I was also asked to write an SQL Query with the correct syntax.
Difference Between Array and Hashmap.
Round 2: Grilled on Projects Concentrated Both on SWE and Data Side End
1. JavaScript events code an example for preventdefault.
2. What are APIs code get put post and patch
3. What is localstorage
4. What are ORM
5. Decorator Functions and Generator Function
6. Tricky snippet of Lambda Function and asked output for the same
7. 8 SQL Queries getting tougher each time
8. React useEffect and useState why and when used
9. Database Indexing
10. Project/Internship Discussion on Resume
Round 3: Managerial Round
1.Asked about Past projects
2.Scare Moment in Development if any
3.Weaknesses
4.Team Collaboration situation scenario
5.Condition wherein I have a critical situation and I got assigned some work on Friday. How to handle then?
Interview Questions (18)
Missing Number from 1 to n
Given a short missing number from 1..n numbers, find the missing number.
Aggregate Data from List of Dictionaries
Given a list of dictionaries, find the aggregate of a particular user ID.
Write SQL Query
Asked to write an SQL Query with the correct syntax.
Difference between Array and Hashmap
Explain the difference between an Array and a Hashmap.
JavaScript `preventDefault` Example
Code an example for JavaScript events using preventDefault.
APIs: GET, PUT, POST, PATCH
Explain what APIs are and provide code examples for GET, PUT, POST, and PATCH methods.
What is Local Storage?
Explain what local storage is.
What are ORMs?
Explain what Object-Relational Mappers (ORMs) are.
Decorator and Generator Functions
Explain decorator functions and generator functions.
Lambda Function Output Prediction
Given a tricky snippet of a Lambda Function, predict its output.
Advanced SQL Queries
Solve 8 SQL queries, progressively increasing in difficulty.
React `useEffect` and `useState`
Explain why and when useEffect and useState hooks are used in React.
Database Indexing Concepts
Discuss concepts related to database indexing.
Discussion on Past Projects
Discuss past projects listed on the resume.
Scare Moment in Development
Describe any scare moments encountered during development.
Discuss Weaknesses
Discuss personal weaknesses.
Team Collaboration Scenario
Describe a team collaboration situation scenario.
Handling Critical Work on Friday
Describe how to handle a critical situation where work is assigned on a Friday.