Tandon Urban Solutions Interview Questions and Answers

Q1. C# question ,asp.net question
Add your answer
Q2. Sql server question
Add your answer

Logical reasoning, pseudo codes, mathematical equations

Q1. Explain OOPS in java
Ans. 
OOPS in Java stands for Object-Oriented Programming System, which is a programming paradigm based on the concept of objects.
• OOPS focuses on creating objects that interact with each other to solve a problem

• It involves concepts like inheritance, encapsulation, polymorphism, and abstraction

• Java supports OOPS principles through classes and objects
Answered by AI
Add your answer
Q2. Data Structure, Basic SQL queries
Add your answer
Q3. Define abstract method and abstract class
Ans. 
Abstract method is a method without implementation in abstract class which cannot be instantiated. Abstract class is a class with abstract methods.
• Abstract method is declared in abstract class without implementation

• Abstract class cannot be instantiated, only used as a base for other classes

• Abstract class can have both abstract and non-abstract methods

• Example: abstract class Animal { abstract void makeSound(); }

• Example:
Answered by AI
Add your answer

Q1. Why should we hire you?
Ans. 
I have a strong technical background, excellent problem-solving skills, and a passion for software development.
• I have a Bachelor's degree in Computer Science and 5 years of experience in software development.

• I have successfully completed multiple projects using various programming languages and technologies.

• I am a quick learner and always eager to expand my knowledge and skills in the field.
Answered by AI
Add your answer
Q2. What challenges your faced in life?
Ans. 
I have faced challenges in balancing work and personal life, overcoming imposter syndrome, and adapting to new technologies.
• Balancing work and personal life: Juggling deadlines at work while making time for family and friends.

• Overcoming imposter syndrome: Feeling like I don't belong in the tech industry and constantly doubting my abilities.

• Adapting to new technologies: Learning new programming languages and tools to st
Answered by AI
Add your answer

Q1. Importance of Hibernates
Ans. 
Hibernate is an ORM tool in Java used for mapping Java classes to database tables.
• Hibernate simplifies the development of Java applications by providing a framework for mapping an object-oriented domain model to a traditional relational database.

• It eliminates the need for writing complex SQL queries by allowing developers to work with objects instead of tables.

• Hibernate provides caching mechanisms to improve performanc...read more
Answered by AI
Add your answer

Q1. Why you want to join in V-Soft?
Add your answer

Q1. What do data analysts do?
Ans. 
Data analysts collect, process, and analyze data to help organizations make informed decisions.
• Collect and organize data from various sources

• Clean and preprocess data to ensure accuracy

• Analyze data using statistical techniques and tools

• Create visualizations and reports to present findings

• Identify trends and patterns in data to provide insights

• Help organizations make data-driven decisions
Answered by AI
Add your answer
Q2. What is your process for cleaning data?
Ans. 
My process for cleaning data involves identifying and handling missing values, removing duplicates, standardizing formats, and detecting outliers.
• Identify and handle missing values by either imputing them with mean/median values or removing the rows/columns with missing data.

• Remove duplicates to ensure each data point is unique.

• Standardize formats such as date formats, text case, and units of measurement.

• Detect and han...read more
Answered by AI
Add your answer

Q1. Tell me something about yourself.
Ans. 
I am a highly motivated and detail-oriented individual with a strong background in consulting.
• I have a Bachelor's degree in Business Administration with a focus on consulting.

• I have completed internships at top consulting firms, where I gained experience in conducting market research and analyzing data.

• I am skilled in problem-solving and have a proven track record of delivering effective solutions to clients.

• I am a str...read more
Answered by AI
Add your answer
Q2. What drives you toward doing something?
Ans. 
I am driven by a desire to make a positive impact and constantly challenge myself.
• I am motivated by the opportunity to make a difference in people's lives.

• I thrive on pushing myself to achieve new goals and overcome challenges.

• I am driven by a passion for continuous learning and personal growth.

• I find fulfillment in using my skills and knowledge to solve complex problems.

