Wells Fargo Senior ETL Production Support Engineer in San Francisco, California

At Wells Fargo, we have one goal: to satisfy our customers’ financial needs and help them achieve their dreams. We’re looking for talented people who will put our customers at the center of everything we do. Join our diverse and inclusive team where you’ll feel valued and inspired to contribute your unique skills and experience.

Help us build a better Wells Fargo. It all begins with outstanding talent. It all begins with you.

Enterprise Finance & Information Technology offers technology and services that exceed Wells Fargo customers’ expectations and directly enable them to succeed financially. We interact with customers more than 12 billion times a year through in-store, online, ATM, and telephone transactions. We impact customers directly, through systems availability and security, as well as indirectly, through our business partners who offer and deliver a myriad of products and services that meet customers’ financial needs. We provide a competitive advantage for the company through excellence in fundamentals, integrated partnerships, and our talented and engaged team members.

The Wells Fargo Enterprise Information Technology’s Data Technology Team team is looking for a Senior ETL (Extract, Transform and Load) Production Support Engineer to support the operations of multiple Enterprise scale Data Warehouse applications within the Production Support Shared Service organization. This position has the primary responsibility of providing Level 2 production support, analyzing, troubleshooting, and resolving production job failures, data research, recommending and implementing code fixes as well as coordinating with the ETL Development, Database, and Business Analyst teams within each application team.

Key Responsibilities include:

  • Primary production support for analytical data ETL jobs within the data warehouse application environment

  • Troubleshoot and analyze complex production problems related to source data

  • Troubleshoot and analyze existing Ab-initio code as well as fix the Ab-initio code to resolve production incidents

  • Collaborate with the business analysts and ETL team members to resolve complex data design issues/provide optimal solutions that meet business requirements and benefits system performance.

  • Follow all enterprise software development lifecycle processes and standards

  • Develop and foster a positive relationship with team members, team leads and business partners

  • Develops and updates documentation, departmental technical procedures and user guides

  • Strictly follow change and incident management processes

  • Participate in design reviews and ensure application of best practices and standards

  • Review ETL code for consistency, quality and performance

  • Be willing to work non-standard business hours on an on-call basis in a 24x7x365 environment

  • Implement best practices for production environments

  • Review release code in lower environments and ensure they follow production standards.

  • Encourage and participate in knowledge sharing as necessary

Required Qualifications:

  • 7+ years of application development and implementation experience

  • 8+ years of information technology experience

  • 5+ years of data warehouse experience

  • 5+ years of ETL (Extract, Transform, Load) Programming experience

  • 5+ years of relational database experience

  • 2+ years of job scheduling experience

  • 1+ years of Unix Bash shell scripting experience

  • 1+ year of Big Data experience

Desired Qualifications:

  • Good verbal, written, and interpersonal communication skills

  • A BS/BA degree or higher in science or technology

  • Job scheduling tools experience

  • Knowledge and understanding of incident management: gathering impacts and analyzing data

  • Flexibility to address incidents as needed 24 hours a day

  • Flexibility to frequently be on call beyond normal working hours

Job Expectations:

  • Flexibility to address incidents as needed 24 hours a day

  • Flexibility to frequently be on call beyond normal working hours

How to Express Interest in This Job: Wells Fargo invites you to apply for this job at https://employment.wellsfargo.com/psc/PSEA/APPLICANTNW/HRMS/c/HRSHRAMFL.HRSCGSEARCHFL.GBL?Page=HRSAPPJBPST_FL&FOCUS=Applicant&SiteId=1&JobOpeningId=5439314&PostingSeq=1.

All offers for employment with Wells Fargo are contingent upon the candidate having successfully completed a criminal background check. Wells Fargo will consider qualified candidates with criminal histories in a manner consistent with the requirements of applicable local, state and Federal law, including Section 19 of the Federal Deposit Insurance Act.

Relevant military experience is considered for veterans and transitioning service men and women.

Wells Fargo is an Affirmative Action and Equal Opportunity Employer, Minority/Female/Disabled/Veteran/Gender Identity/Sexual Orientation.

Relevant military experience is considered for veterans and transitioning service men and women.

Wells Fargo is an Affirmative Action and Equal Opportunity Employer, Minority/Female/Disabled/Veteran/Gender Identity/Sexual Orientation.