Premium Employer
i
This company page is being actively managed by
BCG Team. If you also belong to the team, you
can get access from
here
BCG
Compare
Filter interviews by
BCG Data Engineer Interview Questions and Answers
Updated
7 Nov 2024
6 interviews found
Sort by:
Popular
Anonymous
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. Data warehouse concepts Add Answer
Interview experience
Poor
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Company Website and was interviewed in Apr 2024.
1 Interview Round
1
HR Round (2 Questions)
- Q1. Present yourself Add Answer
- Q2. Asks about level of experience in each tachnology in the CV Add Answer
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. The interiew was around for 1 hr asked python, sql airflow and data warehouse quetion Add Answer
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I applied via Company Website and was interviewed in Dec 2023.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Difference between list and tuple? View Answers (1)
Skills evaluated in this interview
BCG interview questions for designations
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Indeed and was interviewed in May 2023.
5 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2
Technical Round (1 Question)
- Q1. Basics of python, SQL and pyspark Add Answer
3
Technical Round (1 Question)
- Q1. Questions on Python, SQL Add Answer
4
Case Study Round
PySpark questions to solve
5
Technical Round (1 Question)
- Q1. Architectural questions Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - They expect you hold knowledge on everything from architecture to basics
Interview experience
Average
Difficulty level
Moderate
Duration
-
Result
Not Selected
I was interviewed in Sep 2023.
1 Interview Round
1
Technical Round (1 Question)
- Q1. When the interview get started, interviewer directly jump into python coding questions based on the dict, arrays and lists. And then asked about some question d...read more Add Answer
What people are saying about BCG
View All
socialcider
works at
Qualtech Consultants
Will my YOE as SQL developer hold any value if i were to become a Data Analyst?
I'm currently working as an PLSQL Developer with 1.3 YOE in a prod support team. My daily tasks require resolving bugs with the product, deliver new changes in the system etc. The only tool I use is Oracle PLSQL Developer, ireport so I wanted to upskill myself and move into Data Analytics since I'm pretty good with SQL and Excel already. I wanted to know if my years here as SQL developer will be of any use if I want to apply for Data analyst role requiring say 1-2 YOE or will I be treated as a Fresher Data Analyst since that would be my first job as a Data analyst. Thanks for your help
Got a question about BCG?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Average
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I applied via Company Website and was interviewed in Nov 2024.
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Sql constrainsts, star schema, dml dcl commands Add Answer
- Q2. About cureent project and responsibilities Add Answer
2
Technical Round (2 Questions)
- Q1. Current projects and resposibilities Add Answer
- Q2. Where vs having, reason for job change Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - 1. Technical - about you current project and responsibilities, basic SQL question-constraints, starschema, DML DCL command, one sql query write.
2. Technical with senior manager- about project ,where vs having , reason of job change
2. Technical with senior manager- about project ,where vs having , reason of job change
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via LinkedIn and was interviewed in Sep 2024.
2 Interview Rounds
1
Technical Round (5 Questions)
- Q1. Spark architecture Add Answer
- Q2. Difference between coalesce and reparation View Answers (1)
- Q3. SQL question using Lag window function Add Answer
- Q4. Same question in Pyspark Add Answer
- Q5. Project and day to day activities Add Answer
2
Behavioral Round (2 Questions)
- Q1. Scenario based questions Add Answer
- Q2. Gave details about work Add Answer
Interview Preparation Tips
Topics to prepare for PwC Data Engineer interview:
- Spark
- SQL
- Pyspark
- Project
- Soft Skills
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Sep 2024.
3 Interview Rounds
1
Coding Test Round
Some multiple choice, 2 sql and 2 python questions were asked
2
Technical Round (2 Questions)
- Q1. Tell me about you project View Answers (1)
- Q2. Optimising technique that you have used View Answers (1)
3
Technical Round (2 Questions)
- Q1. Window partition question was asked Add Answer
- Q2. Project related question Add Answer
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
4-6 weeks
Result
Not Selected
I applied via Company Website and was interviewed in Aug 2024.
2 Interview Rounds
1
One-on-one Round (2 Questions)
- Q1. Project related discussions Add Answer
- Q2. Meduim level SQl and DSA Add Answer
2
One-on-one Round (2 Questions)
- Q1. This was data modelling round Add Answer
- Q2. Design a uber data model View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare SQl, Python and data modeling
Skills evaluated in this interview
BCG Interview FAQs
How many rounds are there in BCG Data Engineer interview?
BCG interview process usually has 1-2 rounds. The most common rounds in the BCG interview process are Technical, Resume Shortlist and Case Study.
How to prepare for BCG Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at BCG. The most common topics and skills that interviewers at BCG expect are Big Data, Python, Hive, SQL and Consulting.
What are the top questions asked in BCG Data Engineer interview?
Tell us how to improve this page.
BCG Interviews By Designations
- BCG Consultant Interview Questions
- BCG Associate Interview Questions
- BCG Associate Consultant Interview Questions
- BCG Summer Intern Interview Questions
- BCG Intern Interview Questions
- BCG Software Engineer Interview Questions
- BCG Data Engineer Interview Questions
- BCG Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Interview Process at BCG Data Engineer
based on 5 interviews in last 1 year
1 Interview rounds
- Technical Round
View more
People are getting interviews through
based on 3 BCG interviews
Company Website
Job Portal
67%
33%
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Join BCG Beyond is where we begin.
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
68%
more
than the average Data Engineer Salary in India
View more details
BCG Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Consultant
484
salaries
|  ₹24.1 L/yr - ₹93.5 L/yr |
|
Senior Associate
473
salaries
| ₹23 L/yr - ₹51 L/yr |
|
Analyst
224
salaries
| ₹6.5 L/yr - ₹24 L/yr |
|
Associate
178
salaries
| ₹8.2 L/yr - ₹33 L/yr |
|
Project Lead
141
salaries
| ₹53.7 L/yr - ₹120 L/yr |
Explore more salaries
Compare BCG with
McKinsey & Company
Compare
PwC
Compare
Bain & Company
Compare
Deloitte
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- BCG Interview Questions >
- BCG Data Engineer Interview Questions
Share an Interview