Barclays Shared Services Data Engineer Interview Questions and Answers

Q1. Python Coding Question 1: Make a list with all datatypes objects in it.
Ans. 
Create a list containing all Python data types.
• Use the following data types: int, float, complex, str, list, tuple, dict, set, bool, bytes, bytearray, memoryview, None

• Example: ['int', 'float', 'complex', 'str', 'list', 'tuple', 'dict', 'set', 'bool', 'bytes', 'bytearray', 'memoryview', 'None']
Answered by AI
Add your answer
Q2. Python Coding Question 2: Extract a character from the string present in the list.
Ans. 
Extract a character from a string in a list of strings.
• Iterate through the list of strings

• Use indexing to extract the desired character from each string

• Handle cases where the index is out of range

• Return the extracted characters as a new list
Answered by AI
Add your answer
Q3. Python Coding Question 3: Make a dictionary with Name and Age having 4 records.
Ans. 
Create a dictionary with Name and Age for 4 records in Python.
• Use curly braces {} to create a dictionary.

• Separate key-value pairs with a colon :

• Separate each record with a comma ,
Answered by AI
Add your answer
Q4. Python Coding Question 4: Make a string and write code to return the output with the reverse string.
Add your answer
Q5. Python Coding Question 5: Write a function to check if the string is Palindrome. Check the function with a Palindrome.
Ans. 
Function to check if a string is a palindrome.
• Create a function that takes a string as input.

• Reverse the string and compare it with the original string.

• Return true if they are the same, false otherwise.

• Example: 'racecar' is a palindrome.
Answered by AI
Add your answer
Q6. SQL Coding Question 1: Write an SQL query to extract the data from employees table, extract day of joining, month of joining, year of joining from the "Date Of Joining".
Add your answer
Q7. What is Data normalization and standardization?
Ans. 
Data normalization is the process of organizing data in a database efficiently, while data standardization is the process of ensuring consistency and uniformity in data.
• Data normalization involves organizing data into tables and columns to reduce redundancy and improve data integrity.

• Data standardization involves ensuring that data is consistent and uniform across the database.

• Normalization helps in reducing data redun...read more
Answered by AI
Add your answer
Q8. Statistics/Probability Question: 4 ball of each colors(Red, Green, Blue) are present in the box. After drawing 3 ball randomly from the box, what is the probability of getting all 3 ball having the same co...read more
Ans. 
The probability of drawing 3 balls of the same color from a box containing 4 balls of each color (Red, Green, Blue).
• Calculate the total number of ways to draw 3 balls out of 12 balls

• Calculate the number of ways to draw 3 balls of the same color

• Divide the number of favorable outcomes by the total number of outcomes to get the probability
Answered by AI
Add your answer

Q1. What is spark and its architecture
Ans. 
Apache Spark is a fast and general-purpose cluster computing system.
• Apache Spark is an open-source distributed computing system that provides an interface for programming entire clusters with implicit data parallelism and fault tolerance.

• It has a unified architecture that combines SQL, streaming, machine learning, and graph processing capabilities.

• Spark architecture consists of a driver program that coordinates the exe...read more
Answered by AI
Add your answer
Q2. Small question on ADF
Add your answer

Q1. Scenerio based question on Databricks
Add your answer
Q2. Scenerio based on ADF
Add your answer

Q1. Python SQL question
Add your answer

Q1. More on Project side
Add your answer

Q1. Salary Discussion
Add your answer

Q1. Data engineer roles and resposibilities
Add your answer

Q1. What Volume of data have you handled in your POCs ?
Ans. 
I have handled terabytes of data in my POCs, including data from various sources and formats.
• Handled terabytes of data in POCs

• Worked with data from various sources and formats

• Used tools like Hadoop, Spark, and SQL for data processing
Answered by AI
View 1 more answer
Q2. When will you decide to use repartition and coalesce?
Ans. 
Repartition is used for increasing partitions for parallelism, while coalesce is used for decreasing partitions to reduce shuffling.
• Repartition is used when there is a need for more partitions to increase parallelism.

• Coalesce is used when there are too many partitions and need to reduce them to avoid shuffling.

• Example: Repartition can be used before a join operation to evenly distribute data across partitions for bette...read more
Answered by AI
Add your answer
Q3. How will you design/configure a cluster if you have given 10 petabytes of data.
Ans. 
Designing/configuring a cluster for 10 petabytes of data involves considerations for storage capacity, processing power, network bandwidth, and fault tolerance.
• Consider using a distributed file system like HDFS or object storage like Amazon S3 to store and manage the large volume of data.

• Implement a scalable processing framework like Apache Spark or Hadoop to efficiently process and analyze the data in parallel.

• Utilize...read more
Answered by AI
Add your answer

Its mandatory test even for experience people

Q1. Related to technology
Add your answer

Q1. Very good discussion towards work culture, salary and all
Add your answer

Q1. Sql questions were
Add your answer
Q2. Spark related aswell
Add your answer

Basic coding test like prime

Q1. Your Strengths and weakness
Add your answer
Q2. Why Zensar why not other
Add your answer