Upload Button Icon Add office photos
Engaged Employer

i

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

Aspect Ratio Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Aspect Ratio Associate Consultant Interview Questions and Answers

Updated 18 Jul 2024

Aspect Ratio Associate Consultant Interview Experiences

1 interview found

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

I applied via Company Website and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Countif sumif in excel
  • Ans. 

    Countif and Sumif are Excel functions used to count or sum values based on specified criteria.

    • Countif function counts the number of cells within a range that meet a certain condition.

    • Sumif function adds up the values in a range that meet a certain condition.

    • Both functions require a range of cells and a criteria to be met.

    • Example: =COUNTIF(A1:A10, ">10") will count the number of cells in range A1:A10 that are greater th

  • Answered by AI
  • Q2. Distinct count and joins in sql
  • Ans. 

    Distinct count is used to count unique values in a column, while joins are used to combine data from multiple tables in SQL.

    • Distinct count is achieved using the COUNT(DISTINCT column_name) function.

    • Joins are used to combine data from two or more tables based on a related column between them.

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

  • Answered by AI
Round 2 - Case Study 

Profit maximization using lpp.
Market sizing for ev 2 wheelers for next 5 years
Future cash flows

Skills evaluated in this interview

Interview questions from similar companies

I applied via Walk-in and was interviewed before Mar 2019. There were 5 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. Find the length of characters in string array without using inbuilt methods.
  • Ans. 

    Finding length of characters in string array without using inbuilt methods.

    • Iterate through each string in the array and count the number of characters in each string using a loop.

    • Add the count of characters in each string to get the total length of characters in the array.

  • Answered by AI
  • Q2. Write function to convert hexadecimal to binary in any programming langauge.
  • Ans. 

    Function to convert hexadecimal to binary in any programming language.

    • Create a function that takes a hexadecimal string as input.

    • Convert the hexadecimal string to an integer using the language's built-in function.

    • Convert the integer to binary using the language's built-in function.

    • Return the binary string.

  • Answered by AI
  • Q3. From Sql Advance questions
  • Q4. Intermediate level tricky programming questions from java and functionality.
  • Q5. About projects Handling in last company
  • Q6. Are u agree for 2.5 years bond?

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview is not easy if yr concept is not clear.

Skills evaluated in this interview

I applied via Walk-in and was interviewed before Nov 2021. 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 Resume tips
Round 2 - Coding Test 

Basic c programing and data strucure

Round 3 - Technical 

(2 Questions)

  • Q1. Basic Technical questions
  • Q2. Recursion and Tree related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be good listner, prepare good programig langage like c and data structure. Make sure you know about basic and comman question about tree and linklist.

I applied via Naukri.com

Interview Questionnaire 

1 Question

  • Q1.  What are Option Strict and Option Explicit? What are all the differences between Dispose and Finalize()? What is the difference between System.String and System.StringBuilder classes? What is Delegate? ...
  • Ans. 

    Answers to common interview questions for Software Engineer position

    • Option Strict and Option Explicit are compiler directives in VB.NET

    • Dispose() is used to release unmanaged resources while Finalize() is used for garbage collection

    • System.String is immutable while System.StringBuilder is mutable

    • Delegate is a type that represents a reference to a method

    • Value types store data directly while reference types store a referen...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - selection process-
1st round-online test(prpare all kind of logical, verbal, and .net related questions)
2nd round- technical round(prepare all .net interview questions,sql server questions, winforms, web api)
3rd round- hr discussion
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected
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 - Aptitude Test 

Basic aptitude test

Round 3 - Coding Test 

Javascript and react js

Round 4 - One-on-one 

(1 Question)

  • Q1. Related to relevant skill set
Round 5 - One-on-one 

(1 Question)

  • Q1. Related to past experience
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. Questions asked based on spring framework and oops concepts
Round 2 - Technical 

(1 Question)

  • Q1. Technical questions asked on current project
Round 3 - HR 

(1 Question)

  • Q1. Family Background questions
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Divisibility, LCM, HCF.
Numbers, Decimals, Fractions, Powers.
Profit, Loss.
Simple interest and Compound interest.
Speed, Distance, Time.
Work and wages.
Trains, Boats, Streams-upstream/downstream, Circular track questions.
Cistern and pipes.

