Azure SQL Developer

at  Atlantis IT group

Role: Azure SQL Developer
Location: Toronto
Fulltime - Onsite
Skills Required
Experience with Microsoft BI stack SQL Server, T-SQL, SSRS, MS SQL Enterprise Manager etc
Experience with data warehouse, ETL, SSIS to move data / integrate systems.
Clear communication and interpersonal skills required.
Experience in migrating database workload from SQL Server on premise to Azure database services (Azure SQL Managed instance)
Experience in migrating on-premises SSIS workload to SSIS in ADF (or) Synapse pipelines.
Experience with Azure Data / EDL / Hadoop / Hive / Jupyter Notebooks / Tableau a plus
Attention to detail and feedback from clients on dashboards and reports must be completed rapidly.
Experience with SDLC methodologies required eg. Agile / Waterfall
Experience with databases, data modeling design
Experience working with Content Management Systems like MS SharePoint or box.com a plus.
Knowledge on Banking / Risk related systems is a plus.
Experience developing code to consuming REST API services a plus.
Experience integrating systems with COTS Commercial Off the Shelf software packages a plus.
Experience with implementing DevOps a plus
Experience with MS Azure Cloud services

[Critical] Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with data warehouse.
Collecting business requirements / user stories from clients
Complete testing to ensure high quality product for clients.
Developing SQL views to enable data consumers to read data from data warehouse.
Integrate systems via REST API, database views, SharePoint lists, sFTP, etc
Responsible for documenting databases, data process flows and maintain data dictionaries.
Troubleshoot and resolve database and applications defects in a timely manner. Consult with internal and external groups as required.
Train and assist users at all levels..