Software Developer – Senior

LanceSoft Inc. is hiring hashtag#ETLdeveloper for hashtag#Toronto, ON in Canada
Qualified candidates can share their resume at jolly.chauhan@lancesoft.com
Title: Software Developer – Senior
Location: Toronto (Onsite)
Must haves:
5+ year experience working with RDBMS, Azure SQL Server, Database Administration, security management for high-sensitive database, database performance management, query performance analysis & tuning, database quality practice, good understanding of Azure storage concepts and technologies.
5+ years of working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns. Understanding of data pipeline architectures, Azure workflow orchestration tools, and concepts related to data ingestion, transformation, and movement.
Proficiency in Azure Data Factory, SSMA, Database Migration Services, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
Proficiency in scripting languages, relational data models, data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, and experience with Azure-specific scripting using PowerShell or Azure CLI.
Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.