Informatica / Teradata Developer - Apps Systems Engineer 4

Wells Fargo   •  

Redwood City, CA

5 - 7 years

Posted 245 days ago

This job is no longer available.


Job Description

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.

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 bank’s wholesale portfolio data from diverse platforms and bringing into a Teradata platform to create 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 / Collaborate 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
  • 3+ years of ETL (Extract, Transform, Load) Programming experience
  • 3+ years of Informatica experience
  • 3+ years of experience with databases such as Oracle, DB2, SQL server, or Teradata
  • 3+ years of UNIX experience

Desired Qualifications

  • Excellent verbal, written, and interpersonal communication skills
  • 2+ years of Autosys experience
  • Knowledge and understanding of Ab Initio
  • Knowledge and understanding of business intelligence solutions and implementations
  • Financial services experience
  • 3+ years of wholesale banking experience
  • Experience developing partnerships and collaborating with other business and functional areas
  • Strong organizational, multi-tasking, and prioritizing skills
  • Hadoop experience
  • A BS/BA degree or higher in information technology

Other Desired Qualifications

Nice to have:

  • 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
  • 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

Job Expectations

  • Ability to work nights, weekends, and/or holidays as needed or scheduled
  • Ability to travel up to 10% of the time