Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Pristyn Care Team. If you also belong to the team, you can get access from here

Pristyn Care Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Pristyn Care Data Analyst Interview Questions and Answers

Updated 17 Jun 2024

Pristyn Care Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Aftab alam

posted on 17 Jun 2024

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

(2 Questions)

  • Q1. What is SQL pls definitons
  • Ans. 

    SQL is a programming language used for managing and manipulating relational databases.

    • SQL stands for Structured Query Language.

    • It is used to communicate with databases to retrieve, insert, update, and delete data.

    • Common SQL commands include SELECT, INSERT, UPDATE, and DELETE.

    • SQL is used in various database management systems like MySQL, PostgreSQL, and Oracle.

    • Example: SELECT * FROM customers WHERE city = 'New York';

  • Answered by AI
  • Q2. What is left join how many types of join in sql
  • Ans. 

    A left join is a type of join in SQL that returns all records from the left table and the matched records from the right table.

    • Left join is used to retrieve all records from the left table and the matched records from the right table.

    • If there is no match, NULL values are returned for the columns from the right table.

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

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

2 Questions

  • Q1. Explain Normal distribution
  • Ans. 

    Normal distribution is a probability distribution that is symmetric and bell-shaped.

    • It is also known as Gaussian distribution.

    • It is characterized by mean and standard deviation.

    • Many natural phenomena follow normal distribution, such as height and weight of individuals.

    • 68% of the data falls within one standard deviation of the mean, 95% within two standard deviations, and 99.7% within three standard deviations.

    • It is wid...

  • Answered by AI
  • Q2. Types of jobs in sql
  • Ans. 

    SQL jobs include database administrator, data analyst, data scientist, business intelligence analyst, and software developer.

    • Database Administrator

    • Data Analyst

    • Data Scientist

    • Business Intelligence Analyst

    • Software Developer

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare for MySql thoroughly

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Job Portal

Round 1 - Coding Test 

SQL and Python data analysis questions

Round 2 - Technical 

(1 Question)

  • 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...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Coding Test 

SQL query optimisation

Round 2 - HR 

(1 Question)

  • Q1. Regular discussion, about job role, why swiggy

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare excel, and sql
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I applied via Referral and was interviewed before Sep 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Quant, LR, puzzles, cat based level 2 questions

Round 2 - Technical 

(2 Questions)

  • Q1. Difference between tuple nd list
  • Ans. 

    Tuple is immutable and ordered, while list is mutable and ordered in Python.

    • Tuple is created using parentheses () while list is created using square brackets []

    • Tuple elements cannot be changed once assigned, while list elements can be modified

    • Tuple is faster than list for iteration and accessing elements

    • Example: tuple = (1, 2, 3) and list = [1, 2, 3]

  • Answered by AI
  • Q2. How will you cut a cake into 8 equal pieces by 3 cuts
Round 3 - HR 

(2 Questions)

  • Q1. Walk me through ur cv
  • Ans. 

    I have a strong background in data analysis with experience in various industries.

    • Bachelor's degree in Statistics with a focus on data analysis

    • Proficient in SQL, Python, and data visualization tools like Tableau

    • Experience working with large datasets and conducting statistical analysis

    • Completed internships at XYZ Company and ABC Organization

    • Presented findings at industry conferences

  • Answered by AI
  • Q2. What have learnt from this experience?
  • Ans. 

    I have learned to effectively analyze and interpret data to derive meaningful insights and make informed decisions.

    • Developed strong analytical skills through hands-on experience with various data analysis tools and techniques

    • Improved ability to identify trends, patterns, and outliers in data sets

    • Enhanced communication skills by presenting findings and recommendations to stakeholders

    • Learned to collaborate with team memb

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - just be honest , calm

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Apr 2023. There were 2 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 

(6 Questions)

  • Q1. Joins, operations questions not data analysis questions
  • Q2. Customer retention case study
  • Q3. Cumulative sum for given table
  • Ans. 

    To calculate cumulative sum for a given table

    • Sort the table in ascending order based on the column you want to calculate the cumulative sum for

    • Add a new column to the table to store the cumulative sum

    • Iterate through each row of the table and calculate the cumulative sum by adding the current row's value to the previous row's cumulative sum

    • Store the cumulative sum in the new column for each row

  • Answered by AI
  • Q4. Do you have experience in operations/data entry role
  • Ans. 

    Yes, I have experience in both operations and data entry roles.

    • I have worked as a data entry operator for a pharmaceutical company where I was responsible for entering patient data into the system.

    • In my previous role as an operations analyst, I was responsible for analyzing data and creating reports for the management team.

    • I have experience using various data entry software such as Microsoft Excel and Google Sheets.

    • I a...

  • Answered by AI
  • Q5. As a data analyst can you do data entry work also?
  • Ans. 

    Yes, I can do data entry work as a data analyst.

    • Data entry work is a part of data analysis process.

    • I have experience in data entry work and can perform it efficiently.

    • Data entry work includes entering data into spreadsheets, databases, or other software.

    • I understand the importance of accurate data entry for effective analysis.

  • Answered by AI
  • Q6. Normal excel statements like if, vlookup, xlookups etc.,

