AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
bp
Compare
Filter interviews by
bp Data Engineer Interview Questions and Answers
bp Data Engineer Interview Experiences
5 interviews found
Anonymous
(1 Question)
- Q1. What is the purpose of using Common Table Expressions (CTE) in SQL?
Riya Gupta
(1 Question)
- Q1. LRU Cache Implementation
Selected
I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 3 interview rounds.
2 question :
1. Find the longest common subsequence in 2 strings
2. find the 5th highest revenue from the table in last 28 days in a particular region
I was given a list of book, genre of books and books and rating of books . All list was of equal length n.
There were 2 methods which need to be implemented
1. get highest rating of book by genre . if rating are same then in lexographical order
2. update book rating by book name
(2 Questions)
- Q1. These questions were basic
- Q2. There were lots of imaginative situation given and then I was asked to say what I would do in those situation
Interview Preparation Tips
I applied via Company Website and was interviewed in Mar 2023. There were 3 interview rounds.
First round was online assessment test with programming and aptitude games
(2 Questions)
- Q1. Group Anagram question
- Q2. SQL question to get name of employee whose salary is greater than average salary of the department
- Ans.
SQL query to retrieve name of employee with salary greater than department average.
Calculate average salary of department using GROUP BY clause
Join employee and department tables using department ID
Filter employees with salary greater than department average
Select employee name
Interview Preparation Tips
- Spark
- Cloud
- Programming
- SQL
Skills evaluated in this interview
bp interview questions for designations
(1 Question)
- Q1. Aptitude test including SQL and Python
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Selected
I was interviewed in May 2024.
(6 Questions)
- Q1. SQL table distributions.
- Q2. ADF switching questions?
- Q3. How do you optimize the performance?
- Ans.
Performance optimization in data engineering involves tuning queries, indexing, partitioning, and utilizing appropriate hardware.
Tune queries by optimizing SQL code, using appropriate joins, and avoiding unnecessary operations.
Utilize indexing to speed up data retrieval by creating indexes on frequently queried columns.
Partition data to distribute it across multiple nodes or servers for parallel processing.
Utilize appr...
- Q4. What is stored procedure?
- Ans.
A stored procedure is a set of SQL statements that can be saved and reused in a database management system.
Stored procedures are used to perform a specific task or set of tasks in a database.
They can accept input parameters and return output parameters.
Stored procedures can improve performance by reducing the amount of data sent between the database and the application.
They can also enhance security by controlling acce...
- Q5. Ranking functions in SQL?
- Ans.
Ranking functions in SQL are used to assign a rank to each row based on a specific criteria.
Ranking functions include RANK(), DENSE_RANK(), and ROW_NUMBER()
RANK() assigns a unique rank to each distinct row
DENSE_RANK() assigns a unique rank to each distinct row without gaps
ROW_NUMBER() assigns a unique sequential integer to each row
- Q6. Modelling questions.
Skills evaluated in this interview
Selected
I applied via Approached by Company and was interviewed before Dec 2021. There were 2 interview rounds.
(3 Questions)
- Q1. Tell Me About urself
- Q2. SAP overview in PM, RCM, P16
- Ans.
SAP is an enterprise resource planning software used for PM, RCM, and P16.
SAP is a software used for managing business operations and customer relations.
PM (Plant Maintenance) module in SAP helps in managing maintenance activities like planning, scheduling, and execution.
RCM (Reliability Centered Maintenance) module in SAP helps in identifying and prioritizing maintenance tasks based on criticality.
P16 (Project System)...
- Q3. Technical skills and maintainance of rotary equipments, if u r planning dept then its an upperhand for u.
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Apr 2023. There were 5 interview rounds.
Reverse a binary tree and few other technical questions
(1 Question)
- Q1. Data structure and Oops concepts were asked
(1 Question)
- Q1. Technical round on projects that we have worked on and questions around that
(1 Question)
- Q1. General HR questions
(1 Question)
- Q1. More of like a general conversation with the center manager
I applied via campus placement at Siddaganga Institute of Technology (SIT) and was interviewed in Mar 2022. There were 2 interview rounds.
It consisted of 3 coding questions and database questions mainly
(1 Question)
- Q1. About project they asked
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed before Oct 2022. There were 5 interview rounds.
(1 Question)
- Q1. Question as per my skill set from SQL, Unix, Power Center Mappings.
(1 Question)
- Q1. In detail questions on skill sets and writing logic and flow diagram for one of the problem statement
(1 Question)
- Q1. General discussion on expectations and the requirments
(1 Question)
- Q1. Don't remember the exact questions
bp Interview FAQs
Some of the top questions asked at the bp Data Engineer interview -
Tell us how to improve this page.
bp Interviews By Designations
- bp Data Engineer Interview Questions
- bp ARC Analyst Interview Questions
- bp Business Analyst Interview Questions
- bp Financial Analyst Interview Questions
- bp Analyst Interview Questions
- bp Data Analyst Interview Questions
- bp Document Controller Interview Questions
- bp Senior Data Engineer Interview Questions
- Show more
bp Data Engineer Interview Process
based on 5 interviews
1 Interview rounds
- Technical Round
Data Engineer Interview Questions from Similar Companies
bp Data Engineer Reviews and Ratings
based on 3 reviews
Rating in categories
|
Senior Analyst
104
salaries
|  ₹5.6 L/yr - ₹20 L/yr |
|
Analyst
86
salaries
| ₹4.8 L/yr - ₹14 L/yr |
|
ARC Analyst
69
salaries
| ₹5.5 L/yr - ₹16 L/yr |
|
Financial Analyst
57
salaries
| ₹5.5 L/yr - ₹13.9 L/yr |
|
Software Engineer
46
salaries
| ₹19.5 L/yr - ₹50 L/yr |
Reliance Industries
Indian Oil Corporation
Hindustan Petroleum
Bharat Petroleum
- Home >
- Interviews >
- bp Interview Questions >
- bp Data Engineer Interview Questions
