Informatica Developer

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.

About Enterprise Information Technology (EIT)
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.

The Corporate Finance Technology group within Enterprise Information Technology (EIT) is seeking an Software Engineer who will be responsible for development and support of Oracle-based applications using PL/SQL, OFSAAi and data warehouse functionality needed to deliver the best possible solutions to our business partners.

Responsibilities include:

• Provides technical consultation and support in the development of computer applications within Oracle Datamart.
• Analyzes business requirements, architects and writes technical specifications to design or redesign computer solutions.
• Strong experience using Informatica Powercenter tools.
• Develops Informatica workflows to support data load,transformations.
• Develops solutions or provides technical guidance to less experienced staff.
• Verifies program logic by overseeing the preparation of test data, testing and debugging of programs written using 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 Oracle performance issues (for both batch processing as well as end-user interaction) in the datamart.
• Performs the migration of applications to production according to the SDLC model.
• Develops documentation, participates in the development of department technical procedures, and designs user guides.
• Acts as an escalation point for application support and troubleshooting of issues and/or production, application, or system problems for various front-end applications, downstream and upstream applications, and others.
• 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.

• 2+ years of Perl or Shell experience
• 4+ years of UNIX experience
• 5+ years of ETL (Extract, Transform, Load) Programming experience
• 5+ years of Informatica experience
• 3 + years of experience writing relational database queries for stored procedures, query optimization and performance tuning
• 5+ years of PL/SQL experience
• 5+ years of software engineering experience

• A BS/BA degree or higher in information technology
• Banking industry experience
• Ability to work effectively, as well as independently, in a team environment
• Good data analytical and validation skills
• Experience communicating with business partners and project managers
• Knowledge and understanding of accounting principles and policies
• Strong verbal, written, and interpersonal communication skills
• An industry-standard technology certification

• Understanding of batch processing and scheduling tools
• Understanding of SPARC related technologies
• Familiarity with Oracle GL business suite and its processing

NC-Charlotte: 1525 W Wt Harris Blvd - Charlotte, NC
NJ-Summit: 190 River Rd - Summit, NJ

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.

Benefits
 

Visit https://www.wellsfargo.com/about/careers/benefits for benefits information.