Upload Button Icon Add office photos

Karur Vysya Bank

Compare button icon Compare button icon Compare

Filter interviews by

Karur Vysya Bank Data Engineer Interview Questions and Answers

Updated 12 Jun 2024

Karur Vysya Bank Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 12 Jun 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. Normalisation in sql
  • Ans. 

    Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Normalization involves breaking down a table into smaller tables and defining relationships between them.

    • It helps in reducing data redundancy and inconsistencies.

    • There are different normal forms like 1NF, 2NF, 3NF, BCNF, etc.

    • Example: If we have a table with customer details and orders, we can normalize i...

  • Answered by AI
  • Q2. Stored procedure uses
  • Ans. 

    Stored procedures are precompiled SQL statements stored in a database for reuse.

    • Stored procedures help improve performance by reducing network traffic.

    • They can be used to encapsulate business logic in the database.

    • Stored procedures can be parameterized for flexibility.

    • They provide a layer of security by controlling access to data.

    • Examples: sp_GetCustomerById, sp_UpdateEmployeeSalary

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

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

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 experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Assignment 

Easy on cyber security

Round 2 - One-on-one 

(2 Questions)

  • Q1. Introduce yourself this is
  • Q2. What is your work experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident
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 experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Behavioural and culture fit

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
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

Basic maths questions

Round 2 - Group Discussion 

Basic topics movies vs series

Round 3 - Technical 

(2 Questions)

  • Q1. Sql Queries were asked
  • Q2. Was based on resume
Round 4 - HR 

(2 Questions)

  • Q1. Based on resume the questions were
  • Q2. Questions about family

I applied via Recruitment Consulltant and was interviewed before Nov 2021. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What are the windows functions in sql
  • Ans. 

    Window functions in SQL are used to perform calculations across a set of rows that are related to the current row.

    • Window functions are used to calculate running totals, moving averages, and rank values.

    • They are applied to a set of rows defined by an OVER clause.

    • Examples of window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.

  • Answered by AI
  • Q2. Explain CTE in detail
  • Ans. 

    CTE stands for Common Table Expression, a temporary named result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.

    • CTE is defined using the WITH keyword followed by a name and a SELECT statement.

    • It can be used to simplify complex queries, improve readability, and reduce code duplication.

    • CTE can also be recursive, allowing for hierarchical queries.

    • Example: WITH sales AS (SELECT * FROM order...

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. What is your expected salary

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice SQL in detail. Practice scenario based SQL questions. Read all the data warehousing concepts in detail.

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I appeared for an interview in Dec 2024.

Round 1 - Technical 

(1 Question)

  • Q1. I was asked to write code and some scenario based question on Big Data etc
Round 2 - Case Study 

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

Interview Preparation Tips

Interview preparation tips for other job seekers - HDFC dont offer good ctc and what i understood from them till now they are more using legacy system and relied on lot of vendors

1). Prepare well on Pyspark, Lakehouse Arch
2).Basic Sql & bit case studies

Karur Vysya Bank Interview FAQs

How many rounds are there in Karur Vysya Bank Data Engineer interview?
Karur Vysya Bank interview process usually has 1 rounds. The most common rounds in the Karur Vysya Bank interview process are One-on-one Round.
What are the top questions asked in Karur Vysya Bank Data Engineer interview?

Some of the top questions asked at the Karur Vysya Bank Data Engineer interview -

  1. Stored procedure u...read more
  2. Normalisation in ...read more

Tell us how to improve this page.

Karur Vysya Bank Data Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Assistant Manager
559 salaries
unlock blur

₹5 L/yr - ₹14 L/yr

Manager
258 salaries
unlock blur

₹6.6 L/yr - ₹22 L/yr

Business Development Associate
170 salaries
unlock blur

₹1.6 L/yr - ₹3.6 L/yr

Business Development Officer
170 salaries
unlock blur

₹3 L/yr - ₹5.1 L/yr

Business Development Manager
135 salaries
unlock blur

₹2.5 L/yr - ₹8 L/yr

Explore more salaries
Compare Karur Vysya Bank with

HDFC Bank

3.9
Compare

ICICI Bank

4.0
Compare

Axis Bank

3.7
Compare

Kotak Mahindra Bank

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