ZipRecruiter

Log In

SSIS Developer

Purple Drive Technologies

Raleigh, NC • On-site

Full-time

Posted 19 days ago

Job description

Overview:
Microsoft SSIS / SQL ETL Developer
Job Description
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.
Key Responsibilities
1. Microsoft SSIS Development
  • 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.
2. SQL ETL Development
  • 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.
3. Data Integration & Management
  • 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.
4. Deployment, Scheduling & Monitoring
  • 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.
5. Collaboration & Documentation
  • 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).
Required Skills & Qualifications
  • 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.
Preferred Qualifications
  • 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.).

Apply

Most Popular Jobs Similar to Sql Ssis Developer

Frequently asked questions

Q: What skills or qualities help someone succeed as a SQL SSIS Developer?

A: To succeed as a SQL SSIS Developer, key technical skills include proficiency in SQL Server, SSIS (SQL Server Integration Services), and data modeling, as well as experience with data warehousing, ETL (Extract, Transform, Load) processes, and data quality management. Soft skills such as strong problem-solving abilities, effective communication, and collaboration with cross-functional teams are also crucial, as they enable developers to troubleshoot complex data issues and convey technical insights to stakeholders. By combining these technical and soft skills, SQL SSIS Developers can design, implement, and maintain efficient data integration solutions that drive business value and support data-driven decision-making.

Q: What is the career path for a SQL SSIS Developer?

A: A SQL SSIS Developer's career path typically begins as a Junior Developer, where they focus on designing, implementing, and maintaining ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS). As they gain experience, they progress to a Mid-Level Developer role, taking on more complex projects, mentoring junior team members, and contributing to the development of SSIS best practices. Ultimately, Senior Developers lead teams, architect large-scale SSIS solutions, and drive innovation in data integration and analytics, with opportunities to transition into leadership, data architecture, or business intelligence roles.

All JobsSQL SSIS Developer Jobs
Purple Drive Technologies job posting for a SSIS Developer in Raleigh, NC with a salary of $44 to $66 Hourly with a map of Raleigh location.