Gallup Interview Questions and Answers

Common aptitude questions on mettl platform

Q1. Python Standard interview questions
Add your answer
Q2. SQL Standard interview questions (Easy)
Add your answer
Q3. CaseStudy and questions based on it.
Add your answer

Q1. Common hr questions
Add your answer
Q2. Puzzles
Add your answer
Q3. Project Discussion
Add your answer

Q1. Time you worked under pressure, with a team
Add your answer

Writing Sample based on HBR

Case study on 4 day work week using RCA

Q1. Big data , Optimization , Python basic , SQL intermediate
Add your answer
Q2. Find max and min number without sorting Joins related Big data handling Optimization question
Add your answer

Q1. Schema , python , sql
Add your answer
Q2. Case study sql and python based
Add your answer

Sales data from a leading manufacturer

Q1. What is spark,explain its ecosystem
Add your answer
Q2. What are transformations, and how many types of transformations exist?
Add your answer
Q3. Explain about spark job process and its planning
Add your answer
Q4. What are the concepts of coalesce and repartition in data processing?
Add your answer
Q5. Explain about oom and driverhead memory
Add your answer
Q6. What is data skewness
Add your answer

Normal to medium level general aptitude questions

Q1. Types of building contract
Add your answer
Q2. Type of soil for each buildings
Add your answer

Q1. Assesment day GD for 2 rounds
Add your answer
Q2. All situational based questions
Add your answer

Q1. Explain projects worked on and benefits
Add your answer
Q2. What is agile , SDLC, user stories
Ans. 
Agile is a project management methodology focused on iterative development, SDLC is the software development life cycle, and user stories are short descriptions of a feature told from the perspective of the end user.
• Agile is a project management approach that emphasizes flexibility, collaboration, and customer feedback.

• SDLC is the process of planning, creating, testing, and deploying software applications.

• User stories ...read more
Answered by AI
Add your answer

Q1. How will to create a new market in vietnam for LC/BG
Ans. 
To create a new market in Vietnam for LC/BG, we can start by conducting market research, building relationships with local businesses and government agencies, and offering tailored financial solutions.
• Conduct market research to understand the needs and preferences of Vietnamese businesses

• Build relationships with local banks, businesses, and government agencies to establish credibility and trust

• Offer tailored financial ...read more
Answered by AI
Add your answer
Q2. What is acceptance criteria
Ans. 
Acceptance criteria are conditions that a product must satisfy to be accepted by a user, customer, or stakeholder.
• Acceptance criteria are typically defined during the planning phase of a project.

• They are used to determine whether a product or feature is complete and functioning as expected.

• Acceptance criteria are often written in a specific format, such as 'Given X, when Y, then Z.'

• They help ensure that the product mee...read more
Answered by AI
Add your answer

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