Senior ETL Developer - Apps Systems Engineer 5 in San Francisco, California | DiversityInc Careers
This job has expired and you can't apply for it anymore. Start a new search.

Senior ETL Developer - Apps Systems Engineer 5

Job Description

We are looking for a senior developer to join the team supporting the Wholesale Customer Due Diligence Datamart and Reporting. To be successful in this role, you will need an extensive background in Informatica and Teradata database, building complex data systems, and a good understanding of Financial Crimes Risk, Customer Due Diligence domain. You will be working closely with business and technology partners to build and support the platform.

This role will involve:

  • Working as a senior developer providing technical guidance and consultation with developers and business teams for Financial Crimes Risk and Customer Due Diligence reporting Datamart
  • Works closely with business team to participate in sprints, analyze requirements, performs complex data modelling, design code and develop technical solution
  • Performs complex ETL coding using Informatica, database programming using Teradata and batch scheduling tools preferably Autosys and UNIX shell scripting
  • Performs build, test and deploy. Utilizes advanced technologies and methods to integrate data systems and other existing platforms such as SharePoint and websites
  • Develops new documentation and technical procedures
  • Provides guidance and direction to less experienced staff in design, development and resolution of highly complex technical problems
  • Assures quality, security and compliance requirements are met for supported area and oversees creation of or updates to and testing of the business continuation plan
  • Ability to proactively recommend system efficiencies, processes and designs
  • Ability to research and identify root cause of complex production issues; Support production processes
  • Prepare detailed specifications and ETL design documentation
  • Ability to effectively market and communicate concepts and solutions

In addition, will have production support responsibilities of the data processing applications. Collaborate with Enterprise Availability Office (EACO), Wholesale Service Level Management, System Admins, Middleware Support, DBAs, Developers and other stakeholders relevant to addressing production issues.

Required Qualifications

  • 5+ years of performance tuning experience
  • 7+ years of data warehouse experience
  • 5+ years of Informatica experience
  • 5+ years of Teradata experience
  • 3+ years of application production support experience
  • 4+ years of experience leading the requirement design process with both technical and business partners
  • 5 + years of experience gathering business requirements from various sources including end-users and stakeholders
  • 7+ years of application development and implementation experience

Desired Qualifications

  • A BS/BA degree or higher in information technology
  • 1+ year of financial services industry experience
  • Hadoop experience
  • Ability to work effectively in virtual environment where key team members and partners are in various time zones and locations
  • Knowledge and understanding of outsourcing vendors and in-house software development teams focused on data solutions
  • Knowledge and understanding of technology support: System including business requirement design or review, release management support, test script development and execution, and system issue resolution
  • Good verbal, written, and interpersonal communication skills

Job Expectations

  • Willingness to work on-site at stated location on the job opening

Street Address

AZ-Chandler: 2600 S Price Rd - Chandler, AZ
CA-SF-Financial District: 333 Market St - San Francisco, CA
MN-Minneapolis: 255 2nd Ave S - Minneapolis, MN
NC-Charlotte: 401 S Tryon St - Charlotte, NC
CA-Fremont: 3440 Walnut Ave Bldg A - Fremont, CA
NC-Charlotte: 301 S Tryon St - Charlotte, NC
AZ-Tempe: 711 W Broadway - Tempe, AZ


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.