Kissht Finance Data Analyst Interview Questions and Answers

Intermediate level coding round

Q1. Project explaination
Add your answer
Q2. Explain project ind detail
Ans. 
Developed a predictive analytics model to forecast customer churn for a telecommunications company.
• Collected and cleaned customer data from various sources

• Performed exploratory data analysis to identify patterns and trends

• Built a machine learning model using logistic regression to predict customer churn

• Evaluated the model's performance using metrics such as accuracy, precision, and recall
Answered by AI
Add your answer

Technical SQL Coding Round of 1 hour

Began with 2 easy generic question -
1. No. of record on different types of joins.
2. Employees who have higher salaries than their managers,

Then moved to medium questions -
1. Implement Rolling sum with & without window functions.
2. Other questions were on CTEs, Joins & other complex queries.

Bar Raiser Round of 1 hour involving -

1. Case study: How can we leverage product knowledge & analytics to increase Amazon Prime Revenue from 10% to 12%?

2. Metrics awareness: Common metrics discussion like DAU, PDAU, MAU, Retention, Churn, etc.

3. Resume based work exp discussion

Q1. Quick culture fitment round with HR discussing about past work experience, my expectations & why I want to join Jupiter.
Add your answer

Round duration - 90 Minutes
Round difficulty - Easy

Problem solving using SQL questions

Round duration - 90 Minutes
Round difficulty - Easy

A marketing campaign is run, how will you decide metrics to be tracked. Techincaly a KPI round

Q1. In a marketing campaign, how would you decide which metrics to track?
Ans. 
Metrics selection based on campaign objectives, target audience, and key performance indicators.
• Identify campaign objectives and goals

• Consider target audience and their behavior

• Select key performance indicators (KPIs) relevant to the campaign

• Track metrics such as conversion rate, click-through rate, ROI, customer acquisition cost

• Analyze data to measure success and make data-driven decisions
Answered by AI
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

Social empathatic fit round

Q1. Basic SQL questions are asked in this round Some theory questions are asked as well
Add your answer

Q1. Types of Window Function
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.

• They allow for calculations to be performed on a specific subset of rows within a query result set.

• Window functions are commonly used for running totals, moving averages, and ranking data.
Answered by AI
Add your answer
Q2. Difference between Joins with examples
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:
Answered by AI
Add your answer

Q1. How do you think Business analyst?
Ans. 
Business analysts think analytically and strategically to identify business needs and recommend solutions.
• Business analysts analyze data to identify trends and patterns.

• They work closely with stakeholders to gather requirements and understand business processes.

• They use tools such as SWOT analysis, process flow diagrams, and data modeling to recommend solutions.

• Business analysts communicate effectively to bridge the ga...read more
Answered by AI
Add your answer
Q2. Please tell me about your data analyst experience.
Add your answer
Q3. Do you have any experience on SQL or Python
Ans. 
Yes, I have experience with both SQL and Python.
• I have used SQL to query databases and extract relevant information.

• I have written Python scripts to automate data analysis and reporting tasks.

• I am familiar with using SQLAlchemy in Python for database interactions.

• I have experience with data manipulation and visualization using Python libraries like Pandas and Matplotlib.
Answered by AI
Add your answer

How to increase personal insurance revenue to 5x?

Q1. Project Management Life cycle and Scrum principles, agile methodologies, scrum framework
Add your answer
Q2. Roles and Responsibilities of BA
Ans. 
Business Analysts analyze business processes, gather requirements, and recommend solutions to improve efficiency and productivity.
• Analyzing business processes to identify areas for improvement

• Gathering and documenting business requirements from stakeholders

• Creating and maintaining project documentation such as requirements documents, use cases, and process flows

• Collaborating with stakeholders to prioritize requirements...read more
Answered by AI
Add your answer
Q3. General banking domain knowledge - Cards, Account onbaording - CA/SA/Deposits, Loans, Payments
Add your answer

Q1. Previous work experience and your contribution
Ans. 
I have 5 years of experience as a Business Analyst, where I led various projects and implemented process improvements.
• Led cross-functional teams to analyze business processes and identify areas for improvement

• Implemented new software systems to streamline operations and increase efficiency

• Developed and presented reports to senior management with actionable insights

• Collaborated with stakeholders to gather requirements a
Answered by AI
Add your answer
Q2. Banking domain questions
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Why I-Exceed?
Ans. 
I-Exceed offers innovative solutions tailored to meet the unique needs of businesses, driving efficiency and growth.
• I-Exceed provides cutting-edge technology solutions for businesses to streamline operations and enhance productivity.

• Their focus on customization ensures that each client receives a solution that fits their specific requirements.

• I-Exceed's track record of successful implementations and satisfied clients s
Answered by AI
Add your answer
Q3. Salary Discussion
Add your answer