Fiserv Data Analyst Interview Questions and Answers

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. Sql,power bi,aptitude,technical
Add your answer
Q2. How you take criticism
Add your answer

Sql, python, statistical questions

Q1. How daily work looks like?
Ans. 
Daily work involves analyzing data, creating reports, and communicating findings to stakeholders.
• Reviewing and cleaning data sets

• Creating visualizations and dashboards

• Conducting statistical analysis

• Communicating insights to non-technical stakeholders
Answered by AI
Add your answer
Q2. Most ise tools?
Ans. 
Some of the most commonly used tools for data analysis include Excel, Python, R, Tableau, and SQL.
• Excel is widely used for data manipulation and analysis.

• Python and R are popular programming languages for data analysis and machine learning.

• Tableau is a powerful data visualization tool.

• SQL is essential for querying databases and extracting data.
Answered by AI
Add your answer

4 sql tasks on 3 tables. Joins, subqueries

Q1. Sql questions on windows functions, subquery
Add your answer
Q2. Guesstimmate on how many cricket bat is solved in a year
Ans. 
It is difficult to accurately estimate the number of cricket bats sold in a year without specific data.
• The number of cricket bats sold in a year can vary based on factors such as seasonality, popularity of cricket, and market trends.

• One approach to estimate could be to consider the total population of cricket-playing countries and the average number of bats owned by players.

• Another approach could be to look at the sale...read more
Answered by AI
Add your answer

It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.

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

Ask something abouth C+

Data Coding, 1hr, series of questions in excel