drjobs Software Developer - ETL - Senior ETLAzure

Software Developer - ETL - Senior ETLAzure

Employer Active

1 Vacancy
The job posting is outdated and position may be filled
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Toronto - Canada

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

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

Employment Type

Contract

Company Industry

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.