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 Senior Data Engineer Interview Questions and Answers

Updated 31 Aug 2024

Mphasis Senior Data Engineer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. ReduceByKey vs groupByKey
  • Ans. 

    reduceByKey is more efficient than groupByKey for aggregating data in Spark due to reduced shuffling.

    • reduceByKey combines values for each key in each partition before shuffling data

    • groupByKey shuffles all data to a single partition before combining values for each key

    • reduceByKey is preferred for large datasets to minimize data movement and improve performance

  • Answered by AI
  • Q2. Word count in scala
  • Ans. 

    Scala provides a simple way to count words in a string using built-in functions.

    • Use the split function to split the string into an array of words

    • Use the length function to get the count of words in the array

  • Answered by AI
  • Q3. Second highest salary SQL
  • Ans. 

    Use SQL query with ORDER BY and LIMIT to find the second highest salary.

    • Use ORDER BY clause to sort salaries in descending order

    • Use LIMIT 1,1 to skip the first highest salary and get the second highest salary

  • Answered by AI

Skills evaluated in this interview

Senior Data Engineer Jobs at Mphasis

View all

Interview questions from similar companies

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

Round 1 - Aptitude Test 

The first round was an aptitude test with questions ranging from basic mathematical concepts to logical/analytical questions. English was also included in the test. The difficulty was medium and I was able to solve 70-80% of the questions.

Round 2 - Coding Test 

Two coding questions were the part of the test. I was supposed to solve and pass all the test cases for both the questions. The coding questions tested my knowledge in the field of arrays, loops and pointers. I was able to solve one and partially solve another.

Round 3 - Technical 

(1 Question)

  • Q1. The interview was a mixture of both HR as well as Technical. I was asked decent questions and tested my knowledge in the fundamentals of programming.

Interview Preparation Tips

Topics to prepare for LTIMindtree Software Engineer interview:
  • Python
  • Java
  • Full Stack
Interview preparation tips for other job seekers - Make sure that you are good in the fundamentals of Programming(if you are looking for an IT job) or just be good at a particular thing which perfectly suites your current necessities and also helps your career to grow in the future. Do not be disheartened if things do not go your way, there is always hope and a lot of companies would like to hire an intelligent candidate like you.
Cheers :)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Mar 2022. There were 3 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 - HR 

(1 Question)

  • Q1. Salary expectation current salary notice period
Round 3 - HR 

(1 Question)

  • Q1. Current salary notice period expected salary
  • Ans. 

    The question asks for information about current salary, notice period, and expected salary.

    • Provide the current salary, notice period, and expected salary.

    • If you don't have the information, mention that you don't have the data.

    • Format the response in JSON.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Better discuss about JD before joining office and about project related

I applied via Campus Placement and was interviewed before Sep 2021. There were 4 interview rounds.

Round 1 - Aptitude Test 

Prepare normal for aptitude - maths, quant, analytic

Round 2 - Group Discussion 

My GD topic was Is internet good for students or not

Round 3 - Coding Test 

I didn't attempt this as I was noob back in third year Engg

Round 4 - HR 

(1 Question)

  • Q1. Basic questions can you relocate, tell me about ur GD and composition

Interview Preparation Tips

Interview preparation tips for other job seekers - Easy peasy give ur best. Prepare well. Hope u get the job. Phir tho google ka hi dream rhe gaya he mera.

I applied via Campus Placement and was interviewed before Oct 2021. There were 4 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 - Aptitude Test 

Aptitude test has aptitude, logical and 2 coding questions

Round 3 - Technical 

(1 Question)

  • Q1. Asked about the basics of c, data structures, aptitude questions and questions related to your major
Round 4 - HR 

(1 Question)

  • Q1. General hr discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure you keep in resume what you know. Most of the questions will be from your resume

I applied via AmbitionBox and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

Generally the aptitude maintain quick calculations and time reduce.

Round 2 - Coding Test 

Coding built over technical skills

Round 3 - HR 

(1 Question)

  • Q1. General knowledge and some technical questions been asked

Interview Preparation Tips

Topics to prepare for DXC Technology Software Engineer interview:
  • Python
Interview preparation tips for other job seekers - Create an position which you want to reach and move towards an other opportunity will be waiting for our future.

I applied via Naukri.com and was interviewed before Jun 2019. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Core java very basic
  • Q2. Collections, string, object class, == and equals, threads

Interview Preparation Tips

Interview preparation tips for other job seekers - HR Round is important. Negotiate to get variable salary monthly. Otherwise variable salary is gone. Join only if you want to go abroad and put your every efforts for that otherwise useless for the co in sometime. After join, Resource Managers sucks try hard to prepare for the client interview that matters the most.

