Upload Button Icon Add office photos

Filter interviews by

Clear (1)

1Digital Stack Business Analyst Interview Questions and Answers

Updated 17 Feb 2025

1Digital Stack Business Analyst Interview Experiences

5 interviews found

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Jan 2025.

Round 1 - HR 

(1 Question)

  • Q1. Could you describe your past experience with data, your day-to-day work, and the technology stack you have used?
  • Ans. 

    I have extensive experience working with data, utilizing various technologies in my day-to-day work.

    • I have worked with SQL databases to extract and analyze data.

    • I have used Excel and Tableau for data visualization and reporting.

    • I have experience with Python and R for data manipulation and analysis.

    • I have worked with ETL tools like Informatica for data integration.

    • I have used JIRA and Confluence for project management a

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

(2 Questions)

  • Q1. Questions on Aptitude to get to know your problem-solving approach - 2 questions
  • Q2. Guestimate Question
Round 3 - Technical 

(4 Questions)

  • Q1. What are the different types of joins in SQL?
  • Ans. 

    Different types of joins in SQL include inner join, left join, right join, and full outer join.

    • Inner join: Returns rows when there is a match in both tables.

    • Left join: Returns all rows from the left table and the matched rows from the right table.

    • Right join: Returns all rows from the right table and the matched rows from the left table.

    • Full outer join: Returns rows when there is a match in either table.

  • Answered by AI
  • Q2. What is the difference between a Union and an Outer join, and can you provide the syntax for both using two simple tables?
  • Ans. 

    Union combines results from two tables, while Outer join combines matching rows and includes non-matching rows.

    • Union combines all rows from both tables, removing duplicates

    • Outer join combines matching rows and includes non-matching rows with NULL values

    • Syntax for Union: SELECT * FROM table1 UNION SELECT * FROM table2

    • Syntax for Outer join: SELECT * FROM table1 LEFT OUTER JOIN table2 ON table1.id = table2.id

  • Answered by AI
  • Q3. I was provided with simple data in Excel and asked to generate the total sales of a product by date and month. (This can be approached by sumifs formula)
  • Q4. Can you explain how to solve the availability of products throughout the day for campaigns such as Blinkit(campaignid_1) and Zepto (campaignid_2)in Python, using only sorting and removing duplicates, witho...
  • Ans. 

    Sort and remove duplicates to ensure availability of products for Blinkit and Zepto campaigns throughout the day in Python.

    • Sort the products list for each campaign

    • Remove duplicates from the sorted list

    • Repeat the process for both Blinkit and Zepto campaigns

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared in Excel, SQL, and Python. The data provided may be unclear, so it is crucial to have a solid understanding of the core concepts, focusing primarily on Excel and SQL. The interviewer may not respond kindly if you don't answer their questions or if you seek clarification regarding the data or the questions posed. This behavior does not reflect professionalism. If anyone from 1DigitalStack comes across this, I kindly request that you provide training for your interviewers on maintaining professional conduct.

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Jan 2025.

Round 1 - One-on-one 

(2 Questions)

  • Q1. First round was good. Interviewer was very polite and good and asked about basic MySQL and PowerBI.
  • Q2. Guesstimate questions
Round 2 - One-on-one 

(2 Questions)

  • Q1. In second round. Interviewer was very rude and was full of attitude. He was thinking very high of himself. He even told to share screen as if I was cheating. Bad experience
  • Q2. Only business case interviews

Interview Preparation Tips

Interview preparation tips for other job seekers - Check for your interviewer first if he is someone from CU then be prepared he is going to interrogate you.

Business Analyst Interview Questions Asked at Other Companies

asked in Evalueserve
Q1. You have 10 boxes of balls (each ball weighing exactly10 gm) with ... read more
asked in Infosys
Q2. What is your strong point in terms of technical knowledge? Like J ... read more
Q3. There are 100 people standing in a circle, the first person has a ... read more
asked in Paytm
Q4. Sum of Squares of First N Natural Numbers Problem Statement You a ... read more
asked in EXL Service
Q5. If I have 333 digits to number pages of a book, How many pages ca ... read more
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Dec 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Refer to GFG for Aptitude Prep. It is more than enough.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Guesstimates & Puzzles were asked. I don't remember it.
  • Q2. Be thorough with your resume.
