Upload Button Icon Add office photos
Engaged Employer

i

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

Mphasis Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Mphasis Pyspark Developer Interview Questions, Process, and Tips

Updated 28 Jan 2025

Mphasis Pyspark Developer Interview Experiences

1 interview found

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

I was interviewed in Dec 2024.

Round 1 - Technical 

(8 Questions)

  • Q1. Pyspark architecture
  • Q2. Optimisation in pyspark
  • Ans. 

    Optimisation in PySpark involves improving performance and efficiency of Spark jobs.

    • Use partitioning to distribute data evenly across nodes

    • Avoid shuffling data between nodes as much as possible

    • Use broadcast variables for small lookup tables

    • Cache intermediate results to avoid recomputation

    • Optimize transformations and actions for better performance

  • Answered by AI
  • Q3. Null handling in spark
  • Ans. 

    Null handling in Spark involves handling missing or null values in data processing.

    • Use functions like coalesce, na.fill, na.drop to handle null values

    • Consider using when and otherwise functions for conditional null handling

    • Be cautious of potential null pointer exceptions when working with null values

  • Answered by AI
  • Q4. Operators in airflow
  • Ans. 

    Airflow operators are used to define the tasks to be executed in a workflow.

    • Operators are classes that define the logic to execute a task in Airflow.

    • There are various types of operators such as BashOperator, PythonOperator, and more.

    • Operators can be customized to suit specific task requirements.

    • Operators can be chained together to create complex workflows.

    • Example: BashOperator executes a bash command, PythonOperator ru

  • Answered by AI
  • Q5. Sql coding for average rolling , lead lag
  • Ans. 

    SQL coding for calculating average rolling, lead, and lag functions.

    • Use window functions like ROWS BETWEEN and ORDER BY for calculating rolling averages.

    • Use LEAD and LAG functions to access data from previous or next rows.

    • Example: SELECT col1, AVG(col2) OVER (ORDER BY col1 ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS rolling_avg FROM table_name;

  • Answered by AI
  • Q6. Mysql to gcs ,how to move 10 tables at a time?
  • Ans. 

    Use Apache Sqoop to move 10 tables from MySQL to Google Cloud Storage.

    • Use Apache Sqoop to import data from MySQL to HDFS

    • Use Google Cloud Storage connector for Hadoop to move data from HDFS to GCS

    • Create a script to automate the process for all 10 tables

  • Answered by AI
  • Q7. Explode json data
  • Q8. Error logs

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare everything in your resume

Interview questions from similar companies

I was interviewed before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 140 minutes
Round difficulty - Medium

Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.

  • Q1. 

    Sum of Two Numbers Represented as Arrays

    Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...

  • Ans. 

    Given two numbers represented as arrays, calculate their sum and return the result as an array.

    • Iterate through the arrays from right to left, adding digits and carrying over if necessary

    • Handle cases where one array is longer than the other by considering the remaining digits

    • Ensure the final sum array does not have any leading zeros

  • Answered by AI
Round 2 - Face to Face 

Round duration - 20 minutes
Round difficulty - Easy

The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.

Round 3 - HR 

Round duration - 8 minutes
Round difficulty - Easy

This round was conducted right after finishing and clearing the technical round at the same place and on the same day.

Interview Preparation Tips

Eligibility criteriaAbove 60 %Wipro Limited interview preparation:Topics to prepare for the interview - OOPS, Data Structures, Database Concepts, Coding problemsTime required to prepare for the interview - 2-3 monthsInterview preparation tips for other job seekers

Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.

Application resume tips for other job seekers

Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.

Final outcome of the interviewSelected

Skills evaluated in this interview

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

Interview Questionnaire 

1 Question

  • Q1. SOLID principals, oops, c# basics, SQL server, azure, design pattern

Interview Preparation Tips

Interview preparation tips for other job seekers - Clear basics of oops and design pattern

I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. 1.Describe a situation where you have taken a quick decision and failed, and a situation where you succeeded. 2. What is a skill you have tried to achieve but failed? 3. Describe a decision you have taken ...

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Always try to take risk in small problems . When you face the consequences, you would be able to tackle bigger problems.
2. Every skill you learn, even if you didn't excel in it is not to be considered a waste of time/failure, you learn something simply by participating.

Interview Questionnaire 

1 Question

  • Q1. HTML, CSS, BOOTSTRAP, PHP. SQL

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Simple program
  • Q2. I wrote a simple program in C

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and confident

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me about Yourself, some questions related to machine learning, and I was asked more questions to differentiate like differences between ml and ai, python and c, c and java and procedural and functiona...

Interview Preparation Tips

Interview preparation tips for other job seekers - Get a complete grip on your resume and be confident about what you say, If you don't know the answer it is okay to agree that you don't know the answer so that interviewer can ask the next questions.

I applied via Job Portal and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops Concepts,JAVA 8

Interview Preparation Tips

Interview preparation tips for other job seekers - Quite simple and easy. 1st round technical.2nd round HR

I applied via Campus Placement and was interviewed before Aug 2021. There were 2 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 tips
Round 2 - Coding Test 

Easy DSA questions and some questions on resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't join if you are a fresher and want to grow as a developer. I had resigned that time I am writing this review

Mphasis Interview FAQs

How many rounds are there in Mphasis Pyspark Developer interview?
Mphasis interview process usually has 1 rounds. The most common rounds in the Mphasis interview process are Technical.
How to prepare for Mphasis Pyspark Developer 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 Mphasis. The most common topics and skills that interviewers at Mphasis expect are Ab Initio.
What are the top questions asked in Mphasis Pyspark Developer interview?

Some of the top questions asked at the Mphasis Pyspark Developer interview -

  1. mysql to gcs ,how to move 10 tables at a ti...read more
  2. sql coding for average rolling , lead ...read more
  3. optimisation in pysp...read more

Tell us how to improve this page.

Mphasis Pyspark Developer Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
DXC Technology Interview Questions
3.7
 • 795 Interviews
Nagarro Interview Questions
4.0
 • 759 Interviews
View all
Software Engineer
6.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
5.6k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Software Engineer
4.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Module Lead
2.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Transaction Processing Officer
2.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Mphasis with

Cognizant

3.7
Compare

Wipro

3.7
Compare

Accenture

3.8
Compare

TCS

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