Upload Button Icon Add office photos

Fino Payments Bank

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

Fino Payments Bank SQL Database Administrator Interview Questions and Answers for Experienced

Updated 6 Aug 2022

Fino Payments Bank SQL Database Administrator Interview Experiences for Experienced

1 interview found

I applied via Naukri.com and was interviewed in Jul 2022. 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 - Technical 

(2 Questions)

  • Q1. 1.backup type 2.recover type 3.recovery and no recovery mode 4.user management 5.log shipping steps 6.lsn misstatements
  • Q2. 1. replication types and jobs 2. Transitional replication how it's work and which job run and what's is important
  • Ans. 

    Replication types and jobs, and how transactional replication works

    • Replication types include snapshot, transactional, and merge

    • Snapshot replication copies the entire database at a specific point in time

    • Transactional replication copies changes as they occur

    • Merge replication combines changes from multiple sources

    • Transactional replication uses a distributor to send changes to subscribers

    • Important jobs for transactional re...

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. 1. Dr dill steps on log shipping 2. Performance tuning
  • Ans. 

    Log shipping and performance tuning are important aspects of SQL Database Administration.

    • Log shipping is a process of automating the backup of transaction log files on a primary database server and then restoring them onto a secondary server.

    • Performance tuning involves identifying and resolving performance issues in a database system, such as slow queries or inefficient indexing.

    • Techniques for performance tuning includ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - 1.Pump yourself up and stay positive.
2 Focus on log shipping and replication
3.Dr drill process

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Aug 2022. 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 - Aptitude Test 

It was quantitative aptitude test with some coding questions

Round 3 - One-on-one 

(3 Questions)

  • Q1. This round was to majorly check our confidence and communication style. I was asked to explain the projects that I have done..then some general analytical based questions that were non technical.
  • Q2. Why didn't you want to pursue higher studies?
  • Q3. Tell me about urself and the projects you have done

Interview Preparation Tips

Interview preparation tips for other job seekers - There is no much work pressure and it's a fine place for experienced employees..but not a fine play freshers who are just graduated.. since there is less challenging or learn space..
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
  • Q1. Basic to advance
  • Q2. Work flow , project detais
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Prepare Ds algo - array, link list, stack, queue. And advance things of your domain

Round 2 - Coding Test 

DS apti questions oral

Round 3 - One-on-one 

(1 Question)

  • Q1. Ds algo plus your domain discussion. Previous projects

Interview Preparation Tips

Interview preparation tips for other job seekers - Given
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Apr 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Leetcode medium 2 question in 60 minutes.

Round 2 - Coding Test 

Leet code hard 1 question

Round 3 - One-on-one 

(2 Questions)

  • Q1. Design a hashmap and internal working .. then few questions on linked hashmap
  • Q2. Assignment to make a snake and ladder
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Aptitude Test 

Finding possible options of moving horse in chess board

Round 2 - Coding Test 

Write the polyfill of bind (custom bind)

Interview Preparation Tips

Interview preparation tips for other job seekers - good
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Leetcode medium questions using priority queue. I don't remeber exact now

Round 2 - One-on-one 

(1 Question)

  • Q1. Interview round was vry simple binary tree mirror question
Round 3 - HR 

(1 Question)

  • Q1. 5 mins round. basics like location

Interview Preparation Tips

Interview preparation tips for other job seekers - OA is hard, rest process is easy
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before May 2023. There were 3 interview rounds.

Round 1 - Coding Test 

3 Coding problems to be solved in 90 minutes.

Round 2 - Technical 

(1 Question)

  • Q1. Introduction, Project Discussion, HTML Tags, Reverse a string, Level order traversal in a binary tree, Minimum swap operations to sort an array.
Round 3 - Technical 

(1 Question)

  • Q1. N-Queen problem, Coin Change, Number of Islands

Interview Preparation Tips

Interview preparation tips for other job seekers - Stick to the basics.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Resume based+ DSA + Riddles
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Coding Test 

Coding round consisted of three problems with easy to moderate level difficulty.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Variation of Minimum number of platforms required for railway station.
  • Ans. 

    Minimum number of platforms required for a railway station depends on the maximum number of trains arriving and departing at the same time.

    • Calculate the maximum number of trains arriving and departing at the same time.

    • Determine the time intervals for each train's arrival and departure.

    • Add extra platforms for buffer and unexpected delays.

    • Consider factors like train length, frequency, and scheduling conflicts.

    • Example: If...

  • Answered by AI
  • Q2. Rearrange the array such that the negative numbers are shifted to the beginning.
  • Ans. 

    Rearrange array with negative numbers at the beginning

    • Iterate through the array and move negative numbers to the beginning

    • Use two pointers approach to swap elements

    • Maintain the order of negative numbers while shifting them to the beginning

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

(2 Questions)

  • Q1. Implement a simple program using multithreading.
  • Ans. 

    A simple program using multithreading can be implemented to demonstrate parallel execution of tasks.

    • Create a class that implements the Runnable interface in Java.

    • Override the run() method to define the task that will run in a separate thread.

    • Create instances of the class and start them using the Thread class.

    • Use synchronization mechanisms like locks or semaphores to manage shared resources in a thread-safe manner.

  • Answered by AI
  • Q2. Explain in details about the Java Collections API.
  • Ans. 

    Java Collections API provides a set of classes and interfaces to store and manipulate collections of objects.

    • Includes interfaces like List, Set, and Map for different types of collections

    • Provides classes like ArrayList, HashSet, and HashMap for implementing collections

    • Offers utility classes like Collections for common operations on collections

    • Introduced in Java 2 and has been expanded in subsequent versions

  • Answered by AI

Skills evaluated in this interview

Fino Payments Bank Interview FAQs

How many rounds are there in Fino Payments Bank SQL Database Administrator interview for experienced candidates?
Fino Payments Bank interview process for experienced candidates usually has 3 rounds. The most common rounds in the Fino Payments Bank interview process for experienced candidates are Technical and Resume Shortlist.
What are the top questions asked in Fino Payments Bank SQL Database Administrator interview for experienced candidates?

Some of the top questions asked at the Fino Payments Bank SQL Database Administrator interview for experienced candidates -

  1. 1. replication types and jobs 2. Transitional replication how it's work and wh...read more
  2. 1. Dr dill steps on log shipping 2. Performance tun...read more
  3. 1.backup type 2.recover type 3.recovery and no recovery mode 4.user management...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

DBS Bank Interview Questions
3.8
 • 165 Interviews
City Union Bank Interview Questions
3.2
 • 93 Interviews
CSB Bank Interview Questions
3.2
 • 77 Interviews
View all
Assistant Manager
211 salaries
unlock blur

₹1.7 L/yr - ₹8.4 L/yr

Territory Sales Manager
155 salaries
unlock blur

₹1.9 L/yr - ₹4.1 L/yr

Cluster Head
151 salaries
unlock blur

₹3 L/yr - ₹9 L/yr

Manager
126 salaries
unlock blur

₹3.5 L/yr - ₹14 L/yr

Officer
123 salaries
unlock blur

₹1.5 L/yr - ₹5 L/yr

Explore more salaries
Compare Fino Payments Bank with

AU Small Finance Bank

4.2
Compare

Equitas Small Finance Bank

4.4
Compare

ESAF Small Finance Bank

3.7
Compare

DBS Bank

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