Description

You will design, build, and maintain ETL pipelines using SQL Server and SSIS, ensuring data integrity and performance across the data warehouse.

This role is hybrid.

Responsibilities

• Develop batch ETL/ELT processes using SQL Server and SSIS to move and transform data for ODS, staging, data warehousing, and data marts.
• Design and implement data warehouse solutions using Star and Snowflake schemas for reporting and analytical applications.
• Write, optimize, and maintain complex SQL queries and stored procedures for data processing and analysis.
• Implement audit, balance, and control mechanisms within data solutions to ensure accuracy and reliability.
• Build and manage CI/CD pipelines for data pipelines using Azure DevOps.

Required Skills

• 6-8 years of experience with SQL Server and SQL Server Integration Services (SSIS).
• Strong experience designing and building complete data pipelines and ETL processes.
• Proficiency in writing and optimizing T-SQL queries and stored procedures.
• Hands-on experience implementing Data Warehouse solutions (Star/Snowflake schemas).
• Familiarity with Azure DevOps for CI/CD pipeline implementation.
• Experience with large-scale data processing and query optimization techniques.
• Knowledge of Python is preferred.

Preferred Skills

• Demonstrated experience implementing audit and control mechanisms in data solutions.

Key Skills

Education

Any Graduate