Applications Systems Engineer 5-Senior ETL Developer

Compensation

: $89,120.00 - $130,400.00 /year *

Employment Type

: Full-Time

Industry

: 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 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.


Required Qualifications

  • 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



Desired Qualifications

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



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.


Street Address

NC-Charlotte: 1525 W Wt Harris Blvd - Charlotte, NC



Disclaimer


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: data analyst, data architect, data center, data engineer, data integration, data quality, data warehouse, database administrator, hbase, teradata * 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...