AARAV ENTERPRISES Interview Questions and Answers

Q1. Case studies, puzzle , Sql, guesstimate, projects
Add your answer

Q1. Puzzles, probability, work experience
Add your answer

Q1. Python, pyspark
Add your answer

Q1. Behavioral round
Add your answer

Group discussion is a very important tool in addressing various problems.

Q1. What is the count of different types of vernier calipers?
Ans. 
There are mainly two types of vernier calipers: standard vernier caliper and digital vernier caliper.
• Standard vernier caliper

• Digital vernier caliper
Answered by AI
Add your answer
Q2. What is the count of measurements in micrometers?
Ans. 
Measurements in micrometers are used for very small distances.
• Micrometers are commonly used in precision engineering and manufacturing.

• 1 micrometer is equal to 0.001 millimeters.

• Examples of measurements in micrometers include the thickness of a human hair (around 70 micrometers) and the width of a red blood cell (around 8 micrometers).
Answered by AI
Add your answer
Q3. QQC Information About the world
Add your answer

Q1. What the Quality
Ans. 
Quality in engineering refers to the characteristics of a product or service that meet or exceed customer expectations.
• Quality in engineering involves meeting specifications, standards, and requirements.

• It includes ensuring reliability, durability, and performance of the product or service.

• Quality control measures such as inspections, testing, and audits are used to maintain and improve quality.

• Continuous improvement p...read more
Answered by AI
Add your answer
Q2. What are the steps involved in Quality Control (QQC)?
Ans. 
Quality Control (QC) involves a series of steps to ensure products meet quality standards.
• 1. Establish quality standards and specifications for the product.

• 2. Create a quality control plan outlining inspection procedures and criteria.

• 3. Perform inspections and tests during production to identify defects.

• 4. Implement corrective actions to address any issues found.

• 5. Monitor and evaluate the effectiveness of the quality ...read more
Answered by AI
Add your answer

Q1. Why does Paytm company commit fraud with its agents and why does it not pay the salary of its agents on time? While working in Paytm, why is the salary held and why is the money not given?
Add your answer
Q2. Why is Paytm merchant not heard? Why is customer care number not reachable?
Add your answer
Q3. Talking about salary of 18000, why only ₹10000 is given in Paytm. Why is salary held?
Add your answer
Q4. When will I get my salary? The salary was promised on the 30th but did not come. The salary was promised on the 5th but did not come. Today is the 9th. When will my salary come? Why has my salary been put ...read more
Add your answer
Q5. How can the team leaders and HR at Paytm be so careless? Why is no one's salary being paid? Why is their salary being withheld?
Add your answer

Q1. Basic question on the tool I use in previous company and ask question on the components of it.
Add your answer

Q1. More on what is my role and managerial round.
Add your answer

Q1. 2 hour long interview with a panel of 4. Possibly every single question that can be asked and repeatedly same things. They tried understanding the process and functions elaborately way too much which was ...read more
Add your answer

Q1. Everything was already asked. But they need to drench and waste time of the candidate and themselves so they set up another round of technical to ask the same questions again and again.
Add your answer

The Aptitude Test session accesses mathematical and logical reasoning abilities

Q1. What is Vlookup
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Vlookup stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...read more
Answered by AI
Add your answer
Q2. Some IF else Question in Excel
Add your answer
Q3. What does your day in your previous organization look like?
Ans. 
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
• Reviewing and cleaning large datasets to ensure accuracy

• Creating visualizations and reports to communicate insights

• Collaborating with team members to identify trends and patterns

• Presenting findings to stakeholders in meetings or presentations
Answered by AI
Add your answer
Q4. Could you share the technical skills you possess?
Ans. 
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
• Proficient in programming languages such as Python, R, SQL

• Skilled in statistical analysis and data modeling techniques

• Experience with data visualization tools like Tableau, Power BI

• Knowledge of machine learning algorithms and techniques
Answered by AI
Add your answer
Q5. Can you explain what a Pivot Table is?
Ans. 
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.

• Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.

• Pivot tables are commonly used in Excel and other spreadsheet program...read more
Answered by AI
Add your answer
Q6. Find the Highest-paid employee in each department along with their salary and department name.
Ans. 
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
• Group employees by department

