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

Conduent Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Conduent? The Conduent 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 Conduent Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Conduent.</li>
<li>Practice real Conduent 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 Conduent Business Intelligence interview.</p>


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

- Know what skills are necessary for Conduent Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Conduent.
- Practice real Conduent 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 Conduent Business Intelligence interview.
        

Overview

Conduent 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.

Conduent 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>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

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

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

<p><strong><code>players</code></strong> table</p>

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

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

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

Conduent Business Intelligence Interview Questions

<strong>Job Description</strong><br><br><strong>Technology Business Analyst I</strong><br><br><strong>Qualifications:</strong><br><ul> <li>Skills, interest, and aptitude for a career as a Technical Business Analyst </li> <li>Learn and successfully follow business processes for financial modelling and technical reviews. </li> <li>Able to Perform technical-based activities and contributes to and manages projects.</li> <li>Interfaces with and influences key stakeholders and collaborate with production and programming teams.</li> <li>Applies knowledge of business learned through education or prior experience.</li> <li>Bachelor's degree or equivalent</li></ul><br><strong>Responsibilities</strong><br><ul> <li>Responsible for applying IT strategy, development, execution, and management standards to support planning and estimating activities.</li> <li>Provides technical expertise in identifying, evaluating, and developing systems and procedures that are cost effective and meet user requirements.</li> <li>This will include presenting to executives in technical review meetings.</li> <li>This person will be collaborating with the programming teams to communicate effectively in understanding the request and answer any questions.</li></ul><br><strong>Flexible Working</strong><br><br>At Conduent, we want you to be yourself. We recognize that everyone is different and that how people want to work and deliver at their best is different for everyone too. <br>In this role, you can expect the following working conditions:<br><ul> <li><strong>Remote work</strong>: Enjoy the convenience of working from home and maximize your time by unplugging at the end of your workday.</li></ul><br><strong>Working For You</strong><br><br>Perks and rewards designed for you:<br><ul> <li>Health and Welfare Benefits: Our health and welfare benefits can be tailored to fit you and your family's needs and start on the first day of employment.</li> <li>Retirement Savings: We will support you as you save for your future.</li> <li>Employee Discounts: We offer you access to a vast selection of global, national, and local discounts on merchandise, services, travel, and more.</li> <li>Career Growth Opportunities: We help you thrive, so together, we can grow. We provide opportunities to advance your career with a vast portfolio of businesses and a global footprint.</li> <li>Paid Training: Earn while you learn and continue to grow with access to award-winning learning platforms throughout your Conduent career.</li> <li>Paid time off: We provide attractive paid time off packages designed for you to enjoy your life away from work.</li> <li>Great Work Environment: We are proud of our award-winning culture and the recognition we've received for our diversity efforts.</li></ul><br> Pay Transparency Laws in some locations require disclosure of compensation and/or benefits-related information. For this position, actual salaries will vary and may be above or below the range based on various factors including but not limited to location, experience, and performance. In addition to base pay, this position, based on business need, may be eligible for a bonus or incentive. In addition, Conduent provides a variety of benefits to employees including health insurance coverage, voluntary dental and vision programs, life and disability insurance, a retirement savings plan, paid holidays, and paid time off (PTO) or vacation and/or sick time. The estimated salary range for this role is $60,060 - $78,000.<br><br><strong>About Us</strong><br><br>Through our dedicated associates, Conduent delivers mission-critical services and solutions on behalf of Fortune 100 companies and over 500 governments - creating exceptional outcomes for our clients and the millions of people who count on them. You have an opportunity to personally thrive, make a difference and be part of a culture where individuality is noticed and valued every day.<br><br><strong>About the Team</strong><br><br>Conduent is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, creed, religion, ancestry, national origin, age, gender identity, gender expression, sex/gender, marital status, sexual orientation, physical or mental disability, medical condition, use of a guide dog or service animal, military/veteran status, citizenship status, basis of genetic information, or any other group protected by law.<br><br>People with disabilities who need a reasonable accommodation to apply for or compete for employment with Conduent may request such accommodation(s) by submitting their request through this form that must be downloaded: click here to access or download the form. Complete the form and then email it as an attachment to FTADAAA@conduent.com. You may also click here to access Conduent's ADAAA Accommodation Policy.

Conduent Business Intelligence Interview Guide

Overview

Conduent Business Intelligence Salary

Conduent Business Intelligence Interview Process

Conduent Business Intelligence Interview Questions

Conduent Business Intelligence Jobs