British Petroleum Senior Data Engineer Interview Questions and Answers

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...read more
Add your answer
Q2. GC Calibration, sensors and transmitters, system related questions.
Add your answer
Q3. Rig site and structure
Add your answer
Q4. Overall skill whatever you have experience
Add your answer

Q1. Yourself and documentation
Add your answer

Asked basic C++ Qs, tree and linked list Qs

Q1. Manager related Qs
Add your answer
Q2. Future plans, how to maintain team , how do you work with others in the team etc
Add your answer

Just easy or medium level leetcode questions

The topic was how AI is affecting softare developer

Q1. What is oops, explain them?
Ans. 
Object-oriented programming (OOP) is a programming paradigm that uses objects to represent and manipulate data.
• OOP is based on the concept of classes and objects.

• It allows for encapsulation, inheritance, and polymorphism.

• Encapsulation hides the internal details of an object and provides a public interface.

• Inheritance allows classes to inherit properties and methods from other classes.

• Polymorphism allows objects of diff...read more
Answered by AI
View 1 more answer
Q2. What is difference between interface and abstract class?
Ans. 
Interface defines only method signatures while abstract class can have method implementations.
• An interface can be implemented by multiple classes while a class can extend only one abstract class.

• An abstract class can have instance variables while an interface cannot.

• An abstract class can have constructors while an interface cannot.

• An abstract class can provide default implementations for some methods while an interface...read more
Answered by AI
View 1 more answer
Q3. What is difference between docker and kubernet?
Ans. 
Docker is a containerization platform while Kubernetes is a container orchestration tool.
• Docker is used to create, deploy, and run applications in containers.

• Kubernetes is used to manage and orchestrate multiple containers in a cluster.

• Docker provides a way to package and distribute applications in a portable manner.

• Kubernetes provides features like automatic scaling, load balancing, and self-healing.

• Docker is a lower-...read more
Answered by AI
Add your answer
Q4. What is event emitter in angular?
Ans. 
Event emitter is a class in Angular that allows communication between components.
• Event emitter is used to emit custom events in Angular.

• It allows communication between parent and child components.

• It can be used to pass data from child to parent component.

• It is a part of the @angular/core package.

• Example: @Output() eventEmitter = new EventEmitter();
Answered by AI
Add your answer
Q5. What is view encapsulation in angular?
Ans. 
View encapsulation is a feature in Angular that allows for the creation of isolated components.
• View encapsulation ensures that styles defined in a component do not affect other components.

• There are three types of view encapsulation: Emulated, Native, and None.

• Emulated is the default and uses CSS to emulate shadow DOM.

• Native uses the browser's native shadow DOM implementation.

• None does not provide any view encapsulation
Answered by AI
Add your answer
Q6. How to communicate with components in angular?
Ans. 
Components in Angular can communicate with each other using @Input, @Output, and services.
• Use @Input to pass data from parent to child component

• Use @Output to emit events from child to parent component

• Use services to share data between components that are not directly related

• Use RxJS subjects to create a shared data stream between components
Answered by AI
View 1 more answer

Q1. SQL table distributions.
Add your answer
Q2. ADF switching questions?
Add your answer
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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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
Answered by AI
Add your answer
Q6. Modelling questions.
Add your answer

Q1. EKS Cluster and its related configuration
Ans. 
EKS is a managed Kubernetes service by AWS. It simplifies the deployment, scaling, and management of containerized applications.
• EKS stands for Elastic Kubernetes Service

• It is a fully managed service by AWS

• It simplifies the deployment, scaling, and management of containerized applications

• EKS uses Kubernetes as its container orchestration system

• EKS supports both Linux and Windows containers

• EKS can be configured using the...read more
Answered by AI
Add your answer
Q2. AWS Services such as VPC, ALB,EC2
Add your answer
Q3. Git squash , commit , rebase, pulling strategy
Add your answer
Q4. Git ops,Argo CD, Git hub actions
Add your answer