JioHotstar Data Analyst Interview Questions and Answers

SQL and Python data analysis questions

Q1. How do you match the data in different columns.
Ans. 
Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.
• Use string matching techniques like exact match, partial match, or fuzzy matching.

• Apply data cleaning and preprocessing techniques to standardize the data before matching.

• Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.

• Consider using database join...read more
Answered by AI
Add your answer

Q1. Profile screening
Add your answer
Q2. Previous employment details
Add your answer

Q1. Technical questions on tech stack. Mostly statistics and basic ML
Add your answer
Q2. Previous project details
Add your answer

Need to frame questions and their answers on data provided

Q1. Final salary discussion
Add your answer

Q1. What is your name
Ans. 
My name is John Doe.
• My first name is John

• My last name is Doe
Answered by AI
Add your answer
Q2. Introducing ur self
Add your answer

Q1. Why do you want work for us?
Ans. 
I am impressed by your company's innovative approach to data analysis and want to be a part of your team.
• I admire your company's reputation in the industry

• I am excited about the opportunity to work on cutting-edge projects

• I believe my skills and experience align well with the company's goals
Answered by AI
Add your answer
Q2. What are you strength
Ans. 
My strengths include strong analytical skills, attention to detail, and the ability to communicate complex data effectively.
• Strong analytical skills - able to interpret and analyze data effectively

• Attention to detail - meticulous in reviewing and ensuring accuracy of data

• Effective communication of complex data - able to present findings in a clear and understandable manner
Answered by AI
Add your answer

Involve working through a business problem or scenario with the interviewer to reach a logical conclusions

Q1. Introducing your self
Add your answer
Q2. Tell me about your self
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Experienced in using statistical tools such as R and Python

• Skilled in creating insightful data visualizations using Tableau

• Proficient in SQL for data querying and manipulation

• Strong analytical and problem-solving skills

• Excellent communication and presentation abilities
Answered by AI
Add your answer

Employers will set this type of test if they need to hire a person with excellent logical skills.

Code testing refers to running each line of code with a controlled input, and verifying if it performs the expected output

Q1. Introducing the same time
Add your answer
Q2. Telling me about company
Add your answer

Q1. SQL related questions like joins
Add your answer
Q2. Types of join in sql
Ans. 
Types of join in SQL include inner join, left join, right join, and full outer join.
• Inner join returns only the matching records from both tables.

• Left join returns all records from the left table and the matching records from the right table.

• Right join returns all records from the right table and the matching records from the left table.

• Full outer join returns all records when there is a match in either the left or rig...read more
Answered by AI
Add your answer
Q3. Practical use of left join
Add your answer
Q4. Number of rows after applying certain join operations
Add your answer
Q5. Difference between vlookup in excel and some function in sql
Ans. 
VLOOKUP in Excel is used to search for a value in a table and return a corresponding value, while SQL functions like JOIN and WHERE are used to retrieve data from multiple tables based on specified conditions.
• VLOOKUP is specific to Excel and works on a single table, while SQL functions can work on multiple tables.

• VLOOKUP requires the table to be sorted in ascending order, while SQL functions do not have this requiremen...read more
Answered by AI
Add your answer

Q1. Previous company experience and current company roles and responsibilities
Add your answer

HackerRank Test - Python, SQL

Simple SQL & Excel test

Q1. Will Face hiring Manager
Add your answer

Q1. What is the year-over-year growth of the product category ? Sql
Ans. 
Year-over-year growth measures the annual increase in a product category's sales or revenue, indicating performance trends.
• Calculation: Year-over-year growth is calculated using the formula: ((Current Year Value - Previous Year Value) / Previous Year Value) * 100.

• Example: If a product category generated $100,000 last year and $120,000 this year, the growth would be ((120,000 - 100,000) / 100,000) * 100 = 20%.

• Trend Anal...read more
Answered by AI
Add your answer
Q2. What are the days on which the temperature was higher than the previous day? Sql
Ans. 
Identify days when the temperature exceeded the previous day's temperature using SQL queries for data analysis.
• Self-Join: Use a self-join to compare each day's temperature with the previous day's temperature.

• Date Functions: Utilize date functions to ensure you're comparing the correct days.

• Example Query: SELECT current_day, temperature FROM weather_data AS wd1 JOIN weather_data AS wd2 ON wd1.date = DATE_ADD(wd2.date, I...read more
Answered by AI
Add your answer