The Systems technology group inc. Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Systems technology group inc. Business Intelligence Interview Guide

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


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

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

Overview

Systems technology group inc. 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.

Systems technology group inc. 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 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

<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

Systems technology group inc. Business Intelligence Interview Questions

<p><strong>Title:</strong><strong>GCP Data Engineer Lead</strong> </p> <p><strong>Description:</strong> STG is a fast-growing Digital Transformation services company providing Fortune 500 companies with Digital Transformation, Mobility, Analytics and Cloud Integration services in both information technology and engineering product lines. STG has a 98% repeat business rate from existing clients and have achieved industry awards and recognition for our services. </p> <p><strong>Experience Required:</strong> </p><p><strong>8 years of professional experience in: </strong> </p><ul> <li>Data engineering, data product development and software product launches </li><li>At least three of the following languages: Java, Python, Spark, Scala, SQL and experience performance tuning. </li></ul> <p><strong>4 years of cloud data/software engineering experience building scalable, reliable, and cost-effective production batch and streaming data pipelines using: </strong> </p><ul> <li>Data warehouses like <strong>Google BigQuery</strong>. </li><li>Workflow orchestration tools like <strong>Airflow</strong>. </li><li>Relational Database Management System like <strong>MySQL, PostgreSQL, and SQL Server</strong>. </li><li>Real-Time data streaming platform like <strong>Apache Kafka, GCP Pub/Sub</strong> </li><li><strong>Microservices architecture</strong> to deliver large-scale real-time data processing application. </li><li><strong>REST APIs</strong> for compute, storage, operations, and security. </li><li>DevOps tools such as <strong>Tekton, GitHub Actions, Git, GitHub, Terraform, Docker</strong>. </li><li>Project management tools like <strong>Atlassian JIRA</strong> </li></ul> <p><strong>Experience Preferred:</strong> </p><ul> <li>Experience in IDOC processing, APIs and SAP data migration projects. </li><li>Experience working in SAP S4 Hana environment. </li><li>GCP Certification </li><li>Automotive experience is preferred. </li><li>Support in an onshore/offshore model is preferred. </li><li>Excellent at problem solving and prevention. </li><li>Knowledge and practical experience of agile delivery </li></ul> <p><strong>GCP Data Lead Engineer</strong> position is based at our corporate office located in Dearborn, Michigan. A great opportunity to experience the corporate environment leading personal career growth. </p> <p><strong>Resume Submittal Instructions:</strong> Interested/qualified candidates should email their word formatted resumes to Ms. Shweta Huria at Shweta.huria@stgit.com and/or contact at 248.918.4720. In the subject line of the email please include: First and Last Name (<strong>GCP Data Lead Engineer).</strong> </p> <p>For more information about STG, please visit us at www.stgit.com. </p>

Systems technology group inc. Business Intelligence Interview Guide

Overview

Systems technology group inc. Business Intelligence Salary

Systems technology group inc. Business Intelligence Interview Process

Systems technology group inc. Business Intelligence Interview Questions

Systems technology group inc. Business Intelligence Jobs