Old National Bank has been serving clients and communities since 1834. With $53 billion in total assets, we are a regional powerhouse deeply rooted in the communities we serve. Our team members are our greatest asset, and we continually invest in their growth and development through various Impact Network Groups.

We are currently seeking a Data Engineer III to join our team. This position involves the development and implementation of technical solutions, leveraging expertise in database applications, ETL processes, and automation to support internal and external data exchange and integration needs. The role is based in-office, with locations in Joliet, Chicago, Evansville, and Eden Prairie.

If you are passionate about data engineering and eager to help move our bank to a modern data platform, this guide will walk you through the interview process and provide valuable tips. Let’s get started!

Submitting Your Application

The first step in the application process for the Data Engineer position at Old National Bank is to submit a compelling application that reflects your technical skills and interest in joining. Whether you were contacted by a recruiter or have taken the initiative yourself, carefully review the job description and tailor your CV according to the prerequisites.

Tailoring your CV may include identifying specific keywords that the hiring manager might use to filter resumes and crafting a targeted cover letter. Furthermore, don’t forget to highlight relevant skills and valuable work experiences.

Recruiter/Hiring Manager Call Screening

If your CV happens to be among the shortlisted few, a recruiter from the Old National Bank Talent Acquisition Team will make contact and verify key details like your experiences and skill level. Behavioral questions may also be a part of the screening process.

In some cases, the hiring manager for the Data Engineer position may stay present during the screening round to answer your queries about the role and the company itself. They may also indulge in surface-level technical and behavioral discussions.

The whole recruiter call should take about 30 minutes.

Technical Virtual Interview

Successfully navigating the recruiter round will present you with an invitation for the technical screening round. Technical screening for the Data Engineer role usually is conducted through virtual means, including video conference and screen sharing. Questions in this 1-hour long interview stage may revolve around database applications, ETL processes, automation, and specific technologies like SSIS/Azure Data Factory, Python, and T-SQL.

In addition to verbal technical discussions, you might encounter small coding exercises, system design questions, or case studies that assess your approach to solving real-world business problems.

Onsite Interview Rounds

Followed by a second recruiter call outlining the next stage, you’ll be invited to attend the onsite interview loop. Multiple interview rounds, varying with the role, will be conducted during your day at the Old National Bank office. Your technical prowess, including programming, database management skills, and problem-solving capabilities, will be evaluated against the finalized candidates throughout these interviews.

If you were assigned take-home exercises, a presentation round may also await you during the onsite interview for the Data Engineer role at Old National Bank.

Quick Tips for Old National Bank Data Engineer Interviews

Here are a few tips to help you stand out during the interview process for the Data Engineer position at Old National Bank:

• Understand Modern Data Platforms: Since Old National Bank is transitioning to a modern data platform involving Salesforce and digital banking integration, familiarize yourself with modern data engineering principles and tools like Azure Databricks and data lakes.
• Practice SQL and ETL Skills: Given the requirements emphasize strong T-SQL skills and experience with ETL/ELT processes, ensure you are comfortable with complex SQL queries, stored procedures, and ETL tools like SSIS or Azure Data Factory.
• Showcase Agile Experience: The job posting mentions working in an Agile environment and using tools like Azure DevOps or JIRA for work management. Highlight any relevant Agile experience and familiarity with these tools in your interviews.

Typically, interviews at Old National Bank vary by role and team, but commonly Data Engineer interviews follow a fairly standardized process across these question topics.

• Write a function to merge two sorted lists into one sorted list. Given two sorted lists, write a function to merge them into one sorted list.

• Write a function to find the maximum number in a list of integers. Given a list of integers, write a function that returns the maximum number in the list. If the list is empty, return None.

• Write a query to get the top 3 highest employee salaries by department. Given the employees and departments table, write a query to get the top 3 highest employee salaries by department. If the department contains less than 3 employees, list the top 2 or top 1 highest salaries. The output should include the full name of the employee in one column, the department name, and the salary. The output should be sorted by department name in ascending order and salary in descending order.

