ETL Datastage Architect

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 Senior ETL Developer with data processing and integration experience to contribute toward the success of our technology initiatives. Participates in the development and documentation of applications to extract, transform, and load data. Develops queries and ETL that is consistent and integrated with existing ETL processes. Creates and implements automated processes to control data access, transformation, and movement. Ensures source system data availability and update accessibility, data integrity, restart ability, and error handling. Develops processes using ETL tools to implement logical and physical dataflow models according to functional requirements and mapping designs. Codes, tests, and implements ETL mappings and scripts to build and maintain automated ETL processes. Supports, and at times, leads clients and technical staff to investigate, analyze, and resolve technical problems related to system functions and procedures. On call support is a part of the role. Senior level positions oversee basic and advanced transformation activities such as normalization, cleansing, aggregation, summarization, and integration; identifies and manages interfaces, service levels, standards, and configurations.

Basic Qualifications

• Bachelor's degree in Computer Science or related field, or equivalent work experience

• At least 5 years of experience with design, development, automation, and support of applications to extract, transform, and load data

• At least 7 years of experience within a total information technology (IT) environment

Preferred Skills/Experience

• Hands on working experience with IBM Infosphere DataStage or Informatica ETL tool preferred

• Extensive experience with Relational databases and SQL, IBM DB2 and Oracle preferred

• Technical troubleshooting expertise

• Solid knowledge of Linux including basic commands and scripting

• Expert in Database design (Physical), Data warehousing, Application testing, System testing, Implementation and Application development tools

• Knowledge of scheduling tools, Autosys and CA7 preferred

• Familiarity with agile methodology, scrum, Kanban etc.

Location Expectations

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.

Benefits: 

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 law

U.S. Bank is an equal opportunity employer. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, and other factors protected under applicable law.

E-Verify

U.S. Bank participates in the U.S. Department of Ho