BP Data Engineer Interview Experience | Pune | 2025
- Location
- Pune
- Posted
- 23 May 2025
Summary
I recently interviewed with British Petroleum for a Data Engineer role in Pune, which involved five rounds covering coding challenges (DSA and SQL), system design, and behavioral aspects. I'm sharing my experience to help others preparing for similar roles.
How it went
Hey Everyone,
As resources for Data Engineer interview experience are pretty scarce here in Leetcode, please find my recent interview experience with British Petroleum. Plan to upload more in coming weeks. Hopefully it helps!
---
1. Round 1 : On-Demand Video Interview +
60 minute Coding Challenge - Dynamic programming (Longest Common Subsequence) and 2 SQL questions.
3. Round 2 : Technical Assessment 1 - 1 DSA (word break problem) and 2 easy SQL problems. Questions on SQL fundamentals like joins, ranking functions,etc.
4. Round 3 : Techinical Assesment 2 - Valid Sudoku (9x9).
5. Round 4 : Hiring Manager (Who We Are) - Usual behavioural questions and check understanding on solution design and scalability.
6. Round 5 : HR discussion for Salary negotiations and benefits.
Please feel free to drop any questions!
Questions asked (6)
- 01
Longest Common Subsequence
Data Structures & Algorithms
Open the problemGiven two strings
text1andtext2, return the length of their longest common subsequence. If there is no common subsequence, return 0. A subsequence of a string is a new string generated from the original string with some characters (can be none) deleted without changing the relative order of the remaining characters. - 02
SQL Fundamentals: Joins and Ranking Functions
Other · Easy
Questions involved fundamental SQL concepts, specifically focusing on various types of joins (e.g., INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN) and ranking functions such as ROW_NUMBER(), RANK(), and DENSE_RANK().
- 03
Word Break
Data Structures & Algorithms
Open the problemGiven a string
sand a dictionary of stringswordDict, returntrueifscan be segmented into a space-separated sequence of one or more dictionary words. The same word in the dictionary may be reused multiple times in the segmentation. You may assume the dictionary does not contain duplicate words. - 04
Valid Sudoku
Data Structures & Algorithms
Open the problemDetermine if a 9x9 Sudoku board is valid. Only the filled cells need to be validated according to the following rules: Each of the digits 1-9 must appear exactly once in each row. Each of the digits 1-9 must appear exactly once in each column. Each of the digits 1-9 must appear exactly once in each of the nine 3x3 sub-boxes of the grid. The Sudoku board could be partially filled, where empty cells are filled with '.'
- 05
Behavioral Questions
Behavioral
Standard behavioral questions to assess fit, teamwork, problem-solving approach, and past experiences.
- 06
System Design and Scalability
System Design
Questions checking understanding of solution design principles, architectural patterns, and how to achieve scalability for systems (e.g., handling high traffic, distributed systems, database scaling).