Sr. Informatica ETL/IDQ Developer

NY, NY 10017 | Contract

Post Date: 04/12/2018 Job ID: 9981 Industry: Technology

Informatica Data Quality (IDQ) Developer
  • Location: NYC
  • Status: 1+ year contract
  • Hourly Target Range: Open, dependent  upon experience
  • Remote Option: None

  • Work on end to end data quality and data governance initiatives utilizing Informatica Data Quality (IDQ) and PowerCenter implementing capabilities around Address validation, Contact Validation, Business Glossary, Data Stewardship, Data Quality and Data Lineage
  • Deploy address verification which includes transliteration, parsing, analysis, standardization and enrichment at point of entry and batch modes
  • Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules if applicable, then design and develop these rules with IDQ
  • Utilize “ Informatica Developer” and “ Informatica Analyst” to design and develop custom objects and rules, reference data tables and create/import/export mappings
  • As per business requirements perform thorough data profiling with multiple usage patterns, root cause analysis and data cleansing and develop scorecards utilizing Informatica, Excel and other data quality tools
  • Develop " matching" plans, help determine best matching algorithm, configure identity matching and analyze duplicates
  • Build profiles and scripts (Linux) to execute and test mappings and workflows to implement data stewardship and exception processing
  • Develop rules in Data Quality and Deploy in Power center as batch and web services
  • Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.) utilizing IDQ and PowerCenter
  • Serve as the primary resource to team members and data stewards for training, problem resolution, data profiling etc.
  • Analyze and provide data metrics to management in order to help prioritize areas for data quality improvement
  • Maintain excellent working relationship between internal (team and the whole organization) and external parties (vendors, customers)
  • Assist with special projects or ad-hoc reviews as needed

You need to have: 
  • Minimum 5 years of hands-on experience with Informatica Data Quality (IDQ) toolset  and proficiency in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling
  • Minimum 5 years of hands-on experience with Informatica PowerCenter, SQL, Linux
  • Experience implementing Informatica Address Doctor for global address verification
  • Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services
  • Excellent data analysis and data profiling skills using Informatica and Excel
  • Good understanding of data governance principals and strong experience on data quality development and issue management and remediation
  • Excellent communication and presentations skills and ability to lead meetings effectively
  • Ability to multi-task with strong attention to detail and analytical skills
  • Strong work ethic with a highly positive, hands-on, can-do attitude

Benefits include Medical and Dental Insurance, 401(k), Employee Service Center, Referral Bonuses, Loyalty and Longevity Bonuses, along with Hotel Engine Benefits.

Jorge Beltre

Fun Facts: Army Veteran, Roller Coaster Enthusiast, and Thrill Seeker (specifically sky diving)

If you feel like you are the right fit for the job above, please click the apply online button below and I will be sure to reach out ASAP!

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: