Innoviti Technologies Private Limited Data Analyst Interview Questions and Answers

Q1. Questions from SQL,UNIX,PYTHON,AWS
Add your answer

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
Add your answer

Q1. Expected Salary,Process, Offer letter
Add your answer

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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer

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
Add your answer
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
Add your answer

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.

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

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

Round duration - 90 Minutes
Round difficulty - Easy

Problem solving using SQL questions

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
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

Social empathatic fit round

Q1. Basic SQL questions are asked in this round Some theory questions are asked as well
Add your answer

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
Add your answer
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: ...read more
Answered by AI
Add your answer

Q1. What is the order of execution in sql
Add your answer

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...read more
Answered by AI
Add your answer