Upload Button Icon Add office photos

Filter interviews by

Aidetic Software Interview Questions and Answers

Updated 9 Apr 2025
Popular Designations

Aidetic Software Interview Experiences

8 interviews found

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

I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Initially, I began with a medium-level question on LeetCode regarding the longest unique substring. Following that, I was asked about fundamental concepts in data engineering and two SQL questions: one to find the second highest employee salary and the other to determine the highest marks of students in each section.
here are all the questions
You have a dataset with employees, salaries, bonuses, and departments. How
would you calculate the total compensation for each department while
considering that bonuses are applied only to salaries above $50,000?




second highest sal in each department

select empId, dense_rank() over (partition by department order by salary decs) as rnk from employees_table where rank =2




in a streaming job processing event data, how would you handle late-arriving
data to ensure its included in calculations but doesnt delay real-time insights?"

Write PySpark logic to calculate the daily average sales amount for each product
category from a sales dataset spanning years. Consider that the df contains
'category', 'sales_amount', 'sale_date'


sales_df = sales_df.groupBy("category", sale_date).agg({"avg":"sales_amount"}).withColumnRenamed("avg(sales_amount), "Avg_sales_amount"")




-----/

You have a dataset with employees' salaries, bonuses, and departments. How
would you calculate the total compensation for each department while
considering that bonuses are applied only to salaries above $50,000?




in a streaming job processing event data, how would you handle late-arriving
data to ensure its included in calculations but doesnt delay real-time insights?"

Write PySpark logic to calculate the daily average sales amount for each product
category from a sales dataset spanning years. Consider that the df contains 'category', 'sales_amount', 'sale_date'

Round 2 - Technical 

(1 Question)

  • Q1. No coding but a lot of technical questions on architecture mainly on data bricks , medellion architecture how you work with small files problem optimize keyword z indexing, adls2 most spark based scenario ...

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn more about data engineering concepts, dont miss anything

Interview Questions & Answers

user image Anonymous

posted on 19 Feb 2025

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
No response
Round 1 - Coding Test 

It about python basic question on string manipulation

Round 2 - Technical 

(2 Questions)

  • Q1. Tell me about pyspark arcitecture
  • Ans. 

    PySpark architecture is a distributed computing framework that allows for processing large datasets using Python.

    • PySpark is built on top of Apache Spark, a fast and general-purpose cluster computing system.

    • It utilizes a master-slave architecture with a driver program that communicates with a cluster manager to distribute tasks to worker nodes.

    • PySpark supports various data sources such as HDFS, Apache Hive, and Apache H...

  • Answered by AI
  • Q2. Design lld for streaming
  • Ans. 

    Designing a low-level design for streaming data processing system

    • Use a distributed system like Apache Kafka for real-time data streaming

    • Implement data processing pipelines using technologies like Apache Spark or Flink

    • Ensure fault tolerance and scalability by using a microservices architecture

    • Leverage cloud services like AWS Kinesis or Google Cloud Dataflow for managed streaming solutions

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - After Cmpleting the all interview they might ghost so dont give interview here its waste of time
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. What is the code to determine and print a happy number?
  • Ans. 

    A happy number is a number which eventually reaches 1 when replaced by the sum of the square of each digit.

    • Create a function to determine if a number is happy by repeatedly squaring the digits and summing them until the result is 1 or a cycle is detected.

    • Use a set to keep track of seen numbers to detect cycles.

    • Example: For number 19, the process would be 1^2 + 9^2 = 82, 8^2 + 2^2 = 68, 6^2 + 8^2 = 100, 1^2 + 0^2 + 0^2 ...

  • Answered by AI
  • Q2. What is the transformer architecture in the context of neural networks?
  • Ans. 

    Transformer architecture is a type of neural network architecture commonly used in natural language processing tasks.

    • Utilizes self-attention mechanism to weigh the importance of different words in a sentence

    • Consists of encoder and decoder layers for tasks like machine translation

    • Introduced by the paper 'Attention is All You Need' by Vaswani et al.

    • Popular implementations include BERT, GPT, and TransformerXL

  • Answered by AI
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
2-4 weeks
Result
No response

I appeared for an interview in Oct 2024, where I was asked the following questions.

  • Q1. Asked questions related to spark, python and sql
  • Q2. Some advanced questions related to spark and big data

Interview Preparation Tips

Interview preparation tips for other job seekers - Just don’t go for this company. Firstly, the recruiter will call you and talk to you nicely and when you have cleared all the rounds they will start ignoring your calls and messages and finally you will be in mental state. I dont know what they try to achieve by this.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Different JavaScript questions
Round 2 - Technical 

