Prepare for and practice interview questions from Old National Bank.

Old National Bank Interview Questions

Old National Bank Interview Guides

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

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

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

Old National Bank Salaries by Position

<h5 class="iCIMS_Header">
Data Engineering Manager, Sr</h5>



Job Locations

US-IN-Evansville | US-IL-Chicago | US-IL-Joliet






Category/Function

Information Technology



Position Type

Regular Full-Time



Requisition ID

2024-14826



Workplace Type

On Site


































<h5 class="iCIMS_InfoMsg iCIMS_InfoField_Job">



Overview


</h5>






Old National Bank has been serving clients and communities since 1834. With $50 billion in total assets, we are a regional powerhouse deeply rooted in the communities we serve. As a trusted partner, we thrive on helping our clients achieve their goals and dreams, and we are committed to social responsibility and investing in our communities through volunteering and charitable giving. Our team members are our greatest asset, and we continually invest in their growth and development. We offer a variety of Impact Network Groups led by team members who are passionate about driving engagement, creating awareness of diverse backgrounds and experiences, and building inclusion across the organization. We are looking for a Senior Data Engineering Manager to lead our data engineering team and oversee the development and implementation of technical solutions for our data platforms. You will be responsible for setting the vision and direction for our data products, ensuring alignment with the Data Office and other stakeholders across the bank and in IT. You will also act as a technical product owner for our cloud data platforms, including Azure Databricks, and collaborate with other product owners and managers to deliver value to our customers. You will guide and mentor our data engineers, foster a culture of innovation and excellence, and promote best practices in data engineering and agile methodologies. You will report to the Chief Data Technology Officer and work closely with the Enterprise Architecture, Info Security and Data Governance organizations. We have an in-office culture and we are not offering hybrid working agreements. Our offices are located at 8750 W. Bryn Mawr, Chicago (near Rosemont and near the blue line Cumberland station, Joliet at 3800 Rock Creek Blvd, and Evansville Indiana. Key Accountabilities <ul> Act as a technical product owner for the cloud data platforms, including Azure Databricks, and collaborate with other product owners and managers to deliver value to the customers. <li>Oversee the design, development, testing, deployment, and maintenance of data products and platforms, ensuring quality, reliability, and scalability. </li><li>Establish and enforce data engineering standards, best practices, and guidelines, and ensure compliance with the enterprise data architecture and governance frameworks. </li><li>Monitor, troubleshoot, and resolve data issues, and ensure data quality and security. </li><li>Provide technical guidance, mentorship, and coaching to the data engineers, and foster a culture of innovation and excellence. </li><li>Position may require the need to travel to other branch or meeting locations. </li></ul> Key Accountability: Data product development and team leadership. <ul> <li>Lead and manage the data engineering team, including hiring, onboarding, performance management, career development, and retention. </li><li>Define and communicate the data engineering vision, roadmap, and backlog, and ensure alignment with the Data Office and other stakeholders. </li><li>Act as a technical product owner for the cloud data platforms, including Azure Databricks, and collaborate with other product owners and managers to deliver value to the customers. </li><li>Oversee the design, development, testing, deployment, and maintenance of data products and platforms, ensuring quality, reliability, and scalability. </li></ul> Key Accountability : Technical leadership and guidance. <ul> <li>Establish and enforce data engineering standards, best practices, and guidelines, and ensure compliance with the enterprise data architecture and governance frameworks. </li><li>Monitor, troubleshoot, and resolve data issues, and ensure data quality and security. </li><li>Provide technical guidance, mentorship, and coaching to the data engineers, and foster a culture of innovation and excellence. </li></ul> Key Accountability: Forward thinking and leadership communications. <ul> <li>Stay abreast of the latest trends and technologies in data engineering and cloud data platforms, and evaluate and recommend new solutions and tools. </li><li>Prepare and present data engineering reports, dashboards, and metrics to senior leadership and business partners. </li></ul> Key Competencies for Position <ul> <li>Ability to lead, inspire, and empower a team of data engineers, providing clear direction, feedback, and coaching. </li><li>Ability to communicate effectively and persuasively with senior leadership, business partners, and technical teams, both verbally and in writing. </li><li>Ability to define and execute a data engineering strategy that supports the bank's data vision and goals, and aligns with the enterprise data architecture and governance frameworks. </li><li>Ability to manage the end-to-end delivery of data products, from ideation to deployment, using agile and lean principles and practices. </li><li>Ability to prioritize and balance multiple projects and initiatives, and manage stakeholder expectations and dependencies. </li><li>Technical passion and curiosity to explore and adopt new technologies and approaches for data engineering and cloud data platforms. </li></ul> Qualifications and Education Requirements <ul> <li>Over 8 years of experience in data engineering, including developing ETL/ELT, data pipelines, data lakes, data warehouses, and data integration solutions. </li><li>Over 3 years of experience in managing and leading data engineering teams, preferably in a financial services or banking domain. </li><li>Over 3 years of experience in working with cloud data platforms, ideally Azure Databricks, and other Azure data services such as Data Factory, Data Lake Storage, Synapse Analytics, etc. </li><li>Over 3 years of experience in acting as a technical product owner or a product manager for data products, platforms, or solutions, using agile frameworks such as Scrum or Kanban. </li><li>Expertise in building scalable, reliable, and secure data products and platforms, using metadata driven, event driven, and API driven approaches. </li><li>Experience in working with stakeholders on gathering requirements, defining user stories, and translating them to data solutions, with a focus on developing reusable and modular components. </li><li>Experience in scripting tools such as Python, C#, or PowerShell. </li><li>Experience in orchestration tools or job schedulers, such as Azure Data Factory, Airflow, or Luigi. </li><li>Experience in data modeling, data quality, data governance, and data security standards and best practices. </li><li>Experience in code repositories and version control tools such as Azure DevOps, Git, etc. </li><li>Experience in analytical and data visualization tools such as Power BI, Tableau, or Qlik. </li><li>Experience in working with Salesforce data and digital banking data is a plus. </li><li>Very good working experience of T-SQL. Proficiency in complex stored procedures, user defined functions, and query optimization. </li><li>Bachelor's degree in Computer Science, Engineering, Mathematics, or a related field, or equivalent work experience. </li></ul> We continually seek highly motivated and talented individuals. Our people are critical to our Company's strategy and success. In return we offer competitive compensation with our salary, bonus program, day 1 effective, exceptional BC/BS medical, Delta dental, Headspace mental health support and vision insurance, 401k Company "match" dollar for dollar (100%) of the first 5% contributed into the Plan. Continuing education and a unique opportunity with a growing, client-focused and collegial company. Old National is proud to be an equal opportunity employer focused on fostering an inclusive workplace and committed to hiring a workforce comprised of diverse backgrounds, cultures and thinking styles. As such, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, status as a qualified individual with disability, sexual orientation, gender identity or any other characteristic protected by law. We do not accept resumes from external staffing agencies or independent recruiters for any of our openings unless we have an agreement signed by the Director of Talent Acquisition, to fill a specific position Our culture is firmly rooted in our core values. We are optimistic. We are collaborative. We are inclusive. We are agile. We are ethical. We are Old National Bank. Join our team













<h5 class="iCIMS_SubHeader iCIMS_SubHeader_Connect">
Need help finding the right job?
</h5>



We can recommend jobs specifically for you! Click here to get started.
 
If you're qualified for a position but need additional help with the application because of a disability, please email HRservices@oldnational.com (This email will respond to accommodation requests only.)

Old National Bank Interview Questions

Old National Bank Interview Guides

Old National Bank Interview Questions

Old National Bank Salaries by Position

Old National Bank Opening Jobs