FIS Senior Product Support Engineer Interview Questions and Answers

Q1. What is a project that you have worked on before?
Ans. 
Developed a web-based inventory management system for a retail company
• Utilized Java for backend development

• Implemented responsive design using HTML, CSS, and JavaScript

• Integrated barcode scanning functionality for efficient inventory tracking
Answered by AI
Add your answer
Q2. What was your role within the team?
Ans. 
I was responsible for providing technical support to end users and troubleshooting application issues within the team.
• Providing technical support to end users

• Troubleshooting application issues

• Collaborating with team members to resolve issues

• Documenting solutions and best practices
Answered by AI
Add your answer
Q3. What SQL-based queries were asked during your interview? like self join , average
Add your answer

Q1. What is the command to search a file like test.txt in linux?
Ans. 
The command to search a file like test.txt in Linux is 'grep'.
• Use the 'grep' command followed by the search term and the file name to search for a specific text in a file.

• For example, to search for the word 'hello' in a file named test.txt, you would use the command 'grep hello test.txt'.
Answered by AI
Add your answer
Q2. What is constraints?
Ans. 
Constraints are limitations or restrictions that affect the design, implementation, or operation of a system.
• Constraints can be related to time, budget, resources, technology, or regulations.

• They can impact the functionality, performance, scalability, or security of a system.

• Examples include budget constraints limiting the purchase of new hardware, time constraints for project deadlines, or regulatory constraints for d...read more
Answered by AI
Add your answer
Q3. What is the command to get the value present at 80th row , 100th column?
Ans. 
To get the value present at 80th row, 100th column, you can use the command 'awk' in Unix/Linux systems.
• Use the 'awk' command with the syntax 'awk 'NR==80 {print $100}' filename' to get the value at the specified row and column.

• Replace 'filename' with the actual file name where the data is stored.

• Ensure that the row and column numbers are adjusted based on the indexing starting from 1 in 'awk'.
Answered by AI
Add your answer
Q4. What is view in sql?
Ans. 
A view in SQL is a virtual table based on the result-set of a SELECT statement.
• Views are used to simplify complex queries by storing them as virtual tables

• Views do not store data themselves, but display data from underlying tables

• Views can be used to restrict access to certain columns or rows of a table

• Views can be used to join multiple tables and present the data in a single table-like structure
Answered by AI
Add your answer
Q5. What is internal workflow for the BFSI domain?
Ans. 
Internal workflow for BFSI domain involves processes related to banking, financial services, and insurance.
• Customer onboarding and account setup

• Transaction processing and monitoring

• Risk management and compliance checks

• Customer support and issue resolution

• Data analysis and reporting
Answered by AI
Add your answer

Q1. Tell me about yourself?
Ans. 
I am a dedicated and experienced Production Support Analyst with a strong background in troubleshooting and resolving technical issues.
• Over 5 years of experience in providing production support for various applications

• Proficient in analyzing system logs and identifying root causes of issues

• Skilled in collaborating with development teams to implement solutions and prevent future incidents

• Strong communication skills to e...read more
Answered by AI
Add your answer
Q2. What is Asset in BFSI domain?
Ans. 
In the BFSI domain, an asset refers to any valuable item owned by an individual or organization that can be converted into cash.
• Assets can include cash, investments, real estate, equipment, and intellectual property.

• In the banking sector, assets can also refer to loans given out to customers.

• Assets are important for financial institutions as they represent the value of the organization and its ability to generate reven...read more
Answered by AI
Add your answer

Q1. OS concepts- boot, handshake, dhcp, dora
Add your answer
Q2. Networking concepts
Add your answer

Q1. Database concepts and Sql questions
Add your answer
Q2. Datawarehousing concepts
Add your answer

Q1. Previous project details
Add your answer
Q2. Explain critical issue worked on
Add your answer

Q1. Explain previous project in detail.
Add your answer
Q2. Explain critical issue worked on.
Add your answer

Q1. Online interview
Add your answer
Q2. Self introduction
Add your answer

24/7 production environment

Q1. What is the difference between PL SQL AND SQL?
Ans. 
PL/SQL is a procedural language extension to SQL used for writing complex queries and programs.
• SQL is used for querying and manipulating data in a database

• PL/SQL is used for writing complex queries and programs

• PL/SQL is a procedural language that extends SQL with programming constructs like loops and conditional statements

• PL/SQL is used to create stored procedures, functions, and triggers in Oracle databases
Answered by AI
Add your answer
Q2. About programming
Add your answer
Q3. Write a query using below data to find out last string from emp table?
Ans. 
Query to find last string from emp table
• Use the ORDER BY clause with DESC keyword to sort the table in descending order

• Use the LIMIT keyword to limit the result to 1 row

• Assuming the last string refers to the last row in the table
Answered by AI
Add your answer
Q4. Write s query to find maximum salary from EMP?
Ans. 
Query to find maximum salary from EMP
• Use the MAX() function to find the maximum salary

• Specify the column name for salary in the SELECT statement

