Upload Button Icon Add office photos

Filter interviews by

Leaf Technologies Business Analyst Interview Questions and Answers

Updated 18 Mar 2015

Leaf Technologies Business Analyst Interview Experiences

1 interview found

Business Analyst Interview Questions & Answers

user image Hari Govind

posted on 15 Mar 2015

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...

  • Answered by AI
  • 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

  • Answered by AI
  • 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

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
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.

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Coding Test 

It was based on 4 sql questions of medium to hard level and 24 mcqs based on sql,aptitude,excel.

Round 2 - Technical 

(1 Question)

  • Q1. They give you some questions and you have to write sql queries for them
Round 3 - Technical 

(1 Question)

  • Q1. You are given case study and come sql questions based on that
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Introduction and explain any one of the projects plus what was the analytics you used
  • Ans. 

    Implemented a project to optimize marketing campaigns using predictive analytics

    • Developed a predictive model to identify the most effective marketing channels

    • Utilized data from past campaigns to train the model

    • Used techniques such as regression analysis and decision trees to analyze the data

    • Generated insights on customer behavior and preferences to improve campaign targeting

  • Answered by AI
  • Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be very very well prepared with SQL and you should be aware of advanced sql, not only concepts but solving questions
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Apr 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Sql Medium Level questions
  • Q2. Easy guesstimates were asked
Round 2 - Technical 

(2 Questions)

  • Q1. Caee Study was asked
  • Q2. Resume grilling was done
Round 3 - HR 

(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...

  • Answered by AI
  • Q2. Salary Negotiation was done

Interview Preparation Tips

Interview preparation tips for other job seekers - Pretty easy Interview. Just brushup basics
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - HR 

(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

  • Answered by AI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Job Portal and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Coding Test 

Written test, asked to write queries on paper for given questions

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Internshala and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Medium difficultty on pandas SQL

Round 3 - One-on-one 

(1 Question)

  • Q1. Coding interview python pandas medium difficulty
  • Ans. Solved it and had to discuss with manager
  • Answered by govind goel

Interview Preparation Tips

Topics to prepare for Paisabazaar.com Business Analyst interview:
  • Python
Interview preparation tips for other job seekers - Prepare pandas
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL, Case study, and puzzles.

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL, case study, and Puzzles. That's what I was asked.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - Technical 

(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

  • Answered by AI
  • Q2. Queries on self join
Round 2 - Technical 

(1 Question)

  • Q1. Questions on Power B, DAX etc.,

Skills evaluated in this interview

Leaf Technologies Interview FAQs

What are the top questions asked in Leaf Technologies Business Analyst interview?

Some of the top questions asked at the Leaf Technologies Business Analyst interview -

  1. Case Study- GPRS locking device to prevent theft of motorcycles. Should the com...read more
  2. Data science knowledge( confirmation, details of projects on resu...read more

Tell us how to improve this page.

Customer Care Executive
4 salaries
unlock blur

₹3 L/yr - ₹3 L/yr

Computer Service Engineer
3 salaries
unlock blur

₹1.8 L/yr - ₹1.8 L/yr

Explore more salaries
Compare Leaf Technologies with

Udaan

4.0
Compare

BigBasket

3.9
Compare

Swiggy

3.8
Compare

CARS24

3.6
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview