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

Wesco international Business Intelligence Interview Guide

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


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

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

Overview

Wesco international 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.

Wesco international 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>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

<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

Wesco international Business Intelligence Interview Questions

Job Description

As an Architect , you will be responsible for researching, designing, implementing, and managing Azure cloud and data programs. You will serve as the technical expert, this role will identify and develop areas for modification in existing programs, as well as test and evaluate new programs. You will also collaborate with business partners and other technical teams across the organization to deliver proposed solutions. Heavily focused on Beta engineering, designing cloud solutions in an Azure environment, strong experience working with enterprise data sets for outbound integrations.

Responsibilities:
Manage the evaluation, identification, development, and implementation of software solutions.
Define, document and record designs and modifications of application or software.
Locate and direct solutions for critical challenges involving software and hardware interface.
Identify and resolve failures within existing and newly developed software systems and programs.
Design real-time and batch system interfaces and data enrichment pipelines in a cloud-native data ecosystem.
Guide through all phases of software development life cycle (SDLC) and provide customer technical support solution analysis and design, balancing technical and business aspects.
Troubleshoot production issues of all levels and severities, tracks progress from identification through resolution and ensure best practices are followed.
Work with IT leadership and business partners to design features for the cloud platform.
Qualifications:     Bachelor's degree - Computer Science, Information Technology or related field required; Master's degree preferred.
7 years experience in a lead development role.
5+ years experience in common programming and data language, for example Python, SQL, API, or Data Base, etc.
Strong working knowledge of Azure Data Factory and Databricks.
Strong problem-solving and analytical skills.
Adept at conducting research into project-related issues.
Strong written and verbal communication skills
9 years experience in a lead development role.
5+ years experience in Cloud Solution.
Familiarity with NoSQL databases (such as CosmosDB).
Ability to multi-task and reprioritize in a dynamic environment.

Wesco International, Inc., including its subsidiaries and affiliates ("Wesco") provides equal employment opportunities to all employees and applicants for employment. Employment decisions are made without regard to race, religion, color, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, or other characteristics protected by law. US applicants only, we are an Equal Opportunity and Affirmative Action Employer.

Los Angeles Unincorporated County Candidates Only:  Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act.

#LI-JB1

#LI-REMOTE

About Us

The compensation amount is not guaranteed. This amount is what we reasonably believe we will pay for the position, however, offer amounts may vary based on factors such as geographic location, experience and qualifications.

Wesco provides a variety of benefits to employees. More information about benefits is available here. For eligible positions, compensation may also include participation in an incentive plan.

About the Team

At Wesco, we build, connect, power and protect the world. As a leading provider of business-to-business distribution, logistics services and supply chain solutions, we create a world that you can depend on.

Our company's greatest asset is our people. Wesco is committed to fostering diversity and inclusion across our workforce by embracing the unique perspectives, authenticity and individuality of more than 20,000 Wesco employees around the globe. Through our Business Resource Groups, comprehensive benefits plan and our community outreach initiatives, you can be a part of a welcoming work community who provides platforms for your success.

Learn more about Working at Wesco here and apply online today!

Founded in 1922 and headquartered in Pittsburgh, Wesco is a publicly traded (NYSE: WCC) FORTUNE 500® company.

Wesco international Business Intelligence Interview Guide

Overview

Wesco international Business Intelligence Salary

Wesco international Business Intelligence Interview Process

Wesco international Business Intelligence Interview Questions

Wesco international Business Intelligence Jobs