Proficient in Microsoft SQL Server Databases and any of Teradata, Oracle, DB2, MySQL and Mongo DB.
Experience maintaining SharePoint sites. (Maintain team sites, SharePoint Workflow, Lists etc)
Hands On MS Master Data Services, MS Data Quality, MS Reporting Services, Sql Server Integration Services, Sql Server Analysis Services, Team Foundation Server.
Experience with Abstract ETL tools such as Ab-Initio.
IT Asset Management concepts or direct industry experience in an IT Asset Management team / function.
Experience with Dan Linstedts Data Vault Concept..
Define Implement and Maintain a Data Quality Workflow to manage reactive data issues and other incidents.
Define mechanism to report of the State of Data Quality for our Downstream and Upstream partners, Data Governance & Sr Leadership team.
Define and Implement a Knowledge Base to document solutions for commonly occurring data quality issues.
Review processes and recommend solutions to maximize operational efficiencies across the ITAM ODS.
Become knowledgeable across all data sources and integration logic.
Subject Matter Expert in specific data sources or integration subject areas. Understanding what that data set tells us about business processes and state of the infrastructure.
Perform detailed and complex analysis to perform insight into data issues across multiple data sources. Identify trends across data issues to identify root case and affect change upstream.
Profile data with a view to ensuring accuracy and completeness & identify inconsistencies.
Identifying and documenting existing data quality issues like key duplication and inconsistencies and partner with the operations team and or source systems to remediate.
Support the Daily batch process. (Addressing failures and escalating as appropriate.