Responsibilities includes:
- 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.
- Migrate On-prim IDQ to CDQ in data quality migration projects.
- 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, applets, 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.
- 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.
- 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 of writing shell-scripts to invoke mappings or workflows.
- Good at writing SQL queries and verifying the results.
- Should be familiar in migrating object from IDQ to PowerCenter
- Should be familiar with deploying and validating objects to different environments.
- Good at writing Test scenarios and performing Unit Test 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.
About Kanerika Software
Kanerika has been delivering results since we opened in 2015. Our goal is to provide both a superior customer experience and tremendous value for our customers. With over 75 years of collective experience in Software Product Development and is passionate about exceeding expectations of our clients. Our passion is developing path-breaking software products. We love challenges. We are a small team that always ensures the job is done right. It is all about : Partnership, Experience and Creativity.
Similar jobs
Key Responsibilities:
· Solution Design: Collaborate with clients to understand their business requirements and design comprehensive Informatica MDM solutions tailored to their needs.
· Implementation: Lead the implementation of Informatica MDM solutions, including configuration, customization, and integration with existing systems.
· Data Modelling: Design and implement data models to support MDM initiatives, ensuring data integrity, accuracy, and consistency across systems.
· Data Quality Management: Implement Informatica Data Quality (IDQ) processes and workflows to improve data quality and ensure compliance with organizational standards.
· Integration: Integrate Informatica MDM solutions with other enterprise systems, such as CRM, ERP, and BI platforms, to facilitate seamless data exchange and interoperability.
· Customization: Develop custom components, workflows, and extensions to extend the functionality of Informatica MDM and meet specific business requirements.
· Data Governance: Establish data governance policies, standards, and best practices to govern the use, management, and quality of master data within the organization.
· Documentation: Prepare comprehensive documentation, including solution designs, technical specifications, user guides, and training materials, to support the implementation and maintenance of Informatica MDM solutions.
· Testing and Quality Assurance: Conduct thorough testing and quality assurance activities to ensure the reliability, scalability, and performance of Informatica MDM solutions.
· Training and Support: Provide training and support to end-users, administrators, and stakeholders to ensure successful adoption and utilization of Informatica MDM solutions.
What you’ll bring
- Bachelor's degree in Computer Science, Information Systems, or related field; Master's degree preferred.
- Minimum of 4 years of experience in implementing and configuring Informatica MDM solutions.
- Proficiency in Informatica MDM Hub, Informatica Data Director, Informatica Data Quality (IDQ), and related Informatica tools and technologies.
- Strong understanding of data modelling principles, data integration concepts, and master data management best practices.
- Hands-on experience with data profiling, cleansing, and transformation using Informatica IDQ.
- Experience with data governance frameworks, data stewardship workflows, and data quality metrics.
- Excellent communication skills and the ability to effectively collaborate with cross-functional teams and stakeholders.
- Proven ability to work independently, manage multiple priorities, and deliver high-quality results within tight deadlines.
- Informatica certification(s) in MDM and/or IDQ is a plus.