U.S. Bank Senior Database Developer/Database DB2 Architect in Irving, Texas
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.
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.
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.
Bachelor's degree, or equivalent work experience
5-6 years of relevant experience
Advanced knowledge of information systems technology and software development processes and tools, especially industry specific applications
Knowledge in Agile Methodologies and experience working in agile projects
Minimum 6+ years of experience in the IT Industry involving Software Analysis, Design, Implementation, Coding, Development, Testing, and Maintenance with a focus on DB2 Data warehousing applications
Extensive advance level experience on IBM DB2
DB2 / MS SQL Query Performance tuning and optimization, database design/Architecture.
Expert level experience in data modeling based on specifications.
Advanced understanding of relational database architecture.
Extensive knowledge of SQL including the writing of complex stored procedures, functions as well as basic knowledge of database administration
Proficient in database performance tuning including indexing, partitioning, analyzing SQL plans etc.
Expert level in T-SQL & SQL Server Development skills including creating and modifying Stored Procedures.
Expertise in SQL writing by incorporating Joins, Aggregations, Common Table expressions, Analytical functions etc.
Expert-level experience working with Data Warehousing Concepts including OLAP, OLTP, Star Schema, Snowflake Schema, Logical/Physical, and Dimensional Data Modeling.
Extensively used ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation, and loading using SSIS and designed data conversions from a wide variety of source systems including IBM DB2 , MS SQL Server.
Experience with Business Intelligence Suite (SSIS, SSRS, SSAS) for SQL Server is desired.
Design and develop SSIS packages, database objects, stored procedures and packages, views, tables, triggers and ETL code using coding standards and according to technical specifications.
Experience with GitHub or GitLab.
Knowledge of Kafka, Cassandra, any NoSQL database e.g., MongoDB, Orient DB, CouchDB etc.
Experience or willingness to learn public cloud (Azure/AWS/GCP)
Financial or transportation industry experience desired.
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 (https://careers.usbank.com/global/en/disability-accommodations-for-applicants) .
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 (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/eeopost.pdf) poster.
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 (https://careers.usbank.com/verification-of-eligibility-for-employment) .
Salary range reflected is an estimate of base pay and is for the primary location. Base pay range may vary if an offer is made for work in a different location. Pay Range: $108,545.00 - $127,700.00 - $140,470.00
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.
U.S. Bank will consider qualified applicants with criminal histories in a manner consistent with the San Francisco Fair Chance Ordinance.
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.