Upload Button Icon Add office photos

Filter interviews by

Keertana Finserv SQL Developer Interview Questions and Answers

Updated 16 Oct 2024

Keertana Finserv SQL Developer Interview Experiences

1 interview found

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 16 Oct 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(5 Questions)

  • Q1. SQL basics ,dql
  • Q2. DML, TCL,DDL,SUB QUERY,JOINTS
  • Q3. Do you know Functions
  • Ans. 

    Functions in SQL are reusable code blocks that perform a specific task.

    • Functions can be user-defined or built-in

    • They can return a single value or a table of values

    • Examples include SUM(), AVG(), and GETDATE()

  • Answered by AI
  • Q4. Do you know dcl
  • Ans. 

    DCL stands for Data Control Language, used to control access to data stored in a database.

    • DCL commands include GRANT, REVOKE, and DENY.

    • GRANT is used to give specific privileges to a user or role.

    • REVOKE is used to take back privileges that were granted.

    • DENY is used to explicitly deny access to a resource.

  • Answered by AI
  • Q5. Do you knowsub query
  • Ans. 

    A subquery is a query nested within another query to retrieve data based on the results of the outer query.

    • Subqueries can be used in SELECT, INSERT, UPDATE, and DELETE statements.

    • Subqueries can be correlated or non-correlated.

    • Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - full knowledge about sql

Skills evaluated in this interview

Interview questions from similar companies

I applied via Walk-in and was interviewed in May 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(3 Questions)

  • Q1. Any issue in earlier working company
  • Q2. Notice period working request
  • Q3. Salary backage request

Interview Preparation Tips

Interview preparation tips for other job seekers - Very seriously working safe on job.Any secretary asking another person norms & policy
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jul 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(3 Questions)

  • Q1. Tell me about your self
  • Q2. Tell me about your school life
  • Q3. Tell me about your job roll

Interview Preparation Tips

Interview preparation tips for other job seekers - Not about
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

It was very nice test and HR is very helpful

Round 2 - Technical 

(2 Questions)

  • Q1. Question was domain related
  • Q2. Provide all answer very simple way
Round 3 - HR 

(1 Question)

  • Q1. HRabout my experience and about company
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Past experience, Regulatory Analytics and hands on SQL and excel
Round 2 - One-on-one 

(1 Question)

  • Q1. Vision, why job change and previous work EX
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Jan 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Aptitude test with 2 easy to medium questions

Round 2 - Technical 

(1 Question)

  • Q1. Mostly resume based. Details on project Questions on python sql
Round 3 - HR 

(1 Question)

  • Q1. Strengths weaknesses
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. What is life like
  • Q2. What did your dad do

Interview Preparation Tips

Interview preparation tips for other job seekers - dont eat

I applied via Walk-in and was interviewed in Jun 2022. There was 1 interview round.

Round 1 - HR 

(1 Question)

  • Q1. About debt DPD wise discussion

Interview Preparation Tips

Topics to prepare for Home Credit Finance Associate interview:
  • debt collection
Interview preparation tips for other job seekers - who having debt collection statargy and expenses give the chance to apportinity
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jul 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Self-awareness of one's abilities

Round 2 - Coding Test 

Office website, link sharing coding Justin finish it, checking office and resident open

I applied via Campus Placement and was interviewed in May 2021. There were 4 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. Questions on derivatives
  • Q2. Capital Market Knowledge
  • Q3. Questions based on Internship
  • Q4. Technical skills proficiency: MS Excel, Python
  • Q5. Communication Skills

Interview Preparation Tips

Interview preparation tips for other job seekers - One shall be thorough with the basics as a fresher. Good communication skills go a long way.

Keertana Finserv Interview FAQs

How many rounds are there in Keertana Finserv SQL Developer interview?
Keertana Finserv interview process usually has 1 rounds. The most common rounds in the Keertana Finserv interview process are One-on-one Round.
How to prepare for Keertana Finserv SQL Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Keertana Finserv. The most common topics and skills that interviewers at Keertana Finserv expect are Application Development, Communication Skills, Database Design, Database Security and Dmlt.
What are the top questions asked in Keertana Finserv SQL Developer interview?

Some of the top questions asked at the Keertana Finserv SQL Developer interview -

  1. do you know Functi...read more
  2. do you know ...read more
  3. do you knowsub qu...read more

Tell us how to improve this page.

Keertana Finserv SQL Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

BA Continuum Interview Questions
4.1
 • 100 Interviews
Hero FinCorp Interview Questions
4.0
 • 90 Interviews
mPokket Interview Questions
3.8
 • 71 Interviews
Kinara Capital Interview Questions
4.3
 • 68 Interviews
SBFC Finance Interview Questions
3.6
 • 61 Interviews
View all

Keertana Finserv SQL Developer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
MIS Executive
21 salaries
unlock blur

₹2 L/yr - ₹3.6 L/yr

Relationship Officer
17 salaries
unlock blur

₹1.4 L/yr - ₹2.7 L/yr

Branch Manager
17 salaries
unlock blur

₹2.4 L/yr - ₹4.5 L/yr

Operations Manager
11 salaries
unlock blur

₹2 L/yr - ₹3.5 L/yr

Loan Officer
10 salaries
unlock blur

₹1.6 L/yr - ₹2.7 L/yr

Explore more salaries
Compare Keertana Finserv with

Home Credit Finance

4.1
Compare

Kogta Financial India Limited

4.7
Compare

Sammaan Capital Limited

3.7
Compare

Hero FinCorp

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