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

Here Business Intelligence Interview Questions

<p><strong>About role: </strong></p><p><br></p><p>As a principal engineer of HERE IAM team, you’ll be responsible for leadership, development and testing of scalable, robust, high throughput and low latency driven Authentication & Authorization services. You will have an opportunity to have noticeable impact on the performance of a critical component of the platform</p><p> </p><p>Some detailed responsibilities include the following:</p><p>· Working with our customers and leaders across the company to understand the business direction.</p><p>· Providing technical leadership to high performance teams and foster innovation.</p><p>· Developing key features for Identity & Access Management product initiatives</p><p>· Building technical architecture between multiple complex systems</p><p>· Documenting designs and architecture and review with stakeholders</p><p>· Driving continuous improvements with the team's processes</p><p>· Proactively identifying and resolving technical risks and issues that may impair the team's ability to deliver</p><p><br></p><p><strong>Requirement:</strong></p><p>You are a go-getter, with an eye for detail, strong problem-solving and debugging skills. You carry a Bachelors/Master’s in computer science or related fields and have 12+ years of software development experience which includes:</p><p><br></p><p>· Solid experience in Scala/Java, Python development, and understanding of Microservices Architecture.</p><p>· Experience with Amazon Web Services, Splunk, Kubernetes, NGNIX</p><p>· Strong knowledge of algorithms & data structures</p><p>· Solid and proven problem-solving skills in system design and troubleshooting.</p><p>· Passion for cloud technologies</p><p>· Proven track record of having designed and deployed large scale & low latency cloud-based systems</p><p>· Familiarity with HTTP, the REST-principles, and TCP/IP networking, good understanding of OAuth and other authentication and authorization standards</p><p><br></p><p>What do we offer?</p><p><br></p><p>An opportunity to work with exceptional people</p><p>Meaningful problems to solve</p><p>A job that makes a difference in the world</p><p>Freedom to decide how to perform your job</p><p>Variety in the types of projects</p><p>Feedback so you will know how well you are doing</p><p>Collaborative, Supportive Colleagues in an inclusive environment</p><p>Make HERE your destination, we are just getting started!</p><p> </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>

<p><strong>Who are we?</strong></p><p><br></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> </p><p>At HERE we take it upon ourselves to be the change we wish to see. We create solutions that fuel innovation, provide opportunity, and foster inclusion to improve people’s lives. If you are inspired by an open world and driven to create positive change, join us. Learn more about us on our <a>YouTube Channel.</a></p><p><br></p><p> </p><p>HERE is looking for Lead Software Engineers to join its fast-growing and highly motivated Delivery Platform team. The Delivery Platform team is responsible for providing the enabling layers to the HERE Platform through identity and access management, accounting, billing, container orchestration, cloud abstraction, big data management, processing, and streaming services. The Delivery Platform services are mission-critical and meet demanding compliance, security, performance, and uptime requirements.</p><p><br></p><p><strong>What's the role??</strong></p><p><br></p><p>As a Lead Software Engineer, you'll have the opportunity to work on this amazing product. Within the cross-functional and self-organized team, you’ll have fun working on systems under huge loads and storing a vast amount of data in the very heart of our platform - the Delivery Platform. You will help run it on production with full control and responsibility. Your role encompasses defining and working on features and technical tasks in a self-directed fashion, supporting your colleagues with technical challenges, working with product management to analyze requirements, talking to stakeholders, designing, implementing, and documenting solutions as well as testing and reviewing your colleagues' work.</p><p><br></p><ul><li>Architecture, design, develop, and test the backend components</li><li>Evaluate and choose technologies suitable for work</li><li>Elaboration and refinement of user stories</li><li>Development infrastructure (build, testing, continuous integration, delivery)</li><li>Run, monitor, and support in production, ensure our customers receive world-class service by periodically participating in 24x7 on-call shifts</li><li>Team ceremonies (planning, demo, triage, retrospective)</li><li>Communicate effectively about decisions, direction, and progress, both inside and outside the team</li></ul><p><br></p><p><strong>Who are you?</strong></p><p><br></p><p>An ambitious team player who has experience developing and deploying production-grade services. You have experience with the production software lifecycle, as well as the deployment of software to production-ready, stable environments. You have 8+ years of professional software development and deployment experience including knowledge of continuous integration, continuous delivery, and automated testing disciplines. You also have good interpersonal skills and feel comfortable coordinating across teams in multiple design centers across the globe.</p><p><br></p><ul><li>7+ Years of Experience with distributed systems; Docker, Kubernetes, Terraform, Puppet</li><li>Experience leading and mentoring engineering team members</li><li>Strong Python</li><li>Understanding of AWS cloud-based technologies required</li><li>Experience with deployment automation systems (e.g. GitLab, Jenkins, etc.)</li><li>Experience with distributed systems; Docker, Kubernetes, Terraform, and Puppet are desired</li><li>Unix systems administration and scripting skills are desired</li><li>24*7 Shifts </li><li>Interest in high throughput, low latency, highly reliable systems at scale</li><li>Interest in DevOps methodologies to drive throughput and stability</li><li>Work on the development of high-scale services, serving and storing petabytes of data</li><li>Work with cutting-edge, modern technologies</li></ul><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>

Here Business Intelligence Interview Guide

Overview

Here Business Intelligence Salary

Here Business Intelligence Interview Process

Here Business Intelligence Interview Questions

Here Business Intelligence Jobs