Agivetta Consulting Interview Questions and Answers

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

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

The online assessment was broken into three individual rounds held separate days.
Online Assessment
Round 1: Aptitude test and Case Study round
Round 2: AI Communications Assessment test.
Round 3: Coding Round ( 1 DSA question + 2 SQL questions + 10-15 mcqs)

Q1. Started off with some questions were based on resume and projects.
Add your answer
Q2. Questions on sql, a. joins , b. cross join, c. what is window function d. PL/SQL query e. SDLC f. Case study
Add your answer

Quantitative Aptitude as well as Psychometric questions

Current Topics and it was very easy.

Q1. Tell me about Yourself
Ans. 
I am a market research analyst with 5 years of experience in analyzing consumer behavior and market trends.
• I have a Bachelor's degree in Marketing and a certification in Market Research.

• I have conducted surveys, focus groups, and data analysis to provide insights for product development.

• I am proficient in using statistical software like SPSS and Excel for data analysis.

• I have experience in creating reports and presenta
Answered by AI
Add your answer
Q2. Situational Based Question
Add your answer

Q1. Related to Domain
Add your answer
Q2. Some of the guesstimates to analyse analytical and problem-solving skills
Add your answer

Q1. Basic discussion
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

First round was a 1 hour online exam which had 2 sections. 1 was aptitude round which included questions like 'select the appropriate word that matches the goven word' , graph reading etc. 2nd round was technical - accounting entries , basics of SFM , FR

Video assessment - 8 questions were asked. Accrual , deferred entries, hedge fund definition , fund acconting definition , diff b/w management fee and performance fee. Question will be displayed. 1.5 mins reading time. and after should record the answer within given 2 mins time

Q1. A telephonic interview. Basic HR quesitons - about present job , why job change , expected CTC
Add your answer

Q1. Online interview - around 40-45 mins. Mostly technical. Intro about yourself , questions from resume , what did you understand about the job description , accrual and deferred entries based on given case s...read more
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).

Q1. Previous job experience and data
Ans. 
I have over 10 years of experience in data analysis and management in various industries.
• Managed and analyzed large datasets to identify trends and make data-driven decisions

• Implemented data quality control measures to ensure accuracy and reliability of data

• Collaborated with cross-functional teams to develop data-driven strategies and solutions

• Utilized data visualization tools such as Tableau and Power BI to present fi
Answered by AI
Add your answer
Q2. Tell me about yourself
Ans. 
Experienced Senior Advisor with a background in finance and strategic planning.
• Over 10 years of experience in advising senior management on financial decisions

• Skilled in developing and implementing strategic plans to drive business growth

• Strong analytical and problem-solving skills

• Excellent communication and interpersonal abilities

• Previously advised a Fortune 500 company on restructuring their investment portfolio
Answered by AI
Add your answer

Q1. 1uevusiqw aiw us aiwkak
Add your answer
Q2. Auanuwwn aiwnua auw aja ywa ah
Add your answer