BP Data Engineer Interview Experience | Pune | 2025

british petroleum logo
british petroleum
Data EngineerPune
May 23, 20253 reads

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.

Full Experience

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!

Interview Questions (6)

Q1
Longest Common Subsequence
Data Structures & Algorithms

Given two strings text1 and text2, 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.

Q2
SQL Fundamentals: Joins and Ranking Functions
OtherEasy

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().

Q3
Word Break
Data Structures & Algorithms

Given a string s and a dictionary of strings wordDict, return true if s can 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.

Q4
Valid Sudoku
Data Structures & Algorithms

Determine 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 '.'

Q5
Behavioral Questions
Behavioral

Standard behavioral questions to assess fit, teamwork, problem-solving approach, and past experiences.

Q6
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).

Discussion (0)

Share your thoughts and ask questions

Join the Discussion

Sign in with Google to share your thoughts and ask questions

No comments yet

Be the first to share your thoughts and start the discussion!