Fifth Third Bank Lead ETL Developer in Cincinnati, Ohio
Fifth Third Bank is one of the top-performing banks in the country, with a heritage that spans more than 150 years. As The curious bank, we've staked our claim on looking at things differently, at being better listeners and at showing more commitment. This applies to our relationships with customers and employees alike.
We employ about 19,000 people, and what we offer is:
A chance for employees to build their future, with supportive career development and financial wellness programs.
An environment where we win together. We celebrate achievement and work collaboratively. We're also a two-time Gallup Great Workplace honoree.
An invitation to impact lives in a positive and lasting way. Everything we do is geared toward improving lives. That's fun and exciting.
It comes down to the fact that Fifth Third is a warm and caring place to with which to grow # as a customer or as a team member.
Information Technology's vision is to be recognized as an industry-leading services company by efficiently delivering solutions and services our customers can rely on. We strive to create a business-focused team that drives significant value for the Company while building customer-centric service delivery models through the integration of technologies, data, and processes. Our customers' trust is earned through the effective delivery of resilient, secure products and services while balancing business needs with industry and regulatory requirements.
* Fifth Third Information Technology is comprised of several areas including:*
Commercial IT, Consumer IT, Payments IT, Infrastructure IT, Enterprise and Corporate Applications as well as IT Security and Risk.
Fifth Third Bank has several teams across the Information Technology Division responsible for building data structures in support of the Bancorp's Reporting and Analytic needs. The Lead ETL Developer role is a position responsible for theDesign,Development, Testing, and Support of these databases. A key component of the role is to also act as a Technical Lead interfacing with Fifth Third's offshore development partners and as a mentor to more junior level team members. The incumbentmaypossess a level of autonomy to succeed at this level.
Responsible and accountable for risk by openly exchanging ideas and opinions, elevating concerns, and personally following policies and procedures as defined. Accountable for always doing the right thing for customers and colleagues, and ensures that actions and behaviors drive a positive customer experience. While operating within the Bank#s risk appetite, achieves results by consistently identifying, assessing, managing, monitoring, and reporting risks of all types.
DUTIES AND RESPONSIBILITIES
. Design, Code, Test, and Document mappings/transformations of load routines to the Data Warehouse or Data Marts.
. Translation of Functional Specifications into Technical Design Specifications for off-shore development team
. May serve as an individual contributor on smaller initiatives, or as a member of a development team on larger initiatives
. Function as Technical Lead to junior resources or our off-shore development team
. May be asked to tune SQL statements to ensure optimal performance
. Provide input on physical database design decisions
. Trouble shoot and problem solve data integrity issues
. Maintain documentation in corporate data dictionary
. May provide 24 x 7 production support
Fifth Third Bank is proud to have an engaged and inclusive culture and to promote and ensure equal employment opportunity in all employment decisions regardless of race, color, gender, national origin, religion, age, disability, sexual orientation, gender identity, military status, veteran status or any other legally protected status.
KNOWLEDGE AND SKILLS REQUIRED
. 3 - 5 years of related experience
. Proficient in SQL
. General understanding of Data Modeling principles
. General knowledge of Extract, Transform, and Load (ETL) concepts, and working knowledge of 3rd party ETL tool
. Knowledge of DataStage and/or Job Control Language (JCL) a plus
. Scripting skills (SQL, AQT, Shell) a plus