Upload Button Icon Add office photos
Engaged Employer

i

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

Photon Interactive Verified Tick

Compare button icon Compare button icon Compare
4.0

based on 1.7k Reviews

Filter interviews by

Photon Interactive AWS Data Engineer Interview Questions and Answers

Updated 23 Aug 2024

Photon Interactive AWS Data Engineer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
No response

I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - One-on-one 

(3 Questions)

  • Q1. Explain how do you handle large data processing in Pyspark
  • Ans. 

    Large data processing in Pyspark involves partitioning, caching, and optimizing transformations for efficient processing.

    • Partitioning data to distribute workload evenly across nodes

    • Caching intermediate results to avoid recomputation

    • Optimizing transformations to minimize shuffling and reduce data movement

  • Answered by AI
  • Q2. Explain how do you implement data governance in your company
  • Ans. 

    Data governance is implemented through policies, processes, and tools to ensure data quality, security, and compliance.

    • Establish data governance policies and procedures to define roles, responsibilities, and processes for managing data

    • Implement data quality controls to ensure accuracy, completeness, and consistency of data

    • Utilize data security measures such as encryption, access controls, and monitoring to protect sens...

  • Answered by AI
  • Q3. Name any 2 data lineage tools
  • Ans. 

    Two data lineage tools are Apache Atlas and Informatica Enterprise Data Catalog.

    • Apache Atlas is an open source tool for metadata management and governance in Hadoop ecosystems.

    • Informatica Enterprise Data Catalog provides a comprehensive data discovery and metadata management solution.

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Campus Placement and was interviewed in Dec 2024. There were 4 interview rounds.

Round 1 - Coding Test 

Two coding questions related to matrices and heaps.

Round 2 - Technical 

(1 Question)

  • Q1. Python and SQL coding
Round 3 - Technical 

(1 Question)

  • Q1. Same questions like tech 1
Round 4 - HR 

(2 Questions)

  • Q1. Self intro , why tiger
  • Q2. Relocation

Interview Preparation Tips

Topics to prepare for Tiger Analytics Data Analyst interview:
  • Python
  • SQL
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 2024. There were 4 interview rounds.

Round 1 - Coding Test 

NA kjwnoi wniowe nfiow flmi

Round 2 - Coding Test 

NA fklwmoiwef,m ionfwno njnwfeio onfwp

Round 3 - Technical 

(2 Questions)

  • Q1. NAnak wel wenk weon
  • Q2. NAnank
Round 4 - One-on-one 

(2 Questions)

  • Q1. Wedlk k fwkllk own lnfw
  • Q2. Now odnw pmpw pnwpf
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Coding Test 

It was pair programming round where we need to attempt a couple of Spark Scenario along with the Interviewer. You will have a boiler plate code with some functionalities to be filled up. You will be assessed on writing clean and extensible code and test cases.

Round 2 - Technical 

(1 Question)

  • Q1. Questions will be based on the Project where they try to assess the depth of understading you have on your project, data quality checks, handling failure scenarios, reasoning behind choice of tech stack

Interview Preparation Tips

Interview preparation tips for other job seekers - In the Pair programming round, be interactive with the interviewer and try to improvise the existing code, implement functionality, test cases and communicate what you are thinking so that interviewer can work with you to move towards solution.

For Second round, Spark, Cloud Data Processing Components and being thorough with your previous experience will go a long way.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Tableau Questions 1. Difference between dimensions and measures. 2. What is RLS? 3. What are the functions you can assign in RLS? 4. Explain what is drill down approach. 5. What is LOD? 6. What is a calcul...
  • Q2. SQL Questions 1. In employee table find the 2nd highest salary. 2. Find the highest average salary in department 3. Given two tables(sales & product) find total sales per category 4. Two questions to find ...

Interview Preparation Tips

Topics to prepare for TEKsystems Data Analyst interview:
  • SQL
  • Tableau
  • DBMS
Interview preparation tips for other job seekers - Practice SQL interview questions and tableau interview questions from GfG and DataLemur.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. Azure Scenario based questions
  • Q2. Pyspark Coding based questions
Round 2 - One-on-one 

(2 Questions)

  • Q1. ADF, Databricks related question
  • Q2. Spark Performance problem and scenarios
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

Based on SQL , statistics , python , cognitive

Round 2 - Technical 

(2 Questions)

  • Q1. Based on AI/Ml and based on cv
  • Q2. Based on projects
Round 3 - HR 

(2 Questions)

  • Q1. How to handle toxic work culture?
  • Ans. 

    Address toxic work culture by open communication, setting boundaries, seeking support, and considering leaving if necessary.

    • Open communication with colleagues and management about issues

    • Set boundaries to protect your mental and emotional well-being

    • Seek support from HR, a mentor, or a therapist if needed

    • Consider leaving the toxic work environment if the situation does not improve

  • Answered by AI
  • Q2. 5 strength and weakness

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident in interviews and try to calm ur mind!
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is Databricks, and how does it differ from Azure Data Factory?
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in Aug 2024. There were 5 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Self introduction
Round 2 - Aptitude Test 

Maths grammar & communication

Round 3 - Technical 

(2 Questions)

  • Q1. Typeing speed skills check same use paragraph
  • Q2. Typing speed 10 minutes
Round 4 - One-on-one 

(1 Question)

  • Q1. Move on next round easy
Round 5 - Group Discussion 

You're like this job opportunity

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

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. Incremental load in pyspark
  • Ans. 

    Incremental load in pyspark refers to loading only new or updated data into a dataset without reloading the entire dataset.

    • Use the 'delta' function in pyspark to perform incremental loads by specifying the 'mergeSchema' option.

    • Utilize the 'partitionBy' function to optimize incremental loads by partitioning the data based on specific columns.

    • Implement a logic to identify new or updated records based on timestamps or uni...

  • Answered by AI
  • Q2. Drop duplicates

Skills evaluated in this interview

Photon Interactive Interview FAQs

How many rounds are there in Photon Interactive AWS Data Engineer interview?
Photon Interactive interview process usually has 1 rounds. The most common rounds in the Photon Interactive interview process are One-on-one Round.
How to prepare for Photon Interactive AWS Data Engineer 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 Photon Interactive. The most common topics and skills that interviewers at Photon Interactive expect are PDMS and PLSQL.
What are the top questions asked in Photon Interactive AWS Data Engineer interview?

Some of the top questions asked at the Photon Interactive AWS Data Engineer interview -

  1. Explain how do you handle large data processing in Pysp...read more
  2. Explain how do you implement data governance in your comp...read more
  3. Name any 2 data lineage to...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Photon Interactive interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.1k Interviews
Infosys Interview Questions
3.7
 • 7.4k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.7k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
LTIMindtree Interview Questions
3.9
 • 2.8k Interviews
Mphasis Interview Questions
3.4
 • 780 Interviews
CitiusTech Interview Questions
3.4
 • 259 Interviews
View all
Senior Software Engineer
990 salaries
unlock blur

₹6.1 L/yr - ₹23 L/yr

Software Engineer
504 salaries
unlock blur

₹4 L/yr - ₹13 L/yr

Technical Lead
406 salaries
unlock blur

₹10 L/yr - ₹28 L/yr

Softwaretest Engineer
137 salaries
unlock blur

₹2.8 L/yr - ₹12 L/yr

Project Manager
110 salaries
unlock blur

₹8.5 L/yr - ₹24.5 L/yr

Explore more salaries
Compare Photon Interactive with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview