Upload Button Icon Add office photos

Filter interviews by

Clear (1)

NatWest Group Data Engineer Interview Questions and Answers

Updated 27 May 2024

NatWest Group Data Engineer Interview Experiences

3 interviews found

Data Engineer Interview Questions & Answers

user image Abhijith K M

posted on 27 May 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - CPC 

(4 Questions)

  • Q1. What motivates to you for this job ?
  • Q2. What are the risks you have taken in previous role?
  • Q3. How do you handle the situation when your opinion differ from your senior members in your team?
  • Q4. Provide a approach to develop ETL pipeline where csv file is dropped in S3 and transform through airflow and load to snowflake.
  • Ans. 

    Develop ETL pipeline using Airflow to process CSV files in S3 and load data into Snowflake.

    • Set up an S3 sensor in Airflow to detect when a new CSV file is dropped in the specified bucket.

    • Create a custom Python operator in Airflow to read the CSV file from S3, perform necessary transformations, and load data into Snowflake.

    • Use SnowflakeHook in Airflow to establish connection with Snowflake and execute SQL queries to loa...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare all the cpc questions and provide answers with example and previous organization experience. Provide step by step answer to technical questions especially if they ask to design a pipeline.

Skills evaluated in this interview

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 16 Jan 2023

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Jul 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Questions on Data Modelling
  • Q2. Questions on SQL and Data Warehousing
Round 3 - Technical 

(2 Questions)

  • Q1. SQL query writing involving complex queries
  • Q2. Questions on Snowflake and other distributed systems

Interview Preparation Tips

Topics to prepare for NatWest Group Data Engineer interview:
  • SQL
  • Snowflake
  • Python
  • Data modell
Interview preparation tips for other job seekers - Practice complex SQL and other data Engineering modules.

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 19 Jan 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
6-8 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Jan 2023. There were 3 interview rounds.

Round 1 - Telephonic Call 

(1 Question)

  • Q1. Tell me about your current work status, past internships and projects
Round 2 - Technical 

(1 Question)

  • Q1. Difference between sql joins, few sql queries
  • Ans. 

    SQL joins are used to combine rows from different tables based on a related column, while SQL queries are used to retrieve specific data from a database.

    • SQL joins are used to combine rows from different tables based on a related column

    • There are different types of SQL joins, such as inner join, left join, right join, and full outer join

    • SQL queries are used to retrieve specific data from a database based on certain condi...

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. Behavioural questions

Skills evaluated in this interview

Interview questions from similar companies

Interview Preparation Tips

Round: Test
Experience: The written test was quite similar to the typical CAT pattern. It contained sections on Reading Comprehension, Data Interpretation and Mathematics.

Round: Technical + HR Interview
Experience: There were 2 interviewers in the first interview, one was a technical guy and the other was from HR. They asked me a few very simple puzzles, a few basic programming questions (swapping the value of two variables etc.), questions related to the development cycle of software products. The HR guy asked stuff like what do you want to achieve in life? Strengths, weaknesses etc.

Round: Case Study Interview
Experience: The third interview was the most important one (and I guess that was the deciding interview). The interviewer started with questions like why finance? Which companies are you sitting for? Then he gave me a case study:

Interview Questionnaire 

2 Questions

  • Q1. Oops, os, dbms, project
  • Q2. Why hsbc, why should I hire you.
  • Ans. 

    I have a strong background in software engineering and a passion for innovation, making me a valuable asset to HSBC.

    • I have a proven track record of successfully delivering high-quality software solutions in previous roles.

    • I am highly skilled in various programming languages and technologies, including Java, Python, and SQL.

    • I have experience working in agile development environments, allowing me to adapt quickly to chan...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 4 sections, 15 questions each. Sections on apti, english, programming, technical.
Tips: Time management, complete english and technical first
Duration: 1 hour
Total Questions: 60

Round: Group Discussion
Experience: We were asked which super hero would you like to be. Shared the information. Always present the positives and negatives and emphasize that despite of being negatives
Tips: Think everything through before speaking
Duration: 40 minutes

