Prepare for and practice interview questions from First horizon bank.

First horizon bank Interview Questions

First horizon bank Interview Guides

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


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

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?

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

<p><strong>Input:</strong></p>

<p><code>big_table</code> table</p>

<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

<p>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.</p>

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

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


<p>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?</p>

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?

First horizon bank Salaries by Position

<p>Description Location: Onsite in Memphis, TN; Maryville, TN; Birmingham, AL; Lafayette, LA; New Orleans, LA; Charlotte, or NC; Raleigh, NC. Summary: The Data Architect delivers as a hands-on practioner. Youll find yourself delivering standards, patterns, and designs to First Horizons technology organization, as well as diligent engagement with those teams of developers implementing them Your scope of influence will include but is not limited to stability, observability, portability, SDLC management, producing technical requirements and solution designs that align to business requirements. You will join the frontline in ensuring we can meet the banks business needs while producing a modern, digital stack. Primary Responsibilities Manages data system design from conception, through ARB, to delivery Champion platform quality, performance, and integrity Primarily responsible for producing architecture documentation for data systems as assigned and as projects and programs of work dictate Maintains First Horizons Solution Inventory as a member of the Core Enterprise Architecture Team Partners with line of business partners, delivery teams, and SMEs to produce and refine data requirements Designs both the data structure and interactions of solutions that will deliver intended business outcomes Collaborates with architects in other domains (Applications, Security, Infra, Cloud, DevOps) to produce consensus and governance Leads solution design workshops and emerging technology POC workshops Validates 3rd Party/Vendor Solutions Aligns Enterprise Data Strategy and with the companys business goals and objectives Promotes the use of a shared infrastructure and application roadmap to reduce costs and improve how information flows Builds and maintains technical trusted advisor relationships with influential technical decision makers within Technology Works with developers and engineers to ensure that technical solutions as delivered align with Data Architecture Standards & Patterns Works with Portfolio technology leaders to include technical debt initiatives to portfolio roadmap Provides consultation on complex projects May lead the work of others and contribute feature work and code/design reviews as needed Requirements Bachelor's degree in Computer Science, Data Science, or related field (4) years of data architecture experience (7) years of data engineering or application development with an emphasis on data Experience with n-tier application architecture and cloud-native/cloud-hybrid solution architecture Experience with technical documentation like interaction diagrams, process diagrams, ERDs, network topologies and other architectural content Experience with Agile/SAFe methodologies Certifications/Licensures AWS Certified Solution Architect or Azure Solutions Architect Expert Skills And Competencies Ability to adapt to new technologies and learn quickly Stay up-to-date on Databricks developments and best practices An understanding of, and ability to use, design patterns to steer business requirements into enterprise-wide technical strategies Awareness and ability to document designs using internal and external notational standards (Business Process Model and Notation {BPMN}, Unified Modeling Language {UML}, Entity-Relationship Diagrams {ERD}) Hands-on-the-keyboard depth of knowledge in Python, Spark, and SQL languages and frameworks Knowledge of data security design principles and techniques Knowledge of data streaming design principles, techniques, and platforms (Apache Kafka, Azure Event Hubs, etc.) Working knowledge of modern Operating Systems (Linux/Windows), Networking, Servers/Mainframe, Secure Coding Practices, Development Environments (Java/.Net), Databases (DB2/Oracle/SQL Server/Hadoop/Databricks) Understanding of public cloud (AWS, Azure) services and platforms like API Gateways, Serverless, Virtual Private Networks, Elastic RDBMS, NoSQL, Key Managers, Load Balancers, Blob Stores, Indexing Services, etc. About Us: First Horizon is a leading regional financial services company, dedicated to helping our clients, communities and associates unlock their full potential with capital and counsel. With $81.7 billion in assets as of December 31, 2023, we serve clients through a team of approximately 7,300 associates and 418 banking centers throughout the southeastern United States. Headquartered in Memphis, TN, the banking subsidiary First Horizon Bank operates in 12 states across the southern U.S. First Horizon has been recognized as one of the nations best employers by Fortune and Forbes magazines and a Top 10 Most Reputable U.S. Bank. Benefit Highlights: Medical with wellness incentives, dental, and vision HSA with company match Maternity and parental leave Tuition reimbursement Mentor program 401(k) with 6% match More FirstHorizon.com/First-Horizon-National-Corporation/Careers/Our-Benefits Corporate Diversity Commitment: We remain committed to creating a more equitable society, and that starts with our associates, our clients, and the communities we serve. We do this by elevating equity, providing capital and counsel, and committing to excellence in everything we do. Follow Us: Facebook (https://www.facebook.com/FirstHorizonBank) X formerly Twitter LinkedIn (http://www.linkedin.com/company/first-horizon-bank) Instagram YouTube (https://www.youtube.com/channel/UCEVs5OMj-b0H9Dr5Q209_-Q) 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 contractors legal duty to furnish information. 41 CFR 60-1.35(c)</p>

First horizon bank Interview Questions

First horizon bank Interview Guides

First horizon bank Interview Questions

First horizon bank Salaries by Position

First horizon bank Opening Jobs