SSIS SQL Developer

Tata Consultancy Services; Bengaluru; On-site; INR 1,100,000 - 2,000,000; Full time

Job summary

Tata Consultancy Services in Bengaluru seeks an experienced SSIS/ETL engineer to design scalable data integration solutions, translating business requirements into reliable data flows for analytics.

You will develop SSIS packages, write efficient T-SQL, create star and snowflake data warehouse models, and manage deployments via CI/CD pipelines in Azure.

Strong analytical skills, attention to data quality, and collaboration with cross-functional teams are essential.

Qualifications

• Strong expertise in SSIS and SQL Server.
• Proficiency in T-SQL, stored procedures, and query optimization.
• Solid understanding of ETL concepts and data warehousing principles.
• Experience with performance tuning and data quality checks.
• Familiarity with version control and deployment processes for SSIS.
• Knowledge of cloud platforms (Azure) is a plus.

Responsibilities

• Design ETL workflows and SSIS package to meet business requirements.
• Create scalable and maintainable data integration solutions aligned with best practices.
• Design data warehouse schemas (star and snowflake models) and dimensional models for reporting and analytics.
• Design, develop, and optimize SQL/T-SQL components, ETL processes using SSIS to extract, transform, and load data from multiple sources into staging and data warehouse environments.
• Build data transformations, including importing data from files and migrating data between platforms.
• Prepare and execute test plans for ETL processes.
• Deploy SSIS packages to production and non-production environments using CI/CD pipelines.
• Monitor ETL jobs, troubleshoot failures, and resolve performance issues.

Skills

SSIS

SQL Server

T-SQL

Stored Procedures

Query Optimization

ETL Concepts

Data Warehousing

Performance Tuning

Data Quality Checks

Version Control

CI/CD Pipelines

Azure Cloud

Job description

Desired Competencies (Technical/Behavioral Competency)

Must-Have

• Strong expertise in Microsoft SSIS and SQL Server.
• Proficiency in T‑SQL, stored procedures, and query optimization.
• Solid understanding of ETL concepts and data warehousing principles.
• Experience with performance tuning and data quality checks.
• Familiarity with version control and deployment processes for SSIS packages using CI/CD pipelines.
• Knowledge of cloud platforms (Azure) is a plus.

SN

Responsibility of / Expectations from the Role

1

Design & Architecture:

Design ETL workflows and SSIS package to meet business requirements.

Create scalable and maintainable data integration solutions aligned with best practices.

Design data warehouse schemas (star and snowflake models) and dimensional models for reporting and analytics.

ETL Development:

Design, develop, and optimize SQL/T‑SQL components, ETL processes using SSIS to extract, transform, and load data from multiple sources into staging and data warehouse environments.

Build data transformations, including importing data from files and migrating data between platforms.

SQL Server Development:

Create and maintain stored procedures, functions, views, triggers, and indexes for ETL workflows.

Perform query optimization and performance tuning for large datasets.

Data Warehousing:

Design and maintain data warehouse schemas, including star and snowflake models.

Implement best practices for data modeling and dimensional design.

Testing & Deployment:

Prepare and execute test plans for ETL processes.

Deploy SSIS packages to production and non-production environments using CI/CD pipelines.

Monitoring & Support:

Monitor ETL jobs, troubleshoot failures, and resolve performance issues.

Ensure data integrity, security, and compliance across all data processes.

Others:

Strong analytical and problem-solving abilities.

Excellent communication and collaboration skills.

Ability to work independently and in a team environment