In this article, we will see the list of questions asked in Capgemini Company Interview for Data Engineers.
Let’s see the Questions:
1) Describe a recent project you’ve worked on.
2) Which linked service and dataset did you use to connect the gold layer with a SQL Database?
3) What is an index in a database?
4) How do clustered and non-clustered indexes differ?
5) What is the difference between a Delta Table and a Delta Live Table?
6) Explain the ACID properties of a database.
7) What type of index have you used in a fact table?
8) Design a common login mechanism for all ETL processes.
9) Develop an injection process for loading data into a fact table.
10) How to create a temporary ADF pipeline for loading data into an on-premises environment.
11) Given the following SQL table employee_tbl:
Id Name Salary ManagerId
1 Alice 50000 NULL
2 Bob 60000 1
3 Carol 55000 1
4 Dave 70000 2
5 Eve 45000 2
Output:Id Name Salary
2 Bob 60000
3 Carol 55000
4 Dave 70000
- a) Retrieve the manager IDs that are not null.
- b) Write a query to fetch records with the second highest salary, including the second highest salary in the result set.
I hope these questions assist anyone preparing for their interviews.
Check out the given link for knowing about this company: Capgemini – Get The Future You Want
Check out the given link for knowing about this company rating on Glassdoor: Capgemini | Glassdoor
Check out the given link for this company profile on LinkedIn: Capgemini| LinkedIn
Thank you for reading this post.