> Markdown version of [/jobs/ext/2001508-ssis-developer-etl-specialist](https://www.wearedevelopers.com/jobs/ext/2001508-ssis-developer-etl-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# SSIS Developer / ETL Specialist

- **Company:** ClinDCast LLC
- **Location:** Chicago, IL, United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Agile Methodology, Backup Devices, Big Data, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Mining, Data Warehousing, IBM DB2, Database Schema, Software Debugging, Multicasting, Oracle (Applications), Performance Tuning, Power BI, SQL Databases, SQL Server Reporting Services, SQL Server Agent, SQL Server Integration Services, Transact-SQL, Extensible Markup Language (XML), Data Logging, Data Processing, Parallel Computation, Star Schema
- **Published:** August 9, 2026
- **Apply:** https://www.wayup.com/i-j-SSIS-Developer-ETL-Specialist-ClinDCast-LLC-058615602896712/

## About the Role

3+ years of experience in SSIS development and ETL processes.
Strong knowledge of SQL Server, T-SQL, and database objects (procedures, functions, views).
Experience with SSIS performance tuning and troubleshooting.
Familiarity with data warehousing concepts (Star Schema, Fact/Dimension tables).
Exposure to Power BI and SSRS is a plus.
Excellent analytical and communication skills.
Preferred Skills
Knowledge of advanced SSIS components (CDC Splitter, DQS Cleansing, Fuzzy Grouping).
Experience in handling large datasets and optimizing ETL workflows.
Understanding of Agile methodologies.

## Description

The SSIS Developer will design, develop, and maintain ETL workflows using SQL Server Integration Services (SSIS) to support data integration, transformation, and loading processes for enterprise data solutions.
Key Responsibilities
ETL Development
Design and implement complex SSIS packages for data extraction, transformation, and loading (ETL) from multiple sources (DB2, Oracle, Flat Files, XML).
Utilize advanced SSIS transformations such as Conditional Split, Fuzzy Lookup, For Each Loop, MultiCast, and Script Components for data processing.
Implement error handling, logging, and checkpoints for robust package execution.
Performance Optimization
Tune SSIS packages and SQL queries for optimal performance.
Apply best practices for SSIS performance, including parallelization, lookup caching, and bulk loading techniques.
Integration & Scheduling
Schedule and monitor SSIS packages using SQL Server Agent.
Configure credentials, proxy accounts, and permissions for secure execution.
Testing & Troubleshooting
Perform debugging and troubleshooting of SSIS packages.
Conduct backend database testing and validate data integrity.
Collaboration
Work closely with BI teams to provide data for analytics and reporting.
Support Power BI and SSRS reporting requirements when needed.


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization)
- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Dev Digest 162: AI careers, MCP, AWS best practices & floppy sweaters](https://www.wearedevelopers.com/magazine/571-dev-digest-162-ai-careers-mcp-aws-best-practices-floppy-sweaters)
- [Dev Digest 132 - Binging WADFlix?](https://www.wearedevelopers.com/magazine/473-dev-digest-132-binging-wadflix)
- [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline)
- [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany)