What are the responsibilities and job description for the Senior SQL & SSIS Developer Minneapolis - MN - Minnesota position at Sierra Business Solution LLC?
Job Details
Job Description:
>> Design, build, and optimize high-performance data pipelines and ETL solutions across enterprise data platforms
>> Own complex SQL development, SSIS orchestration, performance tuning, and production support
>> Integrate on-prem SQL ServerSSIS with cloud services and some level of AWS Lambda knowledge for event-driven processing and lightweight transformations
Requirements:
>> Hands-on experience in SQL and SSIS development
>> Experience integrating on-prem SQL ServerSSIS with cloud services
>> Knowledge of AWS Lambda for event-driven processing and lightweight transformations
>> Ability to design, develop, and maintain SSIS packages for ETL processes
>> Proficiency in optimizing SQL objects for high-performance data operations
>> Experience in migrating and consolidating data from multiple sources into SQL Server
>> Strong understanding of parameterized, reusable ETL frameworks and metadata-driven pipelines
>> Ability to diagnose and tune query performance using execution plans, indexing, and partitioning strategies
>> Experience in implementing data quality checks, reconciliation processes, and audit trails
>> Knowledge of security controls for sensitive data such as encryption, secrets management, and PII handling
Salary : $60