AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Acuity Knowledge Partners Data Engineer Interview Questions and Answers
Acuity Knowledge Partners Data Engineer Interview Experiences
1 interview found
arpita shetty
Selected
I applied via Referral and was interviewed before Aug 2023. There were 3 interview rounds.
(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()
(1 Question)
- Q1. Pandas questions
(1 Question)
- Q1. Asked regarding the previous project
Skills evaluated in this interview
Data Engineer Jobs at Acuity Knowledge Partners
Top trending discussions
Interview questions from similar companies
Anonymous
Selected
I was interviewed in Sep 2024.
They asked various questions on guestimates and few SQL Questions
(2 Questions)
- Q1. They asked questions on spark, SQL and Python
- Q2. They asked questions on ADF as well
(2 Questions)
- Q1. They majorly focused on PySpark and ADF in this round
- Q2. They focused on the project also in this round
(1 Question)
- Q1. They focused on managerial-related questions in this round
I applied via Instahyre and was interviewed in Dec 2024. There was 1 interview round.
(2 Questions)
- Q1. Basic Spark, Python, SQL Questions.
- Q2. Some Data Modelling Questions.
Vivek S Sirwal
Basic aptitude questions
(2 Questions)
- Q1. SQL basics questions like joins
- Q2. Pandas basics for data manipulation
I applied via Campus Placement
Very Tough Test, high chances of giving up in the beginning. Test was 2 hrs, covered OOPS, Networks, ML, SQL and some other topics total of 8 questions.
(1 Question)
- Q1. Basic AI/ML and SQL/DBMS questions
(1 Question)
- Q1. Mostly about tech stack in projects that I've done, python and AI coding(just asked to write algos) & basic HR
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Sep 2023. There were 2 interview rounds.
1 Python and 1 sql question
(4 Questions)
- Q1. Technical sql and dsa
- Q2. Dsa ,sql,spark, project understanding
- Q3. Puzzle related questions
- Q4. Dsa focused array and string
Selected
I applied via Company Website and was interviewed before Jun 2023. There were 3 interview rounds.
Apptitude test happen in first go it was quite easy
GD happen between 10 group member we have speak for sometime
(2 Questions)
- Q1. Question on OOPS
- Q2. Quesion on SQL and python
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. I/p 1 o.p 1 1,2 1,2,3 Using ab initio
- Q2. Inner Join , left distinct join , delete files grater than 30 days
I applied via Company Website and was interviewed in Jul 2024. There were 2 interview rounds.
Aws, scala and cloud concept
(1 Question)
- Q1. Python question
Selected
I applied via Approached by Company and was interviewed before Feb 2023. There were 3 interview rounds.
(6 Questions)
- Q1. Explain hadoop ecosystem
- Ans.
Hadoop ecosystem is a collection of open-source software tools used for distributed storage and processing of big data.
Hadoop Distributed File System (HDFS) for storage
MapReduce for processing
Apache Hive for data warehousing
Apache Pig for data analysis
Apache Spark for real-time processing
Apache HBase for NoSQL database
Apache Kafka for real-time data streaming
- Q2. Explain YARN architecture
- Ans.
YARN architecture is a resource management layer in Hadoop ecosystem for job scheduling and cluster resource management.
YARN stands for Yet Another Resource Negotiator.
It consists of ResourceManager, NodeManager, ApplicationMaster, and Container.
ResourceManager manages resources and schedules applications.
NodeManager runs on each node and manages resources available on that node.
ApplicationMaster negotiates resources w...
- Q3. Hive external and internal tables
- Q4. Sort by and order by difference
- Ans.
Sort by is used to arrange data in a specific order, while order by is used to specify the sorting order in SQL queries.
Sort by is used in programming languages to arrange data based on a specific criteria
Order by is used in SQL queries to specify the sorting order of the result set
Sort by is more commonly used in programming languages like Python, while order by is used in SQL queries
- Q5. Broadcast and accumulator
- Q6. Optimization techniques
- Ans.
Optimization techniques are methods used to improve the efficiency and performance of data processing.
Use indexing to speed up data retrieval
Implement caching to reduce redundant computations
Utilize parallel processing for faster execution
Optimize algorithms for better performance
Use data compression techniques to reduce storage space
(4 Questions)
- Q1. It was a managerial round which was mostly around the project work and working experience in a team
- Q2. What was your role and responsisbility in the project
- Q3. Why is the approach of the project in this manner
- Q4. Few scenario based question
(1 Question)
- Q1. Compensation and salary discussion
Skills evaluated in this interview
Acuity Knowledge Partners Interview FAQs
Tell us how to improve this page.
Acuity Knowledge Partners Interviews By Designations
- Acuity Knowledge Partners Analyst Interview Questions
- Acuity Knowledge Partners Associate Interview Questions
- Acuity Knowledge Partners Senior Associate Interview Questions
- Acuity Knowledge Partners Delivery Lead Interview Questions
- Acuity Knowledge Partners Delivery Manager Interview Questions
- Acuity Knowledge Partners Equity Research Analyst Interview Questions
- Acuity Knowledge Partners Financial Analyst Interview Questions
- Acuity Knowledge Partners Credit Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Acuity Knowledge Partners Data Engineer Interview Process
based on 1 interview
Interview experience
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Acuity Knowledge Partners Data Engineer Reviews and Ratings
based on 3 reviews
Rating in categories
4-6 Yrs
₹ 9-22.4 LPA
|
Senior Associate
1.7k
salaries
|  ₹4.8 L/yr - ₹21 L/yr |
|
Associate
1.6k
salaries
| ₹4.2 L/yr - ₹14.5 L/yr |
|
Delivery Lead
1.4k
salaries
| ₹8.4 L/yr - ₹28.6 L/yr |
|
Delivery Manager
869
salaries
| ₹11.2 L/yr - ₹31.3 L/yr |
|
Analyst
593
salaries
| ₹3 L/yr - ₹8.5 L/yr |
SG Analytics
Evalueserve
WNS
Genpact
- Home >
- Interviews >
- Acuity Knowledge Partners Interview Questions >
- Acuity Knowledge Partners Data Engineer Interview Questions
