HMPL CONSULTING Interview Questions and Answers

Q1. Questions related to projects and domains
Add your answer
Q2. DSA based question
Add your answer

Q1. Team leader will ask about writing codes in different way (optimization)
Add your answer
Q2. Why would you like to join TCS, Are you Ok for Bangalore location
Ans. 
I am excited to join TCS for the opportunity to work on challenging projects and grow my skills. I am open to Bangalore location.
• Excited about working on challenging projects at TCS

• Opportunity to grow skills and knowledge

• Open to Bangalore location for work
Answered by AI
Add your answer

Q1. This round was managerial round in this round the interviewer was asking if we give you work and you have to give it before a certain deadline how will you manage your personal life.
Add your answer
Q2. As an immediate joiner we want you to come tomorrow in office is this fine for you?
Add your answer

Its very easy
Basic maths questions learned up to 10
Basic Apptitude questions

Q1. Tell me about your self Hi My name is Vikram Adithya I am an hard working and passionate engineering student currently perceiveing in gokaraju rangaraju institute of engineering and technology .I stay with...read more
Add your answer
Q2. Intervier asked about what kind of problems did you solved in leetcode? I said palindrome factorial matrix multiplication etc . Intervier said every one can solve this
Add your answer
Q3. He asked me about my project role i said I have done documentation in my project he said every one can do that
Add your answer
Q4. He asked me to write project code
Add your answer
Q5. He asked me any questions
Add your answer

Q1. What are the aml and kyc requirements?
Ans. 
AML and KYC requirements are regulations that financial institutions must follow to prevent money laundering and verify the identity of their customers.
• AML (Anti-Money Laundering) requirements involve monitoring transactions, reporting suspicious activities, and conducting customer due diligence.

• KYC (Know Your Customer) requirements involve verifying the identity of customers, assessing their risk level, and maintainin...read more
Answered by AI
Add your answer
Q2. Why should we hire you, briefly describe a scenario where you would showcase a different skill or talent compared with your fellow employees?
Ans. 
I have a strong attention to detail and analytical skills that set me apart from my colleagues.
• I have a proven track record of accurately identifying and resolving discrepancies in KYC documentation.

• I excel at conducting thorough research and analysis to ensure compliance with regulations.

• My ability to effectively communicate complex information to stakeholders sets me apart in team collaborations.
Answered by AI
Add your answer
Q3. Strength and weakness?
Ans. 
Strength: attention to detail, Weakness: perfectionism
• Strength: Ability to meticulously review documents and identify discrepancies

• Strength: Strong analytical skills to detect potential risks or fraudulent activities

• Weakness: Striving for perfection may lead to spending too much time on a task

• Weakness: Difficulty in delegating tasks due to desire for everything to be done perfectly
Answered by AI
Add your answer
Q4. Project and achievements?
Ans. 
Implemented a new KYC process resulting in 30% reduction in onboarding time and 20% decrease in errors.
• Led a team to revamp KYC procedures and systems

• Introduced automation tools to streamline verification process

• Trained staff on updated KYC regulations and best practices
Answered by AI
Add your answer
Q5. Are you a team player? What do you do when you don’t get along with certain colleagues? How do you manage conflict resolution?
Ans. 
Yes, I am a team player. I believe in open communication and collaboration. When conflicts arise, I address them directly and seek resolution.
• I believe in open communication and collaboration within the team.

• I address conflicts directly and seek resolution through constructive conversations.

• I focus on finding common ground and working towards a solution that benefits the team as a whole.
Answered by AI
Add your answer
Q6. Provide a situation where you might have failed previously? What has that experience taught you?
Ans. 
I failed to meet a deadline due to poor time management.
• Underestimated the time needed for a project

• Did not prioritize tasks effectively

• Learned to create a detailed schedule and set realistic deadlines
Answered by AI
Add your answer

General English grammar knowledge and some calculations

Q1. CTC and expected salary details?
Add your answer
Q2. No you cannot negotiate and end up taking what they give you!
Add your answer
Q3. No relocation time, do it during weekends
Add your answer
Q4. No target compensation or other benefits
Add your answer
Q5. If ur employed through agency or consultancy you will be always a contingent and treated less than permanent employees
Add your answer
Q6. 12 hours a day, 6 days a week, no social or life balance
Add your answer

