Agivetta Consulting 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. Technical Accounting Questions
Add your answer
Q2. Technical Accounting Questions
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. What is Derivatives
Add your answer
Q2. What is financial Markets
Add your answer
Q3. V Lookup, X Lookup, H lookup
Add your answer
Q4. Experience in SQL And Power bi
Add your answer
Q5. Internship Experience
Add your answer

Q1. How do you manage feedback and various editing requests?
Add your answer

Q1. How would you approach executing a video production assignment, from scriptwriting to recording?
Add your answer

Q1. Write a blog for the executive suite on a topic they will provide
Add your answer

Some basic questions related to profit, time, and distance.

Identify the missing number in the array and remove the duplicate string from another string, then write the remaining portion.

Q1. What is rest api's
Ans. 
REST APIs are a set of rules and conventions for building and interacting with web services.
• REST stands for Representational State Transfer

• Uses standard HTTP methods like GET, POST, PUT, DELETE

• Data is transferred in JSON or XML format

• Stateless communication between client and server

• Example: GET request to retrieve data from a server
Answered by AI
Add your answer
Q2. What is components
Ans. 
Components in software development are modular, reusable parts of a system that perform specific functions.
• Components are building blocks of a software system

• They are designed to be modular and reusable

• Each component performs a specific function or set of functions

• Examples include buttons, forms, navigation bars in a web application
Answered by AI
Add your answer
Q3. Some related to github
Add your answer
Q4. Explain about api testing
Ans. 
API testing involves testing the functionality, reliability, performance, and security of APIs.
• API testing ensures that the API functions as expected and meets the requirements.

• It involves testing the input parameters, output, authentication, error codes, and response time.

• Tools like Postman, SoapUI, and JMeter are commonly used for API testing.

• API testing can be done manually or automated using scripts.

• Common types of...read more
Answered by AI
Add your answer

Q1. Explain about your project
Ans. 
Developed a web application for online food ordering and delivery service
• Used React.js for front-end development

• Implemented Node.js and Express.js for back-end functionality

• Integrated payment gateway for secure transactions
Answered by AI
Add your answer
Q2. What is the logical problem involving 2 rooms, 3 bulbs, and 3 switches?
Add your answer

1. Poor Communication: There was a lack of clear communication from management, leading to confusion and misunderstandings among employees.

2. Unprofessional Behavior: Employees or management displayed unprofessional behavior, such as disrespectful comments or inappropriate conduct in the workplace.

3. Lack of Support: Employees felt unsupported by their supervisors, with little to no guidance on how to perform their tasks effectively.

4. Overwork and Burnout: Employees were consistently overworked with unrealistic deadlines, leading to high levels of stress and burnout.

5. Inadequate Training: New hires received insufficient training, resulting in mistakes and frustration both for themselves and their teams.

6. Toxic Work Environment: The workplace culture was toxic, with favoritism, gossip, and hostility among team members.

7. Unfair Treatment: There was a perception of unfair treatment regarding promotions, pay raises, and workload distribution.

8. Lack of Career Growth: Employees felt there were no opportunities for advancement or professional development within the company.

9. Poor Management: Management was seen as ineffective, lacking leadership skills and failing to motivate or inspire the team.

10. Product or Service Issues: The company had ongoing problems with its products or services, leading to customer complaints and dissatisfaction.

These points can help illustrate a negative experience within a company, highlighting various aspects that contribute to an unpleasant work environment.

Q1. What is bpo ?
Ans. 
BPO stands for Business Process Outsourcing, where a company contracts out specific business processes to a third-party provider.
• BPO involves outsourcing non-core business functions such as customer service, technical support, and data entry.

• Companies often choose to outsource these functions to reduce costs and focus on their core competencies.

• Popular BPO destinations include India, the Philippines, and Eastern Europe...read more
Answered by AI
Add your answer
Q2. Where are you from ?
Add your answer

It was an hour-long coding round, asked questions on basic pandas slicing dicing, building simple regression model, handling class imbalance in SVM

Q1. Mostly resume based, went deep into projects and asked basics of ML algorithms, ML Ops and OOPS concepts
Add your answer

Q1. Resume based questions, basics of Machine Learning, and small case study (problem formulation and feature brainstorming)
Add your answer

Q1. Different types of ML models, how they work, differences among them. Types of performance metrics, pros and cons of them, etc.
Ans. 
Different types of ML models, how they work, differences among them, types of performance metrics, pros and cons.
• Types of ML models include linear regression, decision trees, support vector machines, neural networks, etc.

• ML models work by learning patterns from data to make predictions or decisions.

• Differences among models include complexity, interpretability, scalability, and performance.

• Performance metrics for ML mod...read more
Answered by AI
Add your answer

Develop a solution for inventory optimization of a Shoe retailer. Forecast sales and plan inventory at a store level for a national seller.

Why you want to join the company, Simple case (how do you use analytics to clear stock of a particular seasonal product after the peak season).