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