Axis Bank Data Engineer Interview Questions and Answers

Behavioural and culture fit

SQL server

SQL DBA

Q1. Salary discussed, Appts test
Add your answer

Easy on cyber security

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

Good went well nicce process

Medium level questions

Q1. Asked about core subjects
Add your answer
Q2. Asked about my project
Add your answer

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. 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
Add your answer
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...read more
Answered by AI
Add your answer

Q1. What is your expected salary
Add your answer

Q1. SQL Basics and Good Communication
Add your answer
Q2. Structured Profile Summary
Add your answer