Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Bajaj Finserv Team. If you also belong to the team, you can get access from here

Bajaj Finserv Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Bajaj Finserv SQL Developer Interview Questions and Answers

Updated 6 May 2024

Bajaj Finserv SQL Developer Interview Experiences

2 interviews found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Tell me about joins?
  • Q2. What is stored procedure
  • Ans. 

    A stored procedure is a set of SQL statements that can be saved and reused in a database.

    • Stored procedures help improve performance by reducing network traffic.

    • They can be used to encapsulate complex logic and business rules.

    • Stored procedures can be called from applications or other stored procedures.

    • Example: CREATE PROCEDURE GetCustomerDetails AS SELECT * FROM Customers WHERE Country = 'USA';

  • Answered by AI

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 29 Sep 2022

I applied via LinkedIn and was interviewed in Aug 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 - Technical 

(2 Questions)

  • Q1. All questions SQL scenario. Like Use cases in sql
  • Q2. Asking questions they asking deep knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL Senario base questions mostly asked and all questions are different scenarios some examples they we can prove.

SQL Developer Interview Questions Asked at Other Companies

asked in BNP Paribas
Q1. How is a change request in application serviced by development te ... read more
asked in BNP Paribas
Q2. Write down a procedure to return a certain series (99, 96, 93, .. ... read more
asked in BNP Paribas
Q3. Given sample data on two tables, write down the result sets of al ... read more
asked in Capgemini
Q4. 2. Query optimization techniques? 3. Types of schemas and differe ... read more
asked in HCLTech
Q5. Difference between truncate and drop with more details. eg: 'A' t ... read more

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed in Jun 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Basic react
  • Q2. Basic javascript

Interview Preparation Tips

Interview preparation tips for other job seekers - Know the technology u use including all the basic stuff and technical names of it

Interview Questionnaire 

11 Questions

  • Q1. What is the difference between multi tasking, multi processing and multi programming operating systems with examples ?
  • Ans. 

    Multi tasking, multi processing, and multi programming are different approaches to managing tasks in an operating system.

    • Multi tasking allows multiple tasks to run concurrently on a single processor.

    • Multi processing involves multiple processors running tasks simultaneously.

    • Multi programming allows multiple programs to be loaded into memory and executed concurrently.

    • Examples of multi tasking operating systems include Wi...

  • Answered by AI
  • Q2. Tell me about memory allocation (stack vs. heap)?
  • Ans. 

    Memory allocation refers to the process of assigning memory to programs during runtime.

    • Stack allocation is done automatically and is limited in size.

    • Heap allocation is done manually and is larger in size.

    • Stack memory is used for local variables and function calls.

    • Heap memory is used for dynamic memory allocation.

    • Memory leaks can occur if heap memory is not properly managed.

  • Answered by AI
  • Q3. You have two threads one printing even numbers in order and other odd numbers. Design an algorithm so that it prints numbers in natural order?
  • Ans. 

    Use a shared variable and synchronization mechanisms to ensure natural order printing of numbers.

    • Create two threads, one for printing even numbers and the other for printing odd numbers.

    • Use a shared variable to keep track of the current number to be printed.

    • Implement synchronization mechanisms like locks or semaphores to ensure only one thread can access the shared variable at a time.

    • Each thread should check if it is i...

  • Answered by AI
  • Q4. Print a matrix in spiral order?
  • Ans. 

    Printing a matrix in spiral order

    • Start from the first element and print it

    • Move in a spiral order towards the center of the matrix

    • Repeat until all elements are printed

  • Answered by AI
  • Q5. Thread class and Runnable Interface?
  • Ans. 

    Thread class and Runnable Interface are used for multithreading in Java.

    • Thread class is a predefined class in Java that provides methods to create and control threads.

    • Runnable interface is used to define a task that can be executed by a thread.

    • Thread class implements Runnable interface.

    • Thread class provides more control over threads than Runnable interface.

    • Example: Thread t = new Thread(new MyRunnable()); t.start();

    • Exa...

  • Answered by AI
  • Q6. What’s the difference between a Linked List and an ArrayList and give me an example of when to use which?
  • Ans. 

    Linked List is a dynamic data structure while ArrayList is a static data structure.

    • Linked List is best for frequent insertion and deletion operations.

    • ArrayList is best for frequent access operations.

    • Linked List uses more memory than ArrayList.

    • ArrayList is faster than Linked List for accessing elements.

    • Use Linked List when you need to frequently add or remove elements from the list.

    • Use ArrayList when you need to frequen

  • Answered by AI
  • Q7. Questions of OS concepts?
  • Q8. A role play scenario was given. With a clear instruction on I don’t need to know the basis and the hypothetical assumption was presented. I was told that I was expected to respond to the given scenario, in...
  • Q9. Why are you interested in a career in investment banking?
  • Ans. 

    I am not interested in a career in investment banking.

    • I am more interested in a career in software development

    • I enjoy problem-solving and creating innovative solutions through coding

    • Investment banking does not align with my passion and skill set

  • Answered by AI
  • Q10. Why have you chosen to apply to J.P. Morgan?
  • Ans. 

    I have chosen to apply to J.P. Morgan because of their reputation, global presence, and opportunities for growth.

    • J.P. Morgan has a strong reputation in the financial industry.

    • They have a global presence with offices in multiple countries.

    • The company offers various opportunities for career growth and development.

    • J.P. Morgan is known for its innovative technology solutions in the financial sector.

    • I am impressed by their ...

  • Answered by AI
  • Q11. Have you ever made a mistake? Tell us about it?
  • Ans. 

    Yes, I have made a mistake in my previous project.

    • I underestimated the complexity of a task and ended up missing the deadline.

    • I failed to properly test a feature, resulting in a bug that affected user experience.

    • I accidentally deleted an important file without having a backup.

    • I misunderstood a requirement and implemented a feature incorrectly.

  • Answered by AI

Interview Preparation Tips

Round: Test
Total Questions: 1

General Tips: Interview Process: Aptitude test, followed by 3 rounds of interview. Interview process was very good. Just be positive to clear the interview.
Check this link before appearing for interview with JP Morgan. It will help  -----
Skills: Algorithm, Data structure, Stack
College Name: Na

Skills evaluated in this interview

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 Jul 2022. There were 6 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 - Aptitude Test 

Simple aptitude test ............

Round 3 - Coding Test 

3 question leetcode medium .......

Round 4 - Technical 

(1 Question)

  • Q1. Basic programming based questions
Round 5 - Technical 

(1 Question)

  • Q1. Project based questions
Round 6 - HR 

(1 Question)

  • Q1. Basic personal questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Oops, mvc, design principles
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 Jun 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Round of 3 phases : Vocabulary, Business analytics and Coding

Round 2 - Technical 

(1 Question)

  • Q1. Convert number to ruman numeral
  • Ans. 

    Convert a number to Roman numeral representation.

    • Create a mapping of numbers to Roman numerals (e.g. 1 -> 'I', 5 -> 'V', 10 -> 'X', etc.)

    • Iterate through the mapping in descending order and subtract the largest possible numeral from the number until it reaches 0.

    • Build the Roman numeral representation by appending the corresponding numeral for each subtraction.

    • Handle special cases like 4, 9, 40, 90, etc. by including the

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. Resume questions
Interview experience
3
Average
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Sep 2023. There were 3 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 - Coding Test 

Dsa questions graph and trees dp stack

Round 3 - Technical 

(1 Question)

  • Q1. Dbms os cn technical

Interview Preparation Tips

Interview preparation tips for other job seekers - dsa well prepare
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Dotnet , MVC , SQL
Round 2 - HR 

(1 Question)

  • Q1. CTC and other discussion
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Dependency injection
  • Q2. What are oops concepts
  • Ans. 

    Object-oriented programming concepts that focus on data encapsulation, inheritance, polymorphism, and abstraction.

    • Encapsulation: bundling data and methods that operate on the data into a single unit (class)

    • Inheritance: ability of a class to inherit properties and behavior from another class

    • Polymorphism: ability to present the same interface for different data types

    • Abstraction: hiding the complex implementation details

  • Answered by AI

Bajaj Finserv Interview FAQs

How many rounds are there in Bajaj Finserv SQL Developer interview?
Bajaj Finserv interview process usually has 1-2 rounds. The most common rounds in the Bajaj Finserv interview process are Technical and Resume Shortlist.
How to prepare for Bajaj 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 Bajaj Finserv. The most common topics and skills that interviewers at Bajaj Finserv expect are Data Analytics, Data Warehousing, Development, MIS Reporting and MySQL.
What are the top questions asked in Bajaj Finserv SQL Developer interview?

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

  1. All questions SQL scenario. Like Use cases in ...read more
  2. Asking questions they asking deep knowle...read more

Tell us how to improve this page.

Bajaj Finserv SQL Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Wells Fargo Interview Questions
3.8
 • 575 Interviews
ICICI Securities Interview Questions
3.9
 • 163 Interviews
Sharekhan Interview Questions
3.8
 • 84 Interviews
Bajaj Capital Interview Questions
3.8
 • 79 Interviews
Edelweiss Interview Questions
3.9
 • 58 Interviews
View all
Bajaj Finserv SQL Developer Salary
based on 69 salaries
₹1.8 L/yr - ₹7 L/yr
24% less than the average SQL Developer Salary in India
View more details

Bajaj Finserv SQL Developer Reviews and Ratings

based on 7 reviews

1.8/5

Rating in categories

2.5

Skill development

2.0

Work-life balance

1.7

Salary

3.0

Job security

2.4

Company culture

1.6

Promotions

1.9

Work satisfaction

Explore 7 Reviews and Ratings
Assistant Manager
1.3k salaries
unlock blur

₹1.8 L/yr - ₹6.7 L/yr

Sales Officer
1.2k salaries
unlock blur

₹1 L/yr - ₹5 L/yr

Sales Executive
1.2k salaries
unlock blur

₹0.9 L/yr - ₹5.1 L/yr

Sales Manager
1k salaries
unlock blur

₹1.4 L/yr - ₹9.6 L/yr

Manager
882 salaries
unlock blur

₹3 L/yr - ₹11 L/yr

Explore more salaries
Compare Bajaj Finserv with

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

3.9
Compare

HSBC Group

3.9
Compare

Cholamandalam Investment & Finance

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