2 Affine Consultant Interview Questions & Answers | Complete Prep Guide 2025

Affine Consultant Interview Experiences

1 interview found

Consultant Interview Questions & Answers

Anonymous

posted on 25 Aug 2023

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

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

Add your answer

Round 4 - One-on-one

(1 Question)

Q1. Manager round / 2nd technical round

Add your answer

Top trending discussions

View All

Salary Discussions, Hike & Promotions

I have got an offer of 34 LPA from TCS and Capgemini . I have 11 years of experience , Azure Developer. Can you please guide / suggest which company should I join . I am confused since both are offering the s... read more

Got a question about Affine?

Ask anonymously on communities.

Interview questions from similar companies

Consultant Interview Questions & Answers

AbsolutData

Anonymous

posted on 30 Oct 2021

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

Add your answer

Interview Preparation Tips

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

Consultant Interview Questions & Answers

Algonomy

Anonymous

posted on 13 Dec 2021

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

Interview Questionnaire

1 Question

Q1. Basic SQL questions

Add your answer

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 .

Consultant Interview Questions & Answers

Fractal Analytics

Anonymous

posted on 17 Jan 2025

Interview experience

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

Add your answer

Round 2 - Technical

Consultant Interview Questions & Answers

Tiger Analytics

Anonymous

posted on 21 Jan 2025

Interview experience

Average

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

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

Consultant Interview Questions & Answers

Fractal Analytics

Anonymous

posted on 27 Aug 2022

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

Add your answer

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

Add your answer

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.

Add your answer

Round 4 - HR

(1 Question)

Q1. Salary discussion and all

Add your answer

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

Consultant Interview Questions & Answers

Fractal Analytics

Anonymous

posted on 7 Jan 2023

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

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

Add your answer

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

Add your answer

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

Add your answer

Round 4 - HR

(1 Question)

Q1. Salary Discussion and stuff related to that

Add your answer

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.

Consultant Interview Questions & Answers

Tiger Analytics

Anonymous

posted on 17 Jan 2022

Interview Questionnaire

1 Question

Q1. The interview revolved around the case solution presentation

Add your answer

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.

Consultant Interview Questions & Answers

Fractal Analytics

Anonymous

posted on 14 Dec 2020

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.

Add your answer

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

Add your answer

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.

Consultant Interview Questions & Answers

Fractal Analytics

Anonymous

posted on 2 Feb 2021

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

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Very nice experience, warm and welcoming people.

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 -

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

Tell us how to improve this page.

Affine Interviews By Designations

Interview Questions for Popular Designations

Affine Consultant Interview Process

based on 1 interview

Interview experience

Good

Join Affine Command The New

Fractal Analytics Consultant Interview Questions

4.0

• 25 Interviews

Tredence Consultant Interview Questions

3.6

• 9 Interviews

Tiger Analytics Consultant Interview Questions

3.7

• 2 Interviews

AbsolutData Consultant Interview Questions

3.6

• 1 Interview

Algonomy Consultant Interview Questions

4.0

• 1 Interview

HCL Infosystems Consultant Interview Questions

3.9

• 1 Interview

Incture Technologies Consultant Interview Questions

2.7

• 1 Interview

Winjit Technologies Consultant Interview Questions

3.7

• 1 Interview

Godrej Infotech Consultant Interview Questions

4.0

• 1 Interview

Aujas Cybersecurity-NuSummit company Consultant Interview Questions

3.8

• 1 Interview

View all

National Institute of Technology (NIT), Rourkela Placement Questions

2 Interviews

Sardar Vallabhbhai National Institute of Technology (NIT), Surat Placement Questions

1 Interview

Indian Institute of Technology (IIT), Roorkee Placement Questions

1 Interview

View all

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 Salaries in India

Senior Associate 129 salaries	₹0 L/yr - ₹0 L/yr
Business Analyst 94 salaries	₹0 L/yr - ₹0 L/yr
Senior Business Analyst 87 salaries	₹0 L/yr - ₹0 L/yr
Consultant 87 salaries	₹0 L/yr - ₹0 L/yr
Data Engineer 47 salaries	₹0 L/yr - ₹0 L/yr