Yes Bank Data Engineer Interview Questions and Answers

Q1. I was asked to write code and some scenario based question on Big Data etc
Add your answer

2nd with VP which is easy but he seems not okay with my ECTC

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

Spark Sql and Spark Scripting

Data Modelling for retail brand like dmart

ETL Pipeline which handles streaming data as well

Easy on cyber security

Q1. Introduce yourself this is
Add your answer
Q2. What is your work experience
Add your answer

Q1. Java Stream coding questions
Add your answer
Q2. Java Collections
Add your answer
Q3. Spring Boot Annotations
Add your answer
Q4. Sql Queries highest 3 salary employee name
Ans. 
Use SQL query to retrieve the names of the top 3 employees with the highest salary.
• Use the ORDER BY clause to sort the salaries in descending order.

• Use the LIMIT clause to limit the results to the top 3.

• Join the employee table with the salary table to retrieve employee names.
Answered by AI
Add your answer

Q1. Hardware issues
Add your answer
Q2. Networking issues
Add your answer

Q1. Self introduction
Add your answer
Q2. How do expect for your salary
Ans. 
I am looking for a competitive salary that reflects my experience and skills in the industry.
• Research industry standards for System Engineers in the specific location

• Consider years of experience and level of expertise

• Factor in benefits and perks offered by the company

• Be prepared to negotiate based on the overall compensation package
Answered by AI
Add your answer

It consists of resume-based skill questions.

Q1. Why do you want to join ICICI Bank?
Ans. 
I want to join ICICI Bank because of its strong reputation in the banking industry and the opportunities for growth and development it offers.
• ICICI Bank is one of the leading banks in India with a strong reputation for innovation and customer service

• I am impressed by ICICI Bank's focus on technology and digital banking solutions

• I believe that working at ICICI Bank will provide me with opportunities for career growth an...read more
Answered by AI
Add your answer
Q2. Can you tell me about your projects?
Ans. 
I have worked on projects involving data analysis for marketing campaigns, customer segmentation, and sales forecasting.
• Developed predictive models to optimize marketing strategies

• Utilized clustering techniques for customer segmentation

• Built time series models for sales forecasting
Answered by AI
Add your answer