• Specify the table name and column name for salary in the FROM clause
Answered by AI
Add your answer

Basic aptitude questions were asked on partnerships, time and work, directions, speed and time.

The coding exam was easy, as I have provided with an stack based questions and it was easy to solve. It was an hybrid exam with interview aside.

Q1. Tell us about yourself
Add your answer
Q2. Tell us about the Mortgage Domain
Ans. 
Mortgage domain involves lending money to individuals or businesses to purchase real estate.
• Involves loans for purchasing homes, commercial properties, or land

• Includes various types of mortgages such as fixed-rate, adjustable-rate, and government-insured

• Regulated by laws and guidelines to protect both borrowers and lenders
Answered by AI
Add your answer
Q3. What is your role and domain
Add your answer

Online test consists of
1. Aptitude section
2. Coding
3. Essay writing

1. Aptitude which contains Quants + Logical + Verbal
2. Coding (2 questions)
3. Essay Writing(, 400 words in 20 mins)

Q1. Decrypting the given string
Ans. 
The question is about decrypting a given string.
• Ask for more information about the encryption method used

• Check if there are any clues or hints provided

• Try different decryption techniques such as substitution, transposition, or symmetric/asymmetric encryption

• Use online tools or libraries to assist with decryption
Answered by AI
Add your answer
Q2. DSA based question
Ans. 
Implement a function to check if a given string is a palindrome or not.
• A palindrome is a word, phrase, number, or other sequence of characters that reads the same forward and backward.

• Convert the string to lowercase and remove all non-alphanumeric characters.

• Compare the first and last characters, then the second and second-to-last characters, and so on until the middle of the string is reached.

• If all pairs match, the s...read more
Answered by AI
Add your answer
Q3. Essay topic:- which one would be given higher priority passion or salary
Ans. 
Passion or salary: which should be given higher priority?
• Passion should be given higher priority as it leads to job satisfaction and better performance

• Salary is important but it should not be the sole factor in choosing a job

• Passion can also lead to better career growth and opportunities

• However, financial stability is also important and should not be ignored completely
Answered by AI
Add your answer

Q1. Asked me to introduce myself.
Ans. 
I am a product engineer with experience in designing and developing innovative products.
• I have a degree in mechanical engineering and have worked in the field for 5 years.

• I have experience in CAD software and 3D printing.

• I have designed and developed products such as a smart water bottle and a portable solar charger.

• I am passionate about creating products that improve people's lives.
Answered by AI
View 1 more answer
Q2. Asked about my project
Ans. I did a mini project on random password generator in python and described the whole process of the project and result with validation
Answered by PrepInsta
Add your answer
Q3. Asked the difference between C and Java
Ans. 
C is a low-level language while Java is a high-level language with automatic memory management.
• C is compiled while Java is interpreted

• C has pointers while Java does not

• Java has built-in garbage collection while C does not

• Java is platform-independent while C is not

• Java has a larger standard library than C
Answered by AI
Add your answer
Q4. Asked about method overloading
Ans. 
Method overloading is a feature in OOP where multiple methods can have the same name but different parameters.
• Method overloading allows for more flexibility in programming

• The compiler determines which method to call based on the number and type of arguments passed

• Example: public void print(int num) and public void print(String str) can both be called using print() method
Answered by AI
View 1 more answer
Q5. Asked me to explain a program in any programming language I was comfortable in
Ans. 
Explained a program in a programming language I was comfortable in
• I chose to explain a program in Python

• The program was a simple calculator that could perform basic arithmetic operations

• I explained the code step by step, starting with importing the necessary modules and defining functions

• I also discussed the use of variables and data types in the program

• Finally, I demonstrated how the program could be run and tested wi
Answered by AI
View 1 more answer
Q6. Asked me to explain about OOPs concepts
Ans. 
OOPs concepts are a programming paradigm that focuses on objects and their interactions.
• OOPs stands for Object-Oriented Programming.

• It involves the use of classes, objects, encapsulation, inheritance, and polymorphism.

• Classes are templates for creating objects, while objects are instances of classes.

• Encapsulation is the process of hiding the implementation details of an object from the outside world.

• Inheritance allows ...read more
Answered by AI
View 1 more answer
Q7. Are you okay with relocation?
Ans. 
Yes, I am open to relocation for the right opportunity.
• I am willing to relocate for a challenging and rewarding role

• I am open to exploring new cities and cultures

• I understand that relocation may be necessary for career growth

• I am willing to consider relocation assistance if offered

• Examples: I have previously relocated for a job opportunity and enjoyed the experience

• I have researched the potential new location and am ex
Answered by AI
Add your answer
Q8. Are you okay signing a service bond?
Ans. 
Yes, I am willing to sign a service bond.
• I understand that a service bond is a commitment to work for a certain period of time with the company.

• I am willing to sign a service bond if it is reasonable and fair.

• I would like to know the terms and conditions of the bond before signing it.

• I believe that signing a service bond shows my commitment to the company and the product.

• Examples of reasonable service bond terms includ...read more
Answered by AI
Add your answer