HMC Corporation Interview Questions and Answers

Q1. Filters in Tableau
Ans. 
Filters in Tableau allow users to focus on specific data points within a visualization.
• Filters can be applied to dimensions or measures to narrow down the data being displayed.

• Users can use various types of filters such as quick filters, context filters, and data source filters.

• Filters can be used to show or hide data based on specific criteria, such as date ranges or categories.

• Example: Applying a filter to show only
Answered by AI
Add your answer
Q2. Blending and joins in Tableau
Ans. 
Blending and joins in Tableau allow users to combine data from multiple sources for analysis and visualization.
• Blending is used when data sources have a common field but different levels of granularity.

• Joins are used when data sources have a common field and the same level of granularity.

• Blending creates a virtual join, while joins physically combine the data.

• Examples: Blending sales data from Excel with customer data ...read more
Answered by AI
Add your answer
Q3. LOD expressions in Tableau
Ans. 
LOD expressions in Tableau allow you to compute values at different levels of detail in a visualization.
• LOD expressions include FIXED, INCLUDE, and EXCLUDE functions

• FIXED LOD expressions compute values at a specific level of detail regardless of the visualization level

• INCLUDE LOD expressions compute values at the specified level of detail and include other dimensions in the visualization

• EXCLUDE LOD expressions compute ...read more
Answered by AI
Add your answer
Q4. Different types of Joins in SQL, difference between TRUNCATE and DELETE
Ans. 
Different types of joins in SQL include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. TRUNCATE is faster than DELETE as it removes all rows at once.
• Types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

• TRUNCATE: removes all rows from a table without logging individual row deletions

• DELETE: removes specific rows from a table and logs each row deletion

• TRUNCATE is faster than DELETE as it does not log individual
Answered by AI
Add your answer

Q1. About my technical experience
Add your answer
Q2. What will you do if you get the offer from multiple companies
Add your answer

Q1. Introduction, be prepared to have knowledge on your resume
Add your answer
Q2. Mathematical questions like percentage
Add your answer
Q3. Critical thinking. They asked a question with a given situation what you'll do .
Add your answer
Q4. The past 4 days been climate be stroming . And current was cut off due to rain and flood , you have a important assignment to finish, what you'll do
Add your answer

During the coding test, I was asked to write a program to check the frequency of characters in a string.

Q1. What is Java , what are the four pillars of java
Ans. 
Java is a popular programming language known for its platform independence and object-oriented approach.
• Java is platform-independent, meaning it can run on any device with a Java Virtual Machine (JVM)

• Object-oriented programming is a key feature of Java, allowing for code reusability and modularity

• The four pillars of Java are: Inheritance, Encapsulation, Abstraction, and Polymorphism

• Inheritance allows a class to inherit...read more
Answered by AI
Add your answer
Q2. Related to collection framework
Add your answer
Q3. What is recursion, write a code for it
Ans. 
Recursion is a programming technique where a function calls itself to solve a problem.
• Recursion involves breaking down a problem into smaller subproblems and solving them recursively.

• A base case is needed to stop the recursion and prevent infinite loops.

• Example: Factorial calculation using recursion - function factorial(n) { return n === 0 ? 1 : n * factorial(n-1); }
Answered by AI
Add your answer
Q4. Why we don't use pointers in java
Ans. 
Java doesn't use pointers for security and simplicity reasons.
• Java uses references instead of pointers to avoid direct memory manipulation.

• Pointers can lead to memory leaks and security vulnerabilities.

• Java's garbage collection manages memory automatically, reducing the need for pointers.
Answered by AI
Add your answer
Q5. What are the difference between array and arraylist
Ans. 
Array is a fixed-size data structure while ArrayList is a dynamic-size data structure in Java.
• Array is a fixed-size collection of elements of the same data type, while ArrayList is a dynamic-size collection that can grow or shrink.

• Arrays can store primitive data types and objects, while ArrayList can only store objects.

• Arrays require a specified size at the time of declaration, while ArrayList can dynamically resize it...read more
Answered by AI
Add your answer

Q1. Types of Chunking in data preparation in RAG
Add your answer
Q2. How Embedding works in Vector Databases
Add your answer
Q3. Explain ARIMA model
Add your answer
Q4. How can we decide to choose Linear Regression for a business problem
Add your answer

Q1. What is token and it's limit for Open Source LLMs
Add your answer
Q2. Difference of a Regression and Time Series problem
Add your answer
Q3. Advantage of LSTM over RNN
Add your answer
Q4. Performance Metrics for Logistic Regression
Add your answer

The test will comprise a total of 60 questions, divided as follows: 70% of the questions will focus on finance and accounting, while the remaining questions will cover aptitude and English.

