AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
FNZ
Work with us 
Compare
Filter interviews by
FNZ Interview Questions and Answers
36 Interview questions
To handle a multi-day scenario, I would prioritize tasks, maintain clear communication, and ensure thorough documentation.
Break down the scenario into manageable tasks and set daily goals.
Use a project management tool to track progress and deadlines.
Communicate regularly with team members to address any issues.
Document findings and changes daily to maintain clarity.
Example: If testing a new software feature over s...
A comprehensive leave management software for employees to request, approve, and track leave efficiently.
User Authentication: Employees log in securely to access their leave requests.
Leave Types: Define various leave types (e.g., sick leave, vacation, personal leave).
Request Submission: Employees can submit leave requests with start and end dates.
Approval Workflow: Managers receive notifications to approve or reje...
Dependency injection is a design pattern that allows a program to achieve Inversion of Control by injecting dependencies into a class.
Promotes loose coupling between classes, making them easier to test and maintain.
Facilitates better code organization and separation of concerns.
Commonly used in frameworks like Spring (Java) and Angular (JavaScript).
Example: Instead of a class creating its own dependencies, they ar...
SIT focuses on interactions between integrated systems, while UAT validates the system's functionality for end-users.
SIT tests the interfaces and data flow between integrated systems, ensuring they work together as expected.
UAT is conducted by end-users to verify that the system meets their requirements and is ready for deployment.
Example of SIT: Testing how a payment gateway integrates with an e-commerce platform...
SQL inner joins combine rows from two or more tables based on related columns, enabling complex data retrieval.
Inner joins return only the rows with matching values in both tables.
Example: Joining 'Customers' and 'Orders' tables to find customers with orders.
Syntax: SELECT columns FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Useful for generating reports that require data from multiple sources.
Ex...
The Singleton Design Pattern restricts a class to a single instance and provides a global access point to that instance.
Ensures a class has only one instance, e.g., a configuration manager.
Provides a global point of access, e.g., logging service.
Lazy initialization to create the instance only when needed.
Thread-safe implementation to handle concurrent access.
Commonly used in database connections and resource manag...
IQueryable allows for querying data from a data source with deferred execution, while IEnumerable is for in-memory collections.
Deferred Execution: IQueryable queries are executed only when the data is actually needed, while IEnumerable executes immediately.
Data Source: IQueryable is designed for querying data from external sources like databases, whereas IEnumerable is for in-memory collections.
LINQ Support: IQuer...
WHERE filters rows before aggregation, while HAVING filters groups after aggregation in SQL queries.
Purpose: WHERE is used to filter records before any groupings are made, while HAVING is used to filter records after grouping.
Usage: WHERE can be used with SELECT, UPDATE, DELETE statements; HAVING is typically used with GROUP BY.
Example of WHERE: SELECT * FROM Employees WHERE Salary > 50000; // Filters employees...
DbContext is a core class in Entity Framework that manages database connections and entity interactions for data operations.
Database Connection Management: DbContext handles the connection to the database, allowing for easy querying and saving of data.
Entity Tracking: It tracks changes made to entities, enabling automatic updates to the database when SaveChanges() is called.
LINQ Queries: DbContext allows the use o...
HTTP methods GET, PUT, and POST are used for data retrieval and manipulation in web applications, each serving distinct purposes.
GET: Used to retrieve data from a server. Example: Fetching user details from '/api/users/1'.
PUT: Used to update existing data on a server. Example: Updating user information at '/api/users/1'.
POST: Used to send new data to a server. Example: Creating a new user with data sent to '/api/u...
FNZ Interview Experiences
37 interviews found
Anonymous
Selected
I appeared for an interview in May 2025, where I was asked the following questions.
- Q1. What was your primary skill set? What's your experience level in SQL?
- Ans.
I specialize in SQL with extensive experience in database management, data analysis, and query optimization.
Proficient in writing complex SQL queries for data retrieval and manipulation.
Experience with database design and normalization to ensure data integrity.
Skilled in performance tuning and optimization of SQL queries to improve efficiency.
Familiar with various SQL databases like MySQL, PostgreSQL, and SQL Server.
Wo...
- Q2. Few questions based on a few key achievements I had mentioned in my resume (Technical), and further follow-up questions based on key topics/tool I mentioned.(Literally drilled me down on few things I menti...
- Ans.
I successfully led projects that improved efficiency and user satisfaction, showcasing my analytical and development skills.
Developed a data analytics tool that reduced report generation time by 40%, enhancing decision-making processes.
Implemented a new software feature based on user feedback, resulting in a 25% increase in user engagement.
Collaborated with cross-functional teams to streamline workflows, which improved...
- Q3. And the interviewer showed a slide with tables and queries and asked a few questions there. Eg., What's the business meaning of this query, etc.,
- Q4. Also there was a practical exercise where I was given a laptop and some requirements to build a simple Console App. And fired bunch of questions based on the code I wrote.
I appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. Difference between Abstract Class and Interface.
- Ans.
Abstract classes provide a base for subclasses with shared code, while interfaces define a contract for implementing classes without code.
Abstract Class: Can have both abstract methods (without implementation) and concrete methods (with implementation). Example: `abstract class Animal { void eat(); void sleep() { ... } }`.
Interface: Only contains abstract methods (until Java 8, after which default methods are allowed)....
- Q2. Difference between WHERE and HAVING clauses in SQL.
- Ans.
WHERE filters rows before aggregation, while HAVING filters groups after aggregation in SQL queries.
Purpose: WHERE is used to filter records before any groupings are made, while HAVING is used to filter records after grouping.
Usage: WHERE can be used with SELECT, UPDATE, DELETE statements; HAVING is typically used with GROUP BY.
Example of WHERE: SELECT * FROM Employees WHERE Salary > 50000; // Filters employees with...
- Q3. Difference between IQueryable and IEnumerable.
- Ans.
IQueryable allows for querying data from a data source with deferred execution, while IEnumerable is for in-memory collections.
Deferred Execution: IQueryable queries are executed only when the data is actually needed, while IEnumerable executes immediately.
Data Source: IQueryable is designed for querying data from external sources like databases, whereas IEnumerable is for in-memory collections.
LINQ Support: IQueryable...
- Q4. Explain HTTP methods: GET, PUT, and POST.
- Ans.
HTTP methods GET, PUT, and POST are used for data retrieval and manipulation in web applications, each serving distinct purposes.
GET: Used to retrieve data from a server. Example: Fetching user details from '/api/users/1'.
PUT: Used to update existing data on a server. Example: Updating user information at '/api/users/1'.
POST: Used to send new data to a server. Example: Creating a new user with data sent to '/api/users'...
- Q5. What is the Liskov Substitution Principle (LSP) from SOLID?
- Ans.
LSP states that objects of a superclass should be replaceable with objects of a subclass without affecting program correctness.
Subtypes must be substitutable for their base types without altering the desirable properties of the program.
Example: If 'Bird' is a base class, 'Sparrow' and 'Penguin' should be subclasses that can replace 'Bird'.
Violating LSP can lead to unexpected behavior, such as methods failing when calle...
- Q6. How does multiple inheritance work using interfaces in C#?
- Ans.
C# supports multiple inheritance through interfaces, allowing a class to implement multiple contracts without ambiguity.
Interface Definition: An interface in C# is defined using the 'interface' keyword and can contain method signatures, properties, events, and indexers.
Multiple Implementation: A class can implement multiple interfaces, allowing it to inherit behaviors from multiple sources. Example: 'class MyClass : IF...
- Q7. SQL query combining JOIN and SUBQUERY — asked to trace a value.
- Ans.
Combining JOIN and SUBQUERY in SQL helps trace specific values across related tables efficiently.
JOIN combines rows from two or more tables based on a related column.
SUBQUERY is a query nested inside another SQL query.
Example of JOIN: SELECT * FROM Orders JOIN Customers ON Orders.CustomerID = Customers.CustomerID;
Example of SUBQUERY: SELECT * FROM Products WHERE ProductID IN (SELECT ProductID FROM OrderDetails WHERE Qu...
- Q8. How can you optimize SQL queries? (Follow-up on CTEs too.)
- Ans.
Optimizing SQL queries improves performance and efficiency, reducing execution time and resource usage.
Use indexes: Create indexes on columns frequently used in WHERE clauses. Example: CREATE INDEX idx_name ON table_name(column_name);
Avoid SELECT *: Specify only the columns you need. Example: SELECT column1, column2 FROM table_name;
Use WHERE clauses: Filter data as early as possible. Example: SELECT * FROM table_name W...
- Q9. What is DbContext in Entity Framework, and its role?
- Ans.
DbContext is a core class in Entity Framework that manages database connections and entity interactions for data operations.
Database Connection Management: DbContext handles the connection to the database, allowing for easy querying and saving of data.
Entity Tracking: It tracks changes made to entities, enabling automatic updates to the database when SaveChanges() is called.
LINQ Queries: DbContext allows the use of LIN...
- Q10. Explain the Singleton Design Pattern and its use cases.
- Ans.
The Singleton Design Pattern restricts a class to a single instance and provides a global access point to that instance.
Ensures a class has only one instance, e.g., a configuration manager.
Provides a global point of access, e.g., logging service.
Lazy initialization to create the instance only when needed.
Thread-safe implementation to handle concurrent access.
Commonly used in database connections and resource management...
Interview Preparation Tips
I appeared for an interview in Jan 2025.
The assessment consists of a combination of aptitude questions, reasoning questions, business analyst questions, testing questions, and one SQL question; all are multiple-choice questions except for the SQL query. It is an overall easy round administered through the HackerRank platform, with a minimum passing mark of 65%.
(4 Questions)
- Q1. Different bt system testing vs UAT testing
- Ans.
System testing is done by testers to ensure the system meets requirements, while UAT is done by end users to validate the system's functionality.
System testing is performed by testers to identify defects and ensure the system meets specified requirements.
UAT (User Acceptance Testing) is conducted by end users to validate the system's functionality and ensure it meets business needs.
System testing focuses on technical a...
- Q2. UAT scenario based questions with any website given
- Q3. Bug life cycle
- Q4. Easy testing questions nothing critical
Interview Preparation Tips
Artyom Yeprikyan
I applied via Approached by Company and was interviewed in Oct 2024. There were 4 interview rounds.
(3 Questions)
- Q1. Salary Expectation
- Ans.
I expect a competitive salary that reflects my experience and the industry standards for a Senior Developer Analyst role.
Research industry standards: For example, Glassdoor and Payscale indicate that Senior Developer Analysts typically earn between $90,000 and $130,000 annually.
Consider my experience: With over 7 years in software development and analysis, I believe a salary in the upper range is justified.
Location mat...
- Q2. Work Experience
- Q3. Relocation Plans
Codility Test General C# and SQL
(9 Questions)
- Q1. (live coding) Create a class Employees with fields FirstName LastName, DoB, and Gender Return avg age of employees, return avg age by genders
- Ans.
Create a class Employees with fields FirstName LastName, DoB, and Gender. Return avg age of employees and avg age by genders.
Create a class Employees with fields FirstName, LastName, DoB, and Gender
Calculate the average age of all employees
Calculate the average age by genders
- Q2. What design pattern you know
- Ans.
I am familiar with design patterns such as Singleton, Factory, Observer, and MVC.
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Factory pattern creates objects without specifying the exact class of object that will be created.
Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and up...
- Q3. SOLID principles
- Q4. How to optimize SQL Queries
- Ans.
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using EXISTS or IN clauses instead
Optimize query structure by using appropriate joins and subqueries
- Q5. Which type of Indexes you know
- Ans.
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
Clustered index: Physically reorders the data in the table based on the index key.
Non-clustered index: Contains a sorted list of references to the table data rows.
Unique index: Ensures that no two rows have the same values in the indexed columns.
Composite index: Index that is created on multiple columns.
Filtered index: Index that...
- Q6. Have you ever read SQL Execution Plan?
- Ans.
Yes, I have read SQL Execution Plans to optimize query performance.
I have analyzed SQL Execution Plans to identify bottlenecks in queries.
I have used SQL Execution Plans to optimize query performance by understanding how the database engine executes queries.
I have made query optimization recommendations based on SQL Execution Plans.
I have experience with tools like SQL Server Management Studio to view and analyze Execu...
- Q7. .NET Framework DI 3th party tools
- Q8. Are you familiar with MSUnit, xUnit, nUnit
- Ans.
MSUnit, xUnit, and nUnit are popular testing frameworks for .NET applications, facilitating unit testing and test-driven development.
MSUnit is a Microsoft testing framework, primarily for legacy applications.
xUnit is a modern, extensible framework that supports parallel test execution.
nUnit is widely used for .NET applications, offering a rich set of assertions and test case management.
Example: xUnit allows for easy in...
- Q9. Unit Testing libraries (e.g Bogus, Moq..)
(3 Questions)
- Q1. What questions do you have?
- Q2. How was your interview's?
- Ans.
The interviews were insightful, challenging, and provided a great opportunity to showcase my skills and experience.
The first interview focused on technical skills, where I solved coding challenges in real-time.
In the second round, I discussed my previous projects, highlighting my role in a successful software deployment.
The final interview included behavioral questions, allowing me to demonstrate my problem-solving and...
- Q3. Why you want to change your job?
- Ans.
I'm seeking new challenges and opportunities for growth that align with my career goals and aspirations.
Desire for professional growth: I'm looking for a role that offers more opportunities for advancement and skill development.
Interest in new technologies: I want to work with cutting-edge technologies that can enhance my expertise and keep me engaged.
Cultural fit: I'm seeking a company culture that aligns more closely...
Interview Preparation Tips
Skills evaluated in this interview
Vishal Gupta
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 3 interview rounds.
(3 Questions)
- Q1. There were around 20-22 questions which were 5 SQL questions that you can solve by joins or sub-query.
- Q2. Some wealth management domain questions
- Q3. Aptitude and reasoning
(3 Questions)
- Q1. Difference between UAT and System testing
- Ans.
UAT is user acceptance testing where end users validate the system, while system testing is done by testers to validate the system against requirements.
UAT is done by end users to ensure the system meets their requirements and is ready for production.
System testing is done by testers to validate the system against functional and non-functional requirements.
UAT focuses on user scenarios and real-world usage, while syste...
- Q2. Write test cases for given scenarios
- Ans.
Test cases for various scenarios to ensure software quality and functionality.
Verify user login with valid credentials.
Check error message for invalid login attempts.
Test data input fields for required validations.
Ensure system handles edge cases, like empty fields.
Validate user permissions for different roles.
- Q3. Questions around JIRA, test reports metrics
(2 Questions)
- Q1. Why do you want to switch
- Ans.
I want to switch to explore new challenges and opportunities in the field of software testing.
Seeking growth and advancement in my career
Interested in gaining experience in a different industry or technology
Looking for a more challenging and dynamic work environment
- Q2. Scenario based questions where they just want you to answer - Yes I will work on weekend and 14 hours a day.
Interview Preparation Tips
For the cultural round accept you are a slave and willing to work on weekends and 12 hours a day on any scenario based question.
Prepare yourself to be asked at-least 5 times in each round why do you want to switch you job.
Also they are not going to share any updates with you. Most frustrating thing is they want you to come to office to just attend the cultural round on zoom call in their meeting room.
Skills evaluated in this interview
Selected
I applied via Recruitment Consulltant
It was easy. You can easily solve them
(2 Questions)
- Q1. Bug life cycle and STLC
- Q2. Types of testing and about project
- Ans.
Types of testing include functional, non-functional, manual, automated, regression, performance, and user acceptance testing.
Functional testing ensures that the software functions as intended.
Non-functional testing focuses on aspects like performance, security, and usability.
Manual testing involves human testers executing test cases.
Automated testing uses tools to automate test case execution.
Regression testing checks ...
(2 Questions)
- Q1. About last company
- Q2. About project
Interview Preparation Tips
- SQL
- Types of test
I applied via Campus Placement and was interviewed in Oct 2024. There were 6 interview rounds.
120 mins test. including 6 sections comprising of 3 hr type ques and 3 section of problem solving, puzzles of very very high level, maths related question
Similiar to round 1 but in this round we have to record our video of explaining how i solved the question. it included less number of ques compare to round 1.
Round 3 happened after 2 months. it was happened in FNZ office. it was a casestudy round. i was given a 10 page detailed document that i need to explain to my interviewer and he asked some question regarding my observations
(2 Questions)
- Q1. It was a resume based interviw. interviewer checked my resume and asked a good question from every subheading either it would be my cgpa or project or my leader ship experience of worrking on ground. he gr...
- Q2. He asked me a guesstimate ques. it was easy aptitude ques and discussed my full approach and he said it was correct.
We were given a case study and we have to do 10 mins group discussion on that.
3 ques were their. one was of sql(hard ques). one greedy ques of codeforces div2 B. and one was codeforces div 3 A type ques based on sorting.
Interview Preparation Tips
I applied via Walk-in and was interviewed in Dec 2024. There were 2 interview rounds.
Five sections, total duration of 75 minutes, consisting of 23 questions on HackerRank.
(2 Questions)
- Q1. In progress the process is
- Q2. Will update as soon as its done
I applied via LinkedIn and was interviewed in Nov 2024. There were 3 interview rounds.
First Round is Aptitude Round.
Second Round is technical inteview.
Third round is HR Round.
(2 Questions)
- Q1. Rotate a array by D places.
- Ans.
Rotate an array of strings by D places.
Create a temporary array to store elements that will be rotated
Copy elements from original array to temporary array based on rotation
Copy elements back from temporary array to original array
- Q2. Find Maximum in subarray
- Ans.
To find the maximum value in a subarray within an array of numbers.
Iterate through the array and keep track of the maximum value seen so far.
For each subarray, compare the maximum value with the current element and update if necessary.
Return the maximum value found in the subarray.
(1 Question)
- Q1. What is Your Strength and weakness Family background why do we hire you
- Ans.
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes being too critical of my own work. I come from a supportive family background and believe my qualifications make me a strong candidate for this role.
Strength: Analytical skills
Strength: Attention to detail
Weakness: Being too critical of my own work
Family background: Supportive and encouraging
Qualifications make me a strong ...
RUDRA PRASAD MAHARANA
(2 Questions)
- Q1. OOPS concept implementation in TAF.
- Ans.
OOPS concepts like inheritance, encapsulation, and polymorphism can be implemented in Test Automation Framework (TAF) to improve code reusability and maintainability.
Inheritance: Create a base test class with common methods and properties, then extend it in specific test classes.
Encapsulation: Use access modifiers to control the visibility of methods and properties, ensuring data integrity.
Polymorphism: Implement metho...
- Q2. String manipulation coding question.
Top trending discussions
FNZ Interview FAQs
The duration of FNZ interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
FNZ Interviews By Designations
- FNZ Test Analyst Interview Questions
- FNZ Analyst Developer Interview Questions
- FNZ Software Engineer Interview Questions
- FNZ Software Developer Interview Questions
- FNZ Test Engineer Interview Questions
- FNZ Engineering Analyst Interview Questions
- FNZ Senior Software Engineer Interview Questions
- FNZ Technical Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 37 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
|
Test Analyst
152
salaries
|  ₹10 L/yr - ₹18 L/yr |
|
Analyst Developer
46
salaries
| ₹14.7 L/yr - ₹30.3 L/yr |
|
Test Manager
25
salaries
| ₹21.3 L/yr - ₹57 L/yr |
|
Analyst
18
salaries
| ₹6 L/yr - ₹17.7 L/yr |
|
Software Engineer
14
salaries
| ₹25 L/yr - ₹30 L/yr |
FIS
Broadridge Financial Solutions
PayPal
TransUnion
- Home >
- Interviews >
- FNZ Interview Questions
