AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
BT Group Data Engineer Interview Questions and Answers
BT Group Data Engineer Interview Experiences
1 interview found
Anonymous
(2 Questions)
- Q1. What is the difference between start schema and snowflake schema
- Ans.
Star schema is a denormalized schema with a single fact table and multiple dimension tables, while snowflake schema is a normalized schema with multiple dimension tables normalized into sub-dimension tables.
Star schema has a single fact table surrounded by multiple dimension tables, while snowflake schema has dimension tables normalized into sub-dimension tables.
In star schema, dimensions are denormalized, while in sno...
- Q2. How do you load data into bigquery using dataflow
- Ans.
Data can be loaded into BigQuery using Dataflow by creating a pipeline in Dataflow that reads data from a source and writes it to BigQuery.
Create a Dataflow pipeline using Apache Beam SDK
Read data from a source such as Cloud Storage or Pub/Sub
Transform the data as needed using Apache Beam transformations
Write the transformed data to BigQuery using BigQueryIO.write()
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
It was basic coding to test the Python skills like reading data from local and uploading in cloud then some basic dag related questions
(4 Questions)
- Q1. Clustering and partition difference in data warehousing solutions
- Ans.
Clustering involves grouping similar data together, while partitioning involves dividing data into smaller, manageable sections.
Clustering is used to group similar data points together based on certain criteria, such as customer segments or product categories.
Partitioning involves dividing a large dataset into smaller, more manageable sections for easier data retrieval and processing.
Clustering is often used for data a...
- Q2. What are the different approaches to Optimising SQL
- Ans.
Different approaches to optimizing SQL include indexing, query optimization, and database design.
Use indexing to improve query performance
Optimize queries by avoiding unnecessary joins and using appropriate functions
Design the database schema efficiently to reduce redundancy and improve data retrieval speed
- Q3. Spark and it’s architecture
- Q4. Finding the count of Item bought by an customer from Flipkart during a year excluding February
- Ans.
To find the count of items bought by a customer from Flipkart during a year excluding February, you need to aggregate the data and filter out February transactions.
Aggregate the data by customer and item purchased
Filter out transactions from February
Count the number of items bought by each customer
Interview Preparation Tips
Bhavya R
(2 Questions)
- Q1. What are the different optimization techniques used in your project
- Q2. SQl logic question regarding joins
I applied via Approached by Company
Python and SQL Questions (Easy to Medium)
(5 Questions)
- Q1. Project Work Discussion
- Q2. SQL Coding (Can be with an online compiler)
- Q3. Python Coding (Can be with an online compiler)
- Q4. PySpark Coding (All the coding answers have to be submitted to the interviewer)
- Q5. PySpark Joins, and Databricks, and Vanilla Spark difference
(3 Questions)
- Q1. SQL 2 Questions (Easy to Medium) (Maybe on the compiler)
- Q2. Python (Easy) (Maybe on compiler)
- Q3. Scenario-based questions on the project
Interview Preparation Tips
For Coding be prepared with:
DSA: Easy
SQL: Easy to Medium (Always be prepared with the NULL-based SQL queries and how they behave)
PySpark: Easy (RDD and data frame)
I applied via LinkedIn and was interviewed in Jun 2024. There was 1 interview round.
(3 Questions)
- Q1. Sql question related to windows function
- Q2. Unix basics - find a word in a set of files
- Ans.
Using Unix command 'grep' to find a word in a set of files
Use 'grep' command followed by the word you want to search for and the file(s) you want to search in
Add the '-r' flag to search recursively in all files in a directory
Use '-i' flag for case-insensitive search
Example: grep 'hello' file.txt
Example: grep -r 'error' /path/to/directory
Example: grep -i 'apple' file1.txt file2.txt
- Q3. Python question related to file system, regex
Interview Preparation Tips
Skills evaluated in this interview
Selected
I was interviewed in Dec 2024.
Basic aptitude test asking questions very basic
Coding questions based on dsa
(1 Question)
- Q1. Basic hr question
(1 Question)
- Q1. Current Project
(1 Question)
- Q1. Current Project
I applied via Job Portal
Python data analysis interview
Projects which i worked on
(2 Questions)
- Q1. Salary negotation
- Q2. Projects to work on
I applied via Approached by Company and was interviewed in Aug 2022. There was 1 interview round.
(1 Question)
- Q1. What is the difference between group by and partition by
- Ans.
Group by is used to group rows based on a column, while partition by is used to divide rows into partitions based on a column.
Group by is used with aggregate functions to summarize data
Partition by is used to perform window functions on each partition separately
Group by creates a single result set, while partition by can create multiple result sets
Group by is used in SQL, while partition by is used in window functions
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement
Resume short listing
2 coding questions easy with aptitude questions as well
BT Group Interview FAQs
Tell us how to improve this page.
BT Group Interviews By Designations
- BT Group Financial Analyst Interview Questions
- BT Group Network Engineer Interview Questions
- BT Group Associate Engineer Interview Questions
- BT Group Associate Interview Questions
- BT Group Network Security Engineer Interview Questions
- BT Group Project Coordinator Interview Questions
- BT Group Software Engineer Interview Questions
- BT Group Associate Engineer Trainee Interview Questions
- Show more
BT Group Data Engineer Interview Process
based on 1 interview
Interview experience
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
BT Group Data Engineer Reviews and Ratings
based on 6 reviews
Rating in categories
|
Associate
324
salaries
|  ₹1.5 L/yr - ₹7 L/yr |
|
Associate Engineer
280
salaries
| ₹2.8 L/yr - ₹8 L/yr |
|
Financial Analyst
254
salaries
| ₹6.8 L/yr - ₹23 L/yr |
|
Project Manager
233
salaries
| ₹6 L/yr - ₹23.5 L/yr |
|
Network Engineer
205
salaries
| ₹2.7 L/yr - ₹9 L/yr |
Vodafone Idea
Bharti Airtel
Jio
Tata Communications
- Home >
- Interviews >
- BT Group Interview Questions >
- BT Group Data Engineer Interview Questions