I appeared for an interview before Apr 2020.

Interview Questionnaire 

3 Questions

  • Q1. Data structure algorithms and basics of programming languages
  • Q2. Opps concept
  • Q3. Ask to write 2 codes they provide problem statements for that

Interview Questionnaire 

2 Questions

  • Q1. What is precompilaion unit?
  • Ans. 

    Precompilation unit is a compiled code that can be reused by multiple source files.

    • Precompilation unit is created by the compiler from the source code.

    • It contains the compiled code of header files and other dependencies.

    • It can be reused by multiple source files, reducing compilation time.

    • It is also known as precompiled header or PCH.

    • Example: stdafx.h in Visual Studio is a precompiled header file.

  • Answered by AI
  • Q2. About ur future,ur short term goal,why this company

Interview Preparation Tips

Skills: Resume, CGPA
College Name: IIT Kharagpur

Interview Questionnaire 

3 Questions

  • Q1. First 50 Prime Number
  • Ans. 

    The first 50 prime numbers are...

    • Start with 2, the first prime number

    • Check each odd number greater than 2

    • Use trial division to check if a number is prime

    • Stop when you have found 50 prime numbers

  • Answered by AI
  • Q2. How to sort the file in the range (hint provided)
  • Ans. 

    Sorting a file within a range

    • Use a sorting algorithm like quicksort or mergesort

    • Read the file and store the data in an array or list

    • Sort the array or list within the given range

    • Write the sorted data back to the file

  • Answered by AI
  • Q3. Tell me about yourself
  • Ans. 

    I am a passionate software engineer with experience in developing web applications using various technologies.

    • Experienced in developing web applications using HTML, CSS, JavaScript, and frameworks like React and Angular

    • Proficient in backend development with Node.js, Express, and MongoDB

    • Familiar with version control systems like Git and project management tools like Jira

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: Shortlist cut was 0.0 cgpa
Tips: Need to mention Programming skill in any one of three language C , C++ ,Java

Round: Test
Experience: Test was Average, Many question were from INDIABIX.COM , computer network, operating system ,data structure, c , c++ language
Tips: Understand Data Structure and Algorithm deeply, At least read about computer networks, operating system , DBMS 3-4 times for basic good understand, refer various site
Duration: 180 minutes

Round: Test
Experience: Two question were given , we have to write the code on A4 size sheet
Tips: Deep understanding of STACK AND QUEUE
Duration: 60 minutes

Round: Technical Interview
Experience: Previous Test (2 Questions on A4 size sheet) were discussed and is there any improvement that can be done, discussed each and every step.
Tips: Comments is important using programming
present with demo example (various cases)

Round: HR Interview
Experience: Be calm and show your interest in the company,
ask question about company, what are activity other than techincal technical stuff
Tips: Smile , if possible talk in Hindi - English,Try to Make the interview in discussion

General Tips: Practice Daily , Understand Each and Every Step in Detail , Try to code in A4 size paper then computer
Skill Tips: Read Good Books , Practice Daily

Skills: Algorithms And Data Structures
College Name: IIT Kharagpur

Skills evaluated in this interview

Mphasis Interview FAQs

How many rounds are there in Mphasis Senior Data Engineer interview?
Mphasis interview process usually has 1 rounds. The most common rounds in the Mphasis interview process are Technical.
How to prepare for Mphasis 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 Mphasis. The most common topics and skills that interviewers at Mphasis expect are Data Modeling, AWS, Amazon Redshift, Analysis Services and Analytical skills.
What are the top questions asked in Mphasis Senior Data Engineer interview?

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

  1. reduceByKey vs groupBy...read more
  2. Word count in sc...read more

Tell us how to improve this page.

Mphasis Senior Data Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Mphasis Senior Data Engineer Salary
based on 21 salaries
₹8.7 L/yr - ₹22 L/yr
At par with the average Senior Data Engineer Salary in India
View more details
Software Engineer
6.5k salaries
unlock blur

₹2 L/yr - ₹9.5 L/yr

Senior Software Engineer
5.7k salaries
unlock blur

₹6 L/yr - ₹24 L/yr

Associate Software Engineer
4.7k salaries
unlock blur

₹2 L/yr - ₹6 L/yr

Module Lead
2.4k salaries
unlock blur

₹9.5 L/yr - ₹36 L/yr

Transaction Processing Officer
2.3k salaries
unlock blur

₹1.4 L/yr - ₹4.5 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