Unfortunately, this job posting is expired.
Don't worry, we can still help! Below, please find related information to help you with your job search.
Some similar recruitments
Etl Developer - Pl/Sql
Recruited by Infotek Consulting Inc. 6 months ago Address Toronto, Ontario, Canada
Etl Developer (Sql, Ssis, Data Model)
Recruited by CorGTA Inc. 6 months ago Address Toronto, Ontario, Canada
Business Intelligence Specialist - Etl Developer
Recruited by Tangentia 6 months ago Address Toronto, Ontario, Canada
Senior Software Developer (Frontend)
Recruited by HelloFresh 7 months ago Address Toronto, Ontario, Canada
Software Developer (Java/Cloud, 100% Remote In Ontario)
Recruited by Motion Recruitment 7 months ago Address Toronto, Ontario, Canada
Software Engineer (100% Remote, Java/Vert.x)
Recruited by Motion Recruitment 7 months ago Address Toronto, Ontario, Canada
Senior Devops Jobs
Recruited by Thinkpivot Talent Solutions 7 months ago Address Toronto, Ontario, Canada
Rq05758 - Software Developer - Senior
Recruited by S M Software Solutions Inc 7 months ago Address Toronto, Ontario, Canada
Informatica Powercenter Etl Developer
Recruited by InfoStride 7 months ago Address Toronto, Ontario, Canada
Rq05758 Software Developer, Senior Level
Recruited by Randstad Canada 7 months ago Address North York, Ontario, Canada
Senior Software Developer - React
Recruited by Horizon 7 months ago Address Toronto, Ontario, Canada
Etl + C# Developer Jobs
Recruited by TekStaff IT Solutions 7 months ago Address Toronto, Ontario, Canada
Senior Software Developer, Customer Success
Recruited by DNAstack 7 months ago Address Toronto, Ontario, Canada
Software Developer V - Java
Recruited by Astek 7 months ago Address Toronto, Ontario, Canada
Senior Software Developer (Java)
Recruited by NielsenIQ 7 months ago Address Toronto, Ontario, Canada
Senior Software Developer (Atms)
Recruited by IBI Group 7 months ago Address Toronto, Ontario, Canada
Software Engineer (Java) Jobs
Recruited by Sun Life 7 months ago Address Toronto, Ontario, Canada
Software Developer-Etl-Senior Jobs
Recruited by S M Software Solutions Inc. 8 months ago Address Toronto, Ontario, Canada

Software Developer - Etl - Senior

Company

S M Software Solutions Inc.

Address Toronto, Ontario, Canada
Employment type CONTRACTOR
Salary
Expires 2023-05-29
Posted at 10 months ago
Job Description

Job Title: RQ05076 - Software Developer - ETL - Senior

Work Location: Toronto, Ontario, Hybrid

Estimated Start Date: ASAP

#Business Days: 253.00

Extension: 250.00

Hours per day or Week:7.25 hours per day

Security Level:CRJMC

Must haves:

·Extensive experience withETL tools Informatica PowerCenter and Microsoft SSIS;

·Extensive experience withAzure Data Factory, including:

·Experience withCI/CD (DevOps)pipelines and concepts

·Experience indata modeling

·Experience withOracle, Microsoft SQL Server database and tools

·Extensive knowledge ofAzure SQL DB and Synapse

Description

Scope of Services and Deliverables –

The Services and Deliverables to be provided by the Vendor will include the following:

·Monitor and analyze incident, provide timely resolution

·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 solution using Azure Data Factory (ADF) pipeline and stored procedure, and Informatica PowerCenter

·Develop Azure CI/CD pipeline to automate ADF release

·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

·Debug ADF pipeline and stored procedure, and Informatica workflow to investigate and fix defects

·Actively participate, support and provide feedback to project team during design/development/testing/implementation phase

·Produce supporting documentation

·Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow

·Monitor application functionality and performance on a daily basis

·Provide effective knowledge transfer to Ministry staff at all stages of this assignment