Premium Employer

i

This company page is being actively managed by Affine Team. If you also belong to the team, you can get access from here

Affine Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Affine Consultant Interview Questions and Answers

Updated 25 Aug 2023

Affine Consultant Interview Experiences

1 interview found

Consultant Interview Questions & Answers

user image Anonymous

posted on 25 Aug 2023

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

I applied via Walk-in and was interviewed before Aug 2022. There were 4 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 Resume tips
Round 2 - Coding Test 

Test of SQL, Tableau and other skills based on your resume on Skillate

Round 3 - Technical 

(1 Question)

  • Q1. SQL and other skills technical questions
Round 4 - One-on-one 

(1 Question)

  • Q1. Manager round / 2nd technical round

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed in Sep 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Explain briefly the work and responsibilities in ur previous company
  • Ans. 

    In my previous company, I worked as a Consultant where I provided expert advice and solutions to clients.

    • Analyzed client's business processes and identified areas for improvement

    • Developed and implemented strategies to optimize client's operations

    • Conducted market research and competitor analysis to identify market trends

    • Provided recommendations and solutions to clients based on data analysis

    • Collaborated with cross-funct...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Stick to basics and dont fake about ur work

I applied via Referral and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic SQL questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through fundamental of SQL , how null behaves with all joins, Cte and other objects .
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Questions were all related to the role i.e Market Mix Modeling . Structure of a model, types of KPI that are reported to Client ( ROI, effectiveness etc), Statistical parameters to verify model, how to fin...
Round 2 - Technical 
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Jan 2024.

Round 1 - Case Study 

It was related to a Food & Beverage Industry Data

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Confident and attentive

I applied via LinkedIn and was interviewed before Aug 2021. There were 4 interview rounds.

Round 1 - Assignment 

A technical test for whatever technical round you are applying for. Will be conceptual test rather than hard/coded test

Round 2 - Technical 

(2 Questions)

  • Q1. For almost 1.5 hrs where technical questions being asked. level is easy to medium but mainly they focus on how fast are you while you stuck in a problem and your concepts
  • Q2. How can you derive (%share) in power bi
  • Ans. 

    To derive % share in Power BI, use the 'Group By' function and create a measure using the 'Divide' function.

    • Use the 'Group By' function to group the data by the desired category

    • Create a measure using the 'Divide' function to calculate the percentage share

    • Add the measure to a visual to display the % share

    • Example: = DIVIDE(SUM(Sales[Revenue]), CALCULATE(SUM(Sales[Revenue]), ALL(Sales)))

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

(1 Question)

  • Q1. This was with the Project Manager to see how well you can provide solutions and interact with client.
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion and all

Interview Preparation Tips

Interview preparation tips for other job seekers - Dont brag if you dont know anything at all. Trust me , people at fractal dont expect you to know everything. They just want tour concepts to be crystal clear

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed in Dec 2022. There were 4 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 Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. I was provided with a Marketing Mix Model problem statement and I have to provide the complete solution in excel and powerpoint presentation. In first round, The Question were all around my previous projec...
  • Q2. What is adstock, decay, Due tos Contributions? How do you evaluate the model? What is seasonality and the formula for seasonality? Do seasonality have any contribution?
  • Ans. 

    Explanation of adstock, decay, Due tos Contributions, seasonality and its formula.

    • Adstock is the measure of the lasting impact of advertising on consumer behavior.

    • Decay refers to the reduction in the effectiveness of advertising over time.

    • Due tos Contributions is the attribution of sales to different marketing channels.

    • Seasonality is the pattern of sales or other metrics that repeat over a fixed period of time.

    • The form...

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. Second round was improvement on the model provided by me as the solution for MMM question. Technical questions were more on reasoning for the variables selected and understanding of the concepts of MMM. L...
Round 4 - HR 

(1 Question)

  • Q1. Salary Discussion and stuff related to that

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand Basic Concepts of MMM thoroughly. Try to prepare end to end solution i.e. from data processing to recommendation to the client.

Interview Questionnaire 

1 Question

  • Q1. The interview revolved around the case solution presentation

Interview Preparation Tips

Interview preparation tips for other job seekers - Be sure of whatever analysis you’ve done with the case provided. The entire case discussion round will revolve around your findings. More than the solution, your sound reasoning ability and communication skills will be tested. There were some mistakes which I noticed while presenting the solution but was able to explain what went wrong as I laid out the core approach right from the start.

I applied via Referral and was interviewed in Jun 2020. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Questions were mainly on the technologies I have worked on like Power BI,SQL and few data modelling concepts.
  • Q2. Apart from technical, there were questions on logical reasoning like the guestimates. Exact question for the guesstimate was: In a city like Delhi, how many plates of chola kulcha is consumed in a day? Tip...

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident. Its ok if you dont know the answer for any question. Dont get panic and try to take a question one by one instead of thinking ahead about the next questions. Prepare to explain about your current role and responsibilities in a team or a project in detail and the technologies that you have worked upon.

I applied via Recruitment Consultant and was interviewed in Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Decision tree, random forest, regressions, classification metrics

Interview Preparation Tips

Interview preparation tips for other job seekers - Very nice experience, warm and welcoming people.
Contribute & help others!
anonymous
You can choose to be anonymous

Affine Interview FAQs

How many rounds are there in Affine Consultant interview?
Affine interview process usually has 4 rounds. The most common rounds in the Affine interview process are Coding Test, Technical and One-on-one Round.
How to prepare for Affine Consultant 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 Affine. The most common topics and skills that interviewers at Affine expect are Python, SQL, Analytics, AWS and Data Warehousing.
What are the top questions asked in Affine Consultant interview?

Some of the top questions asked at the Affine Consultant interview -

  1. SQL and other skills technical questi...read more
  2. Manager round / 2nd technical ro...read more

Recently Viewed

INTERVIEWS

Iimb

No Interviews

DESIGNATION

INTERVIEWS

Betsol

No Interviews

INTERVIEWS

Essar Group

No Interviews

INTERVIEWS

Essar Group

No Interviews

INTERVIEWS

Affine

No Interviews

INTERVIEWS

Essar Group

30 top interview questions

INTERVIEWS

Betsol

No Interviews

INTERVIEWS

Betsol

No Interviews

INTERVIEWS

Affine

No Interviews

Tell us how to improve this page.

Affine Consultant Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Join Affine Command The New
Affine Consultant Salary
based on 87 salaries
₹12 L/yr - ₹32 L/yr
61% more than the average Consultant Salary in India
View more details

Affine Consultant Reviews and Ratings

based on 18 reviews

3.6/5

Rating in categories

4.1

Skill development

3.7

Work-life balance

3.3

Salary

3.6

Job security

3.6

Company culture

3.1

Promotions

3.5

Work satisfaction

Explore 18 Reviews and Ratings
Senior Associate
129 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Analyst
94 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Business Analyst
87 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
87 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Engineer
47 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Affine with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

Tiger Analytics

3.7
Compare

LatentView Analytics

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