Upload Button Icon Add office photos

Yes Bank

Compare button icon Compare button icon Compare

Filter interviews by

Yes Bank Data Engineer Interview Questions and Answers

Updated 13 Apr 2024

Yes Bank Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 13 Apr 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • 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
Round 2 - Behavioral interview 

(1 Question)

  • Q1. Tell me a time you resolve conflict

Interview questions from similar companies

I applied via Referral and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Coding Test 

SQL server

Round 2 - Coding Test 

SQL DBA

Round 3 - HR 

(1 Question)

  • Q1. Salary discussed, Appts test

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best... be prepared question

Interview Questionnaire 

1 Question

  • Q1. Explain about self introduction

I applied via Walk-in and was interviewed in Apr 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. About your self

Interview Preparation Tips

Interview preparation tips for other job seekers - please select my profile
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Questions mainly involved window function, recursion, some puzzels
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is data analyst
  • Ans. 

    A data analyst is a professional who collects, processes, and analyzes data to provide insights and support decision-making.

    • Collects data from various sources

    • Cleans and processes data to ensure accuracy

    • Analyzes data using statistical methods and tools

    • Interprets data to identify trends and patterns

    • Presents findings and recommendations to stakeholders

  • Answered by AI
  • Q2. Asked question regarding project mention

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
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 tips
Round 2 - Technical 

(4 Questions)

  • Q1. Base on SQL and tableau
  • Q2. How join work share in detail with examples
  • Q3. How to get nth salary
  • Q4. How to delete duplicates
  • Ans. 

    To delete duplicates, use SQL query with DISTINCT keyword or remove duplicates programmatically in Python using sets.

    • Use SQL query with DISTINCT keyword to remove duplicates from a database table

    • In Python, remove duplicates from a list using sets: list(set(original_list))

    • For pandas DataFrame, drop duplicates using df.drop_duplicates()

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

(1 Question)

  • Q1. Live coding on the platform

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Jan 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Spark Sql and Spark Scripting

Round 2 - Case Study 

Data Modelling for retail brand like dmart

Round 3 - Case Study 

ETL Pipeline which handles streaming data as well

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in Nov 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Airflow SQL Python DWH
Round 2 - Technical 

(1 Question)

  • Q1. Airflow Pyspark SQL AWS
Round 3 - HR 

(1 Question)

  • Q1. Relocation , tech stack
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement

Round 1 - Aptitude Test 

Basic apt questions. Can easily practice online

Round 2 - HR 

(2 Questions)

  • Q1. Few hypothetical questions to check your analysis knowledge
  • Q2. How much flowers were to be accumulated at the end of the day if each person offered 5 flowers a day at the temple.
  • Ans. 

    The total number of flowers accumulated at the end of the day can be calculated by multiplying the number of people by the number of flowers each person offers.

    • Multiply the number of people by 5 to get the total number of flowers accumulated

    • For example, if there are 10 people, the total number of flowers accumulated would be 10 * 5 = 50

  • Answered by AI

Yes Bank Interview FAQs

How many rounds are there in Yes Bank Data Engineer interview?
Yes Bank interview process usually has 2 rounds. The most common rounds in the Yes Bank interview process are Technical.
How to prepare for Yes Bank 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 Yes Bank. The most common topics and skills that interviewers at Yes Bank expect are Data Modeling, Hadoop, ATM, Data Warehousing and ESB.

Tell us how to improve this page.

Yes Bank Data Engineer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Assistant Manager
3.4k salaries
unlock blur

₹2 L/yr - ₹6.7 L/yr

Deputy Manager
3.3k salaries
unlock blur

₹2.2 L/yr - ₹9 L/yr

Manager
2.5k salaries
unlock blur

₹4.3 L/yr - ₹13.1 L/yr

Senior Manager
2.3k salaries
unlock blur

₹5.9 L/yr - ₹21.6 L/yr

Assistant Vice President
1.8k salaries
unlock blur

₹8 L/yr - ₹28.6 L/yr

Explore more salaries
Compare Yes Bank with

HDFC Bank

3.9
Compare

ICICI Bank

4.0
Compare

Axis Bank

3.8
Compare

Kotak Mahindra Bank

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