i
Mphasis
Filter interviews by
I was interviewed in Dec 2024.
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
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
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
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;
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
I was interviewed before Sep 2020.
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.
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...
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
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 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.
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.
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.
I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.
I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.
I applied via Job Portal and was interviewed before Jan 2021. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Aug 2021. There were 2 interview rounds.
Easy DSA questions and some questions on resume
based on 2 interviews
Interview experience
Software Engineer
6.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
5.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Software Engineer
4.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
Module Lead
2.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Transaction Processing Officer
2.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Cognizant
Wipro
Accenture
TCS