at Old National Bank in Joliet, Illinois, United States
Job Description
Old National Bank was established in 1834. Today, we are the largest financial services holding company with dual headquarters in Chicago and Evansville, IN. We provide an array of services to our clients which include Community Banking, Investments, and Wealth Management. At Old National, we believe that by helping our team members balance work life with home life, we create a more productive workforce and a stronger company.
We are currently seeking a Data Engineer responsible for the development and implementation of technical solutions. This role leverages technical expertise in database applications, ETL processes, and automation in support of internal and external customers data exchange and integration needs. Participate and deliver Salesforce integration and data warehouse project and later work as the main ETL support member after the go-live. We are not currently sponsoring H-1. Office is in Chicago near Rosemont Illinois.
REQUIRED EDUCATION, EXPERIENCE AND SKILLS:.
+ Over 5 years of experience with Informatica developing ETL and recent experience with IICS. We prefer 3 years of experience with SSIS, and some knowledge of Python.
+ Expertise in designing and implementing Relational Database mode as per business needs
+ Must have experience in Database Development, Design, Analysis, SQL Servers 2015-2019 in Development, Testing and Production Environments with various business domains
+ Experienced in extracting, transforming and loading ETL data from excel, flat file. C and C# used for scripting in Script Tasking in SSIS to control the flow of SSIS package
+ Very good working experience of T-SQL. Proficiency in complex stored procedures, User Defined Functions (UDF), Database Triggers, using tools like SQL Profiler and Database Tuning Advisor (DTA)
+ Implemented incremental load for many SSIS packages. Experience in error handling, debugging, error logging for production support in SSIS. Experience in bulk importing CSV, XML and Flat files data using Bulk copy program (BCP)
+ Hands on experience in performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes
+ Experienced in normalizing and de-normalizing the tables and maintaining referential integrity by using triggers and primary and foreign keys
+ Ability to work independently and be able to collaborate and guide other team members
+ Strong written and oral communication, experience on reproving and presenting new design and solutions to senior leadership
+ Working knowledge of MS SSMS 2012 to 2019
+ Working knowledge of analytical and data visualization technology such as Power BI, R Services
+ Working knowledge of cloud based data architectures leveraging PAAS, IAAS, DAAS etc..
+ Familiarity with MS DQM, MDM, Big Data concepts Works well independently; capable of self-motivating and managing
+ Position may require the need to travel to other branch or meeting locations.
DUTIES/RESPONSIBILITIES:
+ Design, development, and maintenance (enhancements and maintenance) of ETL processes and business intelligence solutions using the IICS and SQL Server Relational Database technologies.
+ Design and development of processes for various types of data (potentially large datasets and disparate data sources that require transformation and cleansing to become a usable data set.)
+ Monitor production jobs, maintain, and enhance legacy ETL processes on a regular basis. Improve slow running jobs with the help of redesign and better ETL processes to meet business needs.
+ Take directions, follow recommendations provided by data architecture, Info Security and data governance organization.
+ Confer with relevant team members where necessary. Study systems flow, data usage, and work processes.
+ Deliver functional work product that has been thoroughly tested.
+ Follow development team’s SDLC process. Accurately estimate time required to complete projects and tasks.
+ Meet mutually agreed upon deadlines for completion of modules throughout the program development.
+ Work very closely with the existing DBA to design, model, develop, and maintain existing and new SQL databases objects required for all business solutions
Key Competencies for Position
+ Works well independently; capable of self-motivating and managing.
+ Ability to work independently and be able to collaborate and guide other team members.
+ Strong written and oral communication, experience on reproving and presenting new design and solutions to senior leadership.
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 Head of Talent Acquisition, SVP, to fill a specific position.
External Job Title: Informatica IICS Data Engineer
Requisition ID: 2022-11322
Street: 212 N Chicago
