Requirements

Expected technologies

SQL

Our requirements

• 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

Optional

Working experience in:

Records management and archiving

Extensive experience in:

Query and database access tools Relational databases Technical troubleshooting Database design (Physical) Data warehousing Application testing System testing Implementation Application development tools

Subject matter expert in:

Data movement tools

Your responsibilities

U.S. Bank is seeking a proficient ETL Developer with data processes 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.

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.