Assignment : RQ08584 - Software Developer - ETL - Senior Job Title : ETL & Azure Data Engineer Requisition (SS)...Show moreLast updated: 19 hours ago
Promoted
Report Developer
Boyd InteractiveNorth York, ON, Canada
Permanent
Pala offers a full spectrum of games across all distribution channels (web, download, tablet & smartphone).In Canada, they offer sports betting and casino games.
In the US, they offer casino, bingo,...Show moreLast updated: 18 days ago
Golang Developer
SA TechnologiesRichmond Hill Central, ON, ca
Quick Apply
Unlock New Career Horizons with SA Technologies Inc.As a Great Place to Work Certified company, recognized as one of the Best Places for Women, and a CMMI Level 5 Company, we are committed to creat...Show moreLast updated: 18 days ago
Promoted
New!
KDB Developer
First DerivativeOntario, Canada
Full-time
First Derivative is a global leader in consulting, business services and technology.We are the home for diverse thinkers and innovators.
We know that our people are vital to our success and we are p...Show moreLast updated: 7 hours ago
Promoted
E-Learner Developer
Swiss ChaletVaughan, ON, Canada
Full-time
Swiss Chalet is looking for an E-Learner Developer to join their team!.Recipe Unlimited Corporation is Canada’s leading full service restaurant company.
Home to such iconic brands as Swiss Chalet, H...Show moreLast updated: 20 days ago
Promoted
Front End Developer
Robert HalfNorth York, Ontario, Canada
We are seeking a talented Front-End Developer with a strong understanding of modern web technologies to create responsive, user-friendly, and visually appealing web interfaces.The ideal candidate w...Show moreLast updated: 4 days ago
Promoted
RQ08586 Software Developer - ETL
Randstad CanadaNorth York, Ontario, CA
Temporary
Quick Apply
Are you an experienced ETL Developer with expertise in Azure Data Factory (ADF), Informatica PowerCenter, and complex data transformations? Do you have strong SQL and PL / SQL development skills, and...Show moreLast updated: 5 days ago
Promoted
Salesforce Developer
HaysOntario, Canada
Temporary
Design, develop, and implement API integrations between Salesforce and Simplicity.Collaborate with stakeholders to understand integration requirements and objectives.
Ensure data integrity and consi...Show moreLast updated: 10 days ago
Promoted
Web Developer
ConnexallNorth York, ON, Canada
Full-time
Our cornerstone product, Connexall®, is an award-winning Enterprise grade IoT platform, purpose built for the healthcare industry.
Connexall® is a sophisticated and customizable end-to-end integrati...Show moreLast updated: 6 days ago
Promoted
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: 20 days ago
Advanced Software Developer
Snowed In StudiosON, CA
CA$110,000.00–CA$135,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
Senior Python ETL developer
Sun LifeNorth York, 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
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
Intermediate Full Stack Developer
Sym-Tech Dealer ServicesRichmond Hill, ON, Canada
Full-time
Celebrating 53 years of growth, Sym-Tech is a leading finance and insurance provider to the retail automotive industry.At-Sym-Tech we are looking for Associates who share our passion for innovation...Show moreLast updated: 30+ days ago
PHP Developer
PeopleToGoWoodbridge, Ontario
CA$80.00–CA$100.00 hourly
Quick Apply
Our client currently has an opening for a PHP Developer to join their team.Development of PHP based nework applications.Design and implementation of applications from use cases.Database (MySQL) des...Show moreLast updated: 30+ days ago
Promoted
Software Developer (Backend)
Game HiveRichmond Hill, ON, Canada
serp_jobs.filters.currency_variable_a_yearly
This job is currently not accepting applicants.Show moreLast updated: 30+ days ago
Promoted
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: 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
Software Developer (intermediate to senior)
JLI Consulting Talent SearchWoodbridge ON
CA$85.00 hourly
Full-time
Our client, an eServices company, is in search for an experienced software solutions developer.In this role, you will be working with state of the art technologies, in a high performance fully matu...Show moreLast updated: 30+ days 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: 16 hours 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 :