Upload Button Icon Add office photos
Engaged Employer

i

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

phData Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

phData Interview Questions, Process, and Tips

Updated 3 Feb 2025

Top phData Interview Questions and Answers

phData Interview Experiences

Popular Designations

10 interviews found

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

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

Round 1 - Coding Test 

I was given a coding assessment to be completed on Codility. It has 3 parts, One coding assessment like in Leetcode, one SQL problem and architecture design. Architecture design was not timed for the rest I have given 280 minutes.

Senior Solution Architect Interview Questions asked at other Companies

Q1. What are the basics of Angular, including how to debug Angular code and the functionality of components?
View answer (1)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I appeared for an interview in Aug 2024.

Round 1 - Coding Test 

Sql python coming easy to medium

Round 2 - Technical 

(1 Question)

  • Q1. Architectural discussions
Round 3 - Behavioral 

(1 Question)

  • Q1. General team leading, solution designing
Round 4 - HR 

(1 Question)

  • Q1. Salary negotiations

Lead Data Engineer Interview Questions asked at other Companies

Q1. Given a DataFrame df with columns 'A', 'B','C' how would you group the data by the values in column 'A' and calculate the mean of column 'B' for each group, while also summing the values in column 'C' ?
View answer (1)

Solution Architect Interview Questions & Answers

user image Shriram Sankaran

posted on 8 Nov 2024

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

I applied via Approached by Company and was interviewed in May 2024. There were 5 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Handling unstructured data in Snowflake
  • Ans. 

    Snowflake can handle unstructured data through its semi-structured data types like VARIANT and OBJECT.

    • Snowflake supports semi-structured data types like VARIANT and OBJECT for handling unstructured data.

    • Use VARIANT data type to store JSON, XML, or other semi-structured data.

    • Use OBJECT data type to store key-value pairs or nested data structures.

    • Snowflake's automatic schema-on-read feature allows querying unstructured d

  • Answered by AI
  • Q2. Different performance optimization techniques
  • Ans. 

    Performance optimization techniques include caching, code optimization, load balancing, and database indexing.

    • Caching: Store frequently accessed data in memory to reduce load times.

    • Code optimization: Improve code efficiency by reducing redundant operations and improving algorithms.

    • Load balancing: Distribute incoming network traffic across multiple servers to prevent overload.

    • Database indexing: Organize database tables

  • Answered by AI
Round 2 - Case Study 

Legacy to Snowflake migration scenario

Round 3 - Behavioral 

(1 Question)

  • Q1. Technical questions and scenario based questions
Round 4 - Leadership discussion 

(1 Question)

  • Q1. About company and practice explanation
Round 5 - HR 

(1 Question)

  • Q1. Salary discussion

Skills evaluated in this interview

Solution Architect Interview Questions asked at other Companies

Q1. Difference Between classic folder and Modern folder?
View answer (10)

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 21 Nov 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Sql and azure data

Data Engineer Interview Questions asked at other Companies

Q1. Optimal Strategy for a Coin Game You are playing a coin game with your friend Ninjax. There are N coins placed in a straight line. Here are the rules of the game: 1. Each coin has a value associated with it. 2. The game involves two players... read more
View answer (1)

phData interview questions for popular designations

 Senior Data Engineer

 (2)

 Data Engineer

 (2)

 Solution Architect

 (2)

 Senior Solution Architect

 (1)

 Hadoop Administrator

 (1)

 Lead Data Engineer

 (1)

 Associate Data Engineer

 (1)

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
No response

I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Spark interviews
  • Q2. Architecture rounds

Senior Data Engineer Interview Questions asked at other Companies

