Assignment : RQ08584 - Software Developer - ETL - Senior Job Title : ETL & Azure Data Engineer Requisition (SS)...Show moreLast updated: 21 hours ago
Promoted
ThoughtSpot product Owner
Tek Leaders Incontario, Canada
Full-time
ThoughtSpot Developer / ThoughtSpot product Owner.Experienced ThoughtSpot Product Owner with a strong background in data analytics, platform transitions, and end-to-end project management.This role ...Show moreLast updated: 5 days ago
Promoted
Learning Developer
Collaberaontario, Canada
Full-time
This is with one of our banking client.Note : Portfolio of Storyline and RISE work is mandatory – Please ensure the portfolio link is included in the resume.
Learning Design COE by developing engagin...Show moreLast updated: 4 days ago
Promoted
New!
Senior Frontend Developer
Trust In SODAWaterloo, ON, Canada
Full-time
Are you a Frontend Developer that has experience leading and building high performance consumer facing application from scratch?.
You will be working with a stealth-mode AI start up who is based in ...Show moreLast updated: 5 hours ago
Promoted
New!
Senior Software Developer
Empire LifeOntario, Canada
Full-time
Please note the base salary will be determined by the successful candidate's education, skills and experience.The listed salary range serves as a general pay guideline for this position's pay level...Show moreLast updated: 5 hours ago
Promoted
New!
Senior Shopify Developer
AkkodisOntario, Canada
Full-time
Mostly if not entirely backend development.The Customer is taking on the front end development responsibilities.So frontend expertise in liquid is not a hard requirement but good for the candidate ...Show moreLast updated: 5 hours ago
Promoted
New!
Back End Developer
NevvonOntario, Canada
Full-time
Nevvon is hiring an Back End Developer.Where the future of work meets healthcare workers - that’s where you’ll find us! We’re here to make sure vulnerable populations are treated by highly trained ...Show moreLast updated: 5 hours ago
Promoted
New!
BMC Remedy Developer
Pyramid Consulting, IncOntario, Canada
CA$55.00–CA$58.00 hourly
Temporary
Please review the job description below and contact me ASAP if you are interested.Pay Range : CAD$55 - CAD$58 / hour.Employee benefits include, but are not limited to, health insurance (medical, denta...Show moreLast updated: 5 hours ago
Promoted
SAS AML Expert
TES The Employment Solution Inc.ON, Canada
Full-time
Reference Code : 049239 This will be local to Toronto and will be once a week in their Downtown office.This will be part of a Consulting project we have undertaken, initial duration is 2 months but...Show moreLast updated: 7 days ago
Toronto, ON; Burlington, ON; Kitchener, ON; Ottawa, ON.At Deloitte, we are driven to inspire and help our people, organization, communities, and country to thrive.
Our Purpose is to build a better f...Show moreLast updated: 30+ days ago
Promoted
New!
Full Stack Developer
CompuMed SolutionsBreslau, ON, Canada
CA$80,000.00–CA$100,000.00 yearly
Full-time
At Compu-Med Solutions, we seek a Full Stack Developer to create custom software solutions for our clients.You’ll be part of a small team responsible for the full software development life cycle, f...Show moreLast updated: 5 hours ago
Guidewire Developer
E-SolutionsOntario
CA$43.28 hourly
We are looking for a positive and collaborative Senior Guidewire Developer.As part of our Software Engineering Group, you will be working with globally distributed teams, including business represe...Show moreLast updated: 30+ days ago
Cloud Data Engineers
Emonics LLCOntario, Canada
CA$60,000.00 yearly
Must have working knowledge in designing and implementing data pipelines on any of the cloud providers (AWS is preferred).
Must be able to work with large volumes of data coming from various sources...Show moreLast updated: 30+ days ago
Promoted
Senior Java Developer
RecootyGolden Horseshoe, ON, Canada
As a Lowfoot Senior Java Developer, you’ll focus on building and implementing our suite of energy SAAS products.You’re an experienced Java developer who knows how the web works, and can build and s...Show moreLast updated: 19 days ago
Senior Firmware Developer
Blackline SafetyWaterloo, ON, CA
Full-time
Quick Apply
Our team at Blackline Safety is growing! As a people-driven technology company, with a mission to make sure every worker returns home safely, we drive innovation, practice resiliency, demonstrate l...Show moreLast updated: 9 days ago
Senior Python ETL developer
Sun LifeWaterloo, Ontario
Full-time
Do you want to build and maintain mission critical data processing and transformation systems that will help run one of Canada’s biggest financial institutions? Do you enjoy being part of a tight-k...Show moreLast updated: 30+ days ago
ETL Lead
eTeamRemote, ON
CA$60.00–CA$65.00 hourly
Remote
Data management solution for batch and real time data warehouse / data lake designs.Strong working experience in AWS RedShift and AWS Glue, Crawler and Data Catalog.
Technical expert in on-prime, clou...Show moreLast updated: 30+ days ago
Principle Software Developer
Snowed In StudiosON, CA
CA$135,000.00–CA$160,000.00 yearly
Remote
Full-time
Quick Apply
As part of Keywords Studios’ Create service line, we provide support to some of the most exciting games being made today.
You’ll have the chance to make a global impact, working in a studio known fo...Show moreLast updated: 30+ days ago
Data Engineer- Part time (3 days a week)
ApplyBoardKitchener
CA$102,200.00–CA$142,000.00 yearly
Full-time
ApplyBoard simplifies the study abroad search, application, and acceptance process by connecting international students, recruitment partners, and educational institutions on one intuitive and pers...Show moreLast updated: 30+ days ago
Senior Developer
Arctic WolfRemote, Ontario
CA$115,000.00 yearly
Remote
Full-time
Arctic Wolf, with its unicorn valuation, is the leader in security operations in an exciting and fast-growing industry—cybersecurity.
We have won countless awards for our excellence in security oper...Show moreLast updated: 30+ days ago
Office Location : 87 Sir William Hearst Ave., Toronto, Ontario M3M 0B4
Organization : Labour and Transportation Cluster
Extension # of Days : 250.00
Ministry : Ministry of Transportation
Business Days : 252.00
Note : Candidate is required to come in office 3 days a week
Must haves :
Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.
Description
Deliverables section :
Scope of Services and Deliverables - The Services and Deliverables to be provided by the Vendor will include the following :
Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc.
Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards.
Design logical and physical data models using Sybase Power Designer.
Produce transformation mapping document.
Implement data pipelines using Azure Data Factory (ADF), stored procedure, and Informatica PowerCenter performing extraction, transformation, and loading activities.
Implement solutions using Logic App and Function App.
Generate structured JSON file using ADF / SQL.
Develop Azure CI / CD pipeline to automate ADF release.
Develop complex Oracle PL / SQL program to fulfill project requirements.
Implement complex data conversion, e.g., binary to character, EBCDIC to UTF.
Implement complex data transformation(s) for derived and calculated values.
Integrate data sets from diverse source systems.
Implement ADF for initial data load and incremental load.
Promote ADF and Informatica ETL / ELT through all Ministry environments including Development, Integration Testing, QA, UAT, Production.
Resolve and troubleshoot ADF pipeline, stored procedure, and Informatica workflow technical problems.
Monitor and analyze incident, provide timely resolution.
Collaborate with IT Professionals throughout the Software Development Life Cycle.
Document information from diverse business area stakeholders and subject matter experts.
Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow.
Monitor application functionality and performance on daily basis.
Provide effective knowledge transfer to Ministry staff at all stages of this assignment.
Evaluation Table
ETL Development-Data Integration - 40%
Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.
Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, including :
Self-Hosted Integration Runtime
Data movement, ETL pipelines
Performance tuning on large data volumes
Complex data transformations
ADF Debugger to validate data transformation.
Azure Roles
Experience with Informatica, including :
Workflow Manager
Repository Manager
Designer
Workflow Monitor
Experience with developing solutions using Logic App and Function App.
Experience in rapid application development (RAD) methodologies.
Experience in maintaining and improving existing ETL processes.
Experience in investigating data to identify potential issues within ETL pipelines.
Experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI.
Azure Technologies - 40%
Experience with CI / CD (DevOps) pipelines and concepts, including :
Azure Resource Management
GitHub Repo
Source code version control
Branching, pull requests, build, release, multiple parallel development repositories merge.
Experience with Azure DevOps, including :
Azure Boards
Azure Test Plans
Azure Pipelines
Azure Repos
Azure Artefacts
Oracle PL / SQL Development - 10%
Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL / SQL programs.
Database Technologies - 10%
Experience with Oracle, Microsoft SQL Server database and tools.
Experience with relational and hierarchical database technologies.
Extensive knowledge of Azure SQL DB and Synapse platforms, including :