Prepare for and practice interview questions from Mphasis.

Mphasis Interview Questions

Mphasis Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Mphasis Salaries by Position

Mphasis applies next-generation technology to help enterprises transform businesses globally. Customer centricity is foundational to Mphasis and is reflected in the Mphasis’ Front2Back™ Transformation approach. Front2Back™ uses the exponential power of cloud and cognitive to provide hyper-personalized (C=X2C2TM=1) digital experience to clients and their end customers. Mphasis’ Service Transformation approach helps ‘shrink the core’ through the application of digital technologies across legacy environments within an enterprise, enabling businesses to stay ahead in a changing world. Mphasis’ core reference architectures and tools, speed and innovation with domain expertise and specialization are key to building strong relationships with marquee clients. Position Overview:As a Graduate Software Engineer, you will be responsible for supporting our software development team in all aspects of development, testing, implementation, support and maintenance of the application. You will also work on improving the application and avoiding future problems by proactively identifying issues and fixing them. After a few years, you may be able to move into a senior software engineer position in which you will be creating entire programs on your own. Essential Job Functions:<ul><li>Coding, testing, and implementing configuration changes in software applications to meet business requirements</li><li>Good technical coding skills</li><li>Developing, refining, and tuning integrations between applications.</li><li>Participating in execution and documentation of tests.</li><li>Analysing and resolving technical and application problems.</li><li>Working closely with peers to improve the application’s functionality by sharing innovative ideas</li><li>Attending developer meetings / daily stand-ups</li><li>Participating in code reviews and quality assurance activities</li><li>Packaging and supporting deployment of releases.</li><li>Continually improving coding skills</li><li>Preparing reports, manuals and other documentation on the status, operation and maintenance of software.</li><li>Provide technical, administrative or operational support to the business</li></ul> What You Will ReceiveAs well as a highly competitive base salary you can expect to receive:<ul><li>Access to a high-quality, flexible Training and Development Programme where you will be guided through both online and classroom-based training in some of the latest tools and technology that we deploy to our large client base</li><li>Ongoing support throughout the training programme via a dedicated mentor</li><li>Exposure to exciting projects that are typically reserved for experienced consultants</li><li>Continuous opportunities to build your skills and understanding in new and exciting areas</li><li>Ongoing professional and developmental support from your dedicated People Manager</li><li>A range of other benefits including Pension and Life Insurance</li></ul> LocationGlasgow Why You Should Join UsOur training programmes, access to exciting clients and projects, and dedicated support will accelerate your career much faster than most other graduate schemes. You can expect to quickly get involved with real client work alongside more experienced consultants. Please know this role is an immediate requirement

Mphasis Interview Questions

Mphasis Interview Guides

Mphasis Interview Questions

Mphasis Salaries by Position

Mphasis Opening Jobs