Round 2 - Coding Test 

Coding interviews test candidates' technical knowledge, coding ability, problem solving skills, and creativity, typically on a whiteboard.

Round 3 - Assignment 

Choose a topic based on the assignment.
2 Conduct research.
3 Write a thesis statement

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

(2 Questions)

  • Q1. Introduce yourself
  • Ans. 

    I am a dedicated and experienced professional with a background in marketing and a passion for driving results.

    • Experienced in marketing strategies and campaigns

    • Strong track record of achieving goals and targets

    • Passionate about driving results and exceeding expectations

  • Answered by AI
  • Q2. Strengths and weaknesses
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 Oct 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Aptitude round contains 20 mcq's.

Round 2 - Technical 

(3 Questions)

  • Q1. Ask 2 to 3 puzzles
  • Q2. Questions on DBMS
  • Q3. Ask 2/3 questions of dsa on topics like linked list and array
Round 3 - HR 

(1 Question)

  • Q1. What is your motivation to join the company
  • Ans. 

    I am motivated to join the company because of its innovative projects and collaborative work environment.

    • Exciting projects that align with my interests and skills

    • Opportunity for growth and learning

    • Positive company culture and team dynamics

  • Answered by AI
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

The aptitude round included a range of logical and analytical questions.

Round 2 - Technical 

(1 Question)

  • Q1. The Technical round included a mix of problem solving and technical questions , evaluating the grasp of core concepts.
Round 3 - HR 

(1 Question)

  • Q1. The HR round was a discussion focused on personal experience , career aspiration , and alignment with the company's value.
Contribute & help others!
anonymous
You can choose to be anonymous

Aspect Ratio Interview FAQs

How many rounds are there in Aspect Ratio Associate Consultant interview?
Aspect Ratio interview process usually has 2 rounds. The most common rounds in the Aspect Ratio interview process are Technical and Case Study.
How to prepare for Aspect Ratio Associate 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 Aspect Ratio. The most common topics and skills that interviewers at Aspect Ratio expect are Analytics, Python, SQL, CRM and Healthcare.
What are the top questions asked in Aspect Ratio Associate Consultant interview?

Some of the top questions asked at the Aspect Ratio Associate Consultant interview -

  1. Distinct count and joins in ...read more
  2. Countif sumif in ex...read more

Recently Viewed

INTERVIEWS

Airtribe

No Interviews

INTERVIEWS

Classplus

No Interviews

INTERVIEWS

Jupiter Money

No Interviews

INTERVIEWS

Jupiter Money

No Interviews

INTERVIEWS

Aspect Ratio

No Interviews

INTERVIEWS

Classplus

No Interviews

INTERVIEWS

Jupiter Money

No Interviews

INTERVIEWS

Classplus

No Interviews

INTERVIEWS

HARMAN

No Interviews

INTERVIEWS

HARMAN

No Interviews

Tell us how to improve this page.

Aspect Ratio Associate Consultant Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

HyperVerge Interview Questions
4.3
 • 25 Interviews
GfK MODE Interview Questions
3.3
 • 22 Interviews
Technicolor Interview Questions
3.8
 • 21 Interviews
Fleeca India Interview Questions
3.4
 • 13 Interviews
MITA Interview Questions
3.6
 • 13 Interviews
View all
Aspect Ratio Associate Consultant Salary
based on 42 salaries
₹14 L/yr - ₹25.5 L/yr
82% more than the average Associate Consultant Salary in India
View more details

Aspect Ratio Associate Consultant Reviews and Ratings

based on 5 reviews

4.3/5

Rating in categories

3.1

Skill development

4.7

Work-life balance

4.3

Salary

4.1

Job security

4.1

Company culture

3.8

Promotions

3.8

Work satisfaction

Explore 5 Reviews and Ratings
Analyst
82 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
42 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
27 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
19 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
15 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Aspect Ratio with

Prime Focus

3.8
Compare

Reliance Media Works

4.6
Compare

DNEG CREATIVE SERVICES

3.6
Compare

Moving Picture Company

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