SSIS Developer

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.).