Upload Button Icon Add office photos

Filter interviews by

Epsilon Senior Business Analyst Interview Questions and Answers

Updated 11 Jun 2024

Epsilon Senior Business Analyst Interview Experiences

3 interviews found

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. What is difference between groupby and having
  • Ans. 

    Groupby is used to group data based on a specific column, while having is used to filter grouped data based on a condition.

    • Groupby is used to group data based on a specific column in SQL.

    • Having is used to filter grouped data based on a condition in SQL.

    • Groupby is typically used with aggregate functions like SUM, COUNT, AVG, etc.

    • Having is used after the GROUP BY clause to filter groups based on a condition.

  • Answered by AI
  • Q2. SQL joins - Difference between cross join and self join
  • Ans. 

    Cross join combines every row from one table with every row from another table. Self join joins a table with itself.

    • Cross join produces a Cartesian product of the two tables involved.

    • Self join is used to join a table with itself, typically to compare rows within the same table.

    • Cross join does not require a common column between the two tables.

    • Self join requires a common column to join the table with itself.

    • Example of c...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It will be easy with some sql and basic BA questions

Skills evaluated in this interview

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

I applied via Referral and was interviewed before Sep 2022. There were 5 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. Basic questions related to Unica campaign
Round 3 - Technical 

(1 Question)

  • Q1. With one of the US Directors again with Technical questions related to Unica flowchart, Troubleshooting
Round 4 - One-on-one 

(1 Question)

  • Q1. General interview with India Director
Round 5 - HR 

(1 Question)

  • Q1. Final round about offer and compensation

Interview Preparation Tips

Topics to prepare for Epsilon Senior Business Analyst interview:
  • Communication Skills
  • Technical Skills

Senior Business Analyst Interview Questions Asked at Other Companies

asked in Sapiens
Q1. Difference between annuity and pension, types of annuity and pens ... read more
Q2. If you had to accommodate a CR in agile how would you do so?
asked in Brillio
Q3. If I tell you to prepare a TOC for a RFP what will you put into i ... read more
Q4. What are the different meetings that happen in Agile style develo ... read more
asked in EVRY India
Q5. Five concepts in artificial intelligence, In machine learnin ... read more

I applied via Referral and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQl- group by,partition,ranking,count,scenario based questions
Round 2 - One-on-one 

(1 Question)

  • Q1. Technical scenario based ,behavioral,role based situational questions
Round 3 - One-on-one 

(1 Question)

  • Q1. Policies,relocation,roles

Interview Preparation Tips

Topics to prepare for Epsilon Senior Business Analyst interview:
  • Sql
Interview preparation tips for other job seekers - Be confident
Be there for interview only if you are willing to relocate

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Oct 2019. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Scripting was major focus, program to read the numbers 1 to infinity and convert them to words , ex : 1 as one , 100 as hundred , 1543 as one thousand five hundreden fourty three
  • Q2. Ansible concepts, this was major focus
  • Q3. Jenkins pipeline concepts
  • Q4. Basic other tools questions

Interview Preparation Tips

Interview preparation tips for other job seekers - It wasn't that scary, one technical round, managerial tech round, manager round, hr round, all happened in a single day

Interview Questionnaire 

1 Question

  • Q1. SQL queries, basic questions on python programming, statistical concepts and basic questions on machine learning algorithms.
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Profile Related
  • Q2. Product management
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Feb 2022. There were 5 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. Python, sql, etl, cloud, web tool
Round 3 - Behavioral 

(1 Question)

  • Q1. Functional question and write some sql basic query
Round 4 - Client Interview 

(1 Question)

  • Q1. Basic question on project
Round 5 - HR 

(1 Question)

  • Q1. Salary negotiation and check behaviour qiestion

Interview Preparation Tips

Interview preparation tips for other job seekers - Good company too work and enjoy latest tech stack in data science and analytics
Interview experience
4
Good
Difficulty level
Easy
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jun 2022. 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 - Case Study 

They gave me case study in interview based on that I had provide the solution.

Round 3 - Technical 

(1 Question)

  • Q1. They asked question regarding SQL, statistics and some project related questions
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Reasoning and logic base qus

Round 2 - Technical 

(1 Question)

  • Q1. About metrics like Cpc, cvr
Round 3 - One-on-one 

(1 Question)

  • Q1. Discuss about previous work
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Talk about yourself
  • Q2. What is your professional experience
Round 2 - Aptitude Test 

Simple SQL questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest if you don't know!

Epsilon Interview FAQs

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

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

  1. What is difference between groupby and hav...read more
  2. SQL joins - Difference between cross join and self j...read more
  3. With one of the US Directors again with Technical questions related to Unica fl...read more

Tell us how to improve this page.

Epsilon Senior Business Analyst Interview Process

based on 2 interviews

Interview experience

3.5
  
Good
View more

Interview Questions from Similar Companies

R.R. Donnelley Interview Questions
3.9
 • 106 Interviews
Publicis Interview Questions
3.7
 • 52 Interviews
Regalix Interview Questions
2.9
 • 45 Interviews
Xdbs Interview Questions
3.1
 • 39 Interviews
Smollan Group Interview Questions
4.0
 • 36 Interviews
Groupm Media Interview Questions
3.9
 • 35 Interviews
Mediamint Interview Questions
3.4
 • 33 Interviews
View all
Epsilon Senior Business Analyst Salary
based on 89 salaries
₹8.7 L/yr - ₹22.5 L/yr
19% more than the average Senior Business Analyst Salary in India
View more details

Epsilon Senior Business Analyst Reviews and Ratings

based on 6 reviews

2.6/5

Rating in categories

2.1

Skill development

3.0

Work-life balance

3.0

Salary

2.4

Job security

2.2

Company culture

2.8

Promotions

2.2

Work satisfaction

Explore 6 Reviews and Ratings
Senior Software Engineer
375 salaries
unlock blur

₹11.4 L/yr - ₹34.3 L/yr

Software Engineer2
176 salaries
unlock blur

₹6.1 L/yr - ₹18 L/yr

Software Engineer
167 salaries
unlock blur

₹4.5 L/yr - ₹17 L/yr

Senior Developer
147 salaries
unlock blur

₹8.9 L/yr - ₹25.2 L/yr

Campaign Analyst
142 salaries
unlock blur

₹4.9 L/yr - ₹10.4 L/yr

Explore more salaries
Compare Epsilon with

R.R. Donnelley

3.9
Compare

Smollan Group

4.0
Compare

ChannelPlay

3.8
Compare

Affinity Express

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