Logo
Spruce Infotech

SSIS Developer

Spruce Infotech, Plano, Texas, us, 75086


Job DescriptionWe are seeking a talented Data Developer to support enterprise data projects related to ETL development, production support, data triage, SQL development, and other related data initiatives.Requirements:•Work extensively with SSIS (SQL Server Integration Services)•Build SSIS pipelines for various data development projects•Build data transformations with SSIS, including importing data from files and moving data from one database platform to another.•Possess strong knowledge of relational databases, as well as skills in SQL query design and development.•Leverage best practices for error handling, error resolution, and archival processes.•Have strong knowledge of stored procedures and performance tuning, as well as skills in SQL query design and development.•Highly skilled and results oriented professional with a proven track record of designing and implementing efficient data pipelines, resulting in significant reductions in data processing time and improved accuracy.Experience:•8+ years of experience with primary responsibility in working with data, SQL Server database design, and full lifecycle of SSIS ETL development, deployment and Production support.•Experience with Azure Data Factory (ADF)•Experience in AWS Cloud•Experience with AWS Lake formation (S3)•Experience with Snowflake