Software Developer - ETL - Senior (ETL,Azure) - Jobs in Toronto

Job Description

Job DescriptionArthur Grand Technologies is currently seeking a highly motivated and Skilled Software Developer - ETL - Senior for one of our clientsPosition: Software Developer - ETL - Senior Location: 595 Bay Street, Toronto, Ontario (Onsite)Duration: Long Term Contract Must Haves:

•  5+ years of proven 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, Azure Synapse workspaces, PolyBase, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
• Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies.
• Proficiency in scripting languages like Python, experience with Azure-specific scripting using PowerShell or Azure CLI.
• Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysisamp; tuning
• Knowledge of integration technologies commonly used with Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.
• Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.
• Familiarity with data warehousing concepts and experience working with Azure Synapse Analytics or similar platforms for building and managing large-scale data warehousing/lakehouse solutions.
• Experience with SSIS, SSRS, PowerBI

Nice To have:

• Azure cloud certifications (e.g. Azure fundamentals, Azure Data Engineer associate, Azure Database Administrator associate)
• Experience with PowerApps platform, Power Automate, Dynamics CE and F amp;O

Experience and Skill Set Requirements Resumes Evaluation/Criteria:Criteria 1: Data Migration, ETL - 40 Points

• Demonstrated experience with ETL development, data pipelines, workflow orchestration and data ingestion, transformation, and movement
• Demonstrated experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools
• Demonstrated experience working with Azure Data Factory, Azure Synapse workspaces, PolyBase, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
• Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysisamp; tuning
• Demonstrated experience with SQL Server, Oracle, Azure SQL Databases
• Demonstrated experience with data modeling tools (preferably, ERWIN)
• Demonstrated experience in scripting languages like Python and with Azure-specific scripting using PowerShell or Azure CLI.
• Experience with software development lifecycle
• Experience with data modeling, physical database design, data flow diagrams

Criteria 2: Data Warehouse and Reporting - 20 Points

• Demonstrated experience working with Azure Synapse Analytics or similar platforms for building and managing large-scale data warehousing/lakehouse solutions
• Experience with data warehousing modelling concepts such as star and snowflake schemas
• Experience with SSIS, SSRS, PowerBI
• Experience with supporting a data warehouse in a production environment

Criteria 3: Azure Platform - 20 Points

• Experience with Azure Data Factory (ADF) and Synapse Workspaces
• Demonstrated experience Azure data management tools, DevOps, Synapse Studio
• Experience in Azure resource configuration and administration such as Azure Data Lake, Blob Storage, Key Vault, Application Insight resources, resource groups and subscriptions.
• Familiar with Azure cloud platform
• Azure cloud certifications

Criteria 4: Dynamics 365 - 10 Points

• Demonstrated • Demonstrated experience working with integration technologies commonly used with Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.
• Demonstrated experience with PowerApps platform, Power Automate, Dynamics CEamp;F amp;O

Criteria 5: DevOps and CI/CD - 10 Points

• Demonstrated experience with continuous integration/continuous deployment (CI/CD) tools and processes around DevOps, data workflows, Synapse workspaces.

Thanks,Afrah FaizaArthur Grand Technologies IncArthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)