Interview Preparation Tips

Interview preparation tips for other job seekers - 1) Waste of time (never trust interviewer who explains about the role)
2) they are looking for candidates for data reporting operations guy from a tier 1 college
3) as discussed with the interviewer the profile will be like a data entry operations role so get clarification on the role properly.
4) if you get an offer letter try to make this company as least priority company as the JD is not clear and the way they explain the case study is truly confusing.
5) other than this central tendency, normal crunching, joins, etc,.
6) People from non - data analytics team took an interview I hope there is no data analyst in the company while checking in LinkedIn and even the interviewer mentioned the same.
7) Interview will get rescheduled several times because of the interviewer and will be more delay
8) as per their discussion it will be more about data reporting in google sheets, excel on a daily basis i guess and I hope there won't be any proper predictive or quantitative or qualitative analysis.
9) if you are looking for better learning, growth and advancement in your career then this is not a correct company for you(that's how I decided when comparing offers from other company).
10) try to communicate with employees of the company who are in current role or past role get a better understanding.
11) current company situtation might push you but take a better decision.
12)chhallaaang lagaane se pahale dekho.

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Apr 2023. There were 6 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 - HR 

(2 Questions)

  • Q1. Screening questions
  • Q2. Name, age, qualification, prior experience etc
Round 3 - Case Study 

Operation questions like vlookups, Hlookups, xlookups etc,.

Round 4 - Case Study 

Reporting questions like pivot tables, typing speed, power pivots, pricing sheet preparation

Round 5 - Case Study 

SQL queries like joins, aggregation functions, filters etc,.

Round 6 - One-on-one 

(3 Questions)

  • Q1. Advanced analytics and finding trends and patterns with MH - operations data
  • Q2. How fast can you prepare a bar chart with product operations data
  • Ans. 

    I can prepare a bar chart with product operations data within a few minutes.

    • I have experience using data visualization tools like Tableau, Power BI, or Excel to quickly create bar charts.

    • I am proficient in organizing and cleaning data to ensure accurate representation in the chart.

    • I can customize the chart with relevant labels, colors, and titles to make it visually appealing and easy to understand.

  • Answered by AI
  • Q3. How can I do merge multiple excel files together
  • Ans. 

    You can merge multiple Excel files together using the 'Consolidate' feature in Excel.

    • Open Excel and go to the 'Data' tab

    • Click on 'Consolidate' in the 'Data Tools' group

    • Select the files you want to merge and choose the desired options

    • Click 'OK' to merge the files together

  • Answered by AI

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Coding Test 

HackerRank Test - Python, SQL

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Job Portal and was interviewed before Jun 2022. There were 2 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 - One-on-one 

(1 Question)

  • Q1. Previous company experience and current company roles and responsibilities
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. SQL related questions like joins
  • 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
  • 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...

  • Answered by AI
  • 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
  • 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...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for SQL

Skills evaluated in this interview

Pristyn Care Interview FAQs

How many rounds are there in Pristyn Care Data Analyst interview?
Pristyn Care interview process usually has 1 rounds. The most common rounds in the Pristyn Care interview process are Technical.
How to prepare for Pristyn Care Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Pristyn Care. The most common topics and skills that interviewers at Pristyn Care expect are MongoDB, MySQL, Presentation Skills, Program Management and Python.
What are the top questions asked in Pristyn Care Data Analyst interview?

Some of the top questions asked at the Pristyn Care Data Analyst interview -

  1. what is left join how many types of join in ...read more
  2. What is SQL pls definit...read more

Tell us how to improve this page.

Pristyn Care Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Pristyn Care Data Analyst Salary
based on 32 salaries
₹3.5 L/yr - ₹8 L/yr
8% less than the average Data Analyst Salary in India
View more details

Pristyn Care Data Analyst Reviews and Ratings

based on 4 reviews

3.7/5

Rating in categories

4.0

Skill development

2.5

Work-life balance

2.5

Salary

2.5

Job security

2.3

Company culture

2.3

Promotions

3.5

Work satisfaction

Explore 4 Reviews and Ratings
Business Development Manager
679 salaries
unlock blur

₹3 L/yr - ₹7.3 L/yr

Team Lead
229 salaries
unlock blur

₹4 L/yr - ₹9 L/yr

Category Manager
139 salaries
unlock blur

₹7 L/yr - ₹18.6 L/yr

Senior Associate
126 salaries
unlock blur

₹3 L/yr - ₹8 L/yr

Senior Manager
80 salaries
unlock blur

₹9.5 L/yr - ₹30 L/yr

Explore more salaries
Compare Pristyn Care with

Udaan

4.0
Compare

Swiggy

3.8
Compare

BlackBuck

3.8
Compare

Ninjacart

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