SSIS SQL

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