AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
British Petroleum
Compare
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
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
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
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
I applied via Naukri.com and was interviewed in Feb 2022. There were 4 interview rounds.
(1 Question)
- Q1. Core Java, spring jpa, relationship like one to one, one to many, many to oneetc, composit key. More important many questions come from your cv like what you did in your project
(1 Question)
- Q1. Just basic behaviour questions, also be ready with some technical questions as well
(1 Question)
- Q1. Only joining discussion and formalities 😃😃
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed before Nov 2022. There were 3 interview rounds.
Asked basic C++ Qs, tree and linked list Qs
(2 Questions)
- Q1. Manager related Qs
- Q2. Future plans, how to maintain team , how do you work with others in the team etc
Interview Preparation Tips
Software Engineer Interview Questions & Answers
Reliance Industries
Anu yadav Anu
posted on 4 Oct 2021
I applied via Company Website and was interviewed in Sep 2021. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. What is software engineer
- Ans.
A software engineer is a professional who designs, develops, and maintains software applications.
Software engineers use programming languages and tools to create software solutions.
They analyze user needs and design software systems to meet those requirements.
Software engineers write code, test and debug software, and collaborate with other team members.
They may specialize in areas such as web development, mobile app d...
- Q2. What is mca uses of mca
- Ans.
MCA stands for Master of Computer Applications. It is a postgraduate degree in computer science and its applications.
MCA is a professional degree that focuses on the development of computer software and applications.
It covers subjects like programming languages, database management, software engineering, and computer networks.
MCA graduates can work as software engineers, system analysts, software consultants, web devel...
Interview Preparation Tips
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 Business Analyst Interview Questions
- British Petroleum Financial Analyst Interview Questions
- British Petroleum 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
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 >
- British Petroleum Interview Questions >
- British Petroleum Data Engineer Interview Questions
