Overview
Skills
Job Details
Role: Snowflake Azure Engineer
Location: Naperville, IL /St. Paul, MN Onsite
Job Description:
Must-Have:
Primary Skills:
Azure Data factory (Pipelines/Data flows), Azure Data Lake-Gen2 Storage, Logic Apps, SQL Server Analysis Services (Tabular), Power BI (Dataset Creation only), DAX, T-SQL (Stored procedure, views etc), Azure Devops and Snowflake
4 Years of Experience in Snowflake
6 Years of Hands-on Experience with SQL Server in writing complex T-SQL queries and logics
6 Years of Experience using SSIS as a ETL tool - must have experience in complex ETL's building, Deployment, configuration of SSIS Packages
4 Years of Experience in Microsoft Azure & Azure SQL DB's
4 Years of Hands-on Experience in using Azure Data Factory as a ETL/ELT Tool o Must know about connecting to various Azure Storages and other On-prem and cloud sources and destinations using ADF. o Must have knowledge about Azure DevOps
Must Have worked on Agile Methodology.
Good-to-Have:
Secondary Skills:
Data Modelling, SQL Server Integration Services (SSIS), Team Foundation Server (TFS) through Visual Studio, ServiceNow, Power BI, Streamlit, Fivetran
Good To have hands on experience with SSAS, Power BI
Good to have experience with Informatica Data Management Cloud (IDMC)
Added Advantage if there is any relevant C# .Net experience.