Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Priority Technology Holdings Data Analyst Interview Questions and Answers

Updated 17 Feb 2021

Priority Technology Holdings Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 17 Feb 2021

Interview Questionnaire 

2 Questions

  • Q1. What are DDL commands?
  • Ans. 

    DDL commands are used to define and manage the structure of a database.

    • DDL stands for Data Definition Language.

    • DDL commands are used to create, modify, and delete database objects such as tables, indexes, and views.

    • Examples of DDL commands include CREATE, ALTER, and DROP.

    • DDL commands do not manipulate the data within the database, only the structure.

  • Answered by AI
  • Q2. Difference between Truncate and Delete statement??
  • Ans. 

    Truncate is a DDL statement that removes all rows from a table, while delete is a DML statement that removes specific rows.

    • Truncate is faster than delete as it doesn't generate any rollback information.

    • Truncate cannot be rolled back, while delete can be.

    • Truncate resets the identity of the table, delete does not.

    • Truncate does not fire triggers, delete does.

    • Truncate is non-logged operation, delete is logged.

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Data Analyst Interview Questions & Answers

PayPal user image AKASH KUMAR SINGH

posted on 2 Dec 2016

I applied via Campus Placement and was interviewed in Dec 2016. There were 6 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. For this round he gave me lot of problems and asked to develop optimal algorithm to solve that. Problems were mainly on trees and number sequences
  • Q2. In this round he mainly discussed my projects and asked me how these can be put to use in Paypal. He also asked some basic questions from ML
  • Q3. HR round was just for formality
  • Q4. Probability , question on calculating expected number of trials and puzzles

Interview Preparation Tips

Round: Test
Experience: The coding question was:
Given a binary string containing 0's and 1's. You can split the string such that each partition should be a exponential of 5 (1,5,25,625...). You were asked to return minimum number of partition for the given string such each partition is exponential of 5. If no such partition exists return -1.
Examples: '101101101' Ans: 3 (101, 101, 101)
'111' Ans: 3 (1,1,1)
10101 Ans: -1
Tips: For MCQ's prepare DSA, OS and Networking. For DSA you can refer to cormen
For Coding question practice on either geeksforgeeks or from any of the coding platforms like hackerrank
The shortlist was mainly dependent on coding question
Duration: 1 hour 30 minutes

Round: Puzzle Interview
Tips: Do lot of puzzles from heard on the street, -----/ , Try to search for more. It will be helpful in other interviews as well

Round: Technical Interview
Tips: Practice algorithm section from geeksforgeeks. There are lot of standard problems. The given questions were slightly modified version of standard problems

Round: Technical Interview
Tips: For this round you need to be well prepared with your projects and resume.

College Name: IIT Madras

I applied via Company Website

Interview Questionnaire 

1 Question

  • Q1. Tell me about a project you worked on in which you handled large set of data and multiple tables.

Interview Preparation Tips

Interview preparation tips for other job seekers - Share your geniune answers, articulate them well and be yourself.

Data Analyst Interview Questions & Answers

PayPal user image Snehith Korukonda

posted on 21 Aug 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Naukri.com and was interviewed in Jul 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

Topics were, DSA, SQL, PL/SQL, Data Augmentation

Round 2 - Coding Test 

Customer churn classification using a classification ML model

Round 3 - Technical 

(2 Questions)

  • Q1. Write a pseudo code for Bubble sort
  • Ans. 

    Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements, and swaps them if they are in the wrong order.

    • Start with the first element and compare it with the next element, swapping if necessary

    • Repeat this process for each pair of adjacent elements in the array until the entire array is sorted

    • Continue this process for each element in the array until no more swaps are ne

  • Answered by AI
  • Q2. What is an API
  • Ans. 

    An API (Application Programming Interface) is a set of rules and protocols that allows different software applications to communicate with each other.

    • APIs define the methods for requesting and receiving data between software applications

    • APIs can be used to access data from external sources, such as social media platforms or weather services

    • Examples of APIs include the Twitter API, Google Maps API, and Spotify API

  • Answered by AI
Round 4 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a data analyst with a strong background in statistics and data visualization.

    • Graduated with a degree in Statistics

    • Proficient in programming languages like Python and R

    • Experience in analyzing large datasets and creating data visualizations

    • Strong problem-solving skills and attention to detail

  • Answered by AI
  • Q2. Salaray compensation how much

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Job Portal and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Sql and aptitude questions

Round 2 - Technical 

(2 Questions)

  • Q1. Question from resume amd project
  • Q2. Some questions on sql
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Mar 2023. There were 3 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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. Detailed discussion on past experience and projects.
Round 3 - Technical 

(2 Questions)

  • Q1. 2 Hackerrank SQL Questions
  • Q2. 1 Hackerrank Python Question

Interview Preparation Tips

Topics to prepare for Razorpay Data Analyst interview:
  • SQL
  • Python
Interview preparation tips for other job seekers - Deep knowledge of SQL and Python is required along with Data Analysis fundamentals.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Aptitude Test 

It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Basic questions about resume
Round 2 - One-on-one 

(2 Questions)

  • Q1. Workplace adjustment questions
  • Q2. Are you willing to work extra hours
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. What is the order of execution in sql
  • Ans. 

    The order of execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

    • 1. FROM: Specifies the tables involved in the query.

    • 2. WHERE: Filters the rows based on specified conditions.

    • 3. GROUP BY: Groups the rows that have the same values into summary rows.

    • 4. HAVING: Filters groups based on specified conditions.

    • 5. SELECT: Selects the columns to be included in the result set.

    • 6. ORDER BY: Sorts the result set base

  • Answered by AI
Round 2 - Technical 

(1 Question)

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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be through with basics

Skills evaluated in this interview

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

I applied via LinkedIn and was interviewed in Jul 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Easy questions based on Logical Reasoning, Mathematics, English

Round 2 - Group Discussion 

Be sure to put your thoughts on the topic you get, and try to put a point that meets the goals or aspirations of the company.

Round 3 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself Tell me something from your resume Desribe your project
Contribute & help others!
anonymous
You can choose to be anonymous

Priority Technology Holdings Interview FAQs

How to prepare for Priority Technology Holdings 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 Priority Technology Holdings. The most common topics and skills that interviewers at Priority Technology Holdings expect are Looker, SQL, Tableau, Data Analytics and Data Integration.
What are the top questions asked in Priority Technology Holdings Data Analyst interview?

Some of the top questions asked at the Priority Technology Holdings Data Analyst interview -

  1. What are DDL comman...read more
  2. Difference between Truncate and Delete statemen...read more

Recently Viewed

INTERVIEWS

Priority Technology Holdings

5.6k top interview questions

INTERVIEWS

Bridgestone

No Interviews

INTERVIEWS

Continental

No Interviews

SALARIES

Hotel Hindusthan International

SALARIES

SIA PUBLISHERS & DISTRIBUTORS

SALARIES

Hotel Hindusthan International

INTERVIEWS

FedEx Express

No Interviews

JOBS

SIA PUBLISHERS & DISTRIBUTORS

No Jobs

INTERVIEWS

Goodyear

No Interviews

INTERVIEWS

Vepsun Technologies

No Interviews

Tell us how to improve this page.

Fast track your campus placements

View all
Priority Technology Holdings Data Analyst Salary
based on 6 salaries
₹9 L/yr - ₹13 L/yr
74% more than the average Data Analyst Salary in India
View more details

Priority Technology Holdings Data Analyst Reviews and Ratings

based on 2 reviews

3.6/5

Rating in categories

3.0

Skill development

4.0

Work-life balance

3.0

Salary

4.0

Job security

3.0

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 2 Reviews and Ratings
Analyst
34 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
22 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Engineer
20 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
15 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
14 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Priority Technology Holdings with

Fiserv

3.0
Compare

FIS

3.9
Compare

Global Payments

4.1
Compare

WEX Inc

2.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent