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 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.
Wells Fargo Capital Markets Data Services technology team is seeking a hands-on Applications Systems Engineer to work on Enterprise Market Risk Technology (EMRT) data initiatives partnering with Enterprise Credit Risk Technology Team . Most of the data initiatives drive Wells Fargo Market Risk systems to perform valuations, simulations, aggregations and drive reporting of risk sensitivities and stresses on all the major assets classes: equities, bonds, commodities, currencies and their derivatives including structured products, and credit derivatives etc. Market risk activities include market risk, Counterparty Credit Risk, issuer risk, country risk and liquidity risk. The Market Risk systems perform valuation, simulation, aggregation and reporting of risk metrics and models on all simple (bonds) and complex (structured products, derivatives) securities products.The Market Risk systems are comprised of intra-day and overnight batch processes that handle staging for all trading position data and market data required for risk modeling as well as making this data available to the various risk valuation systems, Quantitative models and reporting support trading activities as well as regulatory and business reporting requirements.
It is essential that the senior ETL developer has solid understanding of Market Risk domain including pricing/valuation and VAR calculations. Additionally, a good understanding of data used for Market & Counterparty Risk CCAR reporting, Capital calculations and SACCR calculations is critical to the success in this role. The developer should also have a good knowledge of Capital Markets along with deep knowledge of Advanced C#, design patterns, Core Java development, SSIS or Talend based ETL development, database modeling and database development using SQL Server 2012/2016, Mongo database, Test-Driven Development, Behavior Driven Development practices and deployment skills using Team Foundation Server, concurrent to skills in technical analysis and documentation, application monitoring and application testing. Additionally, technical expertise in Big Data/Hadoop, XML, Team Foundation Server(TFS), GIT, Tortoise SVN, Anthill Pro, Udeploy and Jenkins is needed in order to meet the requirements for this position. It is also necessary to effectively communicate ideas and implementation details across technology teams including business users, technology partners, product owners and other designers, application architects and business functional leadership.
The senior ETL developer will be performing the following duties:
Design and implement highly distributed, scalable processes -Staging, Data Enrichments using SSIS/Talend, SQL, Strong data enrichment & delivery techniques using C#/Java, Microsoft SQL Server, SSIS, TFS, Autosys and UNIX.
The resource will be in charge of leading 3-5 team of database leads/senior application/database developers in the execution of multiple work streams.
For new development, the resource will be expected to work with business partners and analysts in order to understand the data requirements and to analyze and design the necessary data flow and database design.
Assures quality, maintainability, and extensibility for supported systems and risk applications.
The resource should be strong in performance tuning and designing high data volume for high performance throughput on a daily basis. The successful candidate will need to have advanced information delivery and development skills in order to create effective data solutions that can be easily maintained and extended to meet the growing demands of Market and Counterparty Risk Management (MCRM)
This position also requires that the developer has experience supporting front end portal data needs and reporting tools like Tableau. This experience is needed to manage the large amount of position data and market data feeding into the system, as well as the risk results and reporting data stored in a database. This requires skills in schema design, and in stored procedure and view creation.
Pays attention to details and has strong communication skills both in verbal and written and the ability to communicate effectively with peers and business users.
7+ years of application development and implementation experience
5+ years of capital markets experience
5+ years of ETL, data warehouse and data analytics delivery experience on internal or external cloud platforms
7+ years of secure SDLC (System Development Life Cycle) methodologies experience
7+ years of C#.NET experience
7+ years of database experience with at least two of the following platforms: MSSQL, MongoDB, DB2 LUW, Teradata, or Sybase
10+ years of application development experience
3 + years of Core Java experience
5 + years of Team Foundation Server (TFS) experience
A BS/BA degree or higher
Good verbal, written, and interpersonal communication skills
Knowledge and understanding of Big Data
Strong analytical skills and ability to solve complex technical problems
Ability to work effectively, as well as independently, in a team environment
Ability to communicate effectively with business partners and project managers
Ability to develop and promote creative alternatives as a way to solve for business requirements
Knowledge and understanding of multiple source code version control systems in working with branches, tags and labels
Knowledge and understanding of technical documentation: creation of detailed design and technical artifacts
Other Desired Qualifications
Experience creating relevant SDLC documentation/deliverables as part of standard project implementations (architecture & design documents, deployment diagrams, source code, scripts, any necessary documentation, etc.)
Ability to collaborate with the managers to identify key solutions for regulatory obligations, risks, risk mitigations and review technical deliverables during the entire project life cycle.
High level of proficiency in working with systems required to effectively process large volumes of both real-time and batch transactions.
Experience defining data model development methodologies, principles, standards, and governance.
5+ years of experience working on Market Risk related CCAR calculations and reporting.
NC-Charlotte: 1525 W Wt Harris Blvd - 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.
Internal Number: 5543767
About Wells Fargo
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