SSIS/ETL Developer

Description

SSIS/ETL Developer to be part of a team developing an enterprise level data warehouse from scratch. The ideal candidate is expected to have strong SQL Server SSIS and TSQL skills working in a Data Warehouse environment and using SQL Server 2005, knowledge of 2018 is considered a strong plus. A working knowledge of SQL & SSAS is also required. Responsibilities Assist with the development of logical and physical ETL packages Lead in data acquisition and access analysis and design; and archive, recovery, and load strategy design and implementation. Participate in test plan creation and the testing process. Implement an ETL solution that meets the corporate and production operations best practices. Accurately estimate the size of the development effort as measured. Provide complete documentation in the form of commented code, problem status information, and design documents. Special Knowledge/Skills Required Strong background in ETL design and dimensional data warehouse design Strong background in logical/physical data model both OLTP and OLAP Familiarity with ETL and Database best practices Familiarity with Performance optimization techniques Ability to tune ETL packages and database performance for both OLTP and OLAP. Indexing, query planning as part of data extraction Understanding of MDM concepts, Metadata and Data Quality. Data cleansing, Data Standardization Technical Skills Required