Database Analyst 5 - Informatica Database Analyst

Wells Fargo   •  

Saint Louis, MO

8 - 10 years

Posted 246 days ago

This job is no longer available.


Job Description

At Wells Fargo, we have one goal: to satisfy our customers’ financial needs and help them achieve their dreams. 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. 

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.

Data Services and Operations Management (DSOM) team, an arm of Wealth Investment Management Technology (WIMT) group is looking for a database and solutions analyst with a strong experience in Informatica ETL development, product configuration and administration, and many other platform activities in large and complex Informatica, Oracle and DB2 environments. Candidate should have the ability to provide the highest technical expertise for the planning, analysis, design, implementation, maintenance, and control of complex database and Informatica environments. Candidate should have strong experience in making recommendations on scalable and repeatable processes and implement tools/technology to proactively monitor the overall Platform health.

Responsibilities include:

  • Maintenance and administration of Informatica across WIMT group in 24/7 production environments.
  • Provides consultation on the use of re-engineering techniques to improve process performance and data quality
  • Provides production support for technical issues and initiatives related to applications, systems, databases and reporting
  • Troubleshoots and resolve issues and restores services or data impacted
  • Evaluates service level agreement criteria; identifies gaps in current technology processes and recommends changes to assure OLAs/SLAs can be supported.
  • Provide technical expertise in identifying issues that impact the environment and service delivery
  • Organize issues and prioritize in a fast paced environment with hard deadlines
  • Drive multiple complex production issues simultaneously using a wide range of skills
  • Interact effectively with a variety of internal and external partners including distributed Systems, infrastructure, architecture, and software vendors
  • Partner with business and other technology teams on issue identification and resolution, problem solving, and planning
  • Assesses changes for risk to production systems and assures quality, security and compliance requirements are met for supported areas via accepted change control processes
  • Assist with the creation, maintenance, and testing of the business continuation plan

Note: You may be required to work outside of normal working hours to implement scheduled change controls and help resolve production issues in 24x7 environment.

Required Qualifications

  • 3+ years of Informatica experience
  • 7+ years of application production support experience
  • 7+ years of database design and administration experience

Desired Qualifications

  • Ability to make timely and independent judgment decisions while working in a fast-paced and results-driven environment
  • Ability to prioritize work, meet deadlines, achieve goals, and work under pressure in a dynamic and complex environment
  • Strong analytical skills and ability to solve complex technical problems
  • Excellent verbal, written, and interpersonal communication skills
  • Strong analytical skills with high attention to detail and accuracy

Other Desired Qualifications

  • 7+ years of experience with production support and operations of large scale data environments
  • Experience in configuration and administration of Informatica products including Power Center, Metadata Manager, DVO, Message Queues, and Informatica Data Quality (IDQ)
  • Strong skills in all data related subjects like data modelling, SQL, Data Analysis, Database space management, Data Masking, Database Monitoring, Data virtualization
  • Should have thorough understanding of batch job processing, job automation tools like Autosys and be able to provide batch job improvement solutions
  • Experience in Informatica products upgrades/patches in a multi-node environment
  • Experience working with and guiding offshore teams
  • Good understanding of project/support processes/procedures (EACO, PAC2000, JIRA)
  • Experience with version control tools and deployment tools such as Jenkins, Artifactory, and uDeploy
  • Experience with integrating multiple environments into a single HUB is a huge plus
  • Experience with Tech Refresh projects
  • Knowledge and understanding of data governance challenges and approaches: metadata, data quality, and data stewardship
  • Intermediate Microsoft Office skills
  • Knowledge of Financial institution's wealth, trust and brokerage
  • Knowledge of BI tools
  • Superior critical thinking skills, fast learner and ability to take on new challenges as needed
  • Experience with Risk and Regulatory efforts like remediating software vulnerabilities and certificates
  • Experience with implementing Informatica High Availability (HA) Grid
  • Experience with Data Transmission methods like NDM
  • Informatica certification preferred