Jumbotail Technologies Data Analyst Interview Questions and Answers

Q1. Interviewer asked me basic SQL questions
Add your answer
Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
Add your answer

In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.

Simple SQL & Excel test

Q1. Will Face hiring Manager
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
Answered by AI
Add your answer
Q3. Practical use of left join
Ans. 
A left join is used to combine data from two tables based on a common column, including all records from the left table.
• Left join returns all rows from the left table and the matching rows from the right table.

• It is useful when you want to retrieve all records from the left table, even if there are no matches in the right table.

• The result of a left join will have NULL values in the columns from the right table where th...read more
Answered by AI
Add your answer
Q4. Number of rows after applying certain join operations
Ans. 
The number of rows after applying join operations depends on the type of join used and the data in the tables being joined.
• Inner join retains only the rows that have matching values in both tables

• Left join retains all rows from the left table and the matched rows from the right table

• Right join retains all rows from the right table and the matched rows from the left table

• Full outer join retains all rows when there is a
Answered by AI
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

HackerRank Test - Python, SQL

SQL query optimisation

Q1. Regular discussion, about job role, why swiggy
Add your answer

Aptitude test is a way for employers to assess a candidate's abilities through a variety of different testing formats. Aptitude tests will test your ability to perform tasks and react to situations at work. This includes: problem-solving.

Q1. Tell me something about yourself. How did you hear about this position? Why do you want to work here?
Ans. Hi thank you for giving me this opportunity to introduce my self lakshmi r am basically from doddballapur i graduate in b. Com from banglore north university
Answered Anonymously
View 1 more answer
Q2. What is your greatest strength? What are your strengths and weaknesses? What do you know about this company/organization?
Add your answer

Q1. What’s your previous experience
Ans. 
I have 3 years of experience as a data analyst in the finance industry.
• Worked with large datasets to extract meaningful insights

• Performed data cleaning, transformation, and visualization

• Created and maintained dashboards and reports for stakeholders

• Conducted statistical analysis and built predictive models

• Collaborated with cross-functional teams to identify business opportunities
Answered by AI
Add your answer
Q2. What’s your skills for the current role
Ans. 
I have strong skills in data analysis, including proficiency in statistical analysis, data visualization, and programming languages such as Python and SQL.
• Proficient in statistical analysis techniques

• Skilled in data visualization using tools like Tableau

• Strong programming skills in Python and SQL

• Experience with data cleaning and preprocessing

• Ability to interpret and communicate insights from data

• Familiarity with machin...read more
Answered by AI
Add your answer

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