Q1. Zero coupon bonds, long-term liabilities, return on equity, debt-equity ratio, captial budgeting and techniques, bonds and its types, debt instruments meaning, collateral, mortgage, spin off, demerger, mer...read more
Add your answer

Q1. Write your own implementation for shared pointer. How it will handle if it get assigned by another one. How will you use it in main method. How will you overload -> operator and dereferencing operator in t...read more
Ans. 
Implementation of shared and unique pointers in C++ with operator overloading.
• Implement a class for shared pointer with reference counting.

• Handle assignment by incrementing reference count and decrementing old pointer's count.

• Overload -> and * operators to access underlying object.

• Use shared pointer in main method by creating instances and passing them around.

• For unique pointer, implement a class that transfers ownersh
Answered by AI
Add your answer
Q2. Simple problem for binary search but input values are double not integer
Add your answer

Q1. Given bst find two values from tree which will give you required sum. In two pointer is it better to use middle-out instead of starting from both end probabilistically
Add your answer
Q2. Design splitwise like add and explain
Add your answer

Q1. Write signature of shared pointer
Add your answer
Q2. Design system similar to load balancer where if request comes again with same id it should go to server it went for first time. with constant space complexity
Add your answer
Q3. Design system where there is org hierarchy and you should be able to find all sub-ordinates Optimize is using array of pointer
Ans. 
Design a system with org hierarchy to find all sub-ordinates using array of pointers.
• Create a class for each employee with a pointer to their manager

• Use an array of pointers to store all employee objects

• Traverse the array to find all sub-ordinates of a given employee
Answered by AI
Add your answer
Q4. Write lambda function and it's signature
Add your answer
Q5. Do you know about template Class and function template
Add your answer
Q6. How does auto work internally?
Add your answer

Q1. Are you ready to shift to bengaluru
Ans. 
Yes, I am ready to shift to Bengaluru for the c++ associate position.
• I am excited about the opportunity to work in Bengaluru.

• I have researched the city and am comfortable with the relocation.

• I am flexible and adaptable to new environments.

• I have friends/family in Bengaluru who can support me during the transition.
Answered by AI
Add your answer

Q1. Tell me about yourself.
Ans. 
Experienced internal auditor with a background in finance and risk management.
• Over 5 years of experience in internal auditing

• Strong background in finance and risk management

• Skilled in conducting audits, identifying risks, and implementing controls

• Proficient in analyzing financial data and preparing reports

• Excellent communication and interpersonal skills
Answered by AI
Add your answer
Q2. Family background
Add your answer
Q3. What activities did you engage in during your articleship?
Ans. 
During my articleship, I engaged in various activities such as auditing financial statements, conducting internal control reviews, and assisting in risk assessment.
• Auditing financial statements

• Conducting internal control reviews

• Assisting in risk assessment
Answered by AI
Add your answer
Q4. What is the process of conducting an internal audit?
Ans. 
The process of conducting an internal audit involves planning, executing, reporting, and follow-up.
• Plan the audit by defining objectives, scope, and methodology.

• Gather relevant data and evidence through interviews, document reviews, and observations.

• Analyze the data to identify risks, control weaknesses, and areas for improvement.

• Report findings to management and recommend corrective actions.

• Follow up on implementation...read more
Answered by AI
Add your answer
Q5. What is the difference between internal and statutory audits?
Ans. 
Internal audits are conducted by internal staff to evaluate and improve the effectiveness of risk management, control, and governance processes within an organization, while statutory audits are required by law and are conducted by external auditors to ensure compliance with financial reporting standards.
• Internal audits are conducted by internal staff, while statutory audits are conducted by external auditors.

• Internal ...read more
Answered by AI
Add your answer

Q1. Tell me about your self
Add your answer
Q2. Tell me about your experience
Add your answer
Q3. How to know chola
Ans. 
Chola can be known through various methods such as historical records, archaeological findings, and cultural practices.
• Study historical records and documents related to the Chola dynasty

• Explore archaeological sites and artifacts associated with the Chola civilization

• Learn about the cultural practices, art, and architecture of the Chola period

• Consult experts and scholars in the field of Chola history and culture
Answered by AI
Add your answer
Q4. Do you have any experience about loan sales
Add your answer
Q5. How to handled pressure
Ans. 
I handle pressure by staying organized, prioritizing tasks, and maintaining a positive attitude.
• Stay organized by creating to-do lists and setting deadlines

• Prioritize tasks based on urgency and importance

• Maintain a positive attitude by focusing on solutions rather than problems
Answered by AI
Add your answer
Q6. How to manage travelling
Ans. 
Managing travelling involves proper planning, organization, and time management.
• Create a detailed itinerary with travel dates, times, and locations.

• Pack efficiently and only bring necessary items to avoid overpacking.

• Utilize travel apps and tools to stay organized and informed.

• Stay flexible and be prepared for unexpected delays or changes in plans.

