AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
NatWest Group Data Engineer Interview Questions and Answers
NatWest Group Data Engineer Interview Experiences
3 interviews found
Abhijith K M
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
(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...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in Jul 2022. There were 3 interview rounds.
(2 Questions)
- Q1. Questions on Data Modelling
- Q2. Questions on SQL and Data Warehousing
(2 Questions)
- Q1. SQL query writing involving complex queries
- Q2. Questions on Snowflake and other distributed systems
Interview Preparation Tips
- SQL
- Snowflake
- Python
- Data modell
Selected
I applied via LinkedIn and was interviewed before Jan 2023. There were 3 interview rounds.
(1 Question)
- Q1. Tell me about your current work status, past internships and projects
(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...
(1 Question)
- Q1. Behavioural questions
Skills evaluated in this interview
What people are saying about NatWest Group
Interview questions from similar companies
Selected
I applied via Referral
Pyspark, Hive, Yarn, Python
(2 Questions)
- Q1. Questions on windowing function
- Q2. Questions on spark arch and python
Interview Preparation Tips
- pyspark
- hive
- python
- yarn
- sql
H M
I was interviewed in Dec 2024.
(1 Question)
- Q1. I was asked to write code and some scenario based question on Big Data etc
2nd with VP which is easy but he seems not okay with my ECTC
Interview Preparation Tips
1). Prepare well on Pyspark, Lakehouse Arch
2).Basic Sql & bit case studies
(2 Questions)
- Q1. Tell me about you experience as a data engineer
- Q2. In depth technical discussion about projects
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
(1 Question)
- Q1. Load 60 GB of csv file and perform transformation.
- Ans.
Use distributed computing framework like Apache Spark to efficiently load and transform the large CSV file.
Use Apache Spark to distribute the workload across multiple nodes for faster processing.
Utilize Spark's DataFrame API to read the CSV file and apply transformations.
Consider partitioning the data to optimize performance.
Use Spark SQL for complex transformations and aggregations.
Leverage in-memory processing capabi
Discussion of jd, technical questions on spark
(2 Questions)
- Q1. Spark framework
- Q2. Spark dataframes
(2 Questions)
- Q1. Current ctc getting
- Ans.
I am currently earning $80,000 per year.
My current annual salary is $80,000.
I am earning $6,666.67 per month.
I receive a monthly salary of $6,666.67.
- Q2. Expected CTC that is needed
- Ans.
Expected CTC should be based on industry standards, experience, skills, and location.
Research industry standards for Data Engineers in your location
Consider your level of experience and skills
Factor in the cost of living in the area where the job is located
Negotiate based on the value you bring to the company
I applied via LinkedIn and was interviewed in Jan 2024. There were 3 interview rounds.
Spark Sql and Spark Scripting
Data Modelling for retail brand like dmart
ETL Pipeline which handles streaming data as well
Selected
I applied via Referral and was interviewed before Jun 2022. There were 3 interview rounds.
(1 Question)
- Q1. More related towards Hadoop, Spark, scenario based competency questions
(1 Question)
- Q1. Code performance, optimization, batch processing
NatWest Group Interview FAQs
Tell us how to improve this page.
NatWest Group Interviews By Designations
- NatWest Group Software Engineer Interview Questions
- NatWest Group Customer Service & Operations Analyst Interview Questions
- NatWest Group Operations Analyst Interview Questions
- NatWest Group Senior Analyst Interview Questions
- NatWest Group Analyst Interview Questions
- NatWest Group Business Analyst Interview Questions
- NatWest Group Automation Test Engineer Interview Questions
- NatWest Group Senior Software Engineer Interview Questions
- Show more
NatWest Group Data Engineer Interview Process
based on 3 interviews
Interview experience
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
NatWest Group Data Engineer Reviews and Ratings
based on 8 reviews
Rating in categories
|
Senior Analyst
2.7k
salaries
|  ₹3.5 L/yr - ₹13 L/yr |
|
Software Engineer
870
salaries
| ₹7.7 L/yr - ₹28 L/yr |
|
Operations Analyst
772
salaries
| ₹2 L/yr - ₹6 L/yr |
|
Associate Vice President
700
salaries
| ₹12 L/yr - ₹43.5 L/yr |
|
Analyst
672
salaries
| ₹1.4 L/yr - ₹8.5 L/yr |
HSBC Group
Standard Chartered Plc
Barclays PLC
JPMorgan Chase & Co.
- Home >
- Interviews >
- NatWest Group Interview Questions >
- NatWest Group Data Engineer Interview Questions