Round 3 - One-on-one 

(2 Questions)

  • Q1. Guesstimates & Excel functions were asked.
  • Q2. I had Python projects in my resume so libraries and project purpose and methodology was asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident with what you know

Business Analyst Interview Questions & Answers

user image Mohit Khandelwal

posted on 19 Jul 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. What role currently working ?
  • Q2. Reason of changing?
Round 2 - Technical 

(2 Questions)

  • Q1. Aptitude questions
  • Q2. Excel based questions
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(3 Questions)

  • Q1. SQL and power BI dax
  • Q2. Scenario based questions
  • Q3. One from SQL and one from power BI

Interview Preparation Tips

Interview preparation tips for other job seekers - Worst experience.Suggest won't go for it as it's waste of time. Inspite of answering all the questions & clearing. Neither they will give proper feedback.While discussion you might experience that they should be in politics not in the tech.They are politically amazing

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Dec 2019. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Oracle Apps Technical - PlSQL concepts
  • Q2. Basic questions like logic to find even number, swap number ,etc.

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to see all the Technology related questions in Google before going for interview.

Interview Questionnaire 

1 Question

  • Q1. Data transforms, integration, data pages, RAP, Case management

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and give your answer with confidence

I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic questions only ... regarding job and experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident ... always say the truth ... never try to fake your details

Interview Questionnaire 

1 Question

  • Q1. Manual testing basics

I applied via Walk-in and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Its for FP&A process and the major questions were from the basics of FP&A. How it starts and how its ends and Previous job roles.

Interview Preparation Tips

Interview preparation tips for other job seekers - It's quite a moderate interview but be prepare for more rounds of technical interviews.
Contribute & help others!
anonymous
You can choose to be anonymous

1Digital Stack Interview FAQs

How many rounds are there in 1Digital Stack Business Analyst interview?
1Digital Stack interview process usually has 2-3 rounds. The most common rounds in the 1Digital Stack interview process are One-on-one Round, HR and Technical.
How to prepare for 1Digital Stack Business Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at 1Digital Stack. The most common topics and skills that interviewers at 1Digital Stack expect are Business Analysis, Python, SQL, Database Design and ETL.
What are the top questions asked in 1Digital Stack Business Analyst interview?

Some of the top questions asked at the 1Digital Stack Business Analyst interview -

  1. Can you explain how to solve the availability of products throughout the day fo...read more
  2. What is the difference between a Union and an Outer join, and can you provide t...read more
  3. What are the different types of joins in S...read more

Recently Viewed

INTERVIEWS

Titan Company

No Interviews

INTERVIEWS

Titan Company

No Interviews

INTERVIEWS

Air Liquide

No Interviews

INTERVIEWS

Air Liquide

No Interviews

INTERVIEWS

Titan Company

No Interviews

INTERVIEWS

Oriental Carbon & Chemicals

No Interviews

INTERVIEWS

Euler Motors

No Interviews

INTERVIEWS

Euler Motors

No Interviews

INTERVIEWS

Titan Company

No Interviews

INTERVIEWS

Air Liquide

No Interviews

Tell us how to improve this page.

1Digital Stack Business Analyst Interview Process

based on 6 interviews

1 Interview rounds

  • One-on-one Round
View more
1Digital Stack Business Analyst Salary
based on 20 salaries
₹6 L/yr - ₹9 L/yr
28% less than the average Business Analyst Salary in India
View more details

1Digital Stack Business Analyst Reviews and Ratings

based on 4 reviews

3.7/5

Rating in categories

4.0

Skill development

4.0

Work-life balance

3.7

Salary

4.2

Job security

4.2

Company culture

3.8

Promotions

4.0

Work satisfaction

Explore 4 Reviews and Ratings
Business Analyst
20 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
8 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Business Analyst
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
5 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Manager
5 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare 1Digital Stack with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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