Fiserv SQL Developer Interview Questions and Answers

Round duration - 70 minutes
Round difficulty - Easy

The first round was the Online Coding Round of 70 minutes with 3 problems of 3 marks, 3 marks, and 4 marks respectively.
The first two questions were easy and the third one was a bit tricky. The round started at 6 PM. 
Anyone who is practicing continuously could have solved these questions easily within the time limit. The test cases were also not so hard and distinct. I coded in C++ language.
The questions asked were-
1. Minimum insertions required to make a string palindrome
2. To find the distance of the closest leaf from a node with given data.
3. Add two numbers represented by linked lists

22 students were selected for the next round.

Q1. 
Minimum Insertions to Make a String Palindrome
Determine the minimal number of characters needed to insert into a given string STR to transform it into a palindrome.
Example:
Input:
STR = "abcaa"
Outp...read more
Ans. 
The task is to find the minimum number of characters needed to insert into a given string to make it a palindrome.
• Use dynamic programming to find the longest palindromic subsequence of the given string.

• Subtract the length of the longest palindromic subsequence from the length of the original string to get the minimum insertions required.

• Handle edge cases like an empty string or a string that is already a palindrome.

• Exa...read more
Answered by AI
Add your answer
Q2. 
Closest Leaf in a Binary Tree
Ninja is stuck in a maze represented as a binary tree, and he is at a specific node ‘X’. Help Ninja find the shortest path to the nearest leaf node, which is considered an ex...read more
Ans. 
Find the minimum distance from a given node to the nearest leaf node in a binary tree.
• Traverse the binary tree from the given node 'X' to find the nearest leaf node using BFS or DFS.

• Keep track of the distance from 'X' to each leaf node encountered during traversal.

• Return the minimum distance found as the output.
Answered by AI
Add your answer
Q3. 
Adding Two Linked Lists
Given two singly linked lists, with each list representing a positive number without leading zeros, your task is to add these two numbers and return the result in the form of a new...read more
Ans. 
Add two numbers represented by linked lists and return the result as a new linked list.
• Traverse both linked lists simultaneously while adding corresponding elements and carry over the sum if needed

• Handle cases where one linked list is longer than the other

• Create a new linked list to store the sum of the two numbers
Answered by AI
Add your answer

Round duration - 80 minutes
Round difficulty - Easy

It was a technical interview. The platform used was google meet for online video calling. The interviewer first introduced himself then asked me to introduce myself. He also asked about my well-being amid the Covid-19 pandemic. He asked me 3 problems from data structures. He put a lot of focus on my project. We discussed about my project for about 20 mins. He asked various questions related to my project and I answered them confidently. After 70-75 mins he said that interview was over and that I may ask him anything. I asked him to give me feedback about my resume and my project. He gave me advice to improve my resume and the interview was over. The first technical interview was easy and was not so challenging as I was prepared.

Q1. 
All Pairs with Target Sum
Given an array of integers ARR with length 'N' and an integer 'Target', the task is to find all unique pairs of elements that add up to the 'Target'.
Input:
First line: Integer...read more
Ans. 
Find all unique pairs of elements in an array that add up to a given target sum.
• Use a hashmap to store the difference between the target sum and each element as keys and their indices as values.

• Iterate through the array and check if the current element's complement exists in the hashmap.

• Return the pairs of elements that add up to the target sum.
Answered by AI
Add your answer
Q2. 
Quick Sort Problem Statement
Sort the given array of integers in ascending order using the quick sort algorithm. Quick sort is a divide-and-conquer algorithm where a pivot point is chosen to partition the...read more
Ans. 
Implement quick sort algorithm to sort an array of integers in ascending order.
• Choose a pivot element (e.g., rightmost element) to partition the array into two subarrays.

• Recursively apply quick sort on the subarrays until the entire array is sorted.

• Time complexity can be optimized to NlogN for worst-case scenarios.
Answered by AI
Add your answer
Q3. 
Merge Sort Task
Given a sequence of numbers, denoted as ARR, your task is to return a sorted sequence of ARR in non-descending order using the Merge Sort algorithm.
Example:
Explanation:
The Merge Sort...read more
Ans. 
Implement Merge Sort algorithm to sort a sequence of numbers in non-descending order.
• Implement the Merge Sort algorithm which involves dividing the array into two halves, sorting each half, and then merging them back together.

• Recursively call the Merge Sort function on each half of the array until the base case of having a single element in the array is reached.

• Merge the sorted halves back together in a new array in no...read more
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

This was also a technical round. The interviewer focused on data structures and resume. Apart from some basic questions about my resume, he asked majorly about data structures and algorithms. The interview was an hour long and he asked only 2 problems. Both of them were from trees. In this round, he focused if I can change my approach if a slight change is made in the question. Like he asked me to write code for inorder traversal. Obviously, I used a recursive approach. He then asked me to use the iterative method to find inorder traversal of the tree.

The questions he asked were-
1. Inorder traversal (both recursive and iterative method)
2. Level Order Traversal
( For obvious reasons I knew level order traversal very well. I coded it swiftly, so he asked me to write code for Zig-Zag traversal)

Q1. 
Inorder Successor in a Binary Tree
Find the inorder successor of a given node in a binary tree. The inorder successor is the node that appears immediately after the given node during an inorder traversal....read more
Ans. 
Find the inorder successor of a given node in a binary tree.
• Perform an inorder traversal of the binary tree to find the successor of the given node.

• If the given node has a right child, the successor will be the leftmost node in the right subtree.

• If the given node does not have a right child, backtrack to the parent nodes to find the successor.
Answered by AI
Add your answer
Q2. 
Zigzag Traversal of Binary Tree
Given a binary tree with integer values in its nodes, your task is to print the zigzag traversal of the tree.
Note:
In zigzag order, level 1 is printed from left to right...read more
Ans. 
Implement a function to print the zigzag traversal of a binary tree.
• Use a queue to perform level order traversal of the binary tree.

• Maintain a flag to switch between printing nodes from left to right and right to left at each level.

• Store nodes at each level in a list and reverse the list if the flag is set to print in zigzag order.
Answered by AI
Add your answer

Round duration - 50 minutes
Round difficulty - Medium

This was the final round of the Interview process. My interview was scheduled for 7.30 PM. It started at approximately 7.40 PM. The main focus of the interviewer was on my projects and my skills. He asked me many questions regarding my project like what problems I faced, what did you learn from this, apart from developing skills what else did you learn while developing the project, why did you use this tech instead of this, security features, scalability of the project and many more. I answered almost every question as perfectly as I can. Later he asked me some basic questions from NodeJS (as I am a full stack developer). In the end, he asked a puzzle. I didn't know the solution to the puzzle but we discussed it and I figured out the solution.

Q1. Basic end user understanding
Add your answer