ETL Architect

at  US Bank National Association

At U.S. Bank, we’re on a journey to do our best. Helping the customers and businesses we serve to make better and smarter financial decisions and enabling the communities we support to grow and succeed. We believe it takes all of us to bring our shared ambition to life, and each person is unique in their potential. A career with U.S. Bank gives you a wide, ever-growing range of opportunities to discover what makes you thrive at every stage of your career. Try new things, learn new skills and discover what you excel at—all from Day One.

JOB DESCRIPTION

U.S. Bank is seeking a proficient ETL Architect with data architecture experience to contribute toward the success of our technology initiatives. Leads and consults on the design, development, and implementation of the architecture and metadata repository for extraction, transformation, and load (ETL) solutions. Provides technical consulting to development teams during design and development for highly complex or critical projects. Identifies opportunities for new initiatives. Recommends changes to increase scalability and robustness of ETL platforms and solutions. Defines policies and best practices for ETL data manipulation functions. Evaluates new tools and techniques and makes recommendations to improve real-time and batch data access, transformation and movement across heterogeneous technologies and platforms. Determines organizational strategies for data integrity validation processes, optimizing data throughput/accessibility, restart ability, and error-handling for tools to deliver ETL solutions.
Successful applicants will exemplify US Bank’s ethical principles of uncompromising integrity, respect for others, accountability for decisions and actions, and good citizenship.

PREFERRED SKILLS/EXPERIENCE

• Extensive experience in: Query, database access tools and Data movement using IBM DataStage, Informatica PowerCenter and PowerExchange
• Hands on working experience in Records management and archiving
• Hands on experience in : Modeling: (data, process, events, objects), Data warehousing Application development tools, Relational databases and Application design and architecture
• Extensive experience in: Query, database access tools and Data movement using DB2 mainframe and UDB databases
• Knowledge of Linux servers and Autosys for job scheduling.
• Knowledgeable on Relational databases and System testing
• Technical troubleshooting expertise
• Expert in Database design (Physical), Data warehousing, Application testing, System testing, Implementation and Application development tools
• Subject matter expert in Data movement tools

THE ROLE OFFERS A HYBRID/FLEXIBLE SCHEDULE, WHICH MEANS THERE’S AN IN-OFFICE EXPECTATION OF 3 OR MORE DAYS PER WEEK AND THE FLEXIBILITY TO WORK OUTSIDE THE OFFICE LOCATION FOR THE OTHER DAYS.

If there’s anything we can do to accommodate a disability during any portion of the application or hiring process, please refer to our disability accommodations for applicants.

Our approach to benefits and total rewards considers our team members’ whole selves and what may be needed to thrive in and outside work. That’s why our benefits are designed to help you and your family boost your health, protect your financial security and give you peace of mind. Our benefits include the following (some may vary based on role, location or hours):

• Healthcare (medical, dental, vision)
• Basic term and optional term life insurance
• Short-term and long-term disability
• Pregnancy disability and parental leave
• 401(k) and employer-funded retirement plan
• Paid vacation (from two to five weeks depending on salary grade and tenure)
• Up to 11 paid holiday opportunities
• Adoption assistance
• Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by la