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

Here Business Intelligence Interview Guide

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


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

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

Overview

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

Here 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>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Here Business Intelligence Interview Questions

<p><strong>What's the role?</strong></p><p>You will have to solve problems across different products and services and this will expose you to a broad set of technical challenges as well as many different ways of solving them. This exposure will help you grow and you will gain deep understanding of our products.</p><p><strong>Responsibilities</strong></p><ul><li>Design, develop, test, maintain and improve our software</li><li>Track test results and defects in relevant tools/databases and pro-actively take on new challenges by learning new tools and environments</li><li>Manage individual project priorities, deadlines and deliverables</li></ul><p><br></p><p><br></p><p><strong>Who are you?</strong></p><ul><li>BSc or MSc degree in Software Engineering, Computer Science or equivalent practical experience</li><li>5+ years of professional software development experience, including at least <strong>3 years of C++ development</strong></li><li>Experience with<strong> 3D graphics, preferably Direct3D or OpenGL</strong></li><li>DevOps mentality and ways of working (CI/CD and modern testing methodologies)</li><li><strong>Strong math skills</strong>, particularly linear algebra and <strong>geometry</strong></li><li>Willing to work in a team based culture</li><li>Self-motivated</li></ul><p><br></p><p><strong>On top of that, it would be ideal if you also have:</strong></p><ul><li>Mastery with data structures & core libraries, as well as familiarity with both STL & Boost</li><li>Experience in the geolocation area (navigation services)</li><li>knowledge of Unix/Linux, mobile platforms like Android and iOS</li><li>Excellent written and verbal communication skills</li></ul><p><br></p><p><br></p><p><br></p><p>HERE is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, age, gender identity, sexual orientation, marital status, parental status, religion, sex, national origin, disability, veteran status, and other legally protected characteristics.</p>

<p>HERE Technologies is a location data and technology platform company. We empower our customers to achieve better outcomes – from helping a city manage its infrastructure or a business optimize its assets to guiding drivers to their destination safely.</p><p><br></p><p><strong>About Role:</strong></p><p>As a Lead Engineer (Backend) in the Foundation Engineering team, you will work self-sustained in an agile team. Your responsibilities will cover developing, extending, and maintaining tools and services that process data for HERE’s global databases. </p><p> </p><p>Your Tasks</p><ul><li>Be responsible for providing design and development leadership in delivering new software products and tools from the ground up and extending and maintaining them in an innovative environment used for processing map data.</li><li>Implement tools to enhance both automated and semi-automated map data processing, involving backend/service-based software stacks, but also dashboard components for data tracking and analysis.</li><li>Apply and extend CI/CD tools and execute end-2-end ownership of your developed software stack, including DevOps and testing aspects</li><li>Work closely with other full stack and frontend engineers on the team to de/-refine APIs and system integrations</li><li>Work with other engineering teams and internal customers to identify new opportunities, address critical needs, and solve complex problems using your backend development expertise</li><li>Become an expert at leveraging internal platform resources and APIs</li><li>Drive initiatives that contribute to development of software that is efficient, reusable and reliable (e.g. agile, coding, verification)</li><li>Be part of an agile team, share knowledge, carry out code reviews</li></ul><p><br></p><p><br></p><p><strong>Requirement:</strong></p><ul><li>8+ years of software development experience, with 2+ years’ experience in a Lead Engineer role</li><li>Excellent applied skills in Java/or Scala programming, in combination with backend architectures, and related frameworks. </li><li>Strong and applied experience in REST-based web service technologies, JSON and XML, SOA, and microservices architectures.</li><li>Strong experience in Apache frameworks – Kafka, Spark, Flink.</li><li>Strong and applied RDBMS & NoSQL skills, with a strong preference for Oracle, PostgreSQL / MongoDB/AWS Dynamo DB.</li><li>Experience in applied AWS skills (EC2, S3, RDS, VPC, SNS, Lambda’s), as well as experience with virtualization tools like Docker - <strong>Good to have.</strong></li><li>Strong experience with CI/CD tools, with a preference for Jenkins or Gitlab.</li><li>Able to translate business and architectural features into quality, consistent software design </li><li>A strong quality mindset is considered a must: unit testing, performance testing, writing testable code</li></ul><p><br></p><p><br></p><p><br></p><p>HERE is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, age, gender identity, sexual orientation, marital status, parental status, religion, sex, national origin, disability, veteran status, and other legally protected characteristics.</p><p></p>

Here Business Intelligence Interview Guide

Overview

Here Business Intelligence Salary

Here Business Intelligence Interview Process

Here Business Intelligence Interview Questions

Here Business Intelligence Jobs