Premium Employer

i

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

Persistent Systems Verified Tick

Compare button icon Compare button icon Compare
3.5

based on 3.6k Reviews

Filter interviews by

Persistent Systems Senior Data Engineer Interview Questions, Process, and Tips

Updated 27 Sep 2024

Top Persistent Systems Senior Data Engineer Interview Questions and Answers

View all 14 questions

2 Persistent Systems Senior Data Engineer Interview Experiences

23 questions found

Sort by: Popular

Senior Data Engineer Interview Questions

user image Anonymous

posted on 17 Jul 2024

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via Naukri.com and was interviewed in Aug 2024.

2 Interview Rounds

1

Technical Round (12 Questions)

  • Q1. Tell me about yourself and Project
  • Q2. What was you day-to-day job in your project
  • Q3. Spark Architecture
  • Q4. How DAG handle Fault tolerance?
  • Q5. What is shuffling? How to Handle Shuffling?
  • Q6. What is the difference between repartition and Coelsce?
  • Q7. How do you handle Incremental data?
  • Q8. What is SCD ??
  • Q9. Scenerio based questions related to Spark ?
  • Q10. Two SQL Codes and Two Python codes like reverse a string ?
  • Q11. Find top 5 countries with highest population in Spark and SQL
  • Q12. Using two tables find the different records for different joins
2

One-on-one Round (7 Questions)

  • Q1. What is a catalyst optimiser? How it works?
  • Q2. Tell me about the optimization you used in your project.
  • Q3. Pyspark question related to merging two schemas?
  • Q4. What is the best approach to finding whether the data frame is empty or not?
  • Q5. Spark Architecture
  • Q6. How do you decide on cores and worker nodes?
  • Q7. What happens when we enforce schema ?

Interview Preparation Tips

Topics to prepare for Persistent Systems Senior Data Engineer interview:
  • SQL
  • Pyspark
  • Python
  • Spark
  • Database
Interview preparation tips for other job seekers - Be prepared with Spark core concepts and SQL Coding

Skills evaluated in this interview

Senior Data Engineer Interview Questions

user image kajal bomble

posted on 10 Jun 2024

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

I applied via Naukri.com and was interviewed before Jun 2023.

3 Interview Rounds

1

One-on-one Round (2 Questions)

  • Q1. It’s general type of question
  • Q2. Experience n all
2

Group Discussion Round

It’s just reasoning type questions.

3

Technical Round (2 Questions)

  • Q1. What is ssis? How we use
  • Q2. When we use ssis packages? Difference between union merge

Skills evaluated in this interview

Get interview-ready with top interview questions

Interview questions from similar companies

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

I applied via Company Website and was interviewed in Sep 2024.

2 Interview Rounds

1

Coding Test Round

Platform - Hackerank
Duration - 2 Hours
Topics - Spark and SQL

2

Technical Round (3 Questions)

  • Q1. What are the common file formats used in data storages? Which one is best for compression?
  • Q2. SQL Problem - Given the empoyee attendance table, write a query to print the employees who is abscent for more than cosecutive 10 days in their tenure.
  • Q3. Given the list of words, write the Python program to print the most repeating substring out of all words.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well in SQL, Spark and Python coding problems.

Skills evaluated in this interview

Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (3 Questions)

  • Q1. ReduceByKey vs groupByKey
  • Q2. Word count in scala
  • Q3. Second highest salary SQL

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via LinkedIn and was interviewed in Apr 2024.

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. What do you know about Spark architecture?
  • Q2. How many stages will be created if a spark job has 3 wide transformations and 2 narrow transformations?

Interview Preparation Tips

Topics to prepare for Virtusa Consulting Services Senior Data Engineer interview:
  • Spark
  • Python
  • SQL

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Technical Round (1 Question)

  • Q1. SQL Order of execution
2

Technical Round (1 Question)

  • Q1. How to identify the root-cause if an executor is taking longer time compared to others

