Provakil Technologies Data Analyst Interview Questions and Answers

Hacker Rank Test that was not much hard

Q1. Basics of python, SQL and pyspark
Add your answer
Q2. Projects written in the resume
Add your answer

Q1. On databricks architecture
Add your answer
Q2. Previous project experience
Add your answer

Easy and moderate level question

Given a relevant topic and discussion on it

Q1. Introducd yourself
Add your answer
Q2. Why do you want to join us
Add your answer

Intermediate SQL Topics - Window Function, Subquery, Joins

Tables:
registration (userid string, regdate date);
txn(txndate date, userid string, amt int, game string);

1. Write a query to get proportion of users who have played a game within 2 days of registration
2. Find the most money spent on a game for each user
3. Get the list of users who played poker but not ludo

Based on my CV, they assigned me a task related to data migration.

Q1. Project reviews
Add your answer
Q2. Attendance regarding
Add your answer

The Technical coding round will tested me on mid to complicated python and SQL coding

Q1. The technical round delved into my ongoing projects and tech stack where moreover python, SQL, DSA, spark architecture were discussed.
Add your answer

Q1. The HR discussion was a wrap up highlighting the company's culture and values and salary discussion Overall the onboarding was seamless.
Add your answer

Reasoning and aptitude questions were asked

Q1. Interview was around python programming and team fitment
Add your answer

Q1. Pyspark fundamentals
Add your answer
Q2. SQL coding qsns
Add your answer

One python coding question and one sql coding questions and MCQ questions

Q1. --difference between rdd, dataframe and dataset.
Ans. 
RDD is a distributed collection of objects, DataFrame is a distributed collection of rows with schema, and Dataset is a distributed collection of objects with schema.
• RDD is a low-level abstraction in Spark that represents an immutable distributed collection of objects. It lacks the optimization that DataFrames and Datasets provide.

• DataFrame is a distributed collection of data organized into named columns. It provides a...read more
Answered by AI
Add your answer