Senior ETL Developer - Hopkins, MN Or Earth City, MO

US Bank Hopkins , MN 55343

Posted 7 months ago

U.S. Bank is seeking a Senior ETL Developer to support our Mortgage business line to build interfaces and gather data for reporting purposes. The Senior ETL Developer will be responsible for both production support as well as development, for critical, highly visible projects.

Designs, develops, automates, and supports complex applications to extract, transform, and load data. Ensures data quality. Develops logical and physical dataflow models for ETL applications. Codes, tests, implements, and automates complex processes. Plans and conducts ETL unit and development tests; monitors results and takes corrective action. Oversees basic and advanced transformation activities such as normalization, cleansing, aggregation, summarization, and integration. Translates data access, transformation, and movement requirements into functional requirements and mapping designs. Designs automation processes to control data access, transformation, and movement. Ensures source system data availability and update accessibility, data integrity, restart ability, and error handling. Leads technical staff and clients to investigate, analyze, and resolve complex technical problems related to system functions, environment, and procedures. Identifies and manages interfaces, service levels, standards, and configurations.

Senior ETL Developers are also expected to create both high level and detail designs, determine estimates, assign priority and coordinate the development and testing efforts with the business and development teams.

Top candidates must also demonstrate the ability to communicate with wide range of entities and resources within and outside U.S. Bank. This role entails not only leading development efforts, but communication with project management, business leaders, and technical staff. Candidates should demonstrate the ability to communicate at a high level appropriately with each party and entity.

Successful applicants will exemplify U.S. Bank's ethical principles of uncompromising integrity, respect for others, accountability for decisions and actions, and good citizenship.

Basic Qualifications

  • Bachelor's degree or equivalent work experience

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

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

Preferred Skills/Experience

Working experience in:

  • Informatica, Autosys, Encryption/Decryption

  • Data Management

  • SQL

  • 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:

  • ETL

  • Data movement tools

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr Business Analyst / Test Lead Hopkins MN Or Earth City MO

US Bank

Posted 1 week ago

VIEW JOBS 10/3/2019 12:00:00 AM 2020-01-01T00:00 U.S. Bank is seeking a motivated Senior Business Systems Analyst/Test lead with liaison and relationship management experience to contribute toward the success of our digital and payment technology initiatives. Responsible for test planning, execution and oversight. Participates in testing, training, and implementation of applications. Responsible for assisting the business line the development of test scripts and oversight of the execution of those scripts. Participates in developing and maintaining detailed knowledge of the business's current technology and infrastructure from a functional perspective. Provides guidance concerning business implications of development projects. Serves as consultant to internal business groups on various digital and payment related projects designed to improve their business results. . Frequently interfaces with business lines, including management, and/or internal resources to ensure quality, timeliness, and testing of all project/release work. Works with technology and application development teams to design or select solutions that appropriately meet the business needs for large projects. Reviews and validates test plan approaches for proper functionality coverage. May coordinate and execute test plans. Looks for an opportunity to improve testing process. Successful applicants will exemplify US Bank's ethical principles of uncompromising integrity, respect for others, accountability for decisions and actions, and good citizenship Basic Qualifications * Bachelor's degree or equivalent work experience * At least 6 years experience with activities, tasks, practices and deliverables for assessing and documenting business opportunities, benefits, risks, and success factors of potential applications. Preferred Skills/Experience Working experience in: * IT environment * Information management * IT project management * Product and vendor evaluation * Mortgage or consumer lending Extensive experience in: * System testing * System development life cycle * IT standards, procedures, policy * Business assessment * Modeling: data, process, events, objects * Business process modeling Subject matter expert in: * Requirements analysis * Workflow analysis US Bank Hopkins MN

Senior ETL Developer - Hopkins, MN Or Earth City, MO

US Bank