- Working experience with SSIS, SQL, T-SQL
- Practical experience with Microsoft SQL Server platform, and Transact SQL stored procedures and triggers
- Experience with SSIS development and SSRS reports (preferred)
- Experience building and troubleshooting complex pipelines in Snowflake
- Ability to create Functions/Views/Stored Procs.
- Experience with complex queries including use of CTEs, table variables, merge and agile SQL.
- Experience with complex business logic including applying logic to transforms that falls outside of basic schema formatting conversion.
- Experience executing SSIS packages via SQL Server Job Agent
- Experience using all components available in SSIS including sorts, derived values, data conversion, multicast, merge, union, variables, parameters,
package DB connections, project DB connections, flat file connections, excel connections and SMTP connections, expressions and file system tasks.
- Data processing on Azure services (Azure Data Lake, Azure Storage, Azure SQL, Azure DW)
- Working knowledge of Azure Synapse
- Working knowledge of Snowflake
- Airflow experience a bonus but not required