Fiserv Senior Data Analyst Interview Questions and Answers

Q1. Projects, case studies and SQL
Add your answer

Q1. Projects, case studies
Add your answer

Q1. Stats, projects, leadership
Add your answer

Q1. SQL coding tests
Add your answer

Q1. Discussed about hybrid mode of work
Add your answer

Q1. What is a Transformer
Ans. 
A Transformer is a type of deep learning model that uses attention mechanisms to improve the efficiency of sequence-to-sequence tasks.
• Utilizes self-attention mechanism to weigh the importance of different input elements

• Commonly used in natural language processing tasks such as machine translation and text generation

• Examples include BERT, GPT, and Transformer-XL
Answered by AI
Add your answer

Q1. SQL questions regarding window functions
Add your answer
Q2. Calc retained revived new customer per month basis what are joins in sql what is dense rank
Ans. 
To calculate retained, revived, and new customers per month basis, joins in SQL and dense rank are used.
• To calculate retained, revived, and new customers per month basis, you would typically use SQL queries to join different tables containing customer data.

• Joins in SQL are used to combine rows from two or more tables based on a related column between them.

• Dense rank is a function in SQL that assigns a rank to each row ...read more
Answered by AI
Add your answer
Q3. How sql query work behind the scenes
Ans. 
SQL queries work by parsing and executing commands to retrieve data from databases.
• SQL query is written in a specific syntax to communicate with databases.

• The query is parsed by the database management system to understand the command.

• The database engine then executes the query to retrieve the requested data.

• Queries can involve selecting, updating, inserting, or deleting data from tables.

• Example: SELECT * FROM table_na
Answered by AI
Add your answer

Tv commercial case study regarding if we run campaign of product over television how can attribute it to spike or increase in tration which we see in our data.

Q1. Cultural fit round
Add your answer

Given Python coding challenge related to string processing and second question was matrix processing using python

Q1. Bagging boosting and its difference and uses.
Add your answer
Q2. Methods to minimize overfitting and underfitting
Add your answer
Q3. Transformer architecture
Add your answer
Q4. LLM usecase and explain how to work on it
Add your answer

Q1. Given data, find out what AI project can be discovered and how to progress on implementing it.
Add your answer
Q2. Given data and usecase, which model to use to implement solution and how detailed steps.
Add your answer

Q1. Discussed each project in my resume in detail and related questions
Add your answer
Q2. Discussed team and personal behavioural questions
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

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