Important Note: During the application process, ensure your contact information (email and phone number) is up to date and upload your current resume when 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 is a team of more than 40,000 information technology and security professionals who help keep Wells Fargo at the forefront of America's diversified financial services companies. Employees execute an engineering-led IT strategy to deliver stable, secure, scalable and innovative services that provide Wells Fargo global customers 'round-the-clock' banking access through in-store, online, ATM, and other channels. Wells Fargo Technology plays a critical role in the company's customer and employee experience, business and risk management transformation, and growth agenda
The Enterprise Functions Technology (EFT) group provides technology solutions and support for Risk, Audit, Finance, Marketing, Human Resources, Corporate Properties, and Stakeholder Relations business lines. In addition, EFT provides unique technology solutions and innovation for Wells Fargo Technology, Enterprise Shared Services, and Enterprise Data Management. This combined portfolio of applications and tools are continually engineered to meet the challenges of stability, security, scalability, and speed.
We are looking for Senior ETL development Lead or strong individual contributor in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology (Oracle 12g R2, Informatica Powercenter v10.2, AbInitio 3.6), tools (SqlDeveloper,github), Unix Scripting, and existing design methodologies
ETL Development Lead responsibilities include:
Analyzes highly complex business requirements, designs and writes technical specifications to design or redesign complex computer platforms and applications.
Lead and guide development team on Informatica based ETL architecture.
Develop solution in highly demanding environment and provide hands on guidance to other team members.
Develop & Implement an Informatica based ETL solution fulfilling stringent performance requirements.
Collaborate with product development teams and senior designers to develop architectural requirements to ensure business requirements are met.
Assist and verify design of solution and production of all design phase deliverables.
Perform detailed data analysis to understand the source system data.
Review physical Database objects including staging, materialized views, indexes provided by Data Modeler.
Work with appropriate leads and review high level ETL design, source to target data mapping document and be the point of contact for any ETL related questions.
Coordinate ETL and database development work with offshore ETL developers and conduct code reviews.
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.
7+ years of software engineering experience
A BS/BA degree or higher
7+ years of Ab Initio experience
7+ years of Informatica experience
7+ years of Oracle experience
7+ years of SDLC (System Development Life Cycle) experience
7+ years of application production support experience
7+ years of experience with Waterfall and Agile project methodologies
5+ years of experience with Automated Financial Systems (AFS)
2+ years of experience working with Loan IQ software
7+ years of experience with end-to-end design and delivery of ETL (Extract, Transform, Load) applications
5+ years of experience with Oracle Financial Services Analytical Applications (OFSAA) platform in one or a combination of the following: Financial Services Data Foundation (FSDF), General Ledger reconciliation, Data Quality Framework, or Run Rule Framework
An industry-standard technology certification
Strong verbal, written, and interpersonal communication skills
Data warehouse experience
Experience building partnerships and consulting effectively with leadership
Wholesale banking experience
Ability to act as a liaison between the technical design staff and business requester to ensure all requirements are met
Ability to manage multiple technology development efforts
Ability to work effectively in virtual environment where key team members and partners are in various time zones and locations
Exposure to Wells Fargo PAC2000 -WF's ticketing system based on Remedy application
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
7+ years of Autosys experience
7+ years of Metadata experience
Experience successfully escalating complex issues and tracking follow-through to completion
Ability to be flexible and adjust plans quickly to meet changing business needs
Willingness to work on-site at stated location on the job opening
Ability to work on call as assigned
Ability to work additional hours as needed
Ability to travel domestically
CA-Fremont: 3440 Walnut Ave Bldg A - Fremont, CA
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.
Internal Number: 5555224-3
About WELLS FARGO BANK
Wells Fargo & Company (NYSE: WFC) is a diversified, community-based financial services company with $1.9 trillion in assets. Wells Fargo’s vision is to satisfy our customers’ financial needs and help them succeed financially. Founded in 1852 and headquartered in San Francisco, Wells Fargo provides banking, investment and mortgage products and services, as well as consumer and commercial finance, through 7,400 locations, more than 13,000 ATMs, the internet (wellsfargo.com) and mobile banking, and has offices in 32 countries and territories to support customers who conduct business in the global economy. With approximately 260,000 team members, Wells Fargo serves one in three households in the United States. Wells Fargo & Company was ranked No. 29 on Fortune’s 2019 rankings of America’s largest corporations. News, insights and perspectives from Wells Fargo are also available at Wells Fargo Stories.
www.wellsfargo.com | Twitter: @WellsFargo