| Job ID: | Job-0657 | | Job Title: | IDQ Architect | | location: | Wilmington, DE | | Jobtype: | Permanent | | Description: | 1. Establish DQ standard, guidelines and best practices
2. Establish Data Profiling guide lines and best practices.
3. Establish best practices on Process Sequence, Dictionaries, DQ Lifecycles, Naming Convention, Version Control
4. Matching Component Selection Guidelines
5. Data Profiling
· Column Profiling(Base Column, Sub Level Colum ..etc)
· Cross Join Profiling(profiling on joined tables, Integrity Profiling..etc)
· Comparative Profiling pattern
· Profiling summary reports for evaluation.
· Creating Quick Profiles
· Creating Custom Profiles, Run the Profile, Drill Down on Profile Results
· Create a Scorecard from the Profile Results
6. Derived Quality Index pattern
7. Score Carding design & design patterns, Develop confidence factor scoring system, Run the Scorecard, Edit the Scorecard, Configure Thresholds
8. Creating Expression Rules, Creating and Running Scorecards
9. Profiling Report (General profiling report setup and design)
10. Medium to complex quality rule and index design, development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception, notification and reporting with ETL, ELT and Real-Time consideration.
11. Establish Data Quality Requirement Process
12. Build DQ lifecycle management process and governance
13. Establish general DQ requirement templates and examples
14. Deployment and implementation DQ Design patterns for applications.
15. Data transfer/transform quality (eg. Control total, CRC, )
16. Column/attribute profiling and enrichment(cleanse, standardization, parse, ref. data,..)
17. Referential and Integrity check , Match and Duplication detection, Trend recognition
18. DQ rules and metrics (eg. threshold, weighing, scoring, rejection)
19. DQ reports.
20. Export Data Quality Transformation from Data Analyst Tool
21. Import it into PowerCenter as “Mapplet”
22. Develop Webservice for the DQ component.
23. Informatica Analyst tool
· Basic Score Card
· Trend Chart Detail
· Data Quality Index
· Data Quality Rule category, Taxonomy and methods.
· Data Quality Efficiency
24. Standardizing Data
25. Working with Data quality Transformations, Case Converter Data quality Transformation, Match Data quality Transformation, Find Character Patterns in Data and Standardize Data with Reference Tables Email resume in Word to TheBigGameHunter@cisny.com. Please include the job code for the position with your resume. PAID RELOCATION (or fly in / fly out available). VISA TRANSFERS. NO OVERSEAS RESUMES. NO 3RD PARTIES. To receive a complimentary subscription to my job search ezine, No B.S. Job Search Advice, go to www.JeffAltman.com to subscribe. Receive tweets from Twitter with job search tips and job listings – TheBigGameHuntr | |
<< Home