Round: Technical Interview
Experience: Prepare well, anything can be asked on the things written on your resume

Round: HR Interview
Experience: Sell yourself. Tell them why you would be the best candidate.
Tips: Tell your advantages of being a fresher that you would be comfortable in any technology

College Name: Acropolis institute of technology and research

I applied via Naukri.com and was interviewed in Jun 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Sql basics, power bi , tablue, ssis

Interview Preparation Tips

Interview preparation tips for other job seekers - You have to be confident.

I applied via Campus Placement and was interviewed before Jan 2021. There were 4 interview rounds.

Round 1 - Group Discussion 

Generic topics that were trending at the time

Round 2 - One-on-one 

(1 Question)

  • Q1. Puzzle round - aptitude
Round 3 - One-on-one 

(1 Question)

  • Q1. Technical Round - coding related questions
Round 4 - Group Discussion 
Pro Tip by AmbitionBox:
Be a good listener. GDs are not just about speaking. Your listening skills will give you a lot of points to counter and speak when your turn comes.
View all GD tips

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and ensure you're clear with job requirements to clear rounds

I applied via LinkedIn and was interviewed in Feb 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. - Data Structures and Algo - Core Python specific questions
  • Q2. - Design a Cache and some design based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - I actually attended a Weekend drive. So in the 1st round almost related to 2/3 DS Algo questions.
2nd round was related to design small cache and little bit on python questions.
3rd round was managerial and some basic technical questions.

I applied via LinkedIn and was interviewed before Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. All microsoft technologies related

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing

I applied via Recruitment Consultant and was interviewed in Dec 2020. There was 1 interview round.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be 100% technical in java here they will not be any support u need to dig deep lot of complex modules which we cannot understand in depth
Contribute & help others!
anonymous
You can choose to be anonymous

NatWest Group Interview FAQs

How many rounds are there in NatWest Group Data Engineer interview?
NatWest Group interview process usually has 2-3 rounds. The most common rounds in the NatWest Group interview process are Technical, Resume Shortlist and Telephonic Call.
How to prepare for NatWest Group Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at NatWest Group. The most common topics and skills that interviewers at NatWest Group expect are SQL, Python, Data Architecture, Analytics and Data Quality.
What are the top questions asked in NatWest Group Data Engineer interview?

Some of the top questions asked at the NatWest Group Data Engineer interview -

  1. Provide a approach to develop ETL pipeline where csv file is dropped in S3 and ...read more
  2. Difference between sql joins, few sql quer...read more
  3. Questions on Snowflake and other distributed syst...read more

Recently Viewed

JOBS

Browse jobs

Discover jobs you love

COMPANY BENEFITS

KNR Constructions

20 benefits

COMPANY BENEFITS

IRB Infrastructure

60 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

LIST OF COMPANIES

Discover companies

Find best workplace

DESIGNATION

SALARIES

Synergy Marine Group

SALARIES

Siemens Healthineers

SALARIES

Synergy Marine Group

Tell us how to improve this page.

NatWest Group Data Engineer Interview Process

based on 3 interviews

Interview experience

3.3
  
Average
View more
NatWest Group Data Engineer Salary
based on 155 salaries
₹10 L/yr - ₹34.8 L/yr
93% more than the average Data Engineer Salary in India
View more details

NatWest Group Data Engineer Reviews and Ratings

based on 8 reviews

4.6/5

Rating in categories

4.6

Skill development

4.9

Work-life balance

3.5

Salary

4.5

Job security

4.7

Company culture

3.6

Promotions

4.6

Work satisfaction

Explore 8 Reviews and Ratings
Senior Analyst
2.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
893 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Operations Analyst
761 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Vice President
716 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
644 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare NatWest Group with

HSBC Group

3.9
Compare

Standard Chartered Plc

3.0
Compare

Barclays PLC

3.9
Compare

JPMorgan Chase & Co.

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview