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)
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.
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().
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 '.'
Standard behavioral questions to assess fit, teamwork, problem-solving approach, and past experiences.
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).