Senior Informatica Data Quality (IDQ) Developer

  • Salary

    $120,000 - $130,000 Per Year

Experience

8 to 12 Years

Posted On

Dec 02, 2022

Company

Techvilla Solutions

Travel Requirements

0%

Job Overview

Required Skills

  • Data Quality
  • IDQ 
  • Informatica
  • ETL
  • SQL
  • UNIX
  • PowerCenter

Job Type

Full-time

Work Authorization

N/A

Location

New York, NY(Remote)

Job Description

Key Responsibilities 

  • Informatica developer with below responsibilities: 
  • Profile source data and determine all source data and metadata characteristics 
  • Design and execute a Data Quality Audit/Assessment 
  • Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise prepare the project data 
  • Implement data quality processes including transliteration, parsing, analysis, standardization and enrichment at point of entry and batch modes; Deploy mappings that will run in a scheduled, batch, or real-time environment. 
  • Document all mappings, mapplets, and rules in detail and hand over documentation to the customer 
  • 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 

 

Key Skills / Knowledge:

  • Advanced Informatica design and development skills using Informatica Data Quality ( IDQ)  (6+ preferred)  
  • Experience in developing Informatica Data Quality ( IDQ)  ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager  
  • Experience using parameter files, parameters/variables and troubleshooting using advanced informatica techniques like session partitioning, push down optimization etc
  • Verry strong Hands-on experience in IDQ for the last 5 years- can guide the junior resources and customer team for any resolution and roadmap guidance in IDQ  
  • Strong SQL Commands 
  • Knowledge in UNIX commands 
  • Good knowledge on writing shell-scripts to invoke mappings or workflows 
  • Good at writing SQL queries and verifying the results 
  • Should be familiar in migrating object from IDQ to PowerCenter 
  • Should be familiar in deploying and validating objects to different environments 
  • Good at writing Test scenario and perform Unit Test and verifying the end results with business requirements 

Job ID: TVS00130

  • Posted By

    James William

Designation

Sr. HR

Company

Techvilla Solutions

Last Login

Feb 23, 2024

Posted On

Dec 02, 2022


Related Jobs