NatWest Group Data Engineer Interview Questions and Answers

It was quantitative aptitude test with some coding questions

Q1. This round was to majorly check our confidence and communication style. I was asked to explain the projects that I have done..then some general analytical based questions that were non technical.
Add your answer
Q2. Why didn't you want to pursue higher studies?
Add your answer
Q3. Tell me about urself and the projects you have done
Add your answer

Spark Sql and Spark Scripting

Data Modelling for retail brand like dmart

ETL Pipeline which handles streaming data as well

Q1. How to find out prime number
Ans. 
Prime numbers are numbers that are only divisible by 1 and themselves.
• Start by checking if the number is less than 2, as prime numbers start from 2.

• Iterate from 2 to the square root of the number and check if the number is divisible by any of these numbers.

• If the number is not divisible by any number in the range, then it is a prime number.
Answered by AI
Add your answer

Q1. What is an index and what does it do
Ans. 
An index is a data structure that improves the speed of data retrieval operations in a database by allowing quick access to specific data.
• Indexes are used to quickly locate data without having to search every row in a database table.

• They are created on specific columns in a table to speed up queries that filter or sort by those columns.

• Examples of indexes include primary keys, unique keys, and non-unique indexes.
Answered by AI
Add your answer

Q1. Tell me a time you resolve conflict
Add your answer

Behavioural and culture fit

Q1. Questions on pyspark coding, windowing function and all
Add your answer
Q2. Questions on hive and yarn
Add your answer