Prepare for and practice interview questions from Rocket mortgage.

Rocket mortgage Interview Questions

Rocket mortgage Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</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>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Rocket mortgage Salaries by Position

The Rock Family of Companies is made up of nearly 100 separate businesses spanning fintech, sports, entertainment, real estate, startups and more. We're united by our culture - a drive to find a better way that fuels our commitment to our clients, our community and our team members. We believe in and build inclusive workplaces, where every voice is heard and diverse perspectives are welcomed. Working for a company in the Family is about more than just a job - it's about having the opportunity to become the best version of yourself. As a Data Engineer - Web Analytics within Growth Engineering, you'll work as part of the team that handles all the analytics data collection of Rocket digital products and creates A/B Test experiments to increase user engagement and conversion. As a Technology team member, you're empowered to make an impact, employ your entrepreneurial spirit and build a career customized by you because at Rocket, you can. We are creating digital products that solve life's most complex moments. You'll get the chance to shape the future of tech, have your voice heard, get ahead in your career and develop your skills. With a tech career here, there's no limit to what you can achieve. About the Role <ul><li>Work with our Product Management and S&A (Strategy & Analytics) teams to</li><li>create specs for analytics tracking.</li><li>Collaborate with multiple technology streams on how to optimize and integrate</li><li>analytics data collection.</li><li>Work with Engineers on how to automate testing of analytics tracking.</li><li>Create and configure new events in Adobe Launch and Adobe Analytics</li><li>Ensure the analytics strategy is in line with RKT strategies.</li><li>Create Adobe dashboard reports.</li><li>Continuously look for ways to improve the process of analytics data collection.</li><li>Monitor our analytics and detect if there are any anomalies in the data.</li><li>Implement Server- Side, client-side integrations using tag manager</li></ul> About You Minimum Qualifications: <ul><li>5+ years of experience in web development</li><li>4+ years of Experience with tag management system (Adobe Launch)</li><li>Proficient in HTML, CSS, JavaScript</li><li>Experience in Adobe Experience Platform (AEP) and Adobe Web SDK</li><li>knowledge</li><li>Solid understanding of API</li><li>Experience in Pixel implementation.</li><li>Experience in modern front-end technologies like React, Angular</li><li>Expertise in debugging and troubleshooting applications.</li><li>Proficient in Adobe Analytics or any analytical tool</li><li>Creating reporting dashboards</li><li>Metrics and segment creation</li><li>Reporting Suite administration</li></ul> Preferred Qualifications: <ul><li>Knowledgeable in web page speed optimization</li><li>Knowledgeable in Google Analytics 4 implementation</li><li>Knowledge in Amplitude, Segmentation Tools</li><li>Experience integrating analytics tracking to native mobile apps (iOS and Android</li><li>apps)</li><li>Typescript, NextJS, GraphQL experience</li><li>Experience in A/B Testing and experimentation tools (Adobe Target)</li><li>Experience with continuous integration and continuous delivery (CI/CD) and</li><li>automated deployments.</li><li>Experience in Agile working environment.</li><li>Experience with Server side and client side integrations for Pixels</li></ul> What You'll Get Our team members fuel our strategy, innovation and growth, so we ensure the health and well-being of not just you, but your family, too! We go above and beyond to give you the support you need on an individual level and offer all sorts of ways to help you live your best life. We are proud to offer eligible team members perks and health benefits that will help you have peace of mind. Simply put: We've got your back. Check out our full list of Benefits and Perks. About Us Rocket Mortgage® was founded in 1985. Today, we're a Detroit-based, publicly traded company with a mission to Help Everyone Home. At Rocket Mortgage, we believe that home is more than the house you live in. Our wide variety of home loan options, tools and resources empower our clients to achieve their homeownership dreams. We're known as experts in the mortgage industry, but we're also innovators - we strive to create the best experiences for our clients from beginning to end. And we're not your typical employer. We're insistently different in how we look at the world and are committed to an inclusive workplace where every voice is heard. Apply today to join a team that offers career growth, amazing benefits and the chance to work with leading industry professionals. This job description is an outline of the primary responsibilities of this position and may be modified at the discretion of the Company at any time. Decisions related to employment are not based on race, color, religion, national origin, sex, physical or mental disability, sexual orientation, gender identity or expression, age, military or veteran status or any other characteristic protected by state or federal law. The Company provides reasonable accommodations to qualified individuals with disabilities in accordance with applicable state and federal laws. Applicants requiring reasonable accommodations in completing the application and/or participating in the application process should contact a member of the Human Resources team, The Pulse, at Careers@myrocketcareer.com. Colorado, New York City, Jersey City, California, D.C and Washington Candidates Only. The salary range for this position is seventy-nine thousand five hundred dollars to one hundred sixty-nine thousand five hundred dollars. The position may also be eligible for an annual bonus and other employment-related benefits including, but not limited to, medical, dental, and vision benefits, 401K retirement plan, and paid-time off. More information regarding these benefits and others can be found here. The information regarding compensation and other benefits included in this paragraph is only an estimate and is subject to revision from time to time as the Company, in its sole and exclusive discretion, deems appropriate. The Company may determine during its review of the proposed compensation and benefits provided for this position, that the compensation and benefits for such position should be reduced. In no event will the Company reduce the compensation for the position to a level below the applicable jurisdictional minimum wage rate for the position. Los Angeles County Candidates Only. Qualified applicants with arrest or conviction records will be considered for employment per the Fair Chance Ordinance and the California Fair Chance Act. The Company is an Equal Employment Opportunity employer, and does not discriminate in any hiring or employment practices. The Company provides reasonable accommodations to qualified individuals with disabilities in accordance with state and federal law. Applicants requiring reasonable accommodation in completing the application and/or participating in the employment application process should notify a representative of the Human Resources Team, The Pulse, at Careers@myrocketcareer.com.

The Rock Family of Companies is made up of nearly 100 separate businesses spanning fintech, sports, entertainment, real estate, startups and more. We're united by our culture - a drive to find a better way that fuels our commitment to our clients, our community and our team members. We believe in and build inclusive workplaces, where every voice is heard and diverse perspectives are welcomed. Working for a company in the Family is about more than just a job - it's about having the opportunity to become the best version of yourself. As an Enterprise Data Architect, you'll identify the data needs of the organization and designs and maintain blueprints based on those to assist in the guidance of data integration, control of data assets and alignment of data investments with the business strategy. You'll document multiple architectural models or views that show how the current and future needs of the organization will be met in an efficient, sustainable, agile and adaptable manner. About the Role <ul> <li>Create and evolve the technology road maps that define company data architectures and enable a solid company data strategy </li><li>Ensure data solutions are built for performance, fault tolerance and security with reusable patterns </li><li>Develop and share best practices for knowledge and data discovery to deliver impactful data-driven decision support systems </li><li>Form and define best practices for change management, source control and deployment methodologies for big data solutions </li><li>Identify and enable data capabilities across the company </li><li>Design integrations with other data sources </li><li>Research, analyze, and promote data standards to be used across the company </li><li>Set and lead standards discussions among big data engineers, data scientists and other team members across the business </li><li>Architect data solutions </li><li>Identify and implement build vs. buy strategies regarding technology </li><li>Identify performance trends and work with teams to improve processes and procedures </li><li>Partner with the business and appropriate teams to deliver road maps </li><li>Work with the team to build a holistic view of the company's strategy, processes, information and information technology assets </li><li>Define best practices and internal guidelines </li><li>Research new technologies </li><li>Mentor team members and share best practices </li><li>Capture program metrics </li></ul>About You Minimum Qualifications <ul> <li>Bachelor's degree in computer science, information technology, software engineering or a related field </li><li>7 years of experience in database administration, application development, data integration, data modeling and data management </li><li>7 years of experience with relational data modeling, big data modeling, conceptual data modeling and logical data modeling </li><li>5 years of experience with system architecture and normalization considerations </li><li>Experience with enterprise architecture modeling languages or frameworks such as ArchiMate, TOGAF, SOA or CMMI </li> <li>General experience with scripting and data language like Python, PowerShell, SQL and Bash </li><li>Experience with event streaming architecture pattern to design and implement real-time data processing systems </li></ul>Preferred Qualifications <ul> <li>7 years of experience with data quality management, reference data management, master data management, ODS/graph management, enrichment and analytics, metadata management, integrations and service standards, data lakes or governance (architectural and technical) </li><li>5 years of experience with building data solutions </li><li>5 years of experience with inter-system communication strategies, including ESB and web services </li><li>Master's degree in computer science, information technology, software engineering or a related field preferred </li><li>Knowledge of and experience with Open Group Standards </li><li>Experience with Agile software development practices </li><li>Experience with MapReduce syntax such as Hadoop stack </li></ul> What You'll Get Our team members fuel our strategy, innovation and growth, so we ensure the health and well-being of not just you, but your family, too! We go above and beyond to give you the support you need on an individual level and offer all sorts of ways to help you live your best life. We are proud to offer eligible team members perks and health benefits that will help you have peace of mind. Simply put: We've got your back. Check out our full list of Benefits and Perks. About Us Rocket Mortgage® was founded in 1985. Today, we're a Detroit-based, publicly traded company with a mission to Help Everyone Home. At Rocket Mortgage, we believe that home is more than the house you live in. Our wide variety of home loan options, tools and resources empower our clients to achieve their homeownership dreams. We're known as experts in the mortgage industry, but we're also innovators - we strive to create the best experiences for our clients from beginning to end. And we're not your typical employer. We're insistently different in how we look at the world and are committed to an inclusive workplace where every voice is heard. Apply today to join a team that offers career growth, amazing benefits and the chance to work with leading industry professionals. This job description is an outline of the primary responsibilities of this position and may be modified at the discretion of the Company at any time. Decisions related to employment are not based on race, color, religion, national origin, sex, physical or mental disability, sexual orientation, gender identity or expression, age, military or veteran status or any other characteristic protected by state or federal law. The Company provides reasonable accommodations to qualified individuals with disabilities in accordance with applicable state and federal laws. Applicants requiring reasonable accommodations in completing the application and/or participating in the application process should contact a member of the Human Resources team, The Pulse, at Careers@myrocketcareer.com. Colorado, New York City, Jersey City, California, D.C and Washington Candidates Only. The salary range for this position is one hundred twenty-three thousand five hundred dollars to two hundred sixty thousand dollars. The position may also be eligible for an annual bonus and other employment-related benefits including, but not limited to, medical, dental, and vision benefits, 401K retirement plan, and paid-time off. More information regarding these benefits and others can be found here. The information regarding compensation and other benefits included in this paragraph is only an estimate and is subject to revision from time to time as the Company, in its sole and exclusive discretion, deems appropriate. The Company may determine during its review of the proposed compensation and benefits provided for this position, that the compensation and benefits for such position should be reduced. In no event will the Company reduce the compensation for the position to a level below the applicable jurisdictional minimum wage rate for the position. Los Angeles County Candidates Only. Qualified applicants with arrest or conviction records will be considered for employment per the Fair Chance Ordinance and the California Fair Chance Act. The Company is an Equal Employment Opportunity employer, and does not discriminate in any hiring or employment practices. The Company provides reasonable accommodations to qualified individuals with disabilities in accordance with state and federal law. Applicants requiring reasonable accommodation in completing the application and/or participating in the employment application process should notify a representative of the Human Resources Team, The Pulse, at Careers@myrocketcareer.com.

Rocket mortgage Interview Questions

Rocket mortgage Interview Guides

Rocket mortgage Interview Questions

Rocket mortgage Salaries by Position

Rocket mortgage Opening Jobs