Upload Button Icon Add office photos

Target

Compare button icon Compare button icon Compare

Filter interviews by

Target Senior Business Analyst Interview Questions and Answers

Updated 17 Oct 2023

Target Senior Business Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Job Portal 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 - Technical 

(1 Question)

  • Q1. SQL situation based questions
Round 3 - One-on-one 

(1 Question)

  • Q1. Have good understanding of the projects

Interview Preparation Tips

Interview preparation tips for other job seekers - Have a good understanding of projects you've worked on

Interview questions from similar companies

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 - One-on-one 

(1 Question)

  • Q1. Tell Us Something About Yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - JUST BE YOURSELF. The more honest you are the panel will love yo more.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Case Study 

Opening of new stores

Round 2 - Coding Test 

Sql, data visualisation

I applied via Naukri.com and was interviewed before Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Scenario based questions, Forecasting techniques, how to measure covid impact

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for Advanced Excel, SQL based questions along with logical questions

I was interviewed in Dec 2016.

Interview Questionnaire 

2 Questions

  • Q1. What is the remainder when 517517....(15 times 517) is divided by 999 ?
  • Ans. 

    The remainder when a repeating number is divided by 999.

    • Divide 517 by 999 and find the remainder

    • The remainder will repeat every 3 digits

    • Take the first 3 digits of the number and divide by 999

    • Multiply the remainder by 517 and find the remainder

    • Repeat the above step for the next 3 digits

    • Combine all the remainders to get the final answer

  • Answered by AI
  • Q2. How would you approach a machine learning problem?
  • Ans. 

    I would approach a machine learning problem by understanding the problem, collecting and preparing data, selecting appropriate algorithms, training and testing models, and evaluating results.

    • Understand the problem and define the goal

    • Collect and prepare data

    • Select appropriate algorithms

    • Train and test models

    • Evaluate results and refine the approach

    • Iterate as necessary

    • Consider ethical and legal implications

    • Examples: predic...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Most of the questions were from puzzles. A couple of basic coding questions. One of them was on recursion.
Tips: Practice puzzles and basic coding questions.
Duration: 30 minutes
Total Questions: 10

Round: Technical Interview
Experience: The interviewer asked 4 questions, 2 of them were puzzles and the other 2 were from machine learning.
Tips: Must be aware of basic machine learning. You can try lectures of Andrew Ng.

Skills: Basic Coding, Machine Learning, Statistics
College Name: IIT Varanasi

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Technical 

(5 Questions)

  • Q1. Prepare All theoretical questions related to SQL and excel. Learn everything about your resume so that you will be able to explain each and everything about the resume.
  • Q2. Difference between Vlookup and Xlookup ?
  • Ans. 

    Vlookup searches for a value in the first column of a range and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible function that can search in any direction and return multiple results.

    • Vlookup searches vertically in a table and returns a value from a specified column.

    • Xlookup can search in any direction (horizontal, vertical, or both) and return multiple results.

    • Vlookup requ...

  • Answered by AI
  • Q3. Difference between Subquery and CTE. Which is better?
  • Ans. 

    Subquery is a query nested within another query, while CTE is a temporary result set defined within a query. Both have their own use cases.

    • Subquery is enclosed in parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.

    • CTE is defined using the WITH keyword and can be referenced multiple times in a query.

    • CTEs are more readable and easier to maintain compared to subqueries.

    • Subqueries are useful when t...

  • Answered by AI
  • Q4. No of records returned after applying left and inner join on 2 tables.
  • Q5. Pivot the table in SQL using case when statements.
  • Ans. 

    Pivoting a table in SQL using case when statements

    • Use the CASE WHEN statement to create new columns based on specific conditions

    • Use the SUM or COUNT function to aggregate data in the pivoted table

    • Group by the remaining columns to ensure correct aggregation

    • Example: SELECT id, SUM(CASE WHEN category = 'A' THEN value END) AS A_total FROM table_name GROUP BY id;

  • Answered by AI
Round 2 - Case Study 

Business Case Questions Based on a scenario where the company's Sales is Declining. How we can address the issue using transaction data

Interview Preparation Tips

Topics to prepare for Landmark Group Business Analyst interview:
  • SQL
  • EXCEL
Interview preparation tips for other job seekers - Solve as many Business case studies as you can. Prepare well for SQL questions. You might get asked situation-based questions. Follow and show a structured approach while solving these questions. and you are good to go.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Aug 2023.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(5 Questions)

  • Q1. What is you future goal
  • Q2. What is you next step
  • Q3. What is you financial independent
  • Q4. What is you expect salary
  • Q5. What is you experience

Interview Preparation Tips

Interview preparation tips for other job seekers - I am applied for job but no response why
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Tell me about your self
  • Ans. 

    Experienced business development executive with a proven track record of driving revenue growth and building strong client relationships.

    • Over 5 years of experience in business development

    • Successfully increased sales by 30% in previous role

    • Skilled in identifying new business opportunities and negotiating deals

    • Strong communication and interpersonal skills

    • Bachelor's degree in Business Administration

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed before Feb 2024.

