The Mphasis Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Mphasis Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Mphasis? The Mphasis Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Mphasis Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Mphasis.</li>
<li>Practice real Mphasis Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Mphasis Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Mphasis? The Mphasis Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Mphasis Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Mphasis.
- Practice real Mphasis Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Mphasis Business Intelligence interview.
        

Overview

Mphasis Business Intelligence Salary

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Mphasis Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>bank_transactions</code> table</p>

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

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

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>transactions</code> table</p>

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

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

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

<table>
<thead>
<tr>
<th>Column</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>
<p> 
<strong>Output:</strong></p>

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

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


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

<p>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</code> table</p>

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Manager Team Sizes

Mphasis Business Intelligence Interview Questions

<p>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.</p><p><br></p><p>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.</p><p><br></p><p><strong>Position Overview:</strong></p><p>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.</p><p><br></p><p><strong>Essential Job Functions:</strong></p><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><p><br></p><p><strong>What You Will Receive</strong></p><p>As well as a highly competitive base salary you can expect to receive:</p><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><p><br></p><p><strong>Location</strong></p><p>Glasgow</p><p><br></p><p><strong>Why You Should Join Us</strong></p><p>Our 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.</p><p><br></p><p><strong>Please know this role is an immediate requirement</strong></p>

Mphasis Business Intelligence Interview Guide

Overview

Mphasis Business Intelligence Salary

Mphasis Business Intelligence Interview Process

Mphasis Business Intelligence Interview Questions

Mphasis Business Intelligence Jobs