Wells Fargo

Receive alerts when this company posts new jobs.

Similar Jobs

Job Details

Informatica Data Quality (IDQ) Developer

at Wells Fargo

Posted: 8/9/2019
Job Reference #: 12550870
Keywords: technical

Job Description

Job Description

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.

* The Informatica Data Quality Developer (IDQ Developer) is responsible for designing, developing, and deploying data quality procedures and its outputs
* The Developer will leverage IDQ for the profiling of project source data coming into the Global Data Mastering Platform
* He/she will use IDQ for defining and confirming metadata definition, cleansing and validating source of record(s) data, applying deduplication rules and readying the data for consumption by downstream systems.
* The IDQ Developer will also document at a functional level how the procedures work within the data quality applications.  This resource will participate in IDQ development efforts, validate work results, provide knowledge sharing and serve as a technical resource for other Developers

* Leverage profiling methods to properly identify data irregularities and inaccuracies
* Create and execute the data quality mappings that will cleanse, de-duplicate, and otherwise prepare the project data
* Implement data quality processes leveraging the Address Verification engine capabilities; including transliteration, parsing, standardization and enrichment for both batch and single request modes
* Deploy mappings that will run in a scheduled, batch, or real-time environment.
* Work with Business Analysts in documenting all mappings, mapplets, and rules in detail and make documentation available to the project team
* Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules where needed
* Convert profiles into mappings
* Utilize Informatica Developer , Informatica PowerCenter, Informatica Metadata Manager, and Informatica Analyst to design and develop custom objects and rules
* Translate business rules into code and develop them in IDQ
* Design matching plans, assist in defining best matching algorithm, configuring identity matching and analyzing duplicates
* Develop profiles and scripts for the execution and testing of mappings and workflows to implement data stewardship and exception processing
* Create human task workflow scenarios and IDQ scorecards to support data remediation
* Migrate objects from IDQ to PowerCenter or other Informatica component
* Proficient at writing SQL queries and verifying the results
* Knowledge of Agile methodology a plus

Required Qualifications

  • 7+ years of application development and implementation experience
  • 3+ years of ETL (Extract, Transform, Load) Programming experience
  • 4+ years of Informatica experience
  • 3+ years experience with Informatica Data Quality (IDQ) development

Desired Qualifications

  • Good verbal, written, and interpersonal communication skills
  • 2+ years of PL/SQL experience
  • 3+ years of Oracle experience

Other Desired Qualifications

* Excellent communication skills both oral and written
* Process-oriented and experience with SDLC methodologies and phases


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.

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!