• Prioritize rest and self-care to avoid burnout during travel.

• Stay connec...read more
Answered by AI
Add your answer
Q7. Do you have experience of pure field work
Add your answer

Q1. Work experience and relevance of your resume for Amex
Ans. 
My work experience includes roles in financial services and consulting, providing me with relevant skills for Amex.
• I have worked in financial services for 5+ years, including roles at a major bank and a fintech startup.

• I have experience in consulting, where I worked on projects related to financial analysis and strategy development.

• My resume highlights my expertise in financial modeling, data analysis, and client relat...read more
Answered by AI
Add your answer
Q2. Why change to Amex? What attracted you the most about Amex?
Ans. 
I changed to Amex for its reputation for innovation, strong company culture, and opportunities for growth.
• Reputation for innovation in the financial industry

• Strong company culture focused on employee development and diversity

• Opportunities for career growth and advancement within the company
Answered by AI
Add your answer
Q3. Technology questions such as how API works and your experience in working with data?
Add your answer
Q4. How you used data management and analytics in your last role?
Ans. 
I utilized data management and analytics to track project progress, identify trends, and make data-driven decisions.
• Implemented data management systems to organize and store project data efficiently

• Utilized analytics tools to analyze project performance and identify areas for improvement

• Generated reports and dashboards to track key metrics and communicate findings to stakeholders

• Used data insights to make informed deci
Answered by AI
Add your answer
Q5. How you can make business decisions from data in your last role?
Ans. 
I used data analysis tools to identify trends, patterns, and correlations to inform strategic business decisions.
• Utilized data visualization tools to present key findings to stakeholders

• Conducted regression analysis to predict future outcomes based on historical data

• Collaborated with cross-functional teams to gather and analyze data from multiple sources
Answered by AI
Add your answer
Q6. How you solved any disagreement with your boss in last role?
Ans. 
I always approach disagreements with a focus on finding common ground and maintaining open communication.
• Listen actively to understand the boss's perspective

• Express my own perspective calmly and respectfully

• Seek a compromise or solution that benefits both parties

• Follow up to ensure the issue is fully resolved
Answered by AI
Add your answer
Q7. How will you approach different teams with requirements as a product manager?
Ans. 
I will approach different teams with requirements by understanding their unique needs, building relationships, and communicating effectively.
• Understand the goals and priorities of each team to tailor requirements accordingly

• Build relationships with key stakeholders to gain buy-in and support

• Communicate clearly and regularly to ensure alignment and address any concerns

• Collaborate with cross-functional teams to ensure al
Answered by AI
Add your answer

Q1. Logical Questions - Check out Geeks for Geeks Puzzles and memorise them all or atleast understand logic for each
Add your answer
Q2. 3 ants around a triangle problem
Add your answer
Q3. Find top 3 horses from 25 horses set
Ans. 
To find the top 3 horses from a set of 25 horses, we can sort them based on their performance or rankings.
• Sort the horses based on their performance or rankings

• Select the top 3 horses from the sorted list

• Consider factors like speed, endurance, and previous race results
Answered by AI
Add your answer
Q4. How will you approach conflicts at workplace?
Ans. 
I approach conflicts at workplace by actively listening, understanding all perspectives, and finding a mutually beneficial solution.
• Actively listen to all parties involved in the conflict

• Seek to understand the root cause of the conflict

• Encourage open communication and dialogue

• Find a mutually beneficial solution that addresses the concerns of all parties

• Mediate if necessary to facilitate resolution
Answered by AI
Add your answer

Q1. Behavioural questions
Add your answer
Q2. How will you manage work life balance?
Ans. 
I prioritize tasks, set boundaries, delegate when necessary, and make time for self-care.
• Prioritize tasks based on deadlines and importance

• Set boundaries by establishing work hours and sticking to them

• Delegate tasks to team members when overwhelmed

• Schedule time for self-care activities like exercise, hobbies, and relaxation

• Communicate with supervisors and colleagues about workload and availability
Answered by AI
Add your answer
Q3. What are the 3 pillars of data management?
Ans. 
The 3 pillars of data management are data quality, data governance, and data security.
• Data quality ensures that data is accurate, complete, and reliable.

• Data governance involves establishing policies and procedures for managing data assets.

• Data security focuses on protecting data from unauthorized access or breaches.
Answered by AI
Add your answer
Q4. How will you solve disputes and disagreements with your manager?
Ans. 
I will approach disputes with my manager by actively listening, seeking common ground, and proposing solutions collaboratively.
• Actively listen to my manager's perspective and concerns

• Seek common ground and areas of agreement

• Propose solutions collaboratively, considering both perspectives

• Maintain professionalism and respect throughout the discussion

• Seek feedback and learn from the experience to prevent future conflicts
Answered by AI
Add your answer