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. How manage major incident management.
Ans. 
Major incident management involves identifying, prioritizing, and resolving critical issues to minimize impact on business operations.
• Establish a clear process for reporting and escalating major incidents.

• Prioritize incidents based on impact and urgency to ensure timely resolution.

• Communicate effectively with stakeholders to provide updates on incident status and resolution.

• Document incidents and resolutions for future...read more
Answered by AI
Add your answer
Q2. Difference between SLAandOLA
Ans. 
SLA is a formal agreement between a service provider and a customer, while OLA is an agreement between different teams within the same organization.
• SLA is between a service provider and a customer, outlining the services provided, quality, responsibilities, etc.

• OLA is between different teams within the same organization, defining the interdependent relationships and responsibilities.

• SLA is external, OLA is internal.

• SLA...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. About splunk topics. Thry asked sbout alerts, reports snd dashboards
Add your answer
Q2. Unix commands and shell scripting and few scenarios
Add your answer

Q1. Package discussion and about the shift
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. What are your salary expectations?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. Where do you see yourself in 5 years?
Add your answer
Q4. What are your strengths and weaknesses?
Add your answer
Q5. Tell me about yourself.
Add your answer

Q1. Aiw?nnnnnnnnnnnnn? Mmmma q
Add your answer