Don't worry, we can still help! Below, please find related information to help you with your job search.
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 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
-
Agente Ou Agent De Prévention De Soir Au Service De La Gestion Des Sentences
By Ministère de la sécurité publique At Montreal, Quebec, Canada 6 months ago
-
Lead Line Cook/Manager On Duty
By Impact Kitchen At Greater Toronto Area, Canada 6 months ago
-
Refinish Tech (Temporary) Jobs
By Boyd Group Services Inc. At Saskatoon, Saskatchewan, Canada 6 months ago
-
Vice President - Treasury
By Boyd Group Services Inc. At Winnipeg, Manitoba, Canada 6 months ago
-
Rock Mechanics Eit Jobs
By WSP in Canada At Greater Sudbury, Ontario, Canada 6 months ago