DL
Snowflake SSIS Developer
Diverse Lynx India
Location not stated
Mid level
2 months ago
- Snowflake
- SSIS
- ETL
- Microsoft SQL Server
- Excel
- triage
- SQL
- Git
- Azure DevOps
2 months ago
Role Summary
We are seeking an experienced SSIS Developer to design, build, and maintain ETL processes using Microsoft SQL Server Integration Services (SSIS). The role involves developing robust data pipelines, optimizing performance, ensuring data quality, and collaborating with cross-functional stakeholders to deliver reliable analytics and reporting solutions.
Key Responsibilities
• Design, develop, and deploy SSIS packages for data extraction, transformation, and loading (ETL).
• Build reusable components (connections, configurations, templates) and enforce naming conventions.
• Integrate data from diverse sources (SQL Server, flat files, Excel, APIs, cloud storage).
• Implement robust error handling, logging, checkpointing, and retry strategies.
• Schedule and monitor ETL jobs via SQL Server Agent; triage failures and remediate root causes.
• Optimize SSIS packages and underlying SQL (indexes, partitioning, query tuning) for performance and scalability.
• Collaborate with DBAs, Data Engineers, Analysts, and Product/Business teams to capture requirements and deliver solutions.
• Perform data profiling, validation, and reconciliation; document data flows and lineage.
• Maintain version control (e.g., Git/Azure DevOps), peer reviews, and release notes.
• Create and maintain technical documentation, SOPs, and operational runbooks.
Snowflake SSIS Developer · Diverse Lynx India