Upload Button Icon Add office photos

Acuity Knowledge Partners

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Acuity Knowledge Partners Data Engineer Interview Questions and Answers

Updated 2 Aug 2024

Acuity Knowledge Partners Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image arpita shetty

posted on 2 Aug 2024

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

I applied via Referral and was interviewed before Aug 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Windows function on sql
  • Ans. 

    Window functions in SQL are used to perform calculations across a set of table rows related to the current row.

    • Window functions are used to calculate values based on a set of rows related to the current row

    • They do not cause rows to become grouped into a single output row like aggregate functions

    • Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Pandas questions
Round 3 - HR 

(1 Question)

  • Q1. Asked regarding the previous project

Skills evaluated in this interview

Data Engineer Jobs at Acuity Knowledge Partners

View all

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Java Basic questions and Git

Interview Preparation Tips

Interview preparation tips for other job seekers - After selection they haven't rolled the offer and put the profile on hold and then doesn't pick calls.

I applied via Recruitment Consulltant and was interviewed before Jun 2021. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Where do we use BigInteger in java ?
  • Ans. 

    BigInteger is used for mathematical operations involving very large integers in Java.

    • BigInteger is used when the range of values supported by primitive data types like int and long is not sufficient.

    • It is commonly used in cryptography and security applications.

    • It provides methods for arithmetic, bitwise, and logical operations on large integers.

    • Example: calculating factorial of a large number, generating large prime nu

  • Answered by AI
  • Q2. Merge Sort Algo code in java
  • Ans. 

    Merge Sort Algo code in java

    • Divide the array into two halves

    • Recursively sort the two halves

    • Merge the sorted halves

    • Time complexity: O(n log n)

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Genpact Software Engineer interview:
  • Core Java
  • DSA
Interview preparation tips for other job seekers - Not a very good interview experience. I was asked 2-3 questions only. Not satisfied with interview process.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - don't be afraid be positive during the interview, Make eye contact of interview person then they feel u have manage any critical incident occurring work place.

Interview Preparation Tips

Round: Resume Shortlist
Experience: I had a standard resume for this company as per our institute placement cell norms.
I usually changed my “Areas of Interest” as per the company profile. For Headstrong I mentioned subjects that dealt with coding and data structure.

Round: Test
Experience: First round was a written test containing 90 aptitude based questions and the time allotted for the same was 90 minutes. Questions were of high difficulty level; most of the questions based on probability, permutation and combination. 40 people were shortlisted out of the 180 applicants.
Duration: 90 minutes
Total Questions: 90

Round: Group Discussion
Experience: In Group Discussion there were 11 people in my group. The topic for the discussion was the “impact of family drama daily soaps (saas bahu serials) on the society”. Almost all of us agreed to the fact that these serials were sending wrong message to the society. They were interested in students who were expressive. 3 people got selected from my group.

Round: Technical Interview
Experience: The first round was a technical interview. Questions related to my family and areas of interest were also asked though. Questions related to C++ were asked and the topic of data structure was their main focus. They asked me questions on linked list and other forms of data structure. Finally they asked few general puzzles too. This interview continued for around 20 minutes.

Round: HR Interview
Experience: In the HR interview, questions were asked on why they should choose me and why I had opted for Headstrong. They also asked which location I would prefer for the job. They wanted someone who would be comfortable with any location whether it be south or north India. This last interview was small and lasted around 5-10 minutes.
Tips: Preparation of puzzles foe the interview would be beneficial.

College Name: IIT ROORKEE
Motivation: Most information regarding the company was obtained by attending the pre placement talk. The company did not check much about our knowledge related to the company but were more concerned with our technical knowledge.

Interview Preparation Tips

Round: Test
Experience: The questions were of medium to high difficulty. What set this test apart was the fact that each question had different weightage ranging from 0.5 to 3 marks per question. Time was a major factor. So my strategy was to attempt all the 1 and 1.5 marks questions which constitute the major chunk of the paper in around 40 minutes and spend the remaining 20 minutes for the 2 and 3 mark questions. I did not even bother reading the 0.5 mark questions. The 2 and 3 mark questions were difficult and those will differentiate you from others. 1600 students wrote the test and only 86 got shortlisted for the next round.
Duration: 60 minutes
Total Questions: 40

Round: Technical Interview
Experience: I was asked to write a C program to print the Fibonacci sequence and a basic SQL query. Apart from this I was asked a puzzle and other questions related to my resume. Out of the 86, only 26 students were called for the next round which again was a technical interview.

Round: Technical Interview
Experience: This was similar to the first technical interview. I had to write a C program to print the prime numbers between 1 and 100 and a puzzle was asked again. Apart from this a guesstimate to find the number of cars between 2 places was asked and a scenario based question too was asked. These were followed by resume related questions.

Round: HR Interview
Experience: All the 26 students who attended the second technical round were allowed to attend HR round as well. This was just for 4 - 5 minutes. I was asked about my family background and why I should be hired. My fondest memories from school days were asked too. Finally offer letter was given to 10 students out of the 1600 who wrote the test :P

General Tips: Just keep a calm head and attempt the questions. Ask for time to think if you are not able to answer the questions immediately. Be bold and confident. That is sufficient :)
Skills: Puzzle Solving Capability, Ability To Think, SQL, C Programming
College Name: VIT Vellore

