Yes Bank Data Engineer Interview Questions and Answers

Q1. Base on SQL and tableau
Add your answer
Q2. How join work share in detail with examples
Add your answer
Q3. How to get nth salary
Add your answer
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
Add your answer

Q1. Live coding on the platform
Add your answer

Q1. Coding round java
Add your answer
Q2. Spring boot and devops activities
Add your answer

Basic maths questions

Basic topics movies vs series

Q1. Sql Queries were asked
Add your answer
Q2. Was based on resume
Add your answer

Q1. Based on resume the questions were
Add your answer
Q2. Questions about family
Add your answer

HackerEarth / Hacker rank Test

Q1. Find the lowest cost when given days you want to use metro if you have cost of a day 1 ,7 and 30 day pass. DP Problem
Ans. 
Using dynamic programming to find the lowest cost for metro passes based on given days.
• Create an array to store the minimum cost for each day.

• Iterate through each day and calculate the minimum cost based on 1, 7, or 30 day pass.

• Update the minimum cost for each day using dynamic programming.

• Return the minimum cost for the total number of days needed.
Answered by AI
Add your answer

Q1. Normal HR Questions
Add your answer

SQL server

SQL DBA

Q1. Salary discussed, Appts test
Add your answer

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

The first round which is online assessment for eliminating candidates was conducted consist of medium level aptitude questions there were 3 sub sec have duration of 20 15 15 minutes and questions 15 10 10 respectively and you cannot move to further section there is time constraints for each then followed by 15 minutes psychometric section having 50 questions that's all for screening round the total duration was 65 min.
Total 24 candidates were selected from this round out of 200 plus