british petroleum logo
British Petroleum· Data Engineer

BP Data Engineer Interview Experience | Pune | 2025

Location
Pune
Posted
23 May 2025
388 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.

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)

  1. 01

    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.

    Open the problem
  2. 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().

  3. 03

    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.

    Open the problem
  4. 04

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

    Open the problem
  5. 05

    Behavioral Questions

    Behavioral

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

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

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at British Petroleum recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

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