AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Aditi Consulting
Compare
Filter interviews by
Aditi Consulting Data Analyst Interview Questions and Answers for Freshers
Aditi Consulting Data Analyst Interview Experiences for Freshers
1 interview found
Anonymous
I applied via LinkedIn and was interviewed in Apr 2023. There were 3 interview rounds.
(1 Question)
- Q1. Tell me above projects
(1 Question)
- Q1. Questions on SQL
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Interview Preparation Tips
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
Selected
I applied via Campus Placement and was interviewed before Nov 2023. There were 5 interview rounds.
2 coding questions in 45 min
(2 Questions)
- Q1. Basics of java and frameworks
- Q2. Basics of SQL and types of queries
30 min of logical reasoning and basic aptitude
30 min of GD over a general topic to check your communication skills
(2 Questions)
- Q1. Why do you want to join our company
- Q2. Why should we hire you
(1 Question)
- Q1. All basic concepts of pthon sql and ml
Apptitude, tecncal, cognitiive
I applied via Campus Placement and was interviewed in Nov 2023. There were 4 interview rounds.
Blood Relations, Pipes and Cisterns, Time and work etc.
Question based on hashmap
Is Artificial Intelligence boon or ban.
(2 Questions)
- Q1. Python and SQL questions
- Q2. Python and Numpy, Pandas
Interview Preparation Tips
I applied via LinkedIn and was interviewed before Oct 2021. There were 3 interview rounds.
8 python coding
With 2 aptitude
Game based assessment.
More than 8 games need to play
(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...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Nov 2022. There were 5 interview rounds.
Get questions from all topics and medium level questions
They give one topic and provide one minute for thinking its overall 30 min discussion
(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
(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
Interview Preparation Tips
Selected
I applied via Campus Placement
It was easy to approach!
Discussions about common topics like boon or bane to society
Asked about the scenarios
(1 Question)
- Q1. Technical round related to skills and resume
(1 Question)
- Q1. Discussions regarding work culture and compensations
Divyanshu Chaudhary
I applied via Referral and was interviewed before May 2023. There were 3 interview rounds.
Questions were tough- DP Array
Different GPOs policy were discussed
(1 Question)
- Q1. Questions were regarding Behavior
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Nov 2023. There were 2 interview rounds.
It was a 3 hour test with 144 questions
(1 Question)
- Q1. Why did you select this company?
Aditi Consulting Interview FAQs
Tell us how to improve this page.
Aditi Consulting Interviews By Designations
- Aditi Consulting Senior Engineer Interview Questions
- Aditi Consulting Trainee Recruiter Interview Questions
- Aditi Consulting Manager Interview Questions
- Aditi Consulting Senior Recruiter Interview Questions
- Aditi Consulting Data Analyst Interview Questions
- Aditi Consulting Software Developer Interview Questions
- Aditi Consulting Lead Recruiter Interview Questions
- Aditi Consulting Tableau Developer and Business Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Aditi Consulting Data Analyst Interview Process for Freshers
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
Aditi Consulting Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Technical Recruiter
111
salaries
|  ₹3 L/yr - ₹6 L/yr |
|
Senior Technical Recruiter
95
salaries
| ₹4.1 L/yr - ₹10.5 L/yr |
|
Software Engineer
29
salaries
| ₹7.4 L/yr - ₹27.1 L/yr |
|
Technical Lead
28
salaries
| ₹32 L/yr - ₹89 L/yr |
|
Lead Recruiter
20
salaries
| ₹6.3 L/yr - ₹13 L/yr |
Tekwissen
Softenger
XcelServ Solutions
Damco Solutions
- Home >
- Interviews >
- Aditi Consulting Interview Questions >
- Aditi Consulting Data Analyst Interview Questions for Fresher
