Apps Systems Engineer 5 - ETL Developer


: $106,940.00 - $147,100.00 /year *

Employment Type

: Full-Time


: Information Technology

Loading some great jobs for you...

Job Description

Important Note: During the application process, ensure your contact information (email and phone number) is up to date and upload your current resume prior to submitting your application for consideration. To participate in some selection activities you will need to respond to an invitation. The invitation can be sent by both email and text message. In order to receive text message invitations, your profile must include a mobile phone number designated as 'Personal Cell' or 'Cellular' in the contact information of your application.

At Wells Fargo, we want to satisfy our customers' financial needs and help them succeed financially. 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.

Wells Fargo Technology sets IT strategy; enhances the design, development, and operations of our systems; optimizes the Wells Fargo infrastructure footprint; provides information security; and enables continuous banking access through in-store, online, ATM, and other channels to Wells Fargo's more than 70 million global customers.

This is an ETL Developer position supporting Home Lending. We are moving towards the Enterprise Data Environment as the analytics data lake repository, which will ultimately source the Mortgage Integrated Data Environment (MIDE). The scope of the upcoming work includes sourcing data into the data lake, consuming data from the data lake, and providing a consolidated view of Home Lending data within Wells Fargo.

  • Provides design and development support for analytical systems and data integration applications;
  • Analyzes highly complex business requirements, designs and writes technical specifications to design or redesign complex application solutions;
  • Perform extract, transform and load (ETL) processing for complex Analytical Systems Applications using Ab Initio;
  • Design, development, test, and implement application code;
  • Follow proper software development lifecycle processes and standards;
  • Participate in design and code reviews;
  • Develops new documentation, departmental technical procedures and user guides;
  • Be willing to work non-standard hours as the need arises;
  • Follow change and problem management processes;
  • Develop and foster a positive relationship with team members, team leads and business partners.
  • Contribute significantly to the technical direction of the analytical systems environment;
  • Ensure the proper application of best practices and standards;
  • Propose creative solutions to meet technical and business priorities;
  • Provide guidance to other team members and contractors as required;
  • Participate in on-call production support rotation.

Required Qualifications

  • 7+ years of application development and implementation experience
  • 5+ years of Ab Initio experience
  • 5+ years of experience with end-to-end design and delivery of data warehouse applications
  • 3+ years of experience with databases such as Oracle, DB2, SQL server, or Teradata
  • 5+ years of advanced scripting experience using Unix Shell Scripting, Perl, Python, Java, or PL-SQL

Desired Qualifications

  • Good verbal, written, and interpersonal communication skills
  • BS/BA in computer science, applied statistics, quantitative economics, operations research or a related field
  • Experience in performance tuning technologies including data skew, statistics, Join Index, Partitioned Index, TASM rules, single AMP operations, query grid and intra or inter-datacenter database joins
  • Knowledge and understanding of application analysis and tuning including: memory management, process or thread management, resource management
  • Autosys experience
  • Experience working in a large enterprise environment
  • Experience with Waterfall and Agile project methodologies
  • Big Data experience
  • 5+ years of IT experience in a financial services domain
  • Ability to play leadership role in large and complex analytical projects
  • Excellent verbal, written, and interpersonal communication skills
  • Strong analytical skills and ability to solve complex technical problems

Job Expectations

  • Ability to travel up to 10% of the time


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.

Job Requirements:

Associated topics: equipment, infrastructure, ip, maintain, maintenance, satcom, satellite, server, system engineer, system technician * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Create your profile now!

Create your Profile

Loading some great jobs for you...