Q1. Walk me through your resume. About insurance process what is policy life cycle.
Add your answer
Q2. Tell me about your previous role.
Ans. 
I was responsible for analyzing and improving processes to increase efficiency and productivity.
• Led process improvement initiatives to streamline operations

• Identified bottlenecks and implemented solutions to optimize workflows

• Collaborated with cross-functional teams to gather data and feedback

• Utilized data analysis tools to track performance metrics

• Developed and implemented process documentation and training materials
Answered by AI
Add your answer

Yet to complete the test

Q1. Asked about Gallagher.
Add your answer
Q2. What do you know about Gallagher.
Ans. 
Gallagher is a global insurance brokerage, risk management, and consulting firm.
• Founded in 1927 by Arthur J. Gallagher

• Headquartered in Rolling Meadows, Illinois

• Provides insurance, risk management, and consulting services globally

• Offers services in areas such as commercial insurance, employee benefits, and personal insurance

• Has a strong focus on client relationships and personalized service
Answered by AI
Add your answer

Q1. Situation based questions were asked.
Add your answer
Q2. How would you built the trust with the stakeholders
Ans. 
Building trust with stakeholders involves open communication, transparency, and delivering on commitments.
• Establish open lines of communication with stakeholders to address concerns and provide updates

• Be transparent about project progress, challenges, and decisions

• Deliver on commitments and follow through on promises to build credibility

• Seek feedback from stakeholders and incorporate their input into decision-making pr...read more
Answered by AI
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

Q1. SQL problem window function
Add your answer
Q2. SQL code like join and scenerio
Add your answer

Q1. Design round for adf pipeline
Ans. 
Designing an ADF pipeline for data processing
• Identify data sources and destinations

• Define data transformations and processing steps

• Consider scheduling and monitoring requirements

• Utilize ADF activities like Copy Data, Data Flow, and Databricks

• Implement error handling and logging mechanisms
Answered by AI
Add your answer
Q2. Azure synapses and adf adb
Add your answer

Q1. Expected ctc and current ctc negotiations
Ans. 
Discussing expected and current salary for negotiation purposes.
• Be honest about your current salary and provide a realistic expectation for your desired salary.

• Highlight your skills and experience that justify your desired salary.

• Be open to negotiation and willing to discuss other benefits besides salary.

• Research industry standards and salary ranges for similar positions to support your negotiation.

• Focus on the value y...read more
Answered by AI
Add your answer
Q2. Relocation and remote work until ofc open for Pune location
Add your answer

Q1. Self intro , what is payroll, tax
Add your answer
Q2. What is excel Ai, chat GPT
Ans. 
Excel AI and Chat GPT are tools that use artificial intelligence to enhance Excel functionality and enable chatbot interactions.
• Excel AI integrates AI capabilities into Excel to automate tasks and provide insights.

• Chat GPT is a chatbot platform powered by OpenAI's GPT-3 model for natural language processing.

• Both tools leverage AI to improve productivity and user experience in different ways.
Answered by AI
Add your answer
Q3. Previous experience has to share
Add your answer
Q4. Excel questions
Add your answer
Q5. What do know about current affairs
Ans. 
I stay updated on current affairs by regularly reading news articles, watching news channels, and following reputable sources on social media.
• I make it a habit to read news articles from reputable sources such as BBC, CNN, and The New York Times.

• I watch news channels like BBC News, CNN, and Al Jazeera to stay informed about global events.

• I follow reputable news sources on social media platforms like Twitter and Faceboo
Answered by AI
Add your answer

Q1. Tell about yourself
Add your answer
Q2. Please summarize your experience with analytical or programming tools (e.g. Excel, Python, R, SQL, etc) (1 min 30 s)
Ans. 
I have extensive experience with Excel, Python, R, and SQL for data analysis and programming tasks.
• Proficient in Excel for data manipulation, analysis, and visualization

• Skilled in Python for data cleaning, statistical analysis, and machine learning

• Familiar with R for statistical modeling and data visualization

• Experience with SQL for querying databases and extracting insights
Answered by AI
Add your answer
Q3. Describe your experience in working in a cusomer support/service or client-facing role (1 min)
Add your answer
Q4. Why should we hire you (1 min)
Add your answer