AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Schlumberger Data Engineer Interview Questions and Answers
Schlumberger Data Engineer Interview Experiences
3 interviews found
Anonymous
Selected
I was interviewed in May 2024.
(6 Questions)
- Q1. SQL table distributions.
- Q2. ADF switching questions?
- 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...
- 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...
- 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
- Q6. Modelling questions.
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Apr 2023. There were 5 interview rounds.
Reverse a binary tree and few other technical questions
(1 Question)
- Q1. Data structure and Oops concepts were asked
(1 Question)
- Q1. Technical round on projects that we have worked on and questions around that
(1 Question)
- Q1. General HR questions
(1 Question)
- Q1. More of like a general conversation with the center manager
Selected
I applied via Company Website and was interviewed before Oct 2022. There were 5 interview rounds.
(1 Question)
- Q1. Question as per my skill set from SQL, Unix, Power Center Mappings.
(1 Question)
- Q1. In detail questions on skill sets and writing logic and flow diagram for one of the problem statement
(1 Question)
- Q1. General discussion on expectations and the requirments
(1 Question)
- Q1. Don't remember the exact questions
Top trending discussions
Interview questions from similar companies
(1 Question)
- Q1. What is the purpose of using Common Table Expressions (CTE) in SQL?
(1 Question)
- Q1. What is HTML vs XHTML
- Ans.
HTML is a markup language for creating web pages, while XHTML is a stricter version of HTML that follows XML rules.
HTML is more forgiving and allows for sloppy coding, while XHTML requires well-formed and valid code.
XHTML requires all tags to be closed properly, unlike HTML which allows for self-closing tags.
XHTML is case-sensitive, while HTML is not.
XHTML documents must be well-formed XML documents, while HTML documen
Skills evaluated in this interview
Riya Gupta
(1 Question)
- Q1. LRU Cache Implementation
Megha Parmar
Selected
I applied via Approached by Company and was interviewed before Jun 2023. There was 1 interview round.
(2 Questions)
- Q1. Technical challenge faced
- Q2. What are your strengths
Selected
I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 3 interview rounds.
2 question :
1. Find the longest common subsequence in 2 strings
2. find the 5th highest revenue from the table in last 28 days in a particular region
I was given a list of book, genre of books and books and rating of books . All list was of equal length n.
There were 2 methods which need to be implemented
1. get highest rating of book by genre . if rating are same then in lexographical order
2. update book rating by book name
(2 Questions)
- Q1. These questions were basic
- Q2. There were lots of imaginative situation given and then I was asked to say what I would do in those situation
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed before Dec 2021. There were 2 interview rounds.
(3 Questions)
- Q1. Tell Me About urself
- Q2. SAP overview in PM, RCM, P16
- Ans.
SAP is an enterprise resource planning software used for PM, RCM, and P16.
SAP is a software used for managing business operations and customer relations.
PM (Plant Maintenance) module in SAP helps in managing maintenance activities like planning, scheduling, and execution.
RCM (Reliability Centered Maintenance) module in SAP helps in identifying and prioritizing maintenance tasks based on criticality.
P16 (Project System)...
- Q3. Technical skills and maintainance of rotary equipments, if u r planning dept then its an upperhand for u.
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed in Mar 2023. There were 3 interview rounds.
First round was online assessment test with programming and aptitude games
(2 Questions)
- Q1. Group Anagram question
- Q2. SQL question to get name of employee whose salary is greater than average salary of the department
- Ans.
SQL query to retrieve name of employee with salary greater than department average.
Calculate average salary of department using GROUP BY clause
Join employee and department tables using department ID
Filter employees with salary greater than department average
Select employee name
Interview Preparation Tips
- Spark
- Cloud
- Programming
- SQL
Skills evaluated in this interview
Schlumberger Interview FAQs
Tell us how to improve this page.
Schlumberger Interviews By Designations
- Schlumberger Field Engineer Interview Questions
- Schlumberger Junior Field Engineer Interview Questions
- Schlumberger Software Engineer Interview Questions
- Schlumberger Business Analyst Interview Questions
- Schlumberger Design Engineer Interview Questions
- Schlumberger Intern Interview Questions
- Schlumberger Data Analyst Interview Questions
- Schlumberger Data Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Schlumberger Data Engineer Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Schlumberger Data Engineer Reviews and Ratings
based on 6 reviews
Rating in categories
|
Business Process Analyst
205
salaries
|  ₹8 L/yr - ₹32.4 L/yr |
|
Business Analyst
109
salaries
| ₹7.7 L/yr - ₹26 L/yr |
|
Mechanical Engineer
94
salaries
| ₹6.2 L/yr - ₹21 L/yr |
|
Test Analyst
66
salaries
| ₹9.5 L/yr - ₹20 L/yr |
|
Software Engineer
60
salaries
| ₹8.1 L/yr - ₹30 L/yr |
Halliburton
Baker Hughes
Weatherford
TechnipFMC
- Home >
- Interviews >
- Schlumberger Interview Questions >
- Schlumberger Data Engineer Interview Questions
