FNZ Interview Questions and Answers

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%.

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...read more
Answered by AI
Add your answer
Q2. UAT scenario based questions with any website given
Add your answer
Q3. Bug life cycle
Add your answer
Q4. Easy testing questions nothing critical
Add your answer

Q1. Salary Expectation
Add your answer
Q2. Work Experience
Add your answer
Q3. Relocation Plans
Add your answer

Codility Test General C# and SQL

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
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
Q3. SOLID principles
Add your answer
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
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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
Answered by AI
Add your answer
Q7. .NET Framework DI 3th party tools
Add your answer
Q8. Are you familiar with MSUnit, xUnit, nUnit
Add your answer
Q9. Unit Testing libraries (e.g Bogus, Moq..)
Add your answer

Q1. What questions do you have?
Add your answer
Q2. How was your interview's?
Add your answer
Q3. Why you want to change your job?
Add your answer

Q1. There were around 20-22 questions which were 5 SQL questions that you can solve by joins or sub-query.
Add your answer
Q2. Some wealth management domain questions
Add your answer
Q3. Aptitude and reasoning
Add your answer

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...read more
Answered by AI
Add your answer
Q2. Write test cases for given scenarios
Add your answer
Q3. Questions around JIRA, test reports metrics
Add your answer

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
Answered by AI
Add your answer
Q2. Scenario based questions where they just want you to answer - Yes I will work on weekend and 14 hours a day.
Add your answer

It was easy. You can easily solve them

Q1. Bug life cycle and STLC
Add your answer
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 ...read more
Answered by AI
Add your answer

Q1. About last company
Add your answer
Q2. About project
Add your answer