Informatica dataquality Developer

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”, “Informatica Power Exchange”, “Informatica Metadata Manager”, 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

Build human task workflow scenarios and IDQ scorecards to support data remediation

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

Proficient at writing SQL queries and verifying the results

Should be familiar in migrating objects from IDQ to PowerCenter or other Informatica tools

Should be familiar in deploying and validating objects to different environments

Good at writing test scenarios, performing unit testing, 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

Write code for complex system designs. Write programs that span platforms. Code to and/or create Application Programming Interfaces (APIs)

Review code developed by other Developers and provide input to and drive programming standards

Consult with other Developers, Business Analysts, Systems Analysts and Project Managers

Support transition of application throughout the Product Development life cycle.

Document what has to be migrated.

Skills: Big Data, Data Processing, Data Warehousing, Hadoop, Map Reduce

See more: informatica data quality ppt, what is informatica data quality, informatica data quality tutorial, informatica data quality job description, informatica data quality training, informatica idq basics, informatica data quality pdf, informatica data quality developer resume, a php developer profile, it developer profile, personal web developer profile freelancer, iphone freelance developer profile, developer profile site, android developer profile, drupal developer profile

About the Employer:
( 0 reviews ) Guntur, India

Project ID: #15785612

6 freelancers are bidding on average ₹26666 for this job

₹27777 INR in 10 days
(0 Reviews)

I would like to know can I work on virtual machine provided by employer? I live in USA.

₹26666 INR in 15 days
(0 Reviews)

A proposal has not yet been provided

₹33333 INR in 20 days
(0 Reviews)

.. Relevant Skills and Experience I have been in IT industry for more than 6 years in mostly data warehousing and data migration projects with 5.5+years of development,support, debugging experience in ETL(informatica More

₹22222 INR in 10 days
(0 Reviews)

Over all 3.5 Years of extensive experience in design, development, implementation and maintenance of data integration projects using BizTalk,Informatica and Datastage. Strong ETL experience using Informatica PowerCente More

₹22222 INR in 5 days
(0 Reviews)

We provide the developer on tableau, informatica and cognos design dashboard, visualization and reporting. Relevant Skills and Experience Tableau, Informatica Proposed Milestones ₹27777 INR - Informatica project

₹27777 INR in 10 days
(0 Reviews)