Avalon Global Research Interview Questions and Answers

It was online test conducted by whee box. Questions were mix from Automation and Manual testing. Questions on OOPS concept like Encapsulation, polymorphism, abstraction. Questions on Database testing, (none from API). Few questions based on English , few logical reasoning

Q1. API questions - Put vs patch , error codes, API tools used
Add your answer
Q2. Explain STLC in detail
Ans. 
STLC stands for Software Testing Life Cycle, which is a systematic process for testing software applications.
• STLC consists of various phases such as Requirement Analysis, Test Planning, Test Design, Test Execution, and Test Closure.

• Each phase has specific objectives and deliverables to ensure the quality of the software.

• STLC helps in identifying defects early in the development cycle, reducing the cost of fixing them l...read more
Answered by AI
Add your answer
Q3. Introduction, current role
Add your answer
Q4. Current CTC , Expected CTC
Add your answer
Q5. Agile ceremonies
Add your answer
Q6. Stored procedure in DB
Ans. 
Stored procedures are precompiled SQL statements stored in the database for reuse and improved performance.
• Stored procedures are used to encapsulate business logic in the database.

• They can improve performance by reducing network traffic and optimizing execution plans.

• Stored procedures can be called from application code to perform complex operations on the database.

• They can also help with security by controlling access...read more
Answered by AI
Add your answer
Q7. Ready for working in night shift for US based client
Add your answer
Q8. Requirement traceability matrix
Add your answer

Q1. Quick Introduction and role in current project
Ans. 
I am a Senior QA Engineer with 5 years of experience. Currently, I am leading the testing efforts for a web application project.
• Leading the testing efforts for a web application project

• Creating test plans and test cases

• Executing manual and automated tests

• Identifying and reporting bugs

• Collaborating with developers and stakeholders
Answered by AI
Add your answer
Q2. Questions related to agile ceremonies
Add your answer
Q3. API tools used, % of API work done in previous projects
Ans. 
Used Postman for API testing, 60% of work involved API testing in previous projects
• Utilized Postman for API testing

• 60% of work in previous projects involved API testing

• Worked extensively with RESTful APIs
Answered by AI
Add your answer
Q4. Scenario based questions on QA
Add your answer
Q5. Role of QA when the built functionality do not match with requirements
Ans. 
QA plays a crucial role in identifying and communicating the discrepancies between built functionality and requirements.
• QA should thoroughly review the requirements documentation to understand the expected functionality.

• QA should conduct thorough testing to identify any discrepancies between the built functionality and the requirements.

• QA should communicate any discrepancies found to the development team and stakeholde...read more
Answered by AI
Add your answer
Q6. Contract testing in API
Ans. 
Contract testing in API involves verifying the interactions between different services based on predefined contracts.
• Contract testing ensures that each service meets the expectations set by the contract.

• It helps in detecting issues early in the development cycle.

• Popular tools for contract testing in APIs include Pact and Spring Cloud Contract.
Answered by AI
Add your answer
Q7. Overall tools used for database, build deployment, bug tracking, test case/plan track
Ans. 
Various tools used for database, build deployment, bug tracking, and test case/plan tracking in QA engineering.
• Database: SQL Server, MySQL, Oracle

• Build Deployment: Jenkins, TeamCity, Bamboo

• Bug Tracking: Jira, Bugzilla, Redmine

• Test Case/Plan Tracking: TestRail, HP ALM, Zephyr
Answered by AI
Add your answer
Q8. New things which you contributed to current project to improve overall quality process
Ans. 
Implemented automated test scripts using Selenium for regression testing, introduced code review process for test scripts, and conducted training sessions on new testing tools.
• Implemented automated test scripts using Selenium for regression testing

• Introduced code review process for test scripts

• Conducted training sessions on new testing tools
Answered by AI
Add your answer
Q9. How many offer letters you hold? Current CTC, Expected CTC
Ans. 
I currently hold 2 offer letters. My current CTC is $80,000 and my expected CTC is $90,000.
• I hold 2 offer letters

• Current CTC is $80,000

• Expected CTC is $90,000
Answered by AI
Add your answer
Q10. Comfortable in coming to office regularly although it was hybrid model
Ans. 
Yes, I am comfortable with coming to the office regularly in a hybrid model.
• I value face-to-face interactions with team members for better collaboration and communication.

• I am able to manage my time effectively to balance office and remote work.

• I understand the importance of being present in the office for certain tasks or meetings.

