We are implementing PRISM, a solution heavily relying on MS SQL. The project involves working with large datasets, query optimization, and integration processes. At the pilot stage, the main focus will be on SQL development, supporting and enhancing SSIS packages, and working with Azure Data Factory (ADF).
Responsibilities: * Develop and optimize complex SQL queries, stored procedures, and functions in MS SQL Server. * Support and improve SSIS packages. * Work with Azure Data Factory: create and enhance pipelines. * Automate tasks using PowerShell (when needed).
Requirements: * Proven experience with MS SQL Server (T-SQL, performance optimization). * Hands-on experience with SSIS. * Basic to intermediate experience with Azure Data Factory (experience creating pipelines from scratch is a plus). * Understanding of ETL processes and data integration. * Experience with PowerShell is an advantage, but not essential. * Strong analytical skills and ability to work with large datasets.