ETL DeveloperProject skills:Redesign an existing data warehouse ETL from SQL Server 2018 databases to a SQL Server 2018 data warehouse database using incremental loading. Develop and implement ETL design changes into customers production environment. Responsible for architecting an incremental ETL to be fast, accessible, usable, and well-designed with business goals in mind. Perform requirements analysis, data requirements documentation, ETL requirements specification, metadata documentation, and data quality support. Resolve any ETL performance issues, database capacity issues, and other distributed data issues.
Experience with multi-terabyte VLDBs, SSIS, BCP and other SQL Server data migration solutions a plus.