Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Innoviti Technologies Private Limited Team. If you also belong to the team, you can get access from here

Innoviti Technologies Private Limited Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Innoviti Technologies Private Limited Data Analyst Interview Questions and Answers

Updated 16 Jul 2021

Innoviti Technologies Private Limited Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 16 Jul 2021

Interview Questionnaire 

1 Question

  • Q1. Vlookup

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
6-8 weeks
Result
Selected Selected

I was interviewed in Sep 2024.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me brief about your self
  • Ans. 

    I am a data analyst with a strong background in statistics and data visualization.

    • Experienced in analyzing large datasets using SQL, Python, and R

    • Skilled in creating insightful reports and dashboards using Tableau and Power BI

    • Strong communication skills to present findings to stakeholders

    • Certified in data analysis and machine learning techniques

  • Answered by AI
  • Q2. What are youre strenth and weekness
  • Ans. 

    My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.

    • Strength: Strong analytical skills

    • Strength: Attention to detail

    • Weakness: Getting caught up in details (provide example)

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Do best stay carm
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Mar 2023. 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. Detailed discussion on past experience and projects.
Round 3 - Technical 

(2 Questions)

  • Q1. 2 Hackerrank SQL Questions
  • Q2. 1 Hackerrank Python Question

Interview Preparation Tips

Topics to prepare for Razorpay Data Analyst interview:
  • SQL
  • Python
Interview preparation tips for other job seekers - Deep knowledge of SQL and Python is required along with Data Analysis fundamentals.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Aptitude Test 

It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.

I applied via Campus Placement and was interviewed in Dec 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical questions on sql

Interview Preparation Tips

Interview preparation tips for other job seekers - it is good experience and moderate prepare for sql, data visualisation etc,it lasted for 2 hrs 30 mins. the interviwers want to test by both technical and soft skills
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. What is the order of execution in sql
  • Ans. 

    The order of execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

    • 1. FROM: Specifies the tables involved in the query.

    • 2. WHERE: Filters the rows based on specified conditions.

    • 3. GROUP BY: Groups the rows that have the same values into summary rows.

    • 4. HAVING: Filters groups based on specified conditions.

    • 5. SELECT: Selects the columns to be included in the result set.

    • 6. ORDER BY: Sorts the result set base

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. How to do conditional formatting in excel
  • Ans. 

    Conditional formatting in Excel allows users to format cells based on specified conditions.

    • Select the range of cells you want to apply conditional formatting to

    • Go to the 'Home' tab and click on 'Conditional Formatting'

    • Choose the desired formatting option, such as color scales, data bars, or icon sets

    • Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be through with basics

Skills evaluated in this interview

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 - One-on-one 

(1 Question)

  • Q1. General questions and sql questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare aptitude and SQL questions and Bi tools

I applied via IIM Jobs and was interviewed before Nov 2021. 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 - Technical 

(2 Questions)

  • Q1. Different types of Joins in SQL and what are the outputs when you join two tables with nulls.
  • Ans. 

    Different types of Joins in SQL and the outputs when joining two tables with nulls.

    • Types of joins in SQL include inner join, left join, right join, and full outer join.

    • When joining two tables with nulls, the output depends on the type of join used.

    • In an inner join, null values are excluded from the result.

    • In a left join, all rows from the left table and matching rows from the right table are included, with nulls for no...

  • Answered by AI
  • Q2. Can you union tables with different datatypes.
  • Ans. 

    Yes, but it requires careful handling of data types and potential conversion.

    • Union can be performed on tables with different datatypes, but the resulting table will have a common datatype for each column.

    • Data types should be compatible, otherwise conversion may be necessary.

    • For example, a table with a column of integers can be unioned with a table with a column of floats, but the resulting column will be of type float.

    • ...

  • Answered by AI
Round 3 - Technical 

(2 Questions)

  • Q1. Given a data set, should write sql queries to answer a few questions
  • Q2. A few puzzles would be asked to evaluate the problem solving skills.
Round 4 - One-on-one 

(1 Question)

  • Q1. Business Case studies - try parctising profitablility and other cases
Round 5 - Technical 

(1 Question)

  • Q1. An Excel round will also be there if you apply for business analyst role.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be prepared - SQL, Excel and problem solving.
All the best for the interview.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Jul 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Easy questions based on Logical Reasoning, Mathematics, English

Round 2 - Group Discussion 

Be sure to put your thoughts on the topic you get, and try to put a point that meets the goals or aspirations of the company.

Round 3 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself Tell me something from your resume Desribe your project
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Apr 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

Apti was based on analytical skills

Round 2 - Group Discussion 

It was a fun GD which had the topic future app experiences.

Round 3 - Case Study 

Asked questions on guestimates and my analytical skills

Round 4 - HR 

(3 Questions)

  • Q1. HR questions and 1 analytical question asked.
  • Q2. Question asked on my location
  • Q3. Question asked on guestimates

Interview Preparation Tips

Interview preparation tips for other job seekers - Good Company. though long hiring process but was good overall.

Tell us how to improve this page.

Fast track your campus placements

View all
Innoviti Technologies Private Limited Data Analyst Salary
based on 7 salaries
₹3 L/yr - ₹10 L/yr
6% more than the average Data Analyst Salary in India
View more details

Innoviti Technologies Private Limited Data Analyst Reviews and Ratings

based on 2 reviews

2.9/5

Rating in categories

2.9

Skill development

2.3

Work-life balance

2.3

Salary

1.6

Job security

1.6

Company culture

2.3

Promotions

1.6

Work satisfaction

Explore 2 Reviews and Ratings
Software Engineer
82 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Area Sales Manager
43 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

QA Engineer
25 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Customer Support Executive
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Store Relationship Officer
21 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Innoviti Technologies Private Limited with

Razorpay

3.6
Compare

Payed

2.7
Compare

Mobikwik

3.7
Compare

Paytm

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