Arthur Grand Technologies is currently seeking a highly motivated and Skilled Software Developer ETL Senior for one of our clients
Position: Software Developer ETL Senior
Location: Toronto Ontario (Hybrid)
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 Azurespecific scripting using PowerShell or Azure CLI.
- Expert proficiency with data manipulation languages (TSQL PL/SQL) data definition languages physical database design data modeling query performance analysis & 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 largescale 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&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 onpremises 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 (TSQL PL/SQL) data definition languages query performance analysis & 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 Azurespecific 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 largescale 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 CE &F&O
Criteria 5: DevOps and CI/CD 10 Points
Thanks
Afrah Faiza
Arthur Grand Technologies Inc
Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)
Additional Information :
All your information will be kept confidential according to EEO guidelines.
Remote Work :
No
Employment Type :
Contract