Informatica (Certified CDQ/IDQ) Data Consultant
Ontario, Canada
12+ Months Contract
Job Description:
Experience:
Minimum of 8 years of hands-on experience with Informatica Cloud Data Quality (CDQ)/ Informatica Data Quality toolset (version 9.7 or higher, preferably 10.x). Experience with Informatica PowerCenter is a plus.
Certifications:
Informatica certification in CDQ/IDQ or related tools is highly desirable.
Technical Skills:
- Proficiency in CDQ/IDQ development, including data profiling, cleansing, parsing, standardization, verification, matching, and exception monitoring.
- Perform thorough data profiling to identify data quality issues, usage patterns, and metadata characteristics using Informatica CDQ/IDQ, Excel, and other tools. Conduct root cause analysis to address data anomalies.
- Design and implement data quality mappings, rules, and workflows for cleansing, standardization, parsing, validation, and de-duplication using CDQ/IDQ transformations (e.g., Parser, Address Validator, Match, Key Generator).
- Develop and execute ETL jobs for address standardization, email cleanup, name parsing, and other data quality tasks. Integrate CDQ/IDQ processes with Informatica PowerCenter and other ETL tools as needed.
- Create matching plans, configure identity matching algorithms, and analyze duplicates to ensure data consistency and accuracy.
- Strong knowledge of ETL processes, data integration, and transformations (e.g., Address Validator, Parser, Match).
- Expertise in SQL and database management systems (e.g., Oracle, MySQL, SQL Server)
- Expertise in SQL and database management systems (e.g., Oracle, MySQL, SQL Server).
- MDM concepts with respective to CDQ/IDQ.
Analytical Skills:
Excellent data analysis and profiling skills, with the ability to identify trends, patterns, and anomalies in complex data sets.
Communication Skills:
Strong verbal and written communication skills to collaborate with stakeholders and present data quality metrics to management.
Other:
- Knowledge of data governance, MDM concepts with respective to CDQ/IDQ, and agile methodologies.
- Experience with cloud environments or modern data stacks (e.g., Snowflake, Azure) is a Plus.
Job Type: Fixed term contract
Contract length: 12 months
Pay: $50.00-$55.00 per hour
Expected hours: 40 per week
Schedule:
- 8 hour shift
- Day shift
- Monday to Friday
Work Location: In person