Microsoft SSIS / SQL ETL Developer
We are seeking an experienced Microsoft SSIS & SQL ETL Developer responsible for designing, developing, and maintaining enterprise ETL workflows. The ideal candidate will have strong hands-on experience with Microsoft SQL Server , SSIS , and end-to-end ETL pipeline development , ensuring high-quality data integration and processing across systems.
Design, develop, and maintain ETL solutions using Microsoft SSIS .
Create complex data workflows using Control Flow, Data Flow, Script Tasks, Parameters, and Expressions.
Develop reusable SSIS templates and components to standardize ETL processes.
Build and automate incremental and full-load data pipelines.
Develop SQL-based ETL processes using stored procedures, functions, views, and T-SQL scripts.
Optimize SQL ETL workflows for large datasets and high-performance execution.
Implement data transformations, validations, cleansing, and business rules within SQL and SSIS.
Work with relational databases, staging layers, and data warehouse structures.
Integrate data from SQL Server, flat files, APIs, Excel, XML/JSON, and cloud-based sources.
Ensure data integrity, quality, and accuracy across all ETL pipelines.
Conduct data profiling, validation, and reconciliation between systems.
Deploy SSIS packages to different environments and schedule jobs via SQL Server Agent .
Monitor ETL executions and troubleshoot failures, data issues, or performance bottlenecks.
Implement logging, auditing, and error-handling frameworks for reliable ETL solutions.
Work with data analysts, developers, and business stakeholders to gather and understand mapping requirements.
Translate business rules into technical ETL specifications.
Document ETL workflows, mapping documents, data lineage, and operational procedures.
Participate in code reviews and follow version-control best practices (Git/DevOps).
3-8+ years of hands-on experience with Microsoft SSIS and SQL Server ETL development .
Advanced T-SQL programming skills (queries, joins, indexing, performance tuning).
Strong understanding of ETL architecture, data flow optimization, and best practices.
Experience working with data warehouses, star/snowflake schemas, and dimensional modeling.
Ability to handle large datasets and optimize ETL performance.
Strong analytical, debugging, and problem-solving skills.
Experience with the Microsoft BI stack (SSRS, SSAS).
Exposure to Azure SQL , Azure Data Factory (ADF) , or cloud-based ETL solutions.
Knowledge of CI/CD pipelines for database/ETL deployments.
Experience in domain-specific data pipelines (banking/financial, retail, healthcare, etc.).
...Job Description Job Description We are currently looking for a skilled CNC Machine Operator for our premier client in Winona on 2nd shift! This company provides amazing solutions to some very BIG projects all over the world. Do you want to be a part of something...
...Construction Management Intern - Estero, FL (June 2026) ID 2025-9616 Job... ...with vertical service lines that include real estate capital investment, design, self-perform... ...aviation, government, mission critical and commercial. Suffolk is privately held and is led by...
...without commission!) Flexible working hours and location: work when and where you want (online or on-site) To become part of our tutoring team, it is not necessary to submit your resume. We are looking forward to meeting you! About us: Nachhilfeunterricht is one...
...Gutter Lead Installer Join a High-Performance Team at James & Whitney Co.! Ready to take the lead and build something great? James & Whitney Co. is growing fast, and were looking for a skilled, motivated Gutter Lead Installer to join our top-tier production team...
...Week: 20 Schedule Details/Additional Information: Infusion/Team RN position at Aurora Cancer Care Germantown South. This will be... ...Friday. Pay Range $34.90 - $52.35 Utilizing the nursing process, provides ongoing care according to the age specific...