• Write a function to combine sorted integer lists into one sorted list. Given a list of sorted integer lists, write a function sort_lists to create a combined list while maintaining sorted order without importing any libraries or using the 'sort' or 'sorted' functions in Python.

• Write a function to swap nodes in a singly linked list. Given the head of a singly linked list represented as a ListNode, and two zero-indexed positions x and y, write a function swap_node which swaps the positions of nodes x and y and returns the new head. Note that you cannot simply swap the values of these nodes; you must swap these two using pointer manipulation.

• How would you investigate a decrease in credit card payment amount per transaction? You work for a financial company and notice that the credit card payment amount per transaction has decreased. How would you investigate the cause of this change?

• How would you build a strategy to find the best small businesses to partner with? You are a credit card company looking to partner with more merchants. You have 100K small businesses to reach out to but can only contact 1000. How would you strategize to identify the best businesses to approach?

• What features would you include in a model to predict a no-show for pizza orders? Imagine you run a pizza franchise and face a problem with many no-shows after customers place their orders. What features would you include in a predictive model to address this issue?

• How does random forest generate the forest, and why use it over logistic regression? Explain the process by which a random forest generates its forest. Additionally, discuss why one might choose random forest over other algorithms such as logistic regression.

• How would you build a fraud detection model with a text messaging service for a bank? You work at a bank that wants to build a model to detect fraud on its platform. The bank also wants to implement a text messaging service that will text customers when the model detects a fraudulent transaction, allowing the customer to approve or deny the transaction via text. How would you build this model?

• What is the relationship between PCA and K-means clustering? Describe the relationship between Principal Component Analysis (PCA) and K-means clustering.

What is the average salary for a Data Engineer at Old National Bank?

Q: What is Old National Bank's history and mission?
Old National Bank has been serving clients and communities since 1834. With $53 billion in total assets, we pride ourselves on helping clients achieve their goals and dreams while investing in our communities through social responsibility, volunteering, and charitable giving.

Q: What are the key responsibilities for a Data Engineer at Old National Bank?
As a Data Engineer, you'll be responsible for the design, development, and maintenance of ETL/ELT processes, as well as building scalable data products and platforms. You'll be collaborating with various stakeholders, focusing on operational excellence, and moving the bank towards modern data platform principles.

Q: What technical skills are required for the Data Engineer position?
Candidates should have over 5 years of data engineering experience, including ETL/ELT development. Preferred skills include experience with SSIS/Azure Data Factory, Python, T-SQL, Azure Databricks, and a strong background in building scalable data products. Familiarity with cloud-based data architectures using the Azure stack or Snowflake is also beneficial.

Q: What is the interview process like for the Data Engineer position at Old National Bank?
The interview process typically includes a combination of technical assessments and behavioral interviews. You can expect questions that evaluate your technical expertise, problem-solving skills, and cultural fit with the company. To prepare, it's useful to practice with platforms like Interview Query.

Q: What is the work environment like at Old National Bank, and are there any location-specific requirements?
Old National Bank values an inclusive and collaborative workplace. The Data Engineer role requires on-site work at one of our office locations, including Chicago, Eden Prairie, Joliet, Evansville, or Milwaukee. We are not currently sponsoring H-1 visas for this position.

Interested in becoming part of a leading financial institution with a history dating back to 1834? At Old National Bank, we are dedicated to not only serving our clients but also investing in our communities and team members. The Data Engineer role offers a unique opportunity to contribute towards moving the bank to a modern data platform while collaborating with professionals passionate about innovation and excellence.

If you want more insights about the company, check out our Old National Bank Interview Guide, where we have covered many interview questions that could be asked. We’ve also created interview guides for other roles, such as software engineer and data analyst, where you can learn more about Old National Bank’s interview process for different positions.

At Interview Query, we empower you with a comprehensive toolkit, equipping you with the knowledge, confidence, and strategic guidance to conquer every interview challenge.

You can check out all our company interview guides for better preparation, and if you have any questions, don’t hesitate to reach out to us.

Good luck with your interview!