Role & responsibilities

• Senior knowledge of SQL Server tech stack

• Data modelling, database development, data cleansing, data transformations using T-SQL and SSIS

• Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process

• Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems.

• Builds data transformations with SSIS including importing data from files, moving data from one database platform to another

• Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data

• Design, implement and maintain database objects (tables, views, indexes, ) and database security • Experience working with SSIS packages

•Any scripting language like Python/C# for data cleansing in mass is a plus

• Data Integrations design and development using the tech stack of SQL. Knowledge of Azure Event Hub, and Azure Blob Storage is a plus.

• Code development/check-in in Visual Studio, GitHub and Azure DevOps