Ambit Group Interview Questions and Answers

Q1. What is the Look and Say sequence, and how can a program be written to generate the next number in this sequence?
Add your answer
Q2. What is the SQL query to perform a join on two tables and calculate the aggregate sum using the product ID?
Add your answer
Q3. What is the process for writing a Bash script to read and parse a CSV file and print the last character of each line?
Add your answer

Platform: Coderbyte Test. The process is similar to the technical round, except that in the last bash script question, instead of printing the last character, print the third last character of each line.

Q1. Can you tell me about yourself?
Add your answer
Q2. What are the principles of Continuous Integration and Continuous Deployment (CI/CD)?
Add your answer
Q3. What version control tools do you use, and can you explain how you utilize them?
Add your answer
Q4. What is the SQL query to join two tables and use aggregate functions such as SUM and AVG with GROUP BY?
Add your answer
Q5. What is the Bash command to suppress all output and errors?
Add your answer

Q1. Can you tell me about yourself and your family?
Add your answer
Q2. Are you comfortable with the possibility of relocating for the position?
Add your answer
Q3. Would it be acceptable to work shift timings from 6:30 AM to 3:30 PM considering that the client is based in New Zealand?
Add your answer

Q1. Could you provide a description of yourself and an overview of your career accomplishments?
Add your answer
Q2. What are your reasons for wanting to leave your current company?
Add your answer
Q3. What are your salary expectations?
Add your answer

Q1. Interviewer will describe the scenario and discuss the UX terminologies?
Add your answer
Q2. Whiteboarding conducted
Add your answer

Q1. Tech questions and UX related questions were asked
Add your answer

Q1. Manager Round was conducted
Add your answer

Q1. Implement a custom stack that allows fetching the minimum element in constant time, O(1).
Add your answer
Q2. How can one create an immutable class named Employee with fields for name and hobbies defined as List?
Add your answer
Q3. What changes are required in the Employee class to use it as a key for a HashMap?
Add your answer
Q4. What is the implementation of the singleton design pattern?
Add your answer
Q5. Different ways to create a thread
Add your answer
Q6. What are the SOLID principles in software design, and can you provide examples for each?
Add your answer

Q1. What is the concept of Object-Oriented Programming (OOP) and can you provide an example?
Add your answer
Q2. How do threads communicate with each other in Java?
Add your answer
Q3. Write a program to reverse a linked list.
Add your answer
Q4. What is the difference between string literals and the string pool?
Add your answer
Q5. What is the program to print the 90-degree rotated view of a 2D array?
Add your answer

Q1. What are the key topics related to Generative AI, specifically focusing on Retrieval-Augmented Generation (RAG) and Large Language Models (LLM)?
Add your answer
Q2. What is your understanding of the existing project and the technology stacks used?
Add your answer

Q1. What has been your contribution to existing work and the technologies used in that context?
Add your answer
Q2. ML, DL, Gen AI implementation and flow
Add your answer
Q3. Python Coding logic and semantics
Add your answer

Q1. What are the existing work challenges you face, and what solutions have you implemented to address them?
Add your answer
Q2. What is your understanding of Generative AI and Natural Language Processing (NLP), and can you provide examples of their use cases?
Add your answer

Difference between soft skills and hard skills

Q1. What is manual testing
Add your answer
Q2. What is defect life cycleif
Add your answer

Q1. What is the main thing should have for a test engineer
Add your answer
Q2. What's your opinion on testing
Add your answer

Q1. Are you ok with rotational shifts?
Add your answer
Q2. Are you ok with the work location?
Add your answer

The assessment consists of a one-hour aptitude test that includes questions on data structures and algorithms (DSA) as well as SQL query questions, where I am required to write SQL queries, followed by two coding questions.

Our group discussion topic is whether AI can replace human intelligence.

Q1. Oops concept in java
Ans. 
Oops concept in Java refers to Object-Oriented Programming principles like inheritance, encapsulation, polymorphism, and abstraction.
• Inheritance allows a class to inherit properties and behavior from another class.

• Encapsulation refers to bundling data and methods that operate on the data into a single unit.

• Polymorphism allows objects to be treated as instances of their parent class.

• Abstraction hides the implementation ...read more
Answered by AI
Add your answer
Q2. What is compile time polymorphism
Ans. 
Compile time polymorphism is the ability of a programming language to select which method to execute at compile time based on the method signature.
• Compile time polymorphism is achieved through method overloading and operator overloading.

• Method overloading allows multiple methods in the same class with the same name but different parameters.