• I am adaptable and flexible in my work environment.
Answered by AI
Add your answer
Q11. Any experience in working with US based clients, Ready for shift overlapping
Ans. 
Yes, I have experience working with US based clients and I am ready for shift overlapping.
• I have worked with US based clients in my previous role as a QA Engineer

• I am familiar with the time zone differences and have adjusted my schedule accordingly

• I am comfortable with shift overlapping and have done it before when needed
Answered by AI
Add your answer
Q12. RCA and backtracking process in current project
Ans. 
RCA and backtracking process involves identifying root causes of issues and revisiting previous steps to find solutions.
• Root Cause Analysis (RCA) is used to identify the underlying cause of a problem or defect in the project.

• Backtracking process involves revisiting previous steps or decisions to find a solution or correct an issue.

• Examples of RCA in current project could include analyzing code changes that led to a bug...read more
Answered by AI
Add your answer
Q13. Experience in automation testing, any learning in AI or other
Ans. 
I have extensive experience in automation testing and have also taken courses in AI and machine learning.
• I have worked on creating automation frameworks using tools like Selenium and Appium.

• I have taken online courses on AI and machine learning to enhance my skills in these areas.

• I have implemented AI-based testing techniques like neural networks for test automation.
Answered by AI
Add your answer

Q1. What is your previous work experience?
Add your answer
Q2. What is the talent acquisition process?
Add your answer

Q1. How do you handle employee grievances?
Add your answer
Q2. What is the onboarding process in your organization?
Add your answer

Q1. Qualification & self introduction
Add your answer
Q2. What is work at height? It's hazards and precaution
Add your answer

Q1. What is legal documents
Add your answer
Q2. What is tandem lifting
Add your answer

Puzzle solving was done which were moderate in difficulty level and you can ask for hints.

Q1. Data modelling techniques in tableau
Ans. 
Data modelling techniques in Tableau involve creating relationships between data sources to analyze and visualize data effectively.
• Use data blending to combine data from multiple sources

• Create calculated fields to manipulate and transform data

• Utilize hierarchies and groups to organize data for analysis

• Implement filters and parameters to control data display

• Leverage Tableau's data modeling tools like joins and unions
Answered by AI
Add your answer
Q2. Explain your projects.
Add your answer
Q3. RLS implementation
Add your answer

Q1. Vhhjjkhuhhhhjjhhhb
Add your answer
Q2. Cvvbbhjjjjjkkkkkm
Add your answer
Q3. Fggvghhhhjjcxfhjjjjhggyhjjj
Add your answer
Q4. Yyyttuhgguiihhjjjjj
Add your answer
Q5. Ftugguhjiikkhhhjj
Add your answer

Q1. What is status of company
Ans. 
The company is currently in a stable financial position with ongoing projects and a strong reputation in the industry.
• Company has a strong financial position

• Ongoing projects are in progress

• Company has a good reputation in the industry
Answered by AI
Add your answer
Q2. What is job responsibilities
Add your answer
Q3. What is employee growth
Ans. 
Employee growth refers to the development and advancement of an individual within their career.
• Employee growth involves acquiring new skills and knowledge

• It includes taking on more responsibilities and challenges

• Career progression and promotions are indicators of employee growth
Answered by AI
Add your answer
Q4. What is action points at site level
Ans. 
Action points at site level refer to specific tasks or activities that need to be completed on the construction site.
• Action points are typically identified during site inspections or progress meetings.

• They can include tasks such as resolving design issues, coordinating with subcontractors, or ensuring compliance with regulations.

• Examples of action points could be revising drawings to address conflicts, obtaining necess...read more
Answered by AI
Add your answer
Q5. Talking with politely with client
Add your answer
Q6. Very day site round, observation point noted and review with team
Add your answer
Q7. Communication with our team, project achievements as per client requirement
Add your answer
Q8. Project target as per the P O terms
Add your answer
Q9. Internal discussion with project team and vendor
Add your answer

Q1. Why this role is complicated
Add your answer
Q2. What u know about sql
Ans. 
SQL is a programming language used for managing and manipulating databases.
• SQL stands for Structured Query Language

• It is used to communicate with databases to perform tasks such as querying data, updating records, and creating tables

• Common SQL commands include SELECT, INSERT, UPDATE, DELETE

• SQL is used in various database management systems such as MySQL, PostgreSQL, and Oracle
Answered by AI
Add your answer