RWS Group Data Engineer Interview Questions and Answers

Q1. How to Ensure Data loss in ETL pipeline
Add your answer
Q2. Why to spin up Dataproc cluster when there is serverless batch job exists.
Add your answer

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. 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

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