I was interviewed in Mar 2017.

Interview Questionnaire 

1 Question

  • Q1. Views on their recruiting process
  • Ans. 

    I believe the recruiting process is thorough and well-organized.

    • The company uses a combination of resume screening, interviews, and assessments to evaluate candidates.

    • They have a clear timeline for the hiring process and keep candidates informed of their progress.

    • Feedback is provided to candidates after interviews to help them improve for future opportunities.

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience:

I applied via Naukri.com and was interviewed in Mar 2021. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. What is web wrapping
  • Ans. 

    Web wrapping is the process of displaying a website within another website or application.

    • It involves embedding a website within an iframe or a div element.

    • Web wrapping is commonly used in mobile apps to display web content without leaving the app.

    • It can also be used to display content from a different domain on a website.

    • Web wrapping can be done using JavaScript or server-side scripting languages.

    • Examples of web wrapp...

  • Answered by AI
  • Q2. Vba effects
  • Ans. 

    VBA effects on software development

    • VBA can automate repetitive tasks in software development

    • VBA can be used to create custom functions and add-ins in Excel

    • VBA can interact with other Microsoft Office applications

    • VBA can be used to create user interfaces for data entry and analysis

    • VBA can be used to manipulate data in databases

    • VBA can be used to create macros in software applications

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be polite and listen carefully all the questions then answer

Skills evaluated in this interview

I applied via LinkedIn and was interviewed before Oct 2021. There were 3 interview rounds.

Round 1 - Coding Test 

8 python coding
With 2 aptitude

Round 2 - Assignment 

Game based assessment.
More than 8 games need to play

Round 3 - One-on-one 

(2 Questions)

  • Q1. Questions from python and also from SQL. SQL is must to place LatentView. Some projects related questions
  • Q2. How many joins are in SQL what is lamda function in python Difference between tuples and list
  • Ans. 

    Answering questions related to SQL joins, lambda function in Python, and difference between tuples and lists.

    • There are four types of joins in SQL: inner join, left join, right join, and full outer join.

    • Lambda function is an anonymous function in Python that can take any number of arguments, but can only have one expression.

    • Tuples are immutable and ordered collections of elements, while lists are mutable and ordered col...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Want to start your career in analytics field learn SQL and python easily can get a chance to work.

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed in Nov 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 Resume tips
Round 2 - Aptitude Test 

Get questions from all topics and medium level questions

Round 3 - Group Discussion 

They give one topic and provide one minute for thinking its overall 30 min discussion

Round 4 - Technical 

(2 Questions)

  • Q1. Total technical rounds 1)basic resume questions, python and sql questions. 2)same round 1 but a little bit extra dose 3) managerial round
  • Q2. List, tuple, oops concept. joins from sql
Round 5 - HR 

(1 Question)

  • Q1. Why latent view why analytics best achivemnts
  • Ans. 

    Latent view and analytics are essential for data-driven decision making. My best achievement is developing a predictive model for customer churn.

    • Latent view helps to uncover hidden patterns and insights in data that are not immediately apparent.

    • Analytics provides a systematic approach to analyzing data and extracting meaningful insights.

    • My best achievement is developing a predictive model for customer churn that helped

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - go through your basics, no worries definitely every one get job
Contribute & help others!
anonymous
You can choose to be anonymous

Acuity Knowledge Partners Interview FAQs

How many rounds are there in Acuity Knowledge Partners Data Engineer interview?
Acuity Knowledge Partners interview process usually has 3 rounds. The most common rounds in the Acuity Knowledge Partners interview process are Technical and HR.
How to prepare for Acuity Knowledge Partners Data Engineer 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 Acuity Knowledge Partners. The most common topics and skills that interviewers at Acuity Knowledge Partners expect are Python, SQL, AWS, Data Engineering and API.
What are the top questions asked in Acuity Knowledge Partners Data Engineer interview?

Some of the top questions asked at the Acuity Knowledge Partners Data Engineer interview -

  1. windows function on ...read more
  2. pandas questi...read more

Recently Viewed

DESIGNATION

SALARIES

Sigmoid

INTERVIEWS

Sigmoid

No Interviews

SALARIES

JPMorgan Chase & Co.

SALARIES

Fractal Analytics

INTERVIEWS

Sigmoid

No Interviews

REVIEWS

Celebal Technologies

No Reviews

INTERVIEWS

Sigmoid

No Interviews

SALARIES

Sigmoid

SALARIES

JPMorgan Chase & Co.

Tell us how to improve this page.

Acuity Knowledge Partners Data Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Acuity Knowledge Partners Data Engineer Salary
based on 14 salaries
₹7.5 L/yr - ₹22.4 L/yr
42% more than the average Data Engineer Salary in India
View more details

Acuity Knowledge Partners Data Engineer Reviews and Ratings

based on 3 reviews

2.8/5

Rating in categories

2.6

Skill development

4.0

Work-life balance

3.5

Salary

2.6

Job security

3.1

Company culture

2.0

Promotions

3.1

Work satisfaction

Explore 3 Reviews and Ratings
Senior Associate
1.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
1.6k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Delivery Lead
1.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Delivery Manager
876 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
601 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Acuity Knowledge Partners with

SG Analytics

3.1
Compare

Evalueserve

3.3
Compare

WNS

3.4
Compare

Genpact

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