AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
FNZ
Compare
Filter interviews by
FNZ Junior Analyst Interview Questions and Answers
FNZ Junior Analyst Interview Experiences
1 interview found
RIZWAN FF
I applied via Campus Placement and was interviewed in Sep 2024. There were 5 interview rounds.
Basic aptitude on coding approach
10 people discussed on a problem
Given a 13 page file and said do case study
(2 Questions)
- Q1. What you are proud of
- Ans.
I am proud of my ability to analyze complex data and provide valuable insights.
Consistently delivering accurate and actionable recommendations based on data analysis
Successfully leading a team in a project that resulted in significant cost savings for the company
Receiving recognition from senior management for my analytical skills and contributions to the team
- Q2. What you do when you feel pressurized
- Ans.
I prioritize tasks, take deep breaths, and seek help from colleagues or supervisors.
Prioritize tasks to focus on what needs to be done first
Take deep breaths to calm down and think clearly
Seek help from colleagues or supervisors if feeling overwhelmed
Practice time management techniques to stay organized and reduce stress
Two coding and one SQL question was asked
Interview Preparation Tips
Junior Analyst Jobs at FNZ
Interview questions from similar companies
Anonymous
I applied via Referral and was interviewed in Mar 2021. There were 5 interview rounds.
Interview Questionnaire
2 Questions
- Q1. About Capital Market Domain
- Q2. How you can add value to product.
- Ans.
I can add value to a product by identifying and analyzing customer needs, improving processes, and implementing innovative solutions.
Conduct market research to identify customer needs and preferences
Analyze data to identify areas for improvement in product design and functionality
Collaborate with cross-functional teams to develop and implement innovative solutions
Streamline processes to improve efficiency and reduce co...
Interview Preparation Tips
NISM certification will add value.
How to write Business requirement documents.
You must know about SQL.
Selected
I applied via Referral and was interviewed in Sep 2022. There were 4 interview rounds.
First round of test consisted of sql questions , medium and easy level
(1 Question)
- Q1. Mostly sql questions like cumulative sum
(1 Question)
- Q1. This interview was more focused on the decision making in different scenarios
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before Apr 2023. There was 1 interview round.
Aptitude tests + 3 Rounds
Interview Preparation Tips
1. The First Round was a basic guesstimate round.
2. The Second Round was a feature Discussion round about the Netflix search bar.
3. The final round was a mix of a Case Breakdown + HR + Questions about Groww.
I applied via Referral and was interviewed in Dec 2023. There was 1 interview round.
(2 Questions)
- Q1. Joins, SQL query execution
- Q2. Simple Sals Question - SQL
(2 Questions)
- Q1. Questions based on the understanding of joins in sql
- Q2. Convert row to columns using sql
- Ans.
Use SQL pivot function to convert rows to columns
Use the PIVOT function in SQL to convert rows into columns
Specify the columns you want to pivot on and the values you want to display in the new columns
Example: SELECT * FROM table_name PIVOT (MAX(value_column) FOR pivot_column IN (column1, column2, column3)) AS alias_name
Skills evaluated in this interview
Selected
I applied via Referral and was interviewed before Aug 2023. There were 3 interview rounds.
Sql mainly windows function aggregate function
How would you imprpve netflix recommendation system.
(1 Question)
- Q1. Some stat question
(2 Questions)
- Q1. NANANANANANANANA
- Q2. NANANANANANANANANA
(2 Questions)
- Q1. NANANANAANANANA
- Q2. NANANANANANANANANANA
(1 Question)
- Q1. Joins, case when
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them. Case when is a conditional statement used to perform different actions based on different conditions.
Joins are used to retrieve data from multiple tables based on a related column
Case when is used to perform different actions based on different conditions in SQL queries
Example: SELECT * FROM table1 JOIN table2 ON table1.id = ...
Skills evaluated in this interview
(1 Question)
- Q1. Result of different sql joins
- Ans.
SQL joins combine data from two or more tables based on a related column between them.
Inner join returns rows that have matching values 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 all rows when there is a match in either left or right table
Skills evaluated in this interview
FNZ Interview FAQs
Tell us how to improve this page.
FNZ Interviews By Designations
- FNZ Test Analyst Interview Questions
- FNZ Software Engineer Interview Questions
- FNZ Software Developer Interview Questions
- FNZ Test Engineer Interview Questions
- FNZ Engineering Analyst Interview Questions
- FNZ Analyst Developer Interview Questions
- FNZ Senior Test Analyst Interview Questions
- FNZ Technical Analyst Interview Questions
- Show more
FNZ Junior Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Test Analyst
120
salaries
|  ₹8 L/yr - ₹19 L/yr |
|
Analyst
7
salaries
| ₹9 L/yr - ₹18.2 L/yr |
|
Quality Analyst
6
salaries
| ₹10 L/yr - ₹16 L/yr |
|
Analyst Developer
6
salaries
| ₹10.9 L/yr - ₹30 L/yr |
|
Test Manager
5
salaries
| ₹42 L/yr - ₹45 L/yr |
Zerodha
Upstox
Groww
Paytm Money
- Home >
- Interviews >
- FNZ Interview Questions >
- FNZ Junior Analyst Interview Questions