• I am motivated by the satisfaction of seeing the...read more
Answered by AI
Add your answer
Q3. Why would you choose A&M?
Ans. 
A&M is a top consulting firm known for its expertise, global reach, and client-focused approach.
• A&M has a strong reputation in the consulting industry

• A&M has a global presence with offices in major cities around the world

• A&M is known for its client-centric approach and delivering results

• A&M offers diverse and challenging projects that provide opportunities for growth and learning

• A&M has a collaborative and supportive w
Answered by AI
Add your answer
Q4. What can you bring to the company? List your 5 qualities or skills which would help this company grow.
Ans. 
I can bring a unique combination of analytical skills, problem-solving abilities, strong communication, leadership qualities, and a passion for continuous learning.
• Analytical skills: I have a strong background in data analysis and can effectively analyze complex business problems to provide valuable insights.

• Problem-solving abilities: I excel at identifying and resolving challenges by thinking critically and creatively...read more
Answered by AI
Add your answer
Q5. Can you estimate the number of chairs sold in India in a year?
Ans. 
It is difficult to estimate the exact number of chairs sold in India in a year due to lack of available data.
• There is no centralized database for chair sales in India

• The number of chairs sold varies greatly depending on the region, market demand, and type of chair

• Factors such as population growth, urbanization, and economic conditions can also impact chair sales

• Estimates can be made based on industry reports and survey
Answered by AI
Add your answer
Q6. What do you first consider in a race?
Ans. 
In a race, I first consider the starting position, competition, and strategy.
• Starting position: The position from which the race begins can have a significant impact on the outcome.

• Competition: Assessing the skills, strengths, and weaknesses of the competitors helps in formulating a strategy.

• Strategy: Developing a plan based on the race distance, terrain, and individual capabilities is crucial.

• Example: In a sprint race...read more
Answered by AI
Add your answer
Q7. Can you estimate the number of jhumkas sold by a shop in Bareilly Since you are from Bareilly?
Ans. 
It is not possible to estimate the number of jhumkas sold by a shop in Bareilly without additional information.
• The number of jhumkas sold depends on various factors such as the popularity of the shop, the price of the jhumkas, the season, and the target audience.

• Without knowing the above factors, it is impossible to estimate the number of jhumkas sold by a shop in Bareilly.

• Even if I am from Bareilly, it does not give m...read more
Answered by AI
Add your answer
Q8. Can you estimate the number of trees in Lucknow?
Ans. 
It is not possible to estimate the number of trees in Lucknow without proper data and analysis.
• Estimating the number of trees in a city requires a comprehensive survey and analysis.

• Factors such as the size of the city, the types of trees, and the density of vegetation need to be considered.

• Remote sensing techniques such as satellite imagery and LiDAR can be used to estimate tree cover.

• Ground surveys can also be conduct...read more
Answered by AI
Add your answer
Q9. Are you soft spoken in general or are you nervous?
Ans. 
I am generally soft spoken.
• I have a calm and gentle speaking style.

• I prefer to listen and observe before speaking up.

• I am comfortable with silence and don't feel the need to fill every moment with words.
Answered by AI
Add your answer

Q1. How do you handle the different situations and share your overall experience in PORs mentioned in the CV?
Ans. 
I handle different situations in PORs by adapting to the needs of the situation and leveraging my past experiences.
• I assess the specific requirements of each situation and determine the best approach.

• I draw upon my past experiences in similar situations to guide my decision-making.

• I communicate effectively with team members and stakeholders to ensure a collaborative approach.

• I continuously learn and adapt to new challe...read more
Answered by AI
Add your answer
Q2. Can you estimate the number of shoes sold (men's formal) for Bata-type stores in the Lucknow Gomti Nagar area?
Ans. 
It is not possible to estimate the number of shoes sold without data.
• Without sales data, it is impossible to estimate the number of shoes sold.

• Factors such as seasonality, competition, and pricing can also affect sales.

• A survey or analysis of sales data would be necessary to provide an estimate.
Answered by AI
Add your answer

Why do you want to join A&M?

Imagine you are a glass bottle manufacturer related to aerated beverages. Can you determine different factors which might affect the demand and what would be the overall demand in the future for glass bottles?
Mostly, a qualitative discussion focused on factors. Majorly analyzed across 3 verticals - 1) Demand for aerated drinks (What pushes people to buy glass bottles and what drives companies to supply drinks in glass bottles) . 2) Reusability of glass bottles 3) External Factors and regulations

