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
Solid 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