Upload Button Icon Add office photos

Filter interviews by

Impelsys Data Analyst Interview Questions and Answers

Updated 24 Jul 2021

Impelsys Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 24 Jul 2021

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 ...

  • Answered by AI
  • Q2. 2.right join Vs right outer join
  • Ans. 

    Right join and right outer join are the same thing.

    • Right join and right outer join are interchangeable terms.

    • Both return all the rows from the right table and matching rows from the left table.

    • If there is no match, the result will contain NULL values for the left table columns.

    • Used to combine data from two tables based on a common column.

    • Syntax: SELECT * FROM table1 RIGHT JOIN table2 ON table1.column = table2.column;

  • Answered by AI
  • 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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Must have advanced level SQL skills

Skills evaluated in this interview

Interview questions from similar companies

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
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Dec 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Tell about yourself
  • Ans. 

    I am a data analyst with a background in statistics and programming, passionate about turning data into actionable insights.

    • Background in statistics and programming

    • Experience in data analysis and visualization tools like Python, R, and Tableau

    • Strong problem-solving skills and attention to detail

    • Ability to communicate complex data findings to non-technical stakeholders

  • Answered by AI
  • Q2. Rate yourself in sql
  • Ans. 

    I rate myself as proficient in SQL with experience in writing complex queries and optimizing database performance.

    • Proficient in writing complex SQL queries

    • Experience in optimizing database performance

    • Familiar with database management systems like MySQL, PostgreSQL, etc.

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - The process was straightforward and hassle-free.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - The process was straightforward and hassle-free.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Can you tell me about yourself?

Interview Preparation Tips

Interview preparation tips for other job seekers - The process was straightforward and hassle-free.
Interview experience
2
Poor
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I appeared for an interview in Jan 2025.

Round 1 - Technical 

(3 Questions)

  • Q1. Tell me about yourself
  • Q2. Asked All SQL Syllabus
  • Q3. Asked All Power Bi concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - Dont give interview took 2 hours and given 70% answers still not selected
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Online aptitude test have been coundected

Round 2 - Technical 

(1 Question)

  • Q1. About the data procesig and projects on data science

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 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

Impelsys Interview FAQs

What are the top questions asked in Impelsys Data Analyst interview?

Some of the top questions asked at the Impelsys Data Analyst interview -

  1. 1. Different between distinct and group by if it performed in single colu...read more
  2. 3.how to handle column with special ch...read more
  3. 2.right join Vs right outer j...read more

Tell us how to improve this page.

Impelsys Data Analyst Salary
based on 7 salaries
₹5 L/yr - ₹13.8 L/yr
35% more than the average Data Analyst Salary in India
View more details
Senior Software Engineer
191 salaries
unlock blur

₹6.2 L/yr - ₹24 L/yr

Software Engineer
190 salaries
unlock blur

₹2.5 L/yr - ₹12 L/yr

Technical Lead
46 salaries
unlock blur

₹12.2 L/yr - ₹37 L/yr

Softwaretest Engineer
46 salaries
unlock blur

₹3 L/yr - ₹12.6 L/yr

Senior QA Engineer
42 salaries
unlock blur

₹6 L/yr - ₹18 L/yr

Explore more salaries
Compare Impelsys with

Tekwissen

4.8
Compare

Damco Solutions

3.9
Compare

smartData Enterprises

3.3
Compare

In Time Tec Visionsoft

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