SSIS , SQL , DW

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