SSIS SQL

Job description

**Greetings from TATA CONSULTANCY SERVICES!** **Skill: SSIS SQL** **Years of Experience: 6+ years** **Location: Bangalore** **Job Description:-** **Experience required:** - 6+ years of overall IT experience - 6+ years of hands-on SSIS development experience - Strong experience in data warehousing and ETL design patterns **Technical skills:** - Expert in Microsoft SQL Server and SSIS - Strong T-SQL programming and query optimization - Experience with SSRS and/or Power BI (preferred) - Knowledge of data modeling (Dimensional & OLAP) - Experience with performance tuning of ETL packages - Familiarity with Azure Data Factory or cloud ETL tools is a plus - Version control tools (e.g., Git, Azure DevOps) **Key responsibilities:** - Design, develop, and deploy SSIS packages for BIS BACH project - Analyze source systems and define ETL mappings - Ensure data quality, validation, and reconciliation processes - Optimize existing ETL workflows for performance and scalability - Troubleshoot ETL failures and production issues - Collaborate with business analysts, DBAs, and stakeholders - Document ETL processes and technical specifications