Skills evaluated in this interview

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

I applied via Approached by Company and was interviewed in Jun 2023.

3 Interview Rounds

1

Resume Shortlist Round

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 tips
2

Technical Round (3 Questions)

  • Q1. Explain spark internal flow from end to end
  • Q2. Explain details of hive meta store
  • Q3. Write sql query for some simple tables
3

Technical Round (2 Questions)

  • Q1. Depth into data engineer skills
  • Q2. More questions on python programming

Skills evaluated in this interview

Senior Data Engineer Interview Questions

Coforge user image Balamaheswara J

posted on 21 Jul 2023

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Write python code to remove duplicates from list of string
  • Q2. Write SQL to get 2nd highest sal
2

Technical Round (2 Questions)

  • Q1. Pyspark scd type2 implementation
  • Q2. Remove duplicates in a dataframe

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was cleared

Skills evaluated in this interview

Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed in Jun 2023.

4 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2

Technical Round (1 Question)

  • Q1. Pyspark, SQL questions
3

Technical Round (1 Question)

  • Q1. Questions about previous project
4

HR Round (1 Question)

  • Q1. Salary Discussions and expectations

I applied via Recruitment Consulltant and was interviewed in Nov 2021.

4 Interview Rounds

1

Aptitude Test Round

Normal aptitude test

2

Technical Round (1 Question)

  • Q1. Technical discussion on big data and some programing problem
3

Technical Round (1 Question)

  • Q1. 2nd technical discussion based on project, big data and python
4

HR Round (1 Question)

  • Q1. Normal HR discussion and salary negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up your core skill and basic programming knowledge

Persistent Systems Interview FAQs

How many rounds are there in Persistent Systems Senior Data Engineer interview?
Persistent Systems interview process usually has 2-3 rounds. The most common rounds in the Persistent Systems interview process are One-on-one Round, Technical and Group Discussion.
How to prepare for Persistent Systems Senior 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 Persistent Systems. The most common topics and skills that interviewers at Persistent Systems expect are Java, Kafka, Python, HBase and Hadoop.
What are the top questions asked in Persistent Systems Senior Data Engineer interview?

Some of the top questions asked at the Persistent Systems Senior Data Engineer interview -

  1. What is the best approach to finding whether the data frame is empty or n...read more
  2. What is the difference between repartition and Coels...read more
  3. Two SQL Codes and Two Python codes like reverse a strin...read more

Tell us how to improve this page.

People are getting interviews through

based on 2 Persistent Systems interviews
Job Portal
100%
Moderate Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Join Persistent Systems See Beyond, Rise Above
Persistent Systems Senior Data Engineer Salary
based on 17 salaries
₹6.7 L/yr - ₹24.3 L/yr
17% less than the average Senior Data Engineer Salary in India
View more details

Persistent Systems Senior Data Engineer Reviews and Ratings

based on 2 reviews

2.2/5

Rating in categories

2.2

Skill development

3.3

Work-Life balance

2.7

Salary & Benefits

1.0

Job Security

1.6

Company culture

1.6

Promotions/Appraisal

1.6

Work Satisfaction

Explore 2 Reviews and Ratings
Software Engineer
4.6k salaries
unlock blur

₹2.4 L/yr - ₹10 L/yr

Senior Software Engineer
3.7k salaries
unlock blur

₹5 L/yr - ₹14 L/yr

Lead Engineer
3k salaries
unlock blur

₹9.8 L/yr - ₹30 L/yr

Lead Software Engineer
2.9k salaries
unlock blur

₹7.3 L/yr - ₹21 L/yr

Project Lead
1.8k salaries
unlock blur

₹13 L/yr - ₹38.8 L/yr

Explore more salaries
Compare Persistent Systems with

Cognizant

3.8
Compare

TCS

3.7
Compare

IBM

4.1
Compare

Wipro

3.7
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