The role involves conducting data analysis and profiling using Informatica Data Quality (IDQ) to assess data structure, quality, and integrity. Responsibilities include collaborating with business stakeholders and data migration managers to understand data requirements, developing data quality rules and standards, and creating and maintaining source-to-target mappings. The position also requires executing data cleansing rules, troubleshooting, and maintaining data quality workflows. Additionally, the role involves developing test plans, performing data validation, and addressing data quality issues. Continuous monitoring of data quality metrics and effective communication of status reports are essential for ensuring successful data migration and optimization.
General Profiling & Business Requirement Design :
Conduct data analysis and profiling using Informatica Data Quality (IDQ) tool to understand the structure, quality, and integrity of the data.
Collaborate with the data migration manager with project planning and status reporting on data profiling and cleansing activities. Overall adhere to the AX data clean up ways of working.
Collaborate with business stakeholders and data owners to interpret profiling results and understand data requirements and objectives.
Develop data quality rules & standards based on business requirements and industry best practices.
Document data quality processes, rules and standards for future reference and training purposes. Create and maintain source to target mappings.
Create DQ scorecard and reports to track and monitor data quality metrics over time.
Create & Executing Data Cleansing Rules :
Develop and maintain quality mappings, DQ rules, and workflow within informatica data quality environment.
Perform data profiling, cleansing, standardization, and matching using Informatica data quality transformations and functionalities.
Troubleshoot & resolve issues related to the tool.
Collaborate with Informatica SME to implement automated data quality checks and validations within data pipelines and workflows.
Testing :
Develop and execute test plans and test cases to validate effectiveness of data quality rules and cleansing processes.
Conduct data validation and verification activities to ensure data quality improvements meet requirements.
Identify and address data quality issues and anomalies through root cause analysis andtroubleshooting.
Prepare and present test results including defects and resolution status.
Rollout :
Monitor data quality metrics and trends to identify areas for improvement and optimization.
Prepare weekly status reports on data quality activities status, continuously communicate with the data migration manager arising risks, issues, and contingency plan.
Work with the Informatica SME for troubleshooting technical issues related to using informatica data quality effectively for data profiling and cleansing purposes.
Informatica Data Quality (IDQ), Data Profiling, Data Cleansing, Data Standardization, Data Quality Rules Development, Data Validation & Testing, Workflow Management, Root Cause Analysis, Data Quality Scorecards & Reporting.