Round 1 - One-on-one 

(2 Questions)

  • Q1. How important is Vendor relationship for a product team?
  • Ans. 

    Vendor relationships are crucial for a product team's success as they impact product quality, cost, and delivery timelines.

    • Vendor relationships can impact product quality by ensuring high-quality materials and components are used.

    • Strong vendor relationships can lead to cost savings through negotiated pricing and discounts.

    • Timely delivery of components and materials is crucial for meeting product deadlines, which can be...

  • Answered by AI
  • Q2. How would you give each brand a personality and a customer profile?
  • Ans. 

    To give each brand a personality and customer profile, I would conduct market research, analyze target demographics, create brand messaging, and tailor marketing strategies accordingly.

    • Conduct market research to understand target demographics and consumer behavior

    • Create brand messaging that resonates with the target audience

    • Tailor marketing strategies to reach and engage with the specific customer profile

    • Use customer f...

  • Answered by AI
Round 2 - One-on-one 

(2 Questions)

  • Q1. What was the biggest challenge in your career?
  • Ans. 

    The biggest challenge in my career was managing a team through a major company restructuring.

    • Navigating uncertainty and keeping team morale high during the transition

    • Balancing the needs of upper management with the well-being of my team

    • Adapting to new roles and responsibilities in the restructured organization

  • Answered by AI
  • Q2. If you have a team of X number of people, how would you manage each individual basis, their skill set?
  • Ans. 

    I would assess each team member's skill set, assign tasks accordingly, provide necessary training and support, and regularly review performance.

    • Conduct individual skill assessments to understand strengths and weaknesses

    • Assign tasks based on each team member's skill set

    • Provide necessary training and support to enhance skills

    • Regularly review performance and provide feedback for improvement

    • Encourage collaboration and know

  • Answered by AI
Round 3 - One-on-one 

(2 Questions)

  • Q1. What are the missing gaps on the floor in terms of product offering for youth label and smart label?
  • Ans. 

    The missing gaps in product offerings for youth label and smart label on the floor need to be identified and addressed.

    • Expand the range of trendy and fashionable clothing options for the youth label to attract younger customers.

    • Introduce more tech-savvy and innovative products under the smart label to cater to the needs of tech-savvy consumers.

    • Consider adding sustainable and eco-friendly options to both labels to appea...

  • Answered by AI
  • Q2. How would you increase Denim contribution in sales?
  • Ans. 

    To increase Denim contribution in sales, focus on marketing campaigns, product innovation, and customer engagement.

    • Launch targeted marketing campaigns highlighting the unique features of Denim products

    • Introduce new styles and designs to attract a wider customer base

    • Offer special promotions or discounts on Denim products to boost sales

    • Collaborate with influencers or celebrities to promote Denim products on social media

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, be aware of Production brands and buying strategies along with product strategies and Winter strategies.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before May 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL and Visualizationbased questions
Round 2 - Case Study 

Case study for business problems

Round 3 - HR 

(1 Question)

  • Q1. Behaviour fit round

Target Interview FAQs

How many rounds are there in Target Senior Business Analyst interview?
Target interview process usually has 3 rounds. The most common rounds in the Target interview process are Resume Shortlist, Technical and One-on-one Round.
What are the top questions asked in Target Senior Business Analyst interview?

Some of the top questions asked at the Target Senior Business Analyst interview -

  1. Have good understanding of the proje...read more
  2. SQL situation based questi...read more

Tell us how to improve this page.

Target Senior Business Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Target Senior Business Analyst Salary
based on 9 salaries
₹12 L/yr - ₹27 L/yr
13% more than the average Senior Business Analyst Salary in India
View more details

Target Senior Business Analyst Reviews and Ratings

based on 5 reviews

4.9/5

Rating in categories

4.6

Skill development

4.9

Work-life balance

4.9

Salary

4.9

Job security

4.9

Company culture

4.9

Promotions

4.9

Work satisfaction

Explore 5 Reviews and Ratings
Senior Engineer
257 salaries
unlock blur

₹16.6 L/yr - ₹45.2 L/yr

Software Engineer
175 salaries
unlock blur

₹8 L/yr - ₹28.3 L/yr

Senior Software Engineer
163 salaries
unlock blur

₹16.5 L/yr - ₹48 L/yr

Lead Engineer
130 salaries
unlock blur

₹24.3 L/yr - ₹82 L/yr

Lead Specialist
119 salaries
unlock blur

₹3.2 L/yr - ₹8.3 L/yr

Explore more salaries
Compare Target with

Walmart

3.8
Compare

Amazon

4.1
Compare

Flipkart

4.0
Compare

Reliance Retail

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview