Prepare for and practice interview questions from Pacific Premier Bank.

Pacific Premier Bank Interview Questions

Pacific Premier Bank 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

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?

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Pacific Premier Bank Salaries by Position

The Sr Software Engineer is responsible for the development (i.e. configuration and programming activities), architectural design, administration and support of enterprise applications. Performs database design and integration, systems analysis, creates custom reports, and provides support and assistance for system users. Formulates and defines system scope and objectives to develop new or modify existing applications. Designs, codes, tests, debug, and supports and maintains business applications and/or programs. Collaborates with development teams to define and drive best practices. Establishes and maintains effective vendor relationships to ensure continued support. Acts in a lead capacity to all Software Engineers by providing mentoring, guidance and subject matter expertise. RESPONSIBILITIES <ul><li>Works independently, takes or no direction.</li><li>Performs design specification application development, and then analyzes specifications and instructions to develop appropriate systems and programs.</li><li>Collaborate with team on prototyping and other rapid application development techniques to help define system functionality.</li><li>Conducts research, evaluates feasibility then implements new features, upgrades and modifications to assigned application systems.</li><li>Defines application program interfaces to various databases.</li><li>Performs integrated database design and directs design of database structure.</li><li>Write and review code, working closely with team leads on coding guidelines and best practices.</li><li>Review code for security vulnerabilities and correct where identified.</li><li>Perform and verify software releases to various environments including production.</li><li>Manage and maintain code base in a source code tool such as the distributed version control system (DVSC).</li><li>Works closely with Solutions Architect and stakeholders to define and design technology solutions to solve business problems.</li><li>Researches, analyzes and evaluates requests for new or improved software application functionality for websites, intranet and other applications with emphasis on business need and benefit.</li><li>Designs web pages and applications, maintaining consistency with Bank standards and practices.</li><li>Collaborate with product owners to refine and estimate relative effort level of User requirements.</li><li>Provide mentoring to junior team members.</li><li>Ability to represent the application development organization horizontally across the bank.</li><li>Ability to fill in or represent the Director of Engineering when needed.</li><li>Monitors applications system performance and recommends methods for improving efficiency through system and application design. Investigates, analyzes, and reviews performance problems and provides resolution using industry standard debugging methods.</li><li>Provides production troubleshooting analyst and support.</li><li>Evaluates workflow and software development life cycle methods providing recommendations for improvement.</li><li>Recommends and implements new ways to service the customers.</li><li>Makes oral and/or written presentations of system analysis, design and operational data in a clear, concise and non-technical manner.</li><li>Communicates with users orally, in person and on the telephone to solve concerns and recommend alternatives.</li><li>Other duties as assigned</li></ul> QUALIFICATIONS <ul><li>6-8 years of experience required in software development, object oriented principals and programming techniques, source code management and documentation.</li><li>Experience with SQL server in relation to application development required.</li><li>Experience with Microsoft Azure platform preferred. </li><li>Additional preferred qualifications include; .NET Core 6, C#, LINQ, JavaScript, Angular, HTML, XML, JSON, message queueing, API integration (SOAP/REST), system analysis and design, design specification development, MS Windows Active Directory Integration, TCP/IP network environments, integration with various desktop and server applications including Microsoft Office, application debugging, identification and resolution of problems.</li></ul> A reasonable, good faith estimate of the minimum and maximum base salary or pay for this position is $53.12/hr to $79.68/hr. Actual compensation will vary based on various factors including but not limited to location, experience, and performance.A discretionary bonus and/or business line incentive may be provided, in addition to a medical and other benefits, dependent on the position.For more information regarding our benefits, please visit https://www.ppbi.com/careers.html CA (Los Angeles applicants): Applicants are notified that the Company is an insured depository institution subject to the restrictions and requirements of Section 19 of the Federal Deposit Insurance Act (12 CFR 303) ("Section 19"). In accordance with Section 19, the Company will consider an applicant's criminal history after an applicant is made a conditional offer of employment.Qualified applicants with criminal conviction records will be considered for employment in accordance with the Los Angeles Fair Chance Ordinance.Section 19 may prohibit the Company from employing an applicant with criminal conviction(s) for fraud, breach of trust, embezzlement, mishandling of money or any crime of violence may have a direct impact on the job duties as set forth in the job description and such convictions may result in withdrawal of a conditional offer of employment in accordance with the Los Angeles Fair Chance Ordinance.Because of the nature of our business, a review of your criminal history is necessary to comply with Section 19 and to avoid substantial risk to our business operations and licensing. #LI-Onsite #LI-FG1 Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

Pacific Premier Bank Interview Questions

Pacific Premier Bank Interview Guides

Pacific Premier Bank Interview Questions

Pacific Premier Bank Salaries by Position

Pacific Premier Bank Opening Jobs