At U.S. Bank, we're passionate about helping customers and the communities where we live and work. The fifth-largest bank in the United States, we’re one of the country's most respected, innovative and successful financial institutions. U.S. Bank is an equal opportunity employer committed to creating a diverse workforce. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, among other factors. Job Description We are looking for a DB2 developer with ETL experience. This position will be responsible for the analysis, design, testing, development and maintenance of best in class software experiences. The candidate is a self-motivated individual who can collaborate with a team and across the organization. The candidate takes responsibility of the software artifacts produced adhering to U.S. Bank standards in order to ensure minimal impact to the customer experience. The candidate will be adept with the agile software development lifecycle and DevOps principles. #LI-REMOTE Essential Responsibilities: - Responsible for designing, developing, testing, operating and maintaining products. - Takes full stack ownership by consistently writing production-ready and testable code. - Consistently creates optimal design adhering to architectural best practices; considers scalability, reliability and performance of systems/contexts affected when defining technical designs. - Makes sound design/coding decisions keeping customer experience in the forefront. - Takes feedback from code review and apply changes to meet standards. Conducts code reviews to provide guidance on engineering best practices and compliance with development procedures. - Accountable for ensuring all aspects of product development follow compliance and security best practices. - Exhibits relentless focus in software reliability engineering standards embedded into development standards. - Embraces emerging technology opportunities and contributes to the best practices in support of the bank's technology transformation. - Contributes to a culture of innovation, collaboration and continuous improvement. - Reviews tasks critically and ensures they are appropriately prioritized and sized for incremental delivery. Anticipates and communicates blockers and delays before they require escalation. Basic Qualifications - Bachelor's degree, or equivalent work experience - Five to six years of relevant experience Preferred Skills/Experience Extensive experience in DB programming and tuning for ETL processes. Exceptional Analytical and problem solving skills with demonstrated ability to analyze technical information and give guidance to team members. Ability to grasp business requirement and convert them to technical designs and implement them with performance improvements, stability of the system in mind. Apply appropriate design principles. Good knowledge of DB2 UDB EEE (DPF) in a multi-partitioned distributed Environment. Experienced in database application programming including stored procedure and trigger development. Strong DB2 UDB performance tuning and monitoring experience, experience of using Explains Strong SQL skills including the ability to rewrite complex queries for performance improvements. Strong DB2 MOVE/Load Utility(export, import, unload, load, load replace, non-recoverable) Experience. Strong knowledge of SQL/PL(Stored procedures development and SP builder software ie IBM Data Studio) Unix Shell scripting. User defined types (UDTs), Data type casting, parameter markers, compound SQL, embedded SQL, triggers, units of work considerations, federated databases, db2 connect and concurrency considerations. 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: Take care of yourself and your family with U.S. Bank employee benefits. We know that healthy employees are happy employees, and we believe that work/life balance should be easy to achieve. That's why we share the cost of benefits and offer a variety of programs, resources and support you need to bring your full self to work and stay present and committed to the people who matter most - your family. Learn all about U.S. Bank employee benefits, including tuition reimbursement, retirement plans and more, by visiting careers.usbank.com. EEO is the Law Applicants can learn more about the company’s status as an equal opportunity employer by viewing the federal EEO is the Law poster. E-Verify U.S. Bank participates in the U.S. Department of Homeland Security E-Verify program in all facilities located in the United States and certain U.S. territories. The E-Verify program is an Internet-based employment eligibility verification system operated by the U.S. Citizenship and Immigration Services. Learn more about the E-Verify program. Due to legal requirements, U.S. Bank requires that the successful candidate hired for some positions be fully-vaccinated for COVID-19, absent being granted an accommodation due to a medical condition, pregnancy, or sincerely held religious belief or other legally required exemption. For these positions, as part of the conditional offer of employment, the successful candidate will be asked to provide proof of vaccination or approval for an accommodation or exemption upon hire.