Description

You will develop and maintain data pipelines using SSIS and SQL.

This role is on-site.

Responsibilities

• Lead ETL development, data pipelines, and data warehouse loads.
• Design, develop, and optimize complex SQL queries, stored procedures, functions, and views.
• Build and maintain workflows for data ingestion, cleansing, transformation, and transfer using SSIS and SQL.
• Implement and utilize Azure DevOps and CI/CD pipelines for deployments.
• Resolve technical issues and communicate solutions to stakeholders.

Required Skills

• 5+ years of experience in ETL development.
• Expert proficiency in SQL, including T-SQL, stored procedures, and views.
• Experience with Microsoft SQL Server 2019 and above.
• Proven experience building and deploying ETL packages using Microsoft SSIS.
• Deep understanding of data warehousing concepts (star, snowflake, normalized, de-normalized models).
• Strong experience with JSON and XML data structures and formats.
• Experience with SSIS Scripting.
• Experience implementing CI/CD pipelines using Azure DevOps.

Preferred Skills

• Experience with performance optimization for data queries.

Key Skills

Education

Any Graduate