Hetvi Construction Llp Interview Questions and Answers

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. Can you describe your current roles and responsibilities?
Ans. 
I am currently responsible for leading a team of data scientists, developing and implementing data-driven strategies, and ensuring the quality and accuracy of data analysis.
• Leading a team of data scientists

• Developing and implementing data-driven strategies

• Ensuring quality and accuracy of data analysis
Answered by AI
Add your answer
Q2. What are the technical details of one of your projects?
Ans. 
Developed a predictive model for customer churn using machine learning algorithms.
• Used Python for data preprocessing and model building

• Applied techniques like feature engineering and hyperparameter tuning

• Evaluated model performance using metrics like accuracy, precision, and recall
Answered by AI
Add your answer

Q1. What is the loss function used in XGBoost?
Ans. 
The loss function used in XGBoost is typically the gradient boosting algorithm.
• XGBoost uses the gradient boosting algorithm to minimize the loss function

• Common loss functions include regression loss functions like squared error and logistic loss for classification

• Users can also define custom loss functions in XGBoost
Answered by AI
Add your answer
Q2. Logical puzzle question
Add your answer

Q1. What are your professional aspirations?
Ans. 
My professional aspiration is to lead a team of data scientists to drive impactful insights and innovations.
• Lead a team of data scientists to tackle complex problems

• Drive impactful insights and innovations through data analysis

• Continuously learn and stay updated on the latest trends in data science

• Collaborate with cross-functional teams to implement data-driven solutions
Answered by AI
Add your answer
Q2. Puzzle question
Add your answer
Q3. Mathematical series question
Add your answer

Q1. What is the reason for leaving your current organization?
Ans. 
Seeking new challenges and growth opportunities in a more innovative environment.
• Desire for new challenges and growth opportunities

• Seeking a more innovative work environment

• Looking to expand skill set and knowledge in data science
Answered by AI
Add your answer
Q2. What are your reasons for wanting to join IDFC?
Ans. 
I am excited about the opportunity to contribute my data science skills to IDFC's innovative projects and make a meaningful impact.
• Excited about contributing data science skills to innovative projects at IDFC

• Opportunity to make a meaningful impact through data-driven solutions

• Interested in working with a reputable organization like IDFC
Answered by AI
Add your answer
Q3. What are your strengths and weaknesses?
Ans. 
My strengths include strong analytical skills and attention to detail. My weaknesses include a tendency to overthink and difficulty delegating tasks.
• Strengths: strong analytical skills

• Strengths: attention to detail

• Weaknesses: tendency to overthink

• Weaknesses: difficulty delegating tasks
Answered by AI
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

Q1. QC experience about the position
Ans. 
I have 5 years of experience in QC, including conducting inspections, creating quality control plans, and ensuring compliance with industry standards.
• Conducted inspections on raw materials, in-process production, and finished products

• Created and implemented quality control plans to improve product quality and reduce defects

• Ensured compliance with industry standards and regulations, such as ISO 9001 and AS9100

• Collaborat...read more
Answered by AI
Add your answer
Q2. QA experience
Add your answer

Q1. Computer software experience
Ans. 
I have extensive experience with various computer software programs, including QA testing tools and data analysis software.
• Proficient in using QA testing tools such as Selenium, JIRA, and HP Quality Center

• Skilled in data analysis software like Microsoft Excel and SQL

• Familiar with programming languages like Java and Python for automation testing

• Experience with bug tracking systems and version control tools
Answered by AI
Add your answer
Q2. Microsoft experience
Add your answer

Q1. Computer knowledge
Add your answer
Q2. Work knowledge
Add your answer

Q1. Professional knowledge
Add your answer
Q2. Periority of work
Ans. 
Prioritizing work involves identifying and organizing tasks based on their importance and urgency.
• Identify tasks that are critical to project success

• Consider deadlines and time constraints

• Communicate with team members to understand priorities

• Use tools like priority matrices or task lists

• Adjust priorities as needed based on changing circumstances
Answered by AI
Add your answer

Knowledge of computer

Q1. Year of work experience
Ans. 
I have 5 years of work experience as a QA QC Engineer.
• 5 years of work experience in QA QC engineering

• Experience in conducting quality control inspections

• Proficient in creating and implementing quality assurance processes

• Familiar with industry standards and regulations

• Strong analytical and problem-solving skills
Answered by AI
Add your answer
Q2. About the company
Add your answer

About the future company

Q1. Myself and experience in english
Add your answer
Q2. Selected for the peocess
Add your answer
Q3. Last drawn salary why you are not another process
Add your answer
Q4. Why you left last job
Add your answer
Q5. Rate ur english 1 to 10 numbers
Add your answer
Q6. Introduce yourself as a employee
Add your answer
Q7. Season topic talk for two minutes
Add your answer
Q8. How is good english
Add your answer
Q9. Your favourite place on this topic
Add your answer

Assessment via link MCQ

Q1. Microservices theory, Kafka
Add your answer
Q2. Singoloton design pattern, concurrent package, core java, collection questions, Java 8 related problem solving stream api questions
Add your answer

Q1. Same like round 1, little bit managerial
Add your answer
Q2. Producer consumer multithreading, Java 8 , core java, project
Add your answer

Q1. Behavioral questions
Add your answer
Q2. Situation based questions
Add your answer

Shortlisted students were divided in group of 19

Selected students from gd got the call for case study round

Q1. Questions were based on the case study and guesstimates
Add your answer
Q2. No. of aeroplane flying in the sky right now
Ans. 
It is impossible to accurately determine the exact number of airplanes flying in the sky at any given moment.
• The number of airplanes in the sky constantly changes due to take-offs, landings, and flights being at different stages.

• Factors such as time of day, weather conditions, and air traffic also affect the number of airplanes in the sky.

• Air traffic control systems may provide estimates of the number of airplanes in a
Answered by AI
Add your answer
Q3. How will u utilise 1 acre of land provided to u near ur college
Ans. 
I would utilize the 1 acre of land near my college for creating a sustainable community garden.
• Establishing vegetable and fruit gardens to promote healthy eating among students

• Setting up a composting area to reduce waste and enrich the soil

• Creating a space for outdoor classes and events to enhance learning and community engagement
Answered by AI
Add your answer
Q4. How to start a starbuck franchisein ur town
Ans. 
To start a Starbucks franchise in your town, you need to follow a specific process set by the company.
• Contact Starbucks corporate office to inquire about franchise opportunities

• Meet the financial requirements and submit a franchise application

• Find a suitable location for the Starbucks store

• Complete the required training and adhere to Starbucks' standards and guidelines
Answered by AI
Add your answer
Q5. Sql extraction of the given table and data
Ans. 
Use SQL query to extract data from a given table
• Use SELECT statement to retrieve data from the table

• Specify the columns you want to retrieve after SELECT

• Use FROM clause to specify the table name

• Add conditions using WHERE clause if needed

• Use ORDER BY clause to sort the results if necessary
Answered by AI
Add your answer