Senior IDQ Developer
Vacancy expired!
The candidate will be required to work closely with the various teams to perform data analysis, and develop reports and dashboards & application. The candidate must have strong design and analysis skills to ensure the deliverables are comprehensive and intuitive. The candidate must have excellent written and oral communication skills and experience as a client facing representative. Additionally, the candidate must understand the Software Development Lifecycle and the process necessary to perform effective change management. The candidate must have expert skills in all areas related to data quality and the surrounding development of metrics, scorecards, data quality rules to improve the overall quality of data in our Financial ecosystem.
- Implement processes which conform to DQ standard, guidelines and best practices;
- Develop Data Profiles leveraging industry guidelines and best practices;
- Adhere to standard by developing Business glossaries, Data Dictionaries, documenting DQ Lifecycles, and workflow management;
- Matching Component Selection Guidelines;
- Must be both hands-on as well as have the ability to define and explain complex concepts and solution/design to technical and business audiences;
- Design, Develop and implement data profiles in various manner as outlined below:
- Column Profiling (Base Column, Sub Level Colum etc)
- Cross Join Profiling (profiling on joined tables, Integrity Profilingetc)
- Comparative Profiling pattern
- Profiling summary reports for evaluation.
- Creating Quick Profiles
- Creating Custom Profiles, Run the Profile, Drill Down on Profile Results
- Experience in a regulated Financial institution;
- Experience using the IDQ (Informatica Data Quality) suite for development and reporting;
- Knowledge of Informatica components required to operate Data Quality (PowerCenter experience required);
- Deep knowledge of data quality processes, approaches, measurement techniques, and business cases including Profiling, cleansing, standardization and Match/Merge;
- Demonstrated experience implementing Informatica’s Data Quality components (rules, glossaries, scorecards);
- Experienced in integrating data quality transformations across architectures where it is called from one or more production applications to perform DQ services and return back and/or display results;
- Excellent inter-personal and written and verbal communication skills;
- Strong SQL skills using DB2, Oracle databases, Microsoft SQL Server databases;
- Experience in designing Informatica power center mappings, workflows and reusable mapplets;
- Experience with requirements gathering – working with clients to determine analytical needs, and carrying those needs through the development of data-driven tools to facilitate the requirements;
- Experience with predictive and prescriptive data analytics, to include regression analysis and simulation;
- Expertise in designing, building and representing complex databases and data modeling;
- Expertise in the research, development, and support of data visualization techniques;