• Find the employee with the highest salary in each group

• Retrieve the employee's name, salary, and department name
Answered by AI
Add your answer

Q1. Find largest and smallest from an array
Add your answer
Q2. Reverse an array
Add your answer
Q3. Print your name in reverse
Add your answer

Q1. WALK US THROUGH YOUR RESUME.
Add your answer
Q2. WHAT ARE YOUR QUALIFICATIONS, EXPERIENCE AND BIGGEST ACHIEVEMENTS?
Ans. 
I have a Bachelor's degree in Quality Management, 5 years of experience in quality assurance, and successfully implemented a new quality control system.
• Bachelor's degree in Quality Management

• 5 years of experience in quality assurance

• Implemented a new quality control system
Answered by AI
Add your answer
Q3. HOW MANY NUMBER OF PEOPLE DO YOU DIRECTLY MANAGE AND WHAT CHALLENGES DID YOU FACE AT LAST ORGANISATION?
Add your answer
Q4. WHAT ARE YOUR PROBLEM SOLVING TECHNIQUES?
Ans. 
I use a combination of root cause analysis, brainstorming, and data analysis to solve problems efficiently.
• Identify the root cause of the problem before jumping to solutions

• Brainstorm potential solutions with a team or individually

• Use data analysis to make informed decisions and track progress

• Implement solutions and monitor results for effectiveness

• Adjust strategies as needed based on feedback and outcomes
Answered by AI
Add your answer
Q5. WHAT METRICS DID YOU ACHIEVE IN OUR LAST ORGANISATION WITH EXAMPLE?
Add your answer
Q6. WHAT IMPROVEMENTS DID YOU BRING IN YOUR CURRENT ORGANISATION, AND DO YOU GIVE INDIVIDUAL CONTRIBUTION TO THE TEAM FOR THIS OR BY GROUP?
Ans. 
I implemented a new quality control system that improved efficiency by 20% through individual contributions and team collaboration.
• Implemented a new quality control system to streamline processes

• Led training sessions for team members to ensure understanding and compliance

• Collaborated with cross-functional teams to identify and address quality issues

• Introduced regular quality audits to monitor and improve performance
Answered by AI
Add your answer
Q7. WHAT SKILLS DO YOU HAVE- KAIZEN, PROCESS EXCELLENCE, SIX SIGMA, ANY SPECIFIC CERTIFICATIONS AS- SQL OR TABLEAU, DATA STUDIO ETC?
Add your answer
Q8. WHAT ARE YOUR BIGGEST ACHIEVEMENTS IN YOUR LAST ORGANISATION, AND WHAT BRINGS YOUR INTEREST TO QUALITY?
Add your answer
Q9. HOW CLOSELY HAVE YOU WORKED WITH SUPPLY CHAIN OPERATIONS AND WHAT EXACTLY WOULD YOU DO TO REDUCE PICKING TIME IN THE WAREHOUSE?
Ans. 
I have closely worked with supply chain operations and would implement process improvements to reduce picking time in the warehouse.
• I have collaborated with supply chain teams to optimize inventory management and streamline processes.

• Implemented barcode scanning technology to improve accuracy and efficiency in picking orders.

• Analyzed data to identify bottlenecks in the picking process and implemented solutions such as ...read more
Answered by AI
Add your answer
Q10. WHAT TECHNIQUE WOULD YOU USE TO REDUCE THE SCM OPERATIONS IN A WAREHOUSE?
Ans. 
Implementing lean principles such as 5S, Kanban, and Just-in-Time inventory management can help reduce SCM operations in a warehouse.
• Implement 5S methodology to organize the warehouse and reduce waste

• Utilize Kanban system to optimize inventory levels and streamline processes

• Adopt Just-in-Time inventory management to minimize excess inventory and improve efficiency
Answered by AI
Add your answer
Q11. BASIC SITUATION, LOGICS AND GENERAL QUESTIONS.
Add your answer

The coding questions were at Leetcode difficulty level and were derived from the Striver sheet.

Q1. BFS graph level
Add your answer
Q2. Minimum flight distance . I was not shortlisted for interview.
Add your answer