SSIS, SQL Developer

TATA Consultancy Services Ltd

Bengaluru, Karnataka, India

Type: Full-Time Arrangement: On-Site
6 - 10 Yrs800000 - 1500000(Annually)

Posted: 31 Jul 2026

Job Description

Greetings from TCS! TCS is hiring for SSIS, SQL. Role: SSIS, SQL. Experience: 6 years to 10 years. Job Location: Bengaluru. Eligibility Criteria: Minimum 15 years of regular education (10th + 12th + 3 years graduation). BE/B.Tech/MCA/M.Sc/MS with minimum 3 years of relevant experience post qualification IT Experience. B.Sc/BCA Graduates with minimum 3.6 years of relevant experience post qualification IT Experience. Only Full Time courses would be considered. Experience required: 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.

Required Qualifications

  • 6+ years of SSIS development experience
  • Strong experience in data warehousing
  • Expert in Microsoft SQL Server
  • Strong T-SQL programming
  • Experience with SSRS and/or Power BI

Preferred Qualifications

  • Experience with performance tuning of ETL packages
  • Familiarity with Azure Data Factory
  • Knowledge of data modeling (Dimensional & OLAP)
  • Experience with version control tools (e.g., Git, Azure DevOps)

Skills Required

SSISSQL ServerT-SQLData WarehousingETL DesignSSRSPower BIAzure Data FactoryPerformance TuningData Modeling