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

Genworth Business Intelligence Interview Guide

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


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

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

Overview

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

Genworth 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

Genworth Business Intelligence Interview Questions

At Enact Mortgage Insurance (Nasdaq: ACT), we understand that there's no place like home. That's why we bring our deep expertise, insightful offerings, and extra mile service to work every day to help lenders put more people in homes and keep them there.<br><br>We're looking for a career professional <b>Software Data Engineer</b> in <b>Raleigh, NC </b>to join us in fulfilling our mission, while utilizing our values of excellence, improvement and connection. In this role, you will be responsible for maintaining and enhancing our risk and pricing predictive models and technology platforms that run the models. The technology stack comprises of Java, Informatica, Hadoop, AWS, and Snowflake as part of the solution.<br><br>You bring a deep expertise in building and maintaining analytical models, and a bespoke ability to work with your business stakeholders. You're a consummate team player, with a continuous improvement mindset, who can design and lead code reviews. You are comfortable in a highly visible role reporting to the Senior Manager, Data & Analytics Engineering in the IT Organization.<br><br><b>LOCATION</b><br>Enact Headquarters, Raleigh, NC - Hybrid Schedule<br><br><b>YOUR RESPONSIBILITIES</b><br><ul><li>Build and maintain risk analytics models written in Java (future potential supporting Python based models)</li><li>Build and maintain the necessary frameworks and technology architecture for data pipelines (ETL / ELT) and machine learning pipelines</li><li>Contribute actively to processes needed to achieve operational excellence in all areas, including project management and system reliability.</li><li>Design, Build and launch new data pipelines in production in partnership with the business stakeholders.</li><li>Design and support of new machine learning pipelines as well as dashboards and reports in production.</li></ul><br><br><b>YOUR QUALIFICATIONS</b><br><ul><li>BA/BS in Computer Science, Mathematics, Physics, or other technical fields.</li><li>7+ years of strong experience in back-end software engineering in Java, SQL, Python and Data Analysis</li><li>7+ years of experience in Data Engineering, BI, or Data Warehousing using tools like Informatica, Databricks, Talend, Snowflake.</li><li>5+ years in development of data pipelines/ETL for data ingestion, data preparation, data integration, data aggregation, feature engineering, etc.</li><li>Strong analytical skills with high attention to detail and accuracy.</li><li>Demonstrated ability to successfully collaborate with business stakeholders.</li></ul><br><br><b>PREFERRED QUALIFICATIONS</b><br><ul><li>Experience working in risk modeling and analytics in financial services companies.</li><li>Working knowledge of AWS ETL tools like Glue, Athena, SQS triggers, Step functions and Tableau.</li></ul><br><br><b>COMPANY</b><br><br>Enact is a leading publicly traded U.S. private mortgage insurance provider, offering borrower-centric products that enable lenders and other partners across the U.S. to help people responsibly achieve and maintain the dream of homeownership.<br><br>By empowering customers and their borrowers, Enact seeks to positively impact the lives of those in the communities in which it serves in a sustainable way. Headquartered in Raleigh, North Carolina, we play an active role in supporting a healthier Triangle community. We also support our colleagues' philanthropic efforts in their home communities across the U.S.<br><br>Enact values all perspectives, characteristics and experiences, and DEI remains at the forefront of what we do. We strive to create an environment where employees can bring their full, authentic selves to work to help each other and their customers.<br><br>We are proud to be an equal opportunity employer and all hiring decisions are based on merit, qualifications, and business need. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.<br><br><b>WHY WORK AT ENACT</b><br>We bring innovative thinking to the situations at hand<br><br>We seek out and incorporate diverse views to strengthen our outcomes<br><br>We work on challenging and rewarding projects<br><br>We offer competitive benefits:<br><ul><li>Hybrid work schedule (shared in-office days Tues/Wed/Thurs)</li><li>Generous Time Off</li><li>40 Hours of Volunteer Time Off</li><li>Tuition Reimbursement and Student Loan Repayment</li><li>Paid Family Leave and Flexible Spending Accounts</li><li>401k with up to 5% employer match</li><li>Fitness and Emotional Wellness Reimbursements</li></ul>

Genworth Business Intelligence Interview Guide

Overview

Genworth Business Intelligence Salary

Genworth Business Intelligence Interview Process

Genworth Business Intelligence Interview Questions

Genworth Business Intelligence Jobs