Finastra Performance Tester Interview Questions, Process, and Tips for Experienced

Sort the arr, fetch element from array

Q1. Linklist search
Add your answer
Q2. Sort in link List
Ans. 
Sorting in a linked list involves rearranging the elements in ascending or descending order based on a certain criteria.
• Use a sorting algorithm like bubble sort, selection sort, or merge sort to rearrange the elements in the linked list.

• Traverse the linked list and compare each element with the next one to determine the order in which they should be sorted.

• Update the pointers of the nodes in the linked list to reflect ...read more
Answered by AI
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Q1. 
Longest Increasing Subsequence Problem Statement
Given 'N' students standing in a row with specific heights, your task is to find the length of the longest strictly increasing subsequence of their heights...read more
Ans. 
Find the length of the longest strictly increasing subsequence of heights of students in a row.
• Iterate through the heights array and for each element, find the length of the longest increasing subsequence ending at that element.

• Use dynamic programming to keep track of the longest increasing subsequence length for each element.

• Return the maximum length found as the result.
Answered by AI
Add your answer
Q2. 
Overlapping Intervals Problem Statement
You are given the start and end times of 'N' intervals. Write a function to determine if any two intervals overlap.
Note:
If an interval ends at time T and anothe...read more
Ans. 
Given start and end times of intervals, determine if any two intervals overlap.
• Iterate through intervals and check if any two intervals overlap by comparing their start and end times

• Sort intervals based on start times for efficient comparison

• Consider edge cases where intervals end and start at the same time
Answered by AI
Add your answer
Q3. What SQL queries were asked during your interview?
Ans. 
Various SQL queries related to data manipulation and retrieval were asked during the interview.
• Basic SELECT queries to retrieve data from a single table

• JOIN queries to retrieve data from multiple tables based on a common column

• Aggregate functions like COUNT, SUM, AVG, etc. to perform calculations on data

• Subqueries to retrieve data based on the result of another query

• UPDATE queries to modify existing data in a table

• DELE...read more
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

Q1. 
Zig-Zag String Problem Statement
Given a string STR of size N and an integer M representing the number of rows in the zig-zag pattern, return the string formed by concatenating all rows when the string ST...read more
Ans. 
Arrange a string in zig-zag pattern with given number of rows and concatenate the rows.
• Iterate through the string and distribute characters to rows based on zig-zag pattern

• Concatenate the characters in each row to get the final result

• Handle edge cases like when number of rows is 1 or equal to the length of the string
Answered by AI
Add your answer
Q2. 
Next Permutation Problem Statement
You are given a permutation of 'N' integers. A sequence of 'N' integers is considered a permutation if it includes all integers from 1 to 'N' exactly once. Your task is ...read more
Ans. 
The task is to rearrange a given permutation of 'N' integers to form the lexicographically next greater permutation.
• Iterate from right to left to find the first element that is smaller than the element to its right.

• Swap this element with the smallest element to its right that is greater than it.

• Reverse the elements to the right of the swapped element to get the lexicographically next greater permutation.
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

Q1. 
Remove Consecutive Duplicates Problem Statement
Given a string S, your task is to recursively remove all consecutive duplicate characters from the string.
Input:
String S
Output:
Output string
Constr...read more
Ans. 
Recursively remove consecutive duplicate characters from a string.
• Use recursion to check if the current character is the same as the next character, if so skip the next character

• Base case: if the string is empty or has only one character, return the string

• Example: Input: 'aaabcc', Output: 'abc'
Answered by AI
Add your answer
Q2. 
Print Permutations - String Problem Statement
Given an input string 'S', you are tasked with finding and returning all possible permutations of the input string.
Input:
The first and only line of input ...read more
Ans. 
Return all possible permutations of a given input string.
• Use recursion to generate all possible permutations of the input string.

• Swap characters at different positions to generate permutations.

• Handle duplicate characters in the input string by using a set to store unique permutations.
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

Q1. Design an e-commerce website similar to Flipkart or Amazon.
Ans. 
Design an e-commerce website similar to Flipkart or Amazon.
• Implement user-friendly interface for easy navigation

• Include search functionality with filters for products

• Incorporate secure payment gateway for transactions

• Provide personalized recommendations based on user behavior

• Include customer reviews and ratings for products

• Implement order tracking and delivery status updates

• Offer various payment options like credit/deb
Answered by AI
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

It was Technical + Aptitude MCQ round.The technical section consisted if MCQ related to DSA,OS,DBMS.The aptitude section consisted of questions related to basic mathematics.

Q1. 
Candies Distribution Problem Statement
Prateek is a kindergarten teacher with a mission to distribute candies to students based on their performance. Each student must get at least one candy, and if two s...read more
Ans. 
The task is to distribute candies to students based on their performance while minimizing the total candies distributed.
• Create an array to store the minimum candies required for each student.

• Iterate through the students' ratings array to determine the minimum candies needed based on the given criteria.

• Consider the ratings of adjacent students to decide the number of candies to distribute.

• Calculate the total candies req...read more
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

It was a technical interview testing the basic skills of OS and DBMS of candidates along with few project discussions from your CV.

Q1. Can you write 15 Linux commands along with their functions?
Ans. 
List of 15 Linux commands with their functions
• ls - list directory contents

• pwd - print working directory

• cd - change directory

• mkdir - make a new directory

• rm - remove files or directories

• cp - copy files and directories

• mv - move or rename files and directories

• grep - search for patterns in files

• chmod - change file permissions

• ps - display information about running processes

• top - display and update sorted information about pr...read more
Answered by AI
Add your answer
Q2. What are DDL (Data Definition Language) and DML (Data Manipulation Language)?
Ans. 
DDL is used to define the structure of database objects, while DML is used to manipulate data within those objects.
• DDL includes commands like CREATE, ALTER, DROP to define database objects like tables, indexes, etc.

• DML includes commands like INSERT, UPDATE, DELETE to manipulate data within tables.

• Example of DDL: CREATE TABLE employees (id INT, name VARCHAR(50));

• Example of DML: INSERT INTO employees VALUES (1, 'John Doe
Answered by AI
Add your answer