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 for Experienced
Updated
17 Jun 2024
2 interviews found
Sort by:
Popular
Anonymous
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
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
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
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Brief Explain about SCD Type II Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Sep 2024.
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Spark optimization techniques View Answers (1)
- Q2. Data warehousing questions Add Answer
2
Technical Round (2 Questions)
- Q1. Project experience View Answers (1)
- Q2. Challenges faced View Answers (1)
Skills evaluated in this interview
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
4 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Basic Python, SQL & Spark coding questions. Add Answer
- Q2. Nth highest salary, word count in pyspark View Answers (1)
2
Technical Round (1 Question)
- Q1. Questions on SQL & PySpark. Add Answer
3
Behavioral Round (1 Question)
- Q1. Questions about previous projects & optimization techniques etc. Also behavioural Add Answer
4
HR Round (1 Question)
- Q1. Salary negotiation part. Add Answer
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Company Website and was interviewed in Sep 2024.
2 Interview Rounds
1
Coding Test Round
Spark and SQL question can expect
2
Case Study Round
Focusing on the past project
Interview Preparation Tips
Interview preparation tips for other job seekers - Be prepared on basic understanding and practice the coding questions.
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Referral and was interviewed before Mar 2023.
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. SQl, different types of joins, puzzle, guestimates Add Answer
2
One-on-one Round (1 Question)
- Q1. Talk about your strength and weekness Add Answer
Interview Preparation Tips
Topics to prepare for ZS Data Engineer interview:
- SQL
- Python
- AWS
I applied via Recruitment Consulltant and was interviewed in Sep 2021.
3 Interview Rounds
1
Coding Test Round
Round 1 post shortlisting of the Resume was a Hacker Rank test and there were 5 questions:
2 programming questions of easy to Medium difficulty
and 3 Sql questions.
2
One-on-one Round (1 Question)
- Q1. The Second round was One-on-One Technical Interview; When I appeared for it, due to covid restrictions; it was a Virtual Interview over a google meet video call...read more Add Answer
3
HR Round (5 Questions)
- Q1. What are your salary expectations? Add Answer
- Q2. Share details of your previous job. Add Answer
- Q3. Why are you looking for a change? Add Answer
- Q4. What are your strengths and weaknesses? Add Answer
- Q5. Tell me about yourself. Add Answer
Interview Preparation Tips
Topics to prepare for The Smart Cube Data Engineer interview:
- Azure
- AWS
- Spark
- pyspark
- python
- SQL
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Sql question of rank sumover and partion by kinda question Add Answer
- Q2. Roles n responsibility Add Answer
I applied via Approached by Company and was interviewed in Sep 2022.
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
Coding Test Round
It was a MCQ test to intepret codes and its outcomes.
3
Technical Round (4 Questions)
- Q1. Given a dictionary, find out the greatest number for same key in Python. View Answers (1)
- Q2. Write Pyspark code to read csv file and show top 10 records. View Answers (2)
- Q3. Write pyspark code to change column name, divide one column by another column. View Answers (1)
- Q4. What are the optimization techniques applied in pyspark code? View Answers (3)
4
Behavioral Round (1 Question)
- Q1. How do you handle changing schema from source. What are the common issues faced in hadoop and how did you resolve it? View Answers (1)
5
HR Round (1 Question)
- Q1. Mostly it was salary negotiation Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be confident and pratice python, pyspark, sql for big data ppsitiom
Skills evaluated in this interview
BCG Interview FAQs
How many rounds are there in BCG Data Engineer interview for experienced candidates?
BCG interview process for experienced candidates usually has 3 rounds. The most common rounds in the BCG interview process for experienced candidates are Technical, Resume Shortlist and Case Study.
How to prepare for BCG Data Engineer interview for experienced candidates?
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 for experienced candidates?
Some of the top questions asked at the BCG Data Engineer interview for experienced candidates -
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
People are getting interviews through
based on 2 BCG interviews
Company Website
Job Portal
50%
50%
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
71%
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
487
salaries
|  ₹24.7 L/yr - ₹79.9 L/yr |
|
Senior Associate
358
salaries
| ₹24 L/yr - ₹51 L/yr |
|
Analyst
162
salaries
| ₹7.5 L/yr - ₹20 L/yr |
|
Project Lead
151
salaries
| ₹37.2 L/yr - ₹120 L/yr |
|
Senior Analyst
137
salaries
| ₹9 L/yr - ₹31.4 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 for Experienced
Share an Interview