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

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

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 Innoviti Technologies Private Limited?
Ask anonymously on communities.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Types of Window Function
  • Ans. 

    Window functions are used in SQL to perform calculations across a set of table rows related to the current row.

    • Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.

    • They allow for calculations to be performed on a specific subset of rows within a query result set.

    • Window functions are commonly used for running totals, moving averages, and ranking data.

  • Answered by AI
  • Q2. Difference between Joins with examples
  • Ans. 

    Joins are used to combine rows from two or more tables based on a related column between them.

    • Inner Join: Returns rows when there is a match in both tables.

    • Left Join: Returns all rows from the left table and the matched rows from the right table.

    • Right Join: Returns all rows from the right table and the matched rows from the left table.

    • Full Outer Join: Returns rows when there is a match in one of the tables.

    • Cross Join: ...

  • Answered by AI

Skills evaluated in this interview

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Write code to calculate the number of people in a room at the end ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

I appeared for an interview in Dec 2021.

Round 1 - Video Call 

Round duration - 90 Minutes
Round difficulty - Easy

Problem solving using SQL questions

Round 2 - Video Call 

(1 Question)

Round duration - 90 Minutes
Round difficulty - Easy

A marketing campaign is run, how will you decide metrics to be tracked. Techincaly a KPI round

  • Q1. In a marketing campaign, how would you decide which metrics to track?
  • Ans. 

    Metrics selection based on campaign objectives, target audience, and key performance indicators.

    • Identify campaign objectives and goals

    • Consider target audience and their behavior

    • Select key performance indicators (KPIs) relevant to the campaign

    • Track metrics such as conversion rate, click-through rate, ROI, customer acquisition cost

    • Analyze data to measure success and make data-driven decisions

  • Answered by AI
Round 3 - HR 

Round duration - 30 Minutes
Round difficulty - Easy

Social empathatic fit round

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Data Analyst in BangaloreEligibility criteriaNoJupiter Money interview preparation:Topics to prepare for the interview - SQL, Tablea, Data Visualisation, Key Metrics for a Product, Data Visualisation using PythonTime required to prepare for the interview - 2 MonthsInterview preparation tips for other job seekers

Tip 1 : SQL logics to be understood completely
Tip 2 : A good running working logic of Python
Tip 3 : Basics of Dashboarding

Application resume tips for other job seekers

Tip 1 : One pager , single column resume which shows all your skills
Tip 2 : Mention all things that make you relevant for the job

Final outcome of the interviewSelected
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. Basic SQL questions are asked in this round Some theory questions are asked as well

Interview Preparation Tips

Interview preparation tips for other job seekers - focus on SQL
practice plenty of SQL and case study problems
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
6-8 weeks
Result
Selected Selected

I appeared for an interview 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
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I appeared for an interview in Apr 2025, where I was asked the following questions.

  • Q1. What are your salary expectations?
  • Ans. 

    I am looking for a competitive salary that reflects my skills and experience in data analysis, ideally in the range of $70,000 to $90,000.

    • Research industry standards: For example, Glassdoor and Payscale indicate that data analysts in my region earn between $70,000 and $90,000.

    • Consider my experience: With over 3 years in data analysis and proficiency in tools like SQL and Python, I believe I bring significant value.

    • Fact...

  • Answered by AI
  • Q2. Why do you want to work at TU?
  • Ans. 

    I admire TU's commitment to innovation and data-driven decision-making, which aligns perfectly with my passion for analytics.

    • TU's focus on cutting-edge technology in data analysis inspires me to contribute to impactful projects.

    • The collaborative environment at TU encourages knowledge sharing, which I value for personal and professional growth.

    • I am impressed by TU's initiatives in community engagement, and I want to lev...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Nov 2023. There were 4 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 from SQL,UNIX,PYTHON,AWS
Round 3 - One-on-one 

(1 Question)

  • Q1. Current Project
  • Ans. 

    Currently working on analyzing customer data for a retail company.

    • Analyzing customer purchase history

    • Identifying trends and patterns in customer behavior

    • Segmenting customers based on demographics and purchase preferences

  • Answered by AI
Round 4 - HR 

(1 Question)

  • Q1. Expected Salary,Process, Offer letter

Interview Preparation Tips

Interview preparation tips for other job seekers - Team Is very Good
Are these interview questions helpful?
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Assignment 

3 SQL questions were given

Round 2 - Technical 

(1 Question)

  • Q1. It was based upon my work experience and technical questions from SQL
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Easy to moderate level SQL questions will be asked.
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
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

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

I applied via Referral and was interviewed in Sep 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Coding Test 

Technical SQL Coding Round of 1 hour

Began with 2 easy generic question -
1. No. of record on different types of joins.
2. Employees who have higher salaries than their managers,

Then moved to medium questions -
1. Implement Rolling sum with & without window functions.
2. Other questions were on CTEs, Joins & other complex queries.

Round 3 - Case Study 

Bar Raiser Round of 1 hour involving -

1. Case study: How can we leverage product knowledge & analytics to increase Amazon Prime Revenue from 10% to 12%?

2. Metrics awareness: Common metrics discussion like DAU, PDAU, MAU, Retention, Churn, etc.

3. Resume based work exp discussion

Round 4 - HR 

(1 Question)

  • Q1. Quick culture fitment round with HR discussing about past work experience, my expectations & why I want to join Jupiter.

Interview Preparation Tips

Topics to prepare for Jupiter Money Data Analyst interview:
  • SQL

Tell us how to improve this page.

Join Innoviti Technologies Private Limited
Innoviti Technologies Private Limited Data Analyst Salary
based on 6 salaries
₹3.8 L/yr - ₹9.5 L/yr
7% less 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
83 salaries
unlock blur

₹2.5 L/yr - ₹10.4 L/yr

Area Sales Manager
47 salaries
unlock blur

₹4.6 L/yr - ₹9.5 L/yr

QA Engineer
27 salaries
unlock blur

₹3.8 L/yr - ₹9.6 L/yr

Assistant Manager
23 salaries
unlock blur

₹7 L/yr - ₹12.8 L/yr

Customer Support Executive
22 salaries
unlock blur

₹2.1 L/yr - ₹3.4 L/yr

Explore more salaries
Compare Innoviti Technologies Private Limited with

AGS Transact Technologies

2.9
Compare

Hitachi Payment Services

3.7
Compare

Rupeek

3.7
Compare

Mobikwik

3.6
Compare
write
Share an Interview