Add office photos
Filter interviews by
Leaf Technologies Business Analyst Interview Questions and Answers
Leaf Technologies Business Analyst Interview Experiences
1 interview found
Hari Govind
Interview Questionnaire
5 Questions
- Q1. Career aspirations
- Q2. Elaborate on leadership roles and experience in college
- Ans.
As a college student, I held leadership positions in various clubs and organizations.
Served as the president of the debate club, organizing weekly meetings and competitions
Led a team of volunteers for a charity event, coordinating logistics and fundraising efforts
Managed a group project for a marketing class, delegating tasks and ensuring timely completion
Mentored incoming freshmen as a resident advisor, providing guid...
- Q3. Data science knowledge( confirmation, details of projects on resume)
- Q4. Case Study- GPRS locking device to prevent theft of motorcycles. Should the company accept?
- Ans.
Yes, the company should accept the case study.
Implementing GPRS locking device will prevent theft of motorcycles
It will increase the security of the motorcycles and reduce the risk of loss for the company
It will also increase customer satisfaction and trust in the brand
The company can potentially gain a competitive advantage by offering this feature
However, the cost of implementing the device and potential impact on pr
- Q5. Why not Masters?
- Ans.
I believe practical experience is more valuable than a degree.
I have gained valuable experience through internships and on-the-job training.
I have also taken relevant courses and certifications to enhance my skills.
I believe in continuous learning and development, and plan to pursue further education in the future.
A Masters degree is not always necessary for success in the business analyst field.
Employers often value p
Interview Preparation Tips
Experience: Leaf Technologies used a text analytic method of shortlisting resumes. The interviewer informed me that we were graded on basis of academics, leadership and knowledge of data science.
Tips: Pay attention when drafting your resume. Highlight all the important leadership roles you have. Be crystal clear on every word you put in.
Round: Other Interview
Experience: Very frank discussion. The interviewer wanted to see if my goals aligned with that of the startup and if I had the drive, skills and cultural fit.
Tips: If you are clear about your own profile, you will be fine answering questions about it. Adopt a clear methodical method for the case study. Write down neatly. Do not hesitate to ask for time to think and put your thoughts in order.
General Tips: Understand your strengths,weaknesses and talents clearly. Identify which kind of company and post you desire. Contact seniors, and utilize interview experience to understand the general testing process of these companies. For instance, all companies offering an analyst role require aptitude tests. CAT prep helped me, but if you are uninterested in that, then you must still work hard on these skills. Drive the interview yourself. Dont be timid. If you really want the job, it should show in your voice. Say straight out why you want to work for the company and gain their attention in the first tell me about yourself question itself.
Skill Tips: Be clear about your resume. Practice to improve aptitude
Skills: Analysis, Data Science, Leadership, Quantitative Aptitude , Verbal Aptitude
College Name: IIT ROORKEE
Motivation: I am interested in the Energy sector. The company works in developing a device to help households reduce energy consumption. Also, being a well funded startup run by IIT Bombay graduates, the company gave me the opportunity of a great learning experience coupled with a higher than average pay package.
Top trending discussions
Interview questions from similar companies
(2 Questions)
- Q1. SQL Question using window functions
- Q2. Guesstimate on Number of McD orders
- Ans.
The number of McDonald's orders can be estimated based on factors like location, time of day, and day of the week.
Consider the population density of the area where the McDonald's is located
Take into account the time of day - more orders during meal times
Factor in the day of the week - weekends may have higher order volumes
Look at historical data or industry averages for similar locations
Consider any promotions or speci
Selected
I applied via Approached by Company and was interviewed in Apr 2024. There were 3 interview rounds.
(2 Questions)
- Q1. Sql Medium Level questions
- Q2. Easy guesstimates were asked
(2 Questions)
- Q1. Caee Study was asked
- Q2. Resume grilling was done
(2 Questions)
- Q1. Why you want to join Ola ?
- Ans.
I want to join Ola because of its innovative technology, market leadership, and potential for growth.
Ola is a market leader in the ride-sharing industry, which presents exciting challenges and opportunities for a business analyst.
I am impressed by Ola's focus on innovation and technology, which aligns with my passion for leveraging data and analytics to drive business decisions.
I believe Ola's fast-paced environment an...
- Q2. Salary Negotiation was done
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
(1 Question)
- Q1. What work have you done in previous company
- Ans.
I have worked on various projects including data analysis, process improvement, and system implementation.
Led a team in analyzing sales data to identify trends and opportunities for growth
Implemented a new CRM system to streamline customer interactions and improve efficiency
Collaborated with stakeholders to map out current processes and identify areas for improvement
Created detailed documentation outlining project requ
I applied via Job Portal and was interviewed in Aug 2024. There was 1 interview round.
Written test, asked to write queries on paper for given questions
I applied via Referral and was interviewed in Aug 2023. There were 3 interview rounds.
HackerRank OA on SQL. 3 questions, 1 Hour with webcam proctoring.
Question 1:
"""
1. The Good and The Bad City
There is a blood bank which maintains two tables: DONOR that contains information on the people who are willing to donate blood and ACCEPTOR, the people who are in need of blood. The bank wants to conduct a survey and find out the city that has the best and the worst donor sum amount/acceptor sum amount ratio. Both ratios are unique. That is, exactly one city has the best ratio and exactly one city has the worst ratio.
The donor sum amount is the total amount of blood, regardless of blood group, that people are ready to donate. The acceptor sum amount is the total amount of blood needed by that city.
There must be exactly two rows that denote the best and the worst ratios. The order of the rows does not matter. Each row must contain the following attributes:
1. The city's name (CITY).
2. The ratio ( donor sum amount / acceptor sum amount ), correct to 4 decimal places.
The schema of the two tables is given below:
Schema
DONOR
Name Type Description
ID Integer It is the ID of the donor.
NAME String It is the name of the donor.
GENDER Character It is the gender of the donor.
CITY String It is the city where the donor lives.
BLOOD_GROUP String It is the blood group of the donor.
AMOUNT Integer It is the amount of blood in pints, which the donator can donate.
ACCEPTOR
Name Type Description
ID Integer It is the id of the acceptor.
NAME String It is the name of the acceptor.
GENDER Character It is the gender of the acceptor.
CITY String It is the city where the acceptor lives.
BLOOD_GROUP String It is the blood group of the acceptor.
AMOUNT Integer It is the amount of blood in pints, which the acceptor needs.
Sample Data Tables
DONOR
ID NAME GENDER CITY BLOOG_GROUP AMOUNT
1 MARIA F Warne, NH AB+ 7
2 DOROTHY F East Natchitoches, PA AB+ 3
3 CHARLES M East Natchitoches, PA A- 6
4 DOROTHY F East Natchitoches, PA AB+ 9
5 MICHAEL M Warne, NH A+ 1
ACCEPTOR
ID NAME GENDER CITY BLOOG_GROUP AMOUNT
1 LINDA F Warne, NH A+ 9
2 CHARLES M Warne, NH AB+ 8
3 RICHARD M East Natchitoches, PA AB+ 3
4 LINDA F East Natchitoches, PA A+ 1
5 PATRICIA F Warne, NH A+ 5
Sample Output
East Natchitoches, PA 4.5000
Warner, NH 0.3636
Explanation
The amount of blood available for donation in East Natchitoches, PA is 3 + 6 + 9 = 18.
The amount of blood needed in East Natchitoches, PA is 3 +1 = 4.
Hence, the ratio is = ( 18 : 4 ) = 4.5000.
The amount of blood available for donation in Warne, NH is 1 + 7 = 8.
The amount of blood needed in Warne, NH is 9 + 8 + 5 = 22.
Hence, the ratio is = ( 8 : 22 ) = 0.3636.
"""
Question 2:
"""
2. Maximum Discount Product
A department store maintains data on customers, products, and purchase records in three tables: CUSTOMER, PRODUCT, and PURCHASE. The store manager wants to know which product is on maximum discount for each category. Write a query to print the following fields for each category, ordered by category, ascending: category, product ID and discount for the product that has the maximum discount in the category. In the case of multiple products having same maximum discount within a category, print the product with minimum product_id.
Table Schema
CUSTOMER
Name Type Description
CUSTOMER_ID Integer A customer's ID in the inclusive range [1, 500]. This is a primary key.
CUSTOMER_NAME String A customer's name. This field contains between 1 and 100 characters (inclusive).
CITY String A city name. This field contains between 1 and 50 characters (inclusive).
STATE String A state name. This field contains between 1 and 50 characters (inclusive).
PRODUCT
Name Type Description
PRODUCT_ID Integer A product's ID in the inclusive range [1, 500]. This is a primary key.
PRODUCT_NAME String A product's name. This field contains between 1 and 50 characters (inclusive).
CATEGORY String A category name of the product. This field contains between 1 and 50 characters (inclusive).
PRICE Integer The price of the product in the inclusive range [500, 1000].
DISCOUNT Integer The discount associated with the product in the inclusive range [5, 20].
AVAILABLE Integer The availability of a product. It is 1 if the product is available or it is 0 if the product is not available.
PURCHASE
Name Type Description
ID Integer An id associated with a purchase that is done in the inclusive range [1, 1000]. This is a primary key.
CUSTOMER_ID Integer A customer ID. This is a foreign key to customer.customer_id.
PRODUCT_ID Integer A product ID. This is a foreign key to product.product_id.
PURCHASE_DATE Date The date associated with a purchase. The date falls in the range '2000-01-01' to '2000-12-31' (inclusive).
'
Sample Case 0
Sample Input for Custom Testing
CUSTOMER
CUSTOMER_ID CUSTOMER_NAME CITY STATE
1 Pickett Wilhelm Park SD
2 Pickett Ipswich AZ
3 Poole Farwell KS
4 Pollard Bent Pine WV
5 Phelps Momford Landing VA
PRODUCT
PRODUCT_ID PRODUCT_NAME CATEGORY PRICE DISCOUNT AVAILABLE
1 P-1 C-5 720 10 1
2 P-2 C-1 935 17 1
3 P-3 C-2 588 19 1
4 P-4 C-4 619 5 0
5 P-5 C-1 803 16 1
PURCHASE
ID CUSTOMER_ID PRODUCT_ID PURCHASE_DATE
1 5 5 2000-06-04
2 1 5 2000-11-24
3 1 3 2000-10-02
4 5 1 2000-08-06
5 5 3 2000-06-22
6 3 1 2000-06-30
7 2 5 2000-01-10
8 2 1 2000-07-26
9 3 5 2000-09-23
10 4 5 2000-09-02
11 3 2 2000-05-25
Sample Output
C-1 2 17
C-2 3 19
C-4 4 5
C-5 1 10
Explanation
By referring to the sample data above, we find that:
For category C-1, there are two products P-2 and P-5 with discount 17 and 16 respectively. So the maximum discount is for product P-2 which is 17.
For category C-2, there is only one product P-3 with discount 19, so this is the product with maximum discount in this category.
For category C-4, there is only one product P-4 with discount 5, so this is the product with maximum discount in this category.
For category C-5, there is only one product P-1 with discount 10, so this is the product with maximum discount in this category.
"""
Question 3:
"""
3. Increase in Population
You are provided with the records of births and deaths during the course of years. Their records consist of a year and a type, either 'birth' or 'death'. Determine the year(s) when the population is highest versus the starting population. Return the year and the amount of the increase in population. If there is a tie, return the earliest of them.
Schema
You are provided 1 table: records.
records
Name Type Description
id int The unique id of a record.
type char(5) The type of record (birth/death).
year int The year in which the birth/death happened.
Sample Data Tables
records
id type year
2187 birth 2002
9941 death 2001
4361 birth 2003
6477 death 2001
3478 birth 2005
9719 death 2005
7292 birth 2002
4931 death 2005
5833 birth 2002
9379 death 2001
3472 birth 2003
5580 death 2003
4472 birth 2002
5915 death 2004
2624 birth 2003
5223 death 2005
7198 birth 2002
5384 death 2001
7660 birth 2004
5302 death 2005
5192 birth 2003
2537 death 2003
5260 birth 2003
7218 death 2004
2726 birth 2002
3856 death 2002
6594 birth 2003
9013 death 2005
4657 birth 2001
1782 death 2005
9744 birth 2004
5149 death 2001
2054 birth 2003
7423 death 2003
7156 birth 2002
2956 death 2001
3273 birth 2001
3721 death 2002
9756 birth 2002
6632 death 2003
OUTPUT
year count
2003 5
Explanation
year count cumulative
2001 -4 -4
2002 6 2
2003 3 5
2004 0 5
2005 -5 0
The highest cumulative increase in population is in the years 2003 and 2004. Return the earlier of the two, so the output is:
2003 5
"""
(1 Question)
- Q1. No further communication received
Interview Preparation Tips
govind goel
I applied via Internshala and was interviewed in Sep 2023. There were 3 interview rounds.
Medium difficultty on pandas SQL
(1 Question)
- Q1. Coding interview python pandas medium difficulty
- Ans. Solved it and had to discuss with manager
Interview Preparation Tips
- Python
(1 Question)
- Q1. SQL, Case study, and puzzles.
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Find 3rd highest salary using SQL
- Ans.
Use SQL query with ORDER BY and LIMIT to find 3rd highest salary.
Use SELECT statement to retrieve salary column
Use ORDER BY clause to sort salaries in descending order
Use LIMIT 2,1 to skip first two highest salaries and retrieve the third highest salary
- Q2. Queries on self join
(1 Question)
- Q1. Questions on Power B, DAX etc.,
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed before Jun 2022. There were 6 interview rounds.
8 SQL questions with increase in complexity and 1 case study
(1 Question)
- Q1. SQL and Statistics screaning
(1 Question)
- Q1. Business case studies, guess estimates, little technical
(1 Question)
- Q1. Complete profile screaning, Checking if candidate is suited for the role, case studies, guess estimates
(2 Questions)
- Q1. Why sudden job change plan
- Q2. Why Swiggy and what values did you see before applying
- Ans.
I chose Swiggy for its innovative technology, market leadership, and growth potential.
Swiggy's cutting-edge technology in the food delivery industry stood out to me
The company's strong market presence and leadership position were appealing
I was impressed by Swiggy's rapid growth and expansion in the market
Swiggy's customer-centric approach and focus on quality service were values I admired
Leaf Technologies Interview FAQs
Tell us how to improve this page.
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
|
Customer Care Executive
4
salaries
|  ₹3 L/yr - ₹3 L/yr |
|
Computer Service Engineer
3
salaries
| ₹1.8 L/yr - ₹1.8 L/yr |
Udaan
BigBasket
Swiggy
CARS24
Calculate your in-hand salary
- Home >
- Interviews >
- Leaf Technologies Interview Questions >
- Leaf Technologies Business Analyst Interview Questions