Q1. Apart from consulting, do you have any other options in mind?
Ans. 
Yes, I have considered other options apart from consulting.
• I have also considered pursuing a career in finance, as I have a strong background in financial analysis and modeling.

• Another option I have explored is entrepreneurship, as I have a passion for innovation and creating new businesses.

• Additionally, I have thought about transitioning into the technology industry, specifically in product management or business deve...read more
Answered by AI
Add your answer
Q2. What was your role in your previous job?
Ans. 
I was responsible for managing client relationships and providing strategic advice.
• Managed client relationships and served as the main point of contact

• Provided strategic advice and recommendations to clients

• Analyzed data and conducted research to support decision-making

• Developed and delivered presentations to clients

• Collaborated with cross-functional teams to implement solutions
Answered by AI
Add your answer
Q3. How good are you at handling people?
Ans. 
I am highly skilled at handling people and have a strong ability to communicate and build relationships.
• I have excellent communication skills and can effectively convey information and ideas to others.

• I am empathetic and can understand and relate to the emotions and perspectives of others.

• I am a good listener and can actively engage in conversations, making people feel heard and understood.

• I am skilled at conflict reso...read more
Answered by AI
Add your answer
Q4. What is your approach towards aggressive people?
Ans. 
I remain calm and try to understand their perspective before responding.
• I listen actively and acknowledge their feelings.

• I avoid reacting defensively or aggressively.

• I try to find common ground and work towards a solution.

• I set clear boundaries and communicate assertively.

• Example: A client was upset about a delay in project delivery. I listened to their concerns and apologized for the inconvenience. I explained the rea...read more
Answered by AI
Add your answer

Q1. Tell me something about yourself.
Add your answer
Q2. Asked to walk through all the projects in work experience. Some cross questions on the same lines.
Add your answer
Q3. Why I chose biotechnology and now an MBA and how I see the biotech space growing in near future with some new findings in that area.
Add your answer

Started with interviewer telling me about him and his work area in A&M.

Tell me about yourself?
[Please note that I stands for Interviewer and C stands for Candidate]

C: Presented the prepared answer but modulated it more towards work experience and internships done in same area as the interviewer (Pharma).

I: Walk me through your CV and major projects done?

C: Started from work experience and explained all projects with an addition of projects done in internships at the end.

I: Your client is a big hospital looking to improve its operations. Come up with main 3 problems you would consider improving on by applying analytics-based methods.

C: Took a min to note down certain points. Followed the problems a normal person would face in the hospital after entering and effectively communicated my thinking for the problem with the interviewer.

Addressed problems relating to scheduling for a patient in attending a doctor consultation or lab, self-registration after entering hospital and report collection etc. and applied analytics-based solutions for the same.

You are conducting a cricket tournament in IIM Lucknow. How many cricket balls would be used in it if you want to order all at once?
[Please note that I stands for Interviewer and C stands for Candidate]

I: Tell me about your projects in dashboarding?

C: Walked him through all the projects done in that domain with all the technologies used. Some cross questioning on hygiene check of dashboards and things to consider while developing them.

I: As you mentioned you have a liking for sports, let's do a guesstimate. You are conducting a cricket tournament in IIM Lucknow. How many cricket balls would be used in it if you want to order all at once?

C: Asked preliminary questions about the tournament pattern and number of teams involved. Calculated the number of matches that would be played and then the number of balls that would be required. Added a buffer stock at the end as a random percentage but gave reasoning on the basis of loss and wear & tear of the balls.

The Interview was basically a last round just to know me more and about my background. Asked questions on why I chose biotechnology and now an MBA and how I see the biotech space growing in near future with some new findings in that area.

Some questions were about my work experience and internships and also about the life at IIM Lucknow so far.