• The compiler determines which method to call based on the number and type of arg...read more
Answered by AI
Add your answer
Q3. What is the SQL query to select and display the name of person who have highest salary among employees?
Ans. 
SQL query to select and display the name of person with highest salary among employees.
• Use the MAX() function to find the highest salary

• Join the employee table with the salary table using a common key like employee_id

• Select the name of the person with the highest salary
Answered by AI
Add your answer

Q1. Tell me about yourself. then about final year project.
Ans. 
I am a dedicated QA Automation Testing Engineer with experience in creating and executing test cases. My final year project involved developing a test automation framework using Selenium.
• Experienced QA Automation Testing Engineer

• Skilled in creating and executing test cases

• Developed test automation framework using Selenium for final year project
Answered by AI
Add your answer
Q2. What is your family background, and are you prepared to relocate?
Ans. 
I come from a close-knit family with a diverse background. I am open to relocating for the right opportunity.
• Family background is close-knit and diverse

• Open to relocating for the right opportunity
Answered by AI
Add your answer

Some basic testing questions

Q1. Selenium waits, java oops , priority vs severity
Add your answer
Q2. Write a selenium code by using assertions
Add your answer

Q1. Write selenium code and execute on screen
Add your answer
Q2. Write an sql query and get the desired output on screen
Add your answer

Q1. Salary expectations
Add your answer
Q2. Notice period related
Add your answer

Q1. How do you go about SDLC process
Ans. 
I follow the Software Development Life Cycle (SDLC) process to ensure successful project delivery.
• I start with requirements gathering and analysis to understand the project scope and objectives.

• I then move on to design, where I create a detailed plan for how the system will be built.

• Next, I proceed to development, where the actual coding and implementation of the system takes place.

• After development, I conduct thorough...read more
Answered by AI
Add your answer
Q2. What are roles and responsibilities of a BA
Add your answer
Q3. How do you deduce a complex problem statement
Ans. 
By breaking down the problem into smaller components and analyzing each part individually
• Identify the key components of the problem statement

• Break down the problem into smaller, more manageable parts

• Analyze each part individually to understand its impact on the overall problem

• Consider different perspectives and potential solutions

• Collaborate with team members or stakeholders to gain additional insights
Answered by AI
Add your answer

Q1. Explain the difference between BRD and FRD
Ans. 
BRD is a document that outlines business requirements, while FRD is a document that details functional requirements.
• BRD focuses on what the business needs, while FRD focuses on how those needs will be met.

• BRD is high-level and non-technical, while FRD is detailed and technical.

• BRD is created before FRD in the project lifecycle.

• Example: BRD may state the need for a customer relationship management system, while FRD will...read more
Answered by AI
Add your answer
Q2. How do you go about creating user stories, how do you allocate the points
Ans. 
User stories are created by collaborating with stakeholders and allocating points based on complexity and effort required.
• Collaborate with stakeholders to gather requirements and understand user needs

• Break down features into smaller, manageable user stories

• Prioritize user stories based on business value and dependencies

• Allocate points based on complexity, effort, and risk involved

• Use techniques like Planning Poker to a
Answered by AI
Add your answer
Q3. What is the SOP while creating a requirement gathering doc
Ans. 
The SOP for creating a requirement gathering doc involves planning, interviewing stakeholders, documenting requirements, and obtaining approval.
• Plan the requirement gathering process by identifying stakeholders and their needs

• Conduct interviews with stakeholders to gather detailed requirements

• Document the requirements in a clear and organized manner

• Obtain approval from stakeholders to ensure alignment with business goa
Answered by AI
Add your answer

Q1. How proficient are you with using tools such as Jira, Cofluence, SQL
Ans. 
I am highly proficient in using Jira, Confluence, and SQL for various business analysis tasks.
• I have extensive experience using Jira for project management, issue tracking, and agile development.

• I am skilled in using Confluence for documentation, collaboration, and knowledge sharing within teams.

• I have strong SQL skills for data analysis, querying databases, and generating reports.

• I have used these tools in previous pr...read more
Answered by AI
Add your answer
Q2. How do you handle disagreements within internal stakeholders
Add your answer
Q3. What values do you look in a collegue
Ans. 
I look for values such as integrity, teamwork, communication, and adaptability in a colleague.
• Integrity - honesty, trustworthiness, and ethical behavior

• Teamwork - collaboration, support, and willingness to help others

• Communication - clear and effective communication skills

• Adaptability - ability to adjust to changing circumstances and problem-solve
Answered by AI
Add your answer