(1 Question)

  • Q1. Needed to develop simple CRUD with search and sort using GraphQL
  • Ans. 

    Implement a simple CRUD API using GraphQL with search and sort functionalities.

    • Define GraphQL schema with types for data entities, e.g., 'User' type with fields like 'id', 'name', 'email'.

    • Implement resolvers for CRUD operations: createUser, getUser, updateUser, deleteUser.

    • Use arguments in queries for search functionality, e.g., 'users(name: String)': to filter users by name.

    • Implement sorting by adding an argument to qu...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - They hired a lot for their clients once the client deal is completed they fire their employee.

Not a good organization to join.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Basic questions about experience and notice period.
Round 2 - Coding Test 

Asked some List coding questions.

I applied via Job Portal and was interviewed in Mar 2022. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Oops concepts and Data structures
Round 2 - Coding Test 

DSA

Round 3 - Cultural fit 

(1 Question)

  • Q1. Cultural fit round focused questions

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be familiar with OOPs and DSA
Are these interview questions helpful?
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Sep 2022. 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 tips
Round 2 - Technical 

(1 Question)

  • Q1. Questions on Machine Learning and Deep Learning One Python coding question
Round 3 - Technical 

(1 Question)

  • Q1. Questions on Machine Learning, Deep Learning and NLP 1 coding Question on Python

Top trending discussions

View All
Interview Tips & Stories
2w
toobluntforu
·
works at
Cvent
Can speak English, can’t deliver in interviews
I feel like I can't speak fluently during interviews. I do know english well and use it daily to communicate, but the moment I'm in an interview, I just get stuck. since it's not my first language, I struggle to express what I actually feel. I know the answer in my head, but I just can’t deliver it properly at that moment. Please guide me
Got a question about Aidetic Software?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Job Portal and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Basic Hypothesis Understanding !
  • Q2. Apache Spark and Data Frames

Interview Preparation Tips

Interview preparation tips for other job seekers - Ask clearly for job role they said data scientist but currently I am doing MLOPS

Interview Questionnaire 

1 Question

  • Q1. Basic ML

Aidetic Software Interview FAQs

How many rounds are there in Aidetic Software interview?
Aidetic Software interview process usually has 2-3 rounds. The most common rounds in the Aidetic Software interview process are Technical, Coding Test and Resume Shortlist.
How to prepare for Aidetic Software 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 Aidetic Software. The most common topics and skills that interviewers at Aidetic Software expect are Python, SQL, Javascript, MongoDB and JQuery.
What are the top questions asked in Aidetic Software interview?

Some of the top questions asked at the Aidetic Software interview -

  1. What is the code to determine and print a happy numb...read more
  2. What is the transformer architecture in the context of neural networ...read more
  3. Needed to develop simple CRUD with search and sort using Grap...read more

Tell us how to improve this page.

Overall Interview Experience Rating

3/5

based on 6 interview experiences

Difficulty level

Easy 20%
Moderate 80%

Duration

Less than 2 weeks 60%
2-4 weeks 40%
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.6
 • 11.1k Interviews
Accenture Interview Questions
3.7
 • 8.7k Interviews
Infosys Interview Questions
3.6
 • 7.9k Interviews
Wipro Interview Questions
3.7
 • 6.1k Interviews
Cognizant Interview Questions
3.7
 • 5.9k Interviews
Amazon Interview Questions
4.0
 • 5.4k Interviews
Capgemini Interview Questions
3.7
 • 5.1k Interviews
Tech Mahindra Interview Questions
3.5
 • 4.1k Interviews
HCLTech Interview Questions
3.5
 • 4.1k Interviews
Genpact Interview Questions
3.7
 • 3.4k Interviews
View all

Aidetic Software Reviews and Ratings

based on 7 reviews

4.2/5

Rating in categories

4.8

Skill development

4.3

Work-life balance

3.9

Salary

4.0

Job security

4.7

Company culture

3.3

Promotions

4.5

Work satisfaction

Explore 7 Reviews and Ratings
Data Scientist
9 salaries
unlock blur

₹6 L/yr - ₹13.5 L/yr

Senior Data Scientist
6 salaries
unlock blur

₹17 L/yr - ₹20 L/yr

Software Developer
4 salaries
unlock blur

₹5.5 L/yr - ₹13 L/yr

Backend Developer
4 salaries
unlock blur

₹5.5 L/yr - ₹10.8 L/yr

QA Engineer
4 salaries
unlock blur

₹8 L/yr - ₹10.5 L/yr

Explore more salaries
Compare Aidetic Software with

TCS

3.6
Compare

Accenture

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare
write
Share an Interview