Data Quality Engineer
- Full-time
- Contract type: Permanent contract
Company Description
We are entrepreneurs in disruptive technology, at Devoteam, we deliver innovative technology consulting for business. Digital Transformakers, we are 7,000+ professionals across EMEA dedicated to ensuring our clients win their digital battle. We improve business performance making their companies truly digital. We advise our clients and build IT infrastructure for digital, making sure people are along for the ride.
Devoteam Middle East, we are the region's leading consulting firm delivering innovative Business & Technology Consulting & Solutions. Our 14 years of existence anchored in technologies that enables our clients business to flourish, accordingly our focus is to help our clients' win the digital battle, adapted to our clients’ business challenges, with a unique consideration to its impact on their systems and structures.
To know more about us, please visit: www.devoteam.com
Job Description
- 3+ years experience in data quality and master data management and meta data.
- Profile source data and determine all source data and metadata characteristics
- Design and execute a Data Quality Audit/Assessment and mappings that will cleanse.
- Prepare the project data 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, mapplets, 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.
- Design and develop these rules with IDQ Utilize “Informatica Developer” and “Informatica Analyst” to design and develop custom objects and rules, reference data tables and create/import/export mappings 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 and 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 on 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 in deploying and validating objects to different environments
- Good at writing Test scenario and perform 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
Additional Information
Certifications
Informatica Data Quality