Q1. Write a query to get the customer with the highest total order value for each year, month. [Note: Order table is different and Customer table is different. Order_ID and Customer_ID are the PK of the table with Oid from Customer table being ... read more
View answer (2)
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Aug 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Pen and paper test that included writing SQL queries. And there was a basic programing question for which you could only use python or java.There was also a google form with MCQs of computer fundamentals.

Round 2 - Technical 

(3 Questions)

  • Q1. Resume based questions
  • Q2. Pillars of Object oriented programing
  • Ans. 

    Pillars of OOP are Inheritance, Encapsulation, Abstraction, and Polymorphism.

    • Inheritance allows a class to inherit properties and behaviors from another class.

    • Encapsulation restricts access to certain components of an object, protecting its integrity.

    • Abstraction hides complex implementation details and only shows necessary features.

    • Polymorphism allows objects to be treated as instances of their parent class.

  • Answered by AI
  • Q3. Given a node value in a linked list, delete the node.
  • Ans. 

    To delete a node in a linked list, update the pointers of the previous node to skip the node to be deleted.

    • Traverse the linked list to find the node to be deleted.

    • Update the pointers of the previous node to skip the node to be deleted.

    • Free the memory allocated to the node to be deleted.

  • Answered by AI
Round 3 - Technical 

(2 Questions)

  • Q1. Resume based round and questions on project
  • Q2. A few mangerial questions.

Skills evaluated in this interview

Associate Data Engineer Interview Questions asked at other Companies

Q1. Datastge - How will you remove Header and trailer from Sequential data file
View answer (2)

Jobs at phData

View all

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 25 Mar 2024

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

I applied via Approached by Company and was interviewed in Sep 2023. There were 5 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. HR Screening Round. Questions on Hadoop, Big Data, RDD etc.
Round 2 - Coding Test 

Codility round. 3 sections - Python, SQL, Cloud

Round 3 - Coding Test 

Code Review and Technical.

Round 4 - One-on-one 

(1 Question)

  • Q1. Techno Managerial Round
Round 5 - HR 

(1 Question)

  • Q1. HR round and salary discussion.

Data Engineer Interview Questions asked at other Companies

Q1. Optimal Strategy for a Coin Game You are playing a coin game with your friend Ninjax. There are N coins placed in a straight line. Here are the rules of the game: 1. Each coin has a value associated with it. 2. The game involves two players... read more
View answer (1)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Jul 2023. There were 4 interview rounds.

Round 1 - Coding Test 

Duration was 1 hour, coding question was easy and it was take home test

Round 2 - Technical 

(1 Question)

  • Q1. Questions related to your project, Python, SQL, Spark
Round 3 - Technical 

(2 Questions)

  • Q1. Deep dive into your project
  • Q2. End to end of project flow, challenges faced, technical questions around core DE skills
Round 4 - HR 

(1 Question)

  • Q1. No questions, just discussion

Interview Preparation Tips

Topics to prepare for phData Senior Data Engineer interview:
  • python
  • SQL
  • Spark
  • Pyspark
  • Any cloud
  • Snowflake
  • dbt
Interview preparation tips for other job seekers - Be honest about your project experience
Speak out loud for every work you have done , even it's a poc
They respect enthusiasm to learn skills, so don't shy on speaking about in-progress courses
Prepare core DE topics like python, SQL, spark upto intermediate level

Senior Data Engineer Interview Questions asked at other Companies

Q1. Write a query to get the customer with the highest total order value for each year, month. [Note: Order table is different and Customer table is different. Order_ID and Customer_ID are the PK of the table with Oid from Customer table being ... read more
View answer (2)

Interview Questionnaire 

1 Question

  • Q1. They asked questions on hadoop components and architecture.

Hadoop Administrator Interview Questions asked at other Companies

Q1. what will you do if your cluster space gets filled 95% and you have to take some action without adding node and new volume.
View answer (2)

I applied via Approached by Company and was interviewed before Sep 2021. There were 2 interview rounds.

Round 1 - Assignment 

Hadoop administration

Round 2 - HR 

(2 Questions)

  • Q1. What is the expected salary
  • Ans. 

    The expected salary for a Solution Architect depends on factors such as experience, location, and company size.

    • The expected salary for a Solution Architect can range from $80,000 to $150,000 per year.

    • Factors that can influence the salary include the candidate's level of experience, the location of the job, and the size of the company.

    • Solution Architects with more years of experience and those working in high-demand loc...

  • Answered by AI
  • Q2. Why are you joining us
  • Ans. 

    I am joining because I am impressed by the company's innovative solutions and collaborative work environment.

    • Impressed by innovative solutions

    • Collaborative work environment

    • Opportunity for professional growth

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - okayish service based company. data engineering job is okay

Solution Architect Interview Questions asked at other Companies

Q1. Difference Between classic folder and Modern folder?
View answer (10)

phData Interview FAQs

How many rounds are there in phData interview?
phData interview process usually has 2-3 rounds. The most common rounds in the phData interview process are Technical, HR and Coding Test.
How to prepare for phData 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 phData . The most common topics and skills that interviewers at phData expect are Python, Machine Learning, Medical Insurance, SQL and Consulting.
What are the top questions asked in phData interview?

Some of the top questions asked at the phData interview -

  1. Given a node value in a linked list, delete the no...read more
  2. Different performance optimization techniq...read more
  3. Pillars of Object oriented program...read more
How long is the phData interview process?

The duration of phData interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

phData Interview Process

based on 9 interviews

Interview experience

4.4
  
Good
View more

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Fractal Analytics Interview Questions
4.0
 • 204 Interviews
Axtria Interview Questions
3.1
 • 115 Interviews
AbsolutData Interview Questions
3.6
 • 9 Interviews
Algonomy Interview Questions
4.0
 • 9 Interviews
Crayon Data Interview Questions
3.6
 • 4 Interviews
View all

phData Reviews and Ratings

based on 37 reviews

4.1/5

Rating in categories

4.3

Skill development

4.0

Work-life balance

4.2

Salary

4.1

Job security

3.9

Company culture

3.9

Promotions

3.8

Work satisfaction

Explore 37 Reviews and Ratings
Analytics Consultant (Alteryx)

Remote

2-5 Yrs

Not Disclosed

Senior Data Engineer

Remote

4-9 Yrs

₹ 18.3-27.23554 LPA

Solutions Architect (Managed Services)

Remote

10-14 Yrs

Not Disclosed

Explore more jobs
Data Engineer
35 salaries
unlock blur

₹6.3 L/yr - ₹19 L/yr

Senior Data Engineer
21 salaries
unlock blur

₹17 L/yr - ₹28 L/yr

Associate Data Engineer
19 salaries
unlock blur

₹2 L/yr - ₹8 L/yr

Solution Architect
14 salaries
unlock blur

₹22 L/yr - ₹57.2 L/yr

Devops Engineer
10 salaries
unlock blur

₹4.3 L/yr - ₹13.7 L/yr

Explore more salaries
Compare phData with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

LatentView Analytics

3.7
Compare

Tiger Analytics

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