28 days old

Application Systems Engineer 4 -Informatica ETL Developer

Charlotte, NC
  • Job Code
Job Description

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.

HR Systems provides technology support for team member focused applications and processes, including payroll, compensation, benefits, learning and recruiting. The HR Systems total portfolio of supported applications is used by HR professionals, managers, and general Wells Fargo team members. The HR Compensation Team administers enterprise tools for Focal review , Objective management, and other various administrative HR tools.

The HR Systems Compensation team is seeking an Application Systems Engineer to support the PeopleSoft integration with Oracle HCM cloud and creating and supporting reports using BI publisher for HCM cloud - encompassing HR Compensation functions (Focal review and Objective Management) within Wells Fargo.

Responsibilities include:

  • Develop Informatica/ETL code to load Upstream source data into LARS Data Marts
  • Develops original and complex code, creates mappings, sessions, workflows, or provides coding guidance to less experienced staff.
  • Analyzes business requirements, architects and writes technical specifications to design or redesign computer solutions..
  • Verifies program logic by overseeing the preparation of test data, testing and debugging of programs written using Informatica Power Center, SQL, PL/SQL or UNIX scripting
  • Participates in overall systems integration testing. Provides input and direction on scope of testing scripts. Maintains testing data for SIT and UAT environments.
  • Analyzes and troubleshoots various Informatica ETLs, and Oracle performance issues (for both batch processing as well as end-user interaction) in LARS.
  • Develops new documentation, participates in the development of department technical procedures and designs user guides.
  • Serves as an escalation point for application support and troubleshooting, provides guidance and direction to less experienced staff in resolution of escalated issues and/or complex production, application or system problems for front-end applications , downstream and upstream applications and others that are tied to the Liquidity AnalyticsReporting System.
  • Assures quality, security and compliance requirements are met for supported area and oversees updating and testing of the business continuation plan.

Ideal candidate will be an individual who takes ownership of a process and accountability for its day to day activities, is able to work independently or as part of a team, and seeks to work on a diverse range of programming languages.

Note: Preferred work location is Charlotte, NC.

Required Qualifications

  • 5+ years of application development and implementation experience
  • 5+ years of Oracle experience
  • 5+ years of Informatica experience
  • 6 + years of experience writing relational database queries for stored procedures, query optimization and performance tuning
  • 5+ years of UNIX experience
  • 5+ years of Perl or Shell experience
  • 1+ year of process definition and documentation experience

Desired Qualifications

  • Excellent verbal, written, and interpersonal communication skills
  • A BS/BA degree or higher in science or technology
  • Knowledge and understanding of Java
  • Strong organizational, multi-tasking, and prioritizing skills
  • Ability to identify and manage complex issues and negotiate solutions within a geographically dispersed organization

Other Desired Qualifications
  • 3+ years of Erwin experience to maintain data Models
  • Experience with Autosys, batch processing and scheduling tools.
  • Experience with Oracle HCM Cloud (SaaS).
  • Experience with integration of PeopleSoft and/or Oracle HCM Cloud.

Street Address

MN-Minneapolis: 550 South 4th St - Minneapolis, MN
NC-Charlotte: 8740 Research Dr - 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.



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:

Application Systems Engineer 4 -Informatica ETL Developer

Wells Fargo
Charlotte, NC

Share this job

Application Systems Engineer 4 -Informatica ETL Developer

Wells Fargo
Charlotte, NC

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