SSIS Developer -Production support

Key Responsibilities

• Develop, deploy, and maintain SSIS packages for ETL processes
• Support and maintain existing production SSIS/DTS packages and workflows
• Write and optimize complex T-SQL queries, stored procedures, and scripts
• Develop and maintain Windows batch jobs for scheduled data processing
• Provide production support for SSIS and SQL Server-based applications
• Perform SQL Server performance tuning and optimization
• Work on SQL Server Replication and Mirroring for data availability and consistency
• Manage and resolve production issues within defined SLA timelines
• Work with TFS (Team Foundation Server) for version control and deployment activities
• Collaborate with business and technical teams for requirement analysis and delivery