Kavach Financial Services Interview Questions and Answers

Q1. Core java based questions, followed by springboot and then sql queries
Add your answer

Q1. Scenario based java and spring boot questions and more complex sql queries
Add your answer

Q1. Previous project related questions like difficulty faced in project, how you overcome that, day to day routine, discussed role in projects
Add your answer

Q1. Salary discussion and onboarding instructions
Add your answer

2 coding questions .
topics were array and string

Q1. 2D array question and a linkedlist question (find the middle element of the list)
Add your answer
Q2. Dbms questions like keys ,normalization, acid properties, types of network layer , deadlock in os
Add your answer

Q1. Detect loop in a linkedlist
Ans. 
Use Floyd's Tortoise and Hare algorithm to detect loop in a linked list.
• Initialize two pointers, slow and fast, at the head of the linked list.

• Move slow pointer by one step and fast pointer by two steps.

• If they meet at any point, there is a loop in the linked list.
Answered by AI
Add your answer
Q2. SQL queries basic level .
Add your answer

Q1. Oops questions like inheritance and interface
Add your answer
Q2. Sql queries from leetcode hard level
Add your answer

Q1. ACID Properties
Ans. 
ACID properties are a set of properties that guarantee reliable and consistent transactions in a database system.
• Atomicity ensures that either all operations in a transaction are completed successfully or none at all.

• Consistency ensures that the database remains in a valid state before and after the transaction.

• Isolation ensures that the concurrent execution of transactions results in a system state that would be obtai...read more
Answered by AI
Add your answer
Q2. What are Idempotent HTTP Requests?
Ans. 
Idempotent HTTP requests are requests that can be repeated multiple times without changing the result beyond the initial request.
• Idempotent requests have the same outcome no matter how many times they are executed.

• GET, PUT, and DELETE HTTP methods are typically idempotent.

• POST requests are not idempotent as they can create new resources with each execution.
Answered by AI
Add your answer
Q3. Questions regarding your project, and how did you learn from the projects and tasks assigned to you?
Add your answer
Q4. System Design
Add your answer

Q1. About yourself, your past work experience and why you want to get into this role The interviewer was very calm and just wanted to learn about the background.
Add your answer

Q1. All behavioural questions- 1 how do your prioritise your work? 2 do you have experience in managing cross functional teams? 3 what if one of your Co-worker decline working on a project, How would you tackl...read more
Add your answer

Q1. Again all behavioural questions- How do you work with large volume of works? How do you manage work life balance? How do you give harsh feedbacks to your coworkers?
Add your answer

Q1. All behavioural questions again- same as above just a bit here and there asked in different ways
Add your answer

Q1. Questions related to devops tools such as azure terraform kubernetes.
Add your answer
Q2. Java concurrency and exception handling
Add your answer

Q1. Why do you want to join this organization?
Ans. 
I am impressed by the company's innovative approach to DevOps and its commitment to continuous improvement.
• I am excited about the opportunity to work with cutting-edge technologies and tools in a collaborative environment.

• I admire the company's strong reputation for fostering professional growth and development.

• I believe my skills and experience align well with the organization's goals and values.
Answered by AI
Add your answer
Q2. Expected salary
Ans. 
My expected salary is based on my experience, skills, and the market rate for Devops Engineers.
• I have researched the average salary range for Devops Engineers in this location.

• I am looking for a competitive salary that reflects my expertise and contributions.

• I am open to discussing salary based on the overall compensation package offered.
Answered by AI
Add your answer

Q1. What is the SQL query used to remove duplicates from a dataset?
Ans. 
Use the DISTINCT keyword in a SELECT query to remove duplicates from a dataset.
• Use the SELECT DISTINCT statement to retrieve unique rows from a table

• Example: SELECT DISTINCT column1, column2 FROM table_name;

• Another way is to use the GROUP BY clause with aggregate functions like COUNT() or SUM() to remove duplicates
Answered by AI
Add your answer
Q2. What is the SQL query to find the third highest salary in a table?
Ans. 
Use a subquery to find the third highest salary in a table using SQL.
• Use the ORDER BY clause to sort the salaries in descending order.

• Use the LIMIT clause to limit the results to the third row.

• Use a subquery to select the third highest salary from the sorted list.
Answered by AI
Add your answer

Q1. What are the different roles in Power BI?
Ans. 
Different roles in Power BI include Power BI Developer, Power BI Analyst, Power BI Administrator, and Power BI User.
• Power BI Developer - responsible for creating and maintaining Power BI reports and dashboards

• Power BI Analyst - analyzes data using Power BI to provide insights and recommendations

• Power BI Administrator - manages security, access, and data sources in Power BI

• Power BI User - consumes reports and dashboards
Answered by AI
Add your answer
Q2. SQL - basicand advanced questions
Add your answer

Q1. All explain allowance
Ans. 
Allowance is a sum of money paid regularly to cover expenses or losses.
• Allowance is a fixed amount of money given regularly to cover expenses or losses.

• It can be provided as part of a salary package or as a separate payment.

• Examples include travel allowance, housing allowance, and meal allowance.
Answered by AI
Add your answer
Q2. 1) TA allowance 2) travel allowance 3) hotels🏨 allowance
Add your answer
Q3. Interview update me
Add your answer

Q1. Two sum problem.
Add your answer

Q1. System Design concepts
Add your answer

Q1. Database design and principles
Add your answer

Q1. Final discussion and job offer
Add your answer