FIS Senior Lead Analyst Interview Questions and Answers

Q1. Project related questions
Add your answer
Q2. Financial instruments knowledge
Add your answer

Q1. General project related questions
Add your answer
Q2. Financial domain in depth questions
Add your answer

Q1. SQL case study for data
Add your answer
Q2. Find nth salary
Add your answer

Q1. SQL Joins and remove duplicates
Add your answer
Q2. Function to create a transaction bin column
Ans. 
Create a function to generate a transaction bin column based on transaction amounts.
• Create bins based on transaction amounts (e.g. $0-$100, $101-$200, etc.)

• Use pandas cut() function in Python to create bins

• Assign bin labels to the transactions based on the bin ranges
Answered by AI
Add your answer

Q1. Questions asked mostly related to SQL only.
Add your answer

Q1. Mix of questions are expected depending on interviewer i guess, -> few apititude questions on probability, PnC, 6 * 6 Grid Square questions -> Business case study questions on [how will you evaulate few m...read more
Add your answer

Q1. This is probably the elimination round. Majorly focus on 2 portions 1. project discussions mentioned in your resume [cross questioning will be here alot] 2. Case study dicussion
Add your answer

Q1. A tough sql question
Add your answer

Topics were, DSA, SQL, PL/SQL, Data Augmentation

Customer churn classification using a classification ML model

Q1. Write a pseudo code for Bubble sort
Ans. 
Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements, and swaps them if they are in the wrong order.
• Start with the first element and compare it with the next element, swapping if necessary

• Repeat this process for each pair of adjacent elements in the array until the entire array is sorted

• Continue this process for each element in the array until no more swaps are ne
Answered by AI
Add your answer
Q2. What is an API
Ans. 
An API (Application Programming Interface) is a set of rules and protocols that allows different software applications to communicate with each other.
• APIs define the methods for requesting and receiving data between software applications

• APIs can be used to access data from external sources, such as social media platforms or weather services

• Examples of APIs include the Twitter API, Google Maps API, and Spotify API
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Graduated with a degree in Statistics

• Proficient in programming languages like Python and R

• Experience in analyzing large datasets and creating data visualizations

• Strong problem-solving skills and attention to detail
Answered by AI
Add your answer
Q2. Salaray compensation how much
Add your answer

Q1. Common question like about yourself
Add your answer
Q2. Questions like stlc and roles responsibilities
Add your answer
Q3. How to do uat testing
Ans. 
UAT testing involves testing the system in a real-world scenario by end users to ensure it meets their requirements.
• Understand the requirements and scope of the system

• Create test cases based on user scenarios

• Execute test cases with real users

• Document and report any issues found

• Obtain user feedback for improvements
Answered by AI
Add your answer
Q4. What is agile process
Ans. 
Agile process is a project management approach that emphasizes flexibility, collaboration, and incremental development.
• Agile process involves breaking down projects into small, manageable tasks called user stories.

• It focuses on frequent communication and collaboration between team members.

• Iterations, or sprints, are used to deliver working software in short timeframes.

• Adaptability and responding to change are key princ...read more
Answered by AI
Add your answer
Q5. What kind of testing is done in past
Ans. 
Various types of testing were conducted in the past including functional testing, regression testing, performance testing, and user acceptance testing.
• Functional testing to ensure the software functions as expected

• Regression testing to check for any new bugs introduced after changes

• Performance testing to assess the speed and stability of the software

• User acceptance testing to validate if the software meets user require
Answered by AI
Add your answer

Q1. Basic questions about resume
Add your answer

Q1. Workplace adjustment questions
Add your answer
Q2. Are you willing to work extra hours
Add your answer