Add office photos
Filter interviews by
British Petroleum Data Engineer Interview Questions and Answers
British Petroleum Data Engineer Interview Experiences
5 interviews found
(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
What people are saying about British Petroleum
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
British Petroleum interview questions for designations
(1 Question)
- Q1. Aptitude test including SQL and Python
Interview Preparation Tips
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
Data Engineer Interview Questions & Answers
Jindal Drilling & Industries
Anonymous
posted on 8 Nov 2023
Selected
I applied via Approached by Company and was interviewed before Nov 2022. There were 3 interview rounds.
(4 Questions)
- Q1. Technical round you need to face interview: Telephonic or face to face, you need to prepare your technical part what they are looking for Data Engineer they will ask about data and application they are usi...
- Q2. GC Calibration, sensors and transmitters, system related questions.
- Q3. Rig site and structure
- Q4. Overall skill whatever you have experience
(1 Question)
- Q1. Yourself and documentation
Interview Preparation Tips
- Be smart
(1 Question)
- Q1. Basic data science and statistics interview questions along with their mathematical understanding.
(1 Question)
- Q1. Data science questions with mathematical understanding
(1 Question)
- Q1. STAR type questions
Selected
I applied via Company Website and was interviewed in Jun 2023. There were 4 interview rounds.
Asked Real Time Scenario to create Microservice for Train and Station information. The interviewer asked what are the properties needs to be considered for evaluating service.
Core Java 11 questions: Webservices, Improvement in JVM, Threads
Java 8: Asked to write a program based on Group By Scenario.
The interview lasts around 2 hrs.
(1 Question)
- Q1. Managerical round: Asked about current project details, The reason to join BH, Scenario based question on LinkedList vs ArrayList
(1 Question)
- Q1. It was easy. The HR told about company policies
Interview Preparation Tips
2. Go to BH page to know more, This will help u to answer questions will be asked in Manager Round.
(2 Questions)
- Q1. Resume Based questions and ML & DL basics
- Q2. BERT and CNN models
British Petroleum Interview FAQs
Some of the top questions asked at the British Petroleum Data Engineer interview -
Tell us how to improve this page.
British Petroleum Interviews By Designations
- British Petroleum Data Engineer Interview Questions
- British Petroleum ARC Analyst Interview Questions
- British Petroleum Financial Analyst Interview Questions
- British Petroleum Analyst Interview Questions
- British Petroleum Business Analyst Interview Questions
- British Petroleum Data Analyst Interview Questions
- British Petroleum Document Controller Interview Questions
- British Petroleum Senior Data Engineer 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
British Petroleum Data Engineer Interview Process
based on 5 interviews
1 Interview rounds
- Technical Round
Data Engineer Interview Questions from Similar Companies
British Petroleum Data Engineer Reviews and Ratings
based on 3 reviews
Rating in categories
|
Senior Analyst
103
salaries
|  ₹5.6 L/yr - ₹19.5 L/yr |
|
Analyst
81
salaries
| ₹4.8 L/yr - ₹13 L/yr |
|
ARC Analyst
68
salaries
| ₹5.5 L/yr - ₹16 L/yr |
|
Financial Analyst
50
salaries
| ₹5.5 L/yr - ₹14 L/yr |
|
Inventory Analyst
47
salaries
| ₹5.8 L/yr - ₹11 L/yr |
Reliance Industries
Indian Oil Corporation
Hindustan Petroleum
Bharat Petroleum
- Home >
- Interviews >
- British Petroleum Interview Questions >
- British Petroleum Data Engineer Interview Questions
