The Tek Leaders Inc Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Tek Leaders Inc Business Intelligence Interview Guide

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


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

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

Overview

Tek Leaders 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.

Tek Leaders 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>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

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

<p><strong><code>friend_requests</code></strong></p>

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

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

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

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

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

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

<tr>
<td>age_group</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>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

Tek Leaders Inc Business Intelligence Interview Questions

<p><strong>Role: DBT (Core/ Cloud) Developer</strong></p><p><strong>Location: Remote </strong></p><p><br></p><p>Please find the revised JD Senior DBT Developer. Please evaluate the resume based on below highlighted skills. </p><p><br></p><ul><li>Client looking for Senior/ Lead DBT Developer. </li><li>Good AWS experience.</li><li>Should have some DBT Admin experience.</li></ul><p> </p><p> <strong>Senior DBT developer:</strong></p><p>Technical Skills:</p><p>DBT Proficiency: </p><ul><li>model development: </li><li>Experience in creating complex DBT models including incremental models, snapshots and documentation</li><li>Ability to write and maintain DBT macros for reusable code</li><li>Testing and documentation: </li><li>Proficiency in implementing DBT tests for data validation and quality checks</li><li>Familiarity with generating and maintaining documentation using DBT's built in features</li><li>Version control: </li><li>Experience in managing DBT projects using git ,including implementing CI/CD process from the scratch</li><li>AWS Expertise: </li><li>Data STORAGE solutions: </li><li>In depth understanding of AWS S3 for data storage, including best practices for organization and security</li><li>Experience with AWS redshift for data warehousing and performance optimization</li><li>Data Integration: </li><li>Familiarity with Aws glue for ETL processes and orchestration -Nice to have</li><li>Experience with AWS lambda for serverless data processing tasks</li><li>Workflow Orchestration: </li><li>Proficiency in using Apache Airflow on AWS to design ,schedule and monitor complex data flows</li><li>Ability to integrate Airflow with AWS services and DBT models such as triggering a DBT model or EMR or reading from s3 writing to redshift</li><li>Data Lakes and Data warehousing: </li><li>Understanding the architecture of data lakes vs data warehouses and when to use each</li><li>Experience with amazon Athena for querying data directly in s3 using SQL</li><li>Monitoring and Logging: </li><li>Familiarity with AWS cloud watch for monitoring the pipelines and setting up alerts for workflow failures</li><li>Cloud Security: </li><li>Knowledge of AWS security best practices ,including IAM roles, encryption, DBT profiles access configurations</li></ul><p>Programming Skills:</p><ul><li>Python: </li><li>Proficiency in Pandas and NumPy for data analysis and manipulation</li><li>Ability to write scripts for automating ETL processes and scheduling jobs using airflow</li><li>Experience in creating custom DBT macros using jinja and Python allowing for reusable components within dbt models</li><li>Knowledge on how to implement conditional logic in DBT through python</li><li>SQL: </li><li>Advanced SQL skills, including complex joins ,window functions, CTE’s and subqueries</li></ul><p>Experience in optimizing SQL queries for performance and optimization</p>

Tek Leaders Inc Business Intelligence Interview Guide

Overview

Tek Leaders Inc Business Intelligence Salary

Tek Leaders Inc Business Intelligence Interview Process

Tek Leaders Inc Business Intelligence Interview Questions

Tek Leaders Inc Business Intelligence Jobs