AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Impelsys Data Analyst Interview Questions and Answers
Impelsys Data Analyst Interview Experiences
1 interview found
Anonymous
I applied via LinkedIn and was interviewed in Jun 2021. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. 1. Different between distinct and group by if it performed in single column
- Ans.
Distinct returns unique values while group by groups and aggregates data based on a column.
Distinct returns only unique values from a single column.
Group by groups and aggregates data based on a column.
Distinct can be used to count the number of unique values in a column.
Group by can be used to group data by a column and perform aggregate functions like sum, count, avg, etc.
Distinct is used to remove duplicates from a ...
- Q2. 2.right join Vs right outer join
- Q3. 3.how to handle column with special char.
- Ans.
Special characters in columns can be handled by replacing or removing them.
Identify the special characters in the column
Replace the special characters with a suitable alternative
Remove the special characters if they are not necessary
Use regular expressions to handle complex special characters
Ensure that the data type of the column is appropriate
Interview Preparation Tips
Skills evaluated in this interview
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 appeared for an interview in Jan 2025, where I was asked the following questions.
- Q1. How do you handle criticism?
- Ans.
I view criticism as an opportunity for growth and improvement, embracing feedback to enhance my skills and work quality.
I actively listen to the feedback without becoming defensive, ensuring I understand the critique fully.
For example, if a colleague points out an error in my data analysis, I take time to review their comments and learn from the mistake.
I ask clarifying questions to gain deeper insights into the critic...
- Q2. Are you willing to relocate or work flexible hours?
- Ans.
I am open to relocating and working flexible hours to meet the needs of the role and contribute effectively to the team.
Relocation: I am willing to move to a new city if it enhances my career opportunities.
Flexible Hours: I understand that data analysis can require working outside of standard hours, and I am adaptable.
Example: In my previous role, I often adjusted my schedule to collaborate with international teams.
I applied via Referral and was interviewed in Jun 2022. There were 3 interview rounds.
In this test they asked about basic internet knowledge like what is domain and co domain. And how to get the details of a company and cross check them. And basic ms office knowledge to work on given files.
(3 Questions)
- Q1. Why do you wanna work here.
- Ans. To achieve my goals while helping the company to grow.
- Q2. What you see yourself after 2 years.
- Ans. To be at higher position in this company.
- Q3. Why do you want to work in this field.
- Ans. Because it's an great opportunity to earn while learning and growing.
Interview Preparation Tips
- MS Office
- Basic internet knowledge
- Adobe Acrobat
(1 Question)
- Q1. Tell me about yourself.
Interview Preparation Tips
(1 Question)
- Q1. Tell me about yourself.
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
(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
Impelsys Interview FAQs
Tell us how to improve this page.
Impelsys Interviews By Designations
- Impelsys Software Engineer Interview Questions
- Impelsys Senior Software Engineer Interview Questions
- Impelsys Associate Software Engineer Interview Questions
- Impelsys Software Engineer Trainee Interview Questions
- Impelsys PHP Developer Interview Questions
- Impelsys Data Analyst Interview Questions
- Impelsys Software Developer Interview Questions
- Impelsys Business Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Interview Questions from Similar Companies
Impelsys Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Software Engineer
219
salaries
|  ₹4.2 L/yr - ₹10.3 L/yr |
|
Senior Software Engineer
199
salaries
| ₹11.9 L/yr - ₹21 L/yr |
|
Senior QA Engineer
48
salaries
| ₹8.2 L/yr - ₹15.1 L/yr |
|
QA Engineer
44
salaries
| ₹4.5 L/yr - ₹9 L/yr |
|
Softwaretest Engineer
44
salaries
| ₹4.1 L/yr - ₹10.3 L/yr |
Damco Solutions
smartData Enterprises
In Time Tec Visionsoft
AgreeYa Solutions
- Home >
- Interviews >
- Impelsys Interview Questions
