Fino Payments Bank SQL Database Administrator Interview Questions and Answers

Q1. What's your name? Previously working details
Add your answer
Q2. Your long term goals?
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Contained mix of coding, oops and general programming questions

Coding was live coding round
It was around 12pm
They used their own coding environment, I coded in java

Q1. 
Maximum Subarray Sum Problem Statement
Given an array arr of length N consisting of integers, find the sum of the subarray (including empty subarray) with the maximum sum among all subarrays.
Explanation...read more
Ans. 
Find the sum of the subarray with the maximum sum among all subarrays in an array of integers.
• Iterate through the array and keep track of the maximum sum subarray seen so far.

• Use Kadane's algorithm to efficiently find the maximum subarray sum.

• Consider the case where all elements in the array are negative.

• Handle the case where the array contains only one element.
Answered by AI
Add your answer

Round duration - 90 Minutes
Round difficulty - Hard

It was a collection of HLD AND LLD
Was around 12pm
This was conducted on bluejeans

Q1. Design a URL shortener with a database and all necessary components.
Ans. 
Design a URL shortener with database and necessary components
• Use a unique identifier for each URL to generate short links

• Store the original URL and corresponding short link in a database

• Implement a redirect mechanism to redirect short links to original URLs

• Consider implementing analytics to track usage and performance

• Ensure scalability and reliability of the system
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Easy

It was a friendly managerial round with director of my team, he was very for me to come on board and explained truthfully how payu is.

Round duration - 30 Minutes
Round difficulty - Easy

Just a normal HR discussion, he informed me that I've been selected and we discussed about the salary part

Q1. Can you describe your experience working in a corporate environment?
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

Time - afternoon. 
Interviewer jumped straight into interview, formal and comfortable environment. 
1. Interviewer introduction 
2. Interviewee introduction
3. Coding question 1 - difficulty medium, topic - arrays
- explain approach, write code (pseudo code is fine), dry run on given TCS. 
4. Coding question 2 - same as above, only question was different. Slightly more difficult but on arrays only. 
5. Questions on Python & Django - difficulty medium - write code related to queryset on django objects
6. SQL question to code - 10th highest salary.

Q1. 
Reverse Only Letters Problem Statement
You are given a string S. The task is to reverse the letters of the string while keeping non-alphabet characters in their original position.
Example:
Input:
S = "...read more
Ans. 
Reverse the letters of a string while keeping non-alphabet characters in their original position.
• Iterate through the string and store the non-alphabet characters in their original positions

• Reverse the letters of the string using two pointers technique

• Combine the reversed letters with the non-alphabet characters to get the final reversed string
Answered by AI
Add your answer
Q2. 
Alternate Positive and Negative Numbers
Given an array arr that contains an equal number of positive and negative elements, rearrange the given array such that positive and negative numbers are arranged a...read more
Ans. 
Rearrange an array with equal positive and negative numbers alternatively while maintaining relative order.
• Iterate through the array and separate positive and negative numbers into two separate arrays.

• Merge the two arrays alternatively into the original array.

• Ensure the relative order of positive and negative numbers is maintained.
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

1. Intro of interviewer
2. Intro of interviewee
3. Questions on Python - decorators, static method, class methods
4. Principal of coding, best practices
5. Question on DB - What is indexing, how to improve, best use of indexing.
6. Questions on django - what is django ORM, What is sandbox, Django models, Django queries.
7. Previous job, what do you do, stack you work on.

Very friendly environment, very pleasing person, loved it.

Q1. DSA round containing 2 coding questions along with some Java Questions
Add your answer

Q1. Design Round along with some puzzles
Add your answer

Q1. Managerial Round
Add your answer

There was a Hackerearth test with two questions

Q1. Some standard data structures question on array
Add your answer
Q2. Standard question on trees
Add your answer

Q1. Anagram question
Add your answer
Q2. Sql join questions
Add your answer