Upload Button Icon Add office photos
Engaged Employer

i

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

Triarq Health Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Triarq Health Data Analyst Interview Questions and Answers

Updated 29 May 2024

Triarq Health Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 29 May 2024

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

I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Tableau and Sql related questions
Round 2 - Technical 

(1 Question)

  • Q1. Questions based on project done

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Practo user image Pratik Chaudhari

posted on 17 Nov 2015

I applied via Referral

Interview Preparation Tips

Round: Resume Shortlist
Experience: Sent resume to an HR through Linkedin and got the call for interview

Round: Technical Interview
Experience: Had 3 rounds of technical interviews with Product Owner, Product Manager and VP Product. Most of the questions were related to maths, statistics and a few on machine learning. Even though I did not have much background on these, I was asked to give my inputs and try to find a solution. We discussed recommendation engines for Quora, Linkedin and e-commerce websites. Then they asked me how can we remove the bias that comes in the practo ratings of the doctors due to feedback from various channels. How can we identify if the customer is booking an appointment by looking at reviews or ratings? How can we identify spam reviews before publishing them? How can we build a product which can help users write a better quality review? Most of the questions were related to data science and how we can improve the products using data. The data analyst role for which I was being interviewed, was a first of its kind role in Practo. The JD was to basically work with the product team and help them in improving products, building new features etc. using data science/ data analytics.

Skills: Product Sense, Attitude, Data Science, Data Analysis, Basics Of Machine Learning
College Name: IIT Madras
Motivation: being the leader of the healthcare industry, high growth startup, opportunity to solve interesting problems using data

I applied via LinkedIn and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. SQL joins, python basics, resume based,

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare the basics well
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(5 Questions)

  • Q1. Basic Excel Questions
  • Q2. Medium and Basic SQL Questions
  • Q3. Resume based Question
  • Q4. Case Study Questions
  • Q5. Questions on Project
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Dec 2023. There were 2 interview rounds.

Round 1 - Assignment 

Power bi assignment was given to solve

Round 2 - Technical 

(6 Questions)

  • Q1. Optimization techniques in sql
  • Ans. 

    Optimization techniques in SQL involve using indexes, query optimization, and proper database design.

    • Use indexes on columns frequently used in WHERE clauses to speed up query performance

    • Avoid using SELECT * and instead specify only the columns needed in the query

    • Optimize queries by using appropriate join types and conditions

    • Normalize database tables to reduce redundancy and improve query efficiency

  • Answered by AI
  • Q2. Sub queries in sql
  • Ans. 

    Sub queries in SQL are queries nested within another query to retrieve data based on the result of the outer query.

    • Sub queries can be used in SELECT, INSERT, UPDATE, and DELETE statements.

    • They can be used to filter results, retrieve data from multiple tables, or perform calculations.

    • Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);

  • Answered by AI
  • Q3. Types of Join in sql
  • Ans. 

    Types of joins in SQL include inner join, left join, right join, and full outer join.

    • 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 all rows when there is a match in either table

  • Answered by AI
  • Q4. Time intelligence functions in power bi
  • Ans. 

    Time intelligence functions in Power BI are used to analyze and compare data based on time periods.

    • Time intelligence functions help in calculating year-to-date, month-to-date, and other time-based calculations.

    • Functions like TOTALYTD, SAMEPERIODLASTYEAR, and PARALLELPERIOD are commonly used for time intelligence in Power BI.

    • These functions allow for easy comparison of data across different time periods and help in tren

  • Answered by AI
  • Q5. Logical questions in aptitude
  • Q6. Row level security in power bi
  • Ans. 

    Row level security in Power BI allows users to restrict access to specific rows of data based on their role or criteria.

    • Row level security can be implemented by creating roles in Power BI and defining rules to filter data based on user roles.

    • Users can be assigned to specific roles which determine the data they have access to.

    • Row level security helps in ensuring data privacy and compliance with regulations.

    • For example, ...

  • Answered by AI

Skills evaluated in this interview

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

(2 Questions)

  • Q1. Salary discussion
  • Q2. Expected salary vs what they can offer

I applied via Naukri.com and was interviewed in Oct 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How do u rate yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest to the recruiter that's it
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via IIM Jobs and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

SQL + Python based questions

Round 2 - Technical 

(2 Questions)

  • Q1. More SQL + simple aptitude problems
  • Q2. Questions on joins, group by etc. Other questions on average speed, guesstimates.
Round 3 - Case Study 

A data set was given and the questions were asked around strategies to handle cancellations.

Interview Preparation Tips

Topics to prepare for Practo Business Analyst interview:
  • SQL
  • Case Studies
Interview preparation tips for other job seekers - Focus on SQL and problem solving.

Interview Questionnaire 

1 Question

  • Q1. Different types of joins in SQL, Delete drop truncate difference
  • Ans. 

    Different types of joins in SQL, Delete drop truncate difference

    • Types of joins: Inner join, Left join, Right join, Full outer join

    • Inner join returns only matching rows from both tables

    • Left join returns all rows from left table and matching rows from right table

    • Right join returns all rows from right table and matching rows from left table

    • Full outer join returns all rows from both tables

    • Delete is used to remove specific ...

  • Answered by AI

Skills evaluated in this interview

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

I applied via LinkedIn and was interviewed before Sep 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Normal aptitude question

Round 2 - Coding Test 

Detail of sql especially joins

Triarq Health Interview FAQs

How many rounds are there in Triarq Health Data Analyst interview?
Triarq Health interview process usually has 2 rounds. The most common rounds in the Triarq Health interview process are Technical.

Tell us how to improve this page.

Triarq Health Data Analyst Interview Process

based on 1 interview

Interview experience

2
  
Poor
View more

Triarq Health Data Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

5.0

Skill development

3.0

Work-life balance

2.0

Salary

1.0

Job security

2.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
94 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
18 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Engineer
18 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

QA Engineer
18 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
17 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Triarq Health with

Practo

3.2
Compare

Portea Medical

3.8
Compare

PharmEasy

3.7
Compare

Columbia Asia

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