1+ months

Informatica and Teradata Developer / Apps Systems Engineer 4

Chandler, AZ
  • Job Code
Job Description

Freemont, CA and Charlotte, NC are the preferred locations.

Wells Fargo Wholesale Banking Technology is seeking an Informatica and Teradata developer for WDM (Wholesale DataMart) team within Wholesale Banking Technology Group. WDM team is building a complex active data warehouse system sourcing banks wholesale portfolio data from diverse platforms and bringing into a Teradata platform tocreate a business analytics environment. This team use is leveraging Teradata as main database technology and Informatica as its primary ETL tool.

As a member of the Wholesale Core Services Technology Team you will play an important role in the crucial area of data strategy. The member will be working on design and development ETL applications for various data sourcing and subject area data mart projects; The focus of this role will be to utilize advanced data tools and techniques to build efficient ETL applications for the platform

Responsibilities include

  • Acts as a core Teradata/ETL developer in application development and support data marts inside the Wholesale Teradata analytic platform
  • Candidate will work closely with application lead to understand business requirements, write functional design specs and participate in efficient development delivery and deployment
  • Evaluate system designs for efficiency with focus on performance. Verifies program logic by preparation of test data, testing and debugging of programs
  • Develops documentation as per compliance and support needs
  • Participates as needed in compliance, risk and regulatory processes within Wells Fargo
  • Interact / Colloorate closely with teammates, DBAs, and interface partners as well as ensuring quality throughout the development lifecycle

    Additional responsibilities include

  • Coordinating with offshore development teams
  • Support ad-hoc report requests for reporting analysis and data issue investigation

Required Qualifications

  • 5+ years of application development and implementation experience
  • 5+ years of ETL (Extract, Transform, Load) Programming experience
  • 3+ years of Teradata experience
  • 3+ years of data warehouse experience
  • 3+ years of UNIX experience

Desired Qualifications

  • Excellent verbal, written, and interpersonal communication skills
  • 3+ years of financial services experience
  • 3+ years of wholesale banking experience
  • 3+ years of Autosys experience
  • Ability to identify and manage complex issues and negotiate solutions within a geographically dispersed organization
  • Experience developing partnerships and collaborating with other business and functional areas
  • Excellent verbal, written, and interpersonal communication skills
  • Strong organizational, multi-tasking, and prioritizing skills
  • A BS/BA degree or higher in information technology
  • 4+ years relational database management system (RDBMS) experience

Other Desired Qualifications
  • 5 + years of experience building data warehouse, datamart or operational datastore systems; experience with database design, data modeling, dimension modeling concepts, ETL, data development, data integration, data distribution, data quality and analytics
  • Experience in using ETL tools like Talend and Sqoop
  • 3+ years of direct experience in designing, implementing and supporting applications using Teradata utilities (Hands on experience in BTEQ, TPT load utilities, View point, writing complex SQL queries involving aggregation, OLAP functions etc , query tuning, Teradata performance tuning)
  • Clear understanding of Teradata architecture
  • Clear understanding of RDBMS, BI and dimensional modeling concepts
  • Experience in writing and reading from Hadoop distribution platforms

Street Address

CA-Fremont: 3440 Walnut Ave Bldg A - Fremont, CA
AZ-Chandler: 2600 S Price Rd - Chandler, AZ
NC-Charlotte: 301 S Tryon St - Charlotte, NC


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.



  • Engineering
  • Financial Services
  • Legal
  • Retail / Wholesale
  • Transportation / Warehouse

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Informatica and Teradata Developer / Apps Systems Engineer 4

Wells Fargo
Chandler, AZ

Share this job

Informatica and Teradata Developer / Apps Systems Engineer 4

Wells Fargo
Chandler, AZ

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast