drjobs
Senior IDQ Developer
drjobs
Senior IDQ Developer
Sysmind LLC
drjobs Senior IDQ Developer العربية

Senior IDQ Developer

Employer Active

1 Vacancy
The job posting is outdated and position may be filled
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs

Job Location

drjobs

others - USA

Monthly Salary

drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Req ID : 1754803

Senior IDQ Developer "Informatica"

Remote to Start

TCS

JD

  • 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.
  • Strong SQL Commands
  • Experience with at least one end to end Master Data Management implementation is required
  • 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
  • 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 complex profiles and scripts to execute and test mappings and workflows to implement data stewardship and exception processing
  • Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.) utilizing IDQ and other ETL tools
  • 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
  • Participate in improvement of master data management process and support transactional systems and processes
  • 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 Power Center.
  • 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
  • Perform both record-level and large-scale manual additions, adjustments and corrections to continuously ensure overall data quality and integrity
  • 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"

Employment Type

Full Time

Company Industry

About Company

100 employees
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.