AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
BCG
Compare
Filter interviews by
BCG Data Engineer Interview Questions and Answers
BCG Data Engineer Interview Experiences
6 interviews found
Anonymous
(1 Question)
- Q1. Data warehouse concepts
I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. Present yourself
- Q2. Asks about level of experience in each tachnology in the CV
(1 Question)
- Q1. The interiew was around for 1 hr asked python, sql airflow and data warehouse quetion
I applied via Company Website and was interviewed in Dec 2023. There was 1 interview round.
(1 Question)
- Q1. Difference between list and tuple?
- Ans.
List is mutable, tuple is immutable in Python.
List can be modified after creation, tuple cannot.
List is defined using square brackets [], tuple using parentheses ().
Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)
Skills evaluated in this interview
BCG interview questions for designations
I applied via Indeed and was interviewed in May 2023. There were 5 interview rounds.
(1 Question)
- Q1. Basics of python, SQL and pyspark
(1 Question)
- Q1. Questions on Python, SQL
PySpark questions to solve
(1 Question)
- Q1. Architectural questions
Interview Preparation Tips
I was interviewed in Sep 2023.
(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 data ware houses on SCD, Data Modeling,...etc....
Data Engineer Jobs at BCG
What people are saying about BCG
Interview questions from similar companies
I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Project related discussions
- Q2. Meduim level SQl and DSA
(2 Questions)
- Q1. This was data modelling round
- Q2. Design a uber data model
- Ans.
Uber data model design for efficient storage and retrieval of ride-related information.
Create tables for users, drivers, rides, payments, and ratings
Include attributes like user_id, driver_id, ride_id, payment_id, rating_id, timestamp, location, fare, etc.
Establish relationships between tables using foreign keys
Implement indexing for faster query performance
Interview Preparation Tips
Skills evaluated in this interview
I applied via Approached by Company and was interviewed in Aug 2024. There was 1 interview round.
Maxium sub string and reverse a string
avish goswami
(2 Questions)
- Q1. Difference between star and Snowflake schema in detail
- Ans.
Star schema has a single fact table connected to multiple dimension tables, while Snowflake schema has normalized dimension tables.
Star schema denormalizes data for faster query performance
Snowflake schema normalizes data to reduce redundancy
Star schema is easier to understand and query
Snowflake schema is more flexible and scalable
Example: A star schema for a sales database would have a fact table for sales transaction...
- Q2. Diff btw transient table , fact table and dimension table
- Ans.
Transient tables are temporary tables, fact tables contain quantitative data, and dimension tables contain descriptive data.
Transient tables are temporary and used for intermediate processing or storing temporary data.
Fact tables contain quantitative data such as sales, revenue, or quantities.
Dimension tables contain descriptive data like customer names, product categories, or dates.
Interview Preparation Tips
Skills evaluated in this interview
I applied via Approached by Company and was interviewed in May 2023. There were 2 interview rounds.
(2 Questions)
- Q1. It's question on collect list - it should be a straight question instead it was asked like comma separated and in a vague way.
- Q2. Few questions on triggers, integration runtime
Interview Preparation Tips
Few questions asked itself is wrong. Interviewer asking in her way of understanding.
Wishi Kaur is the interviewer and she is so rude and didn't know the way to ask questions and no respect over candidates.
She is thinking she knows everything.
It's a humble request to avoid these kind of interviewers.
BCG Interview FAQs
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 Software Engineer Interview Questions
- BCG Intern 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
BCG Data Engineer Interview Process
based on 7 interviews
1 Interview rounds
- Technical Round
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
BCG Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Consultant
527
salaries
|  ₹24.7 L/yr - ₹80 L/yr |
|
Senior Associate
417
salaries
| ₹24 L/yr - ₹50 L/yr |
|
Analyst
161
salaries
| ₹7 L/yr - ₹21.8 L/yr |
|
Project Lead
155
salaries
| ₹40 L/yr - ₹120 L/yr |
|
Senior Analyst
143
salaries
| ₹10.2 L/yr - ₹31.4 L/yr |
McKinsey & Company
PwC
Bain & Company
Deloitte
- Home >
- Interviews >
- BCG Interview Questions >
- BCG Data Engineer Interview Questions
