Datawarehouse Desveloper

Description

Develop, maintain and support SQL Server Integration Services (SSIS) packages related to the extraction, transformation and loading (ETL) process using Microsoft SQL Server 2012 or laterFollow Agile practiceBe able to use Data Quality Services (DQS) to create a knowledgeDriven solution, which includes using DQS features and setup the Knowledge Base (rules) to resolve data quality issues, such as Data Cleansing, Matching, Reference Data Services, Profiling and Monitoring.Write TSQL queries, complex stored procedures and functions to perform database tasks such as inserts, updates and deletesResponsible for data profiling as well as SQL and database tuning / optimizationDevelop detailed technical specifications and ETL documentation in collaboration with data warehouse architect and Business Intelligence developersDesign ETL audit control and scheduling processesDevelop testing and implementation strategy, conduct appropriate functional and performance testing to identify and resolve process bottlenecks and data quality issueCollaborate with Business Intelligence Developers through dashboard and application development process for requirements gathering, feedback on proposed designs and models, and acceptance testing