Software Developer 7244-2612

HM Note: This hybrid role is three (3) days in office

Responsibilities: and nbsp;

Design implement and continuously expand data pipelines by performing extraction transformation and loading activities. and nbsp;

Required to translate technical systems specifications into working tested applications. This includes developing detailed programming specifications writing and/or generating code compiling datadriven programs maintaining and conducting unit tests.

Resolves and troubleshoots technical problems which arise during the use and operation of software packages including technical assistance in implementation conversion and migrations. and nbsp;

General and nbsp;Skills: and nbsp;

Experience and nbsp;in and nbsp;programming and nbsp;and and nbsp;analysis; and nbsp;specialized and nbsp;software and nbsp;package and nbsp;support and nbsp;at and nbsp;the and nbsp;specified and nbsp;experience and nbsp;level and nbsp;

Ability and nbsp;to and nbsp;collaborate and nbsp;with and nbsp;IT and nbsp;Professionals and nbsp;throughout and nbsp;the and nbsp;Software and nbsp;Development and nbsp;Life and nbsp;Cycle and nbsp;

Experience and nbsp;in and nbsp;structured and nbsp;methodologies and nbsp;for and nbsp;the and nbsp;development and nbsp;design and nbsp;implementation and nbsp;and and nbsp;maintenance and nbsp;of and nbsp;applications and nbsp;

Experience and nbsp;in and nbsp;design and nbsp;code and nbsp;test and nbsp;debug and nbsp;and and nbsp;document and nbsp;applications and nbsp;

Experience and nbsp;in and nbsp;the and nbsp;use and nbsp;of and nbsp;object and nbsp;and/or and nbsp;third and nbsp;generation and nbsp;language and nbsp;development and nbsp;tools and nbsp;

Experience and nbsp;in and nbsp;one and nbsp;or and nbsp;more and nbsp;programming and nbsp;languages and nbsp;

Experience and nbsp;in and nbsp;application and nbsp;design and nbsp;latest and nbsp;design and nbsp;patters and nbsp;deployment and nbsp;and and nbsp;troubleshooting and nbsp;

Experience and nbsp;with and nbsp;relational and nbsp;and and nbsp;hierarchical and nbsp;database and nbsp;technologies and nbsp;

Experience and nbsp;in and nbsp;the and nbsp;use and nbsp;of and nbsp;information and nbsp;retrieval and nbsp;packages and nbsp;using and nbsp;query and nbsp;languages and nbsp;

Experience and nbsp;with and nbsp;one and nbsp;or and nbsp;more and nbsp;communications and nbsp;protocols and nbsp;

Experience and nbsp;in and nbsp;structured and nbsp;methodologies and nbsp;for and nbsp;the and nbsp;design and nbsp;development and nbsp;implementation and nbsp;and and nbsp;maintenance and nbsp;of and nbsp;applications and nbsp;

Experience and nbsp;eliciting and nbsp;and and nbsp;documenting and nbsp;information and nbsp;from and nbsp;diverse and nbsp;business and nbsp;area and nbsp;stakeholders and nbsp;and and nbsp;subject and nbsp;matter and nbsp;experts and nbsp;

Excellent and nbsp;analytical and nbsp;problemsolving and nbsp;and and nbsp;decisionmaking and nbsp;skills; and nbsp;verbal and nbsp;and and nbsp;written and nbsp;communication and nbsp;skills; and nbsp;interpersonal and nbsp;and and nbsp;negotiation and nbsp;skills and nbsp;

A and nbsp;team and nbsp;player and nbsp;with and nbsp;a and nbsp;track and nbsp;record and nbsp;for and nbsp;meeting and nbsp;deadlines and nbsp;

ETL and nbsp;Skills: and nbsp;

Knowledge and nbsp;and and nbsp;experience and nbsp;in and nbsp;gathering and nbsp;requirements and nbsp;and and nbsp;business and nbsp;process and nbsp;knowledge and nbsp;in and nbsp;order and nbsp;to and nbsp;transform and nbsp;the and nbsp;data and nbsp;in and nbsp;a and nbsp;way and nbsp;thats and nbsp;geared and nbsp;towards and nbsp;the and nbsp;needs and nbsp;of and nbsp;end and nbsp;users and nbsp;

Knowledge and nbsp;and and nbsp;experience and nbsp;maintaining and nbsp;and and nbsp;improving and nbsp;already and nbsp;existing and nbsp;processes. and nbsp;

Knowledge and nbsp;and and nbsp;experience and nbsp;ensuring and nbsp;that and nbsp;the and nbsp;data and nbsp;architecture and nbsp;is and nbsp;scalable and nbsp;and and nbsp;maintainable and nbsp;

Knowledge and nbsp;and and nbsp;experience and nbsp;working and nbsp;with and nbsp;the and nbsp;business and nbsp;in and nbsp;designing and nbsp;and and nbsp;delivering and nbsp;correct and nbsp;high and nbsp;quality and nbsp;data and nbsp;

Experience and nbsp;investigating and nbsp;data and nbsp;to and nbsp;identify and nbsp;potential and nbsp;issues and nbsp;within and nbsp;ETL and nbsp;pipelines and nbsp;notify and nbsp;endusers and nbsp;and and nbsp;propose and nbsp;adequate and nbsp;solutions and nbsp;

Experience and nbsp;preparing and nbsp;detailed and nbsp;documentation and nbsp;for and nbsp;further and nbsp;reference and nbsp;

Desirable and nbsp;Skills: and nbsp;

Knowledge and nbsp;and and nbsp;experience and nbsp;with and nbsp;programming and nbsp;Internetready and nbsp;applications and nbsp;

Knowledge and nbsp;and and nbsp;experience and nbsp;in and nbsp;rapid and nbsp;application and nbsp;development and nbsp;(RAD) and nbsp;methodologies and nbsp;

Knowledge and nbsp;and and nbsp;understanding and nbsp;of and nbsp;Information and nbsp;Management and nbsp;principles and nbsp;concepts and nbsp;policies and nbsp;and and nbsp;practices and nbsp;

Experience and nbsp;with and nbsp;middleware and nbsp;and and nbsp;gateways and nbsp;Experience and nbsp;reviewing and nbsp;analyzing and nbsp;and and nbsp;modifying and nbsp;product and nbsp;installation and nbsp;scripts and nbsp;including and nbsp;encoding and nbsp;testing and nbsp;debugging and nbsp;

Ability and nbsp;to and nbsp;provide and nbsp;postimplementation and nbsp;support and nbsp;and and nbsp;resolve and nbsp;any and nbsp;postimplementation and nbsp;technical and nbsp;issues and nbsp;

Experience and nbsp;conducting and nbsp;design and nbsp;walkthrough and nbsp;sessions and nbsp;with and nbsp;project and nbsp;team and nbsp;

Knowledge and nbsp;and and nbsp;understanding and nbsp;of and nbsp;Accessibility and nbsp;for and nbsp;Ontarians and nbsp;with and nbsp;Disability and nbsp;Act and nbsp;(AODA) and nbsp;and and nbsp;related and nbsp;regulations and nbsp;and and nbsp;standards and nbsp;

Ability and nbsp;to and nbsp;provide and nbsp;user and nbsp;and and nbsp;system and nbsp;documentation and nbsp;as and nbsp;required

Skills

Experience and Skill Set Requirements

Responsibilities/Assignment and nbsp;Deliverables and nbsp; and nbsp;Senior and nbsp;ETL and nbsp;Developer

• Designs and nbsp;develops and nbsp;and and nbsp;maintains and nbsp;database and nbsp;back and nbsp;end and nbsp;and and nbsp;ETL and nbsp;applications and nbsp;for and nbsp;Data and nbsp;Warehouse and nbsp;and and nbsp;Business and nbsp;Intelligence and nbsp;solutions. and nbsp;
• Uses and nbsp;knowledge and nbsp;of and nbsp;ETL and nbsp;languages and nbsp;and and nbsp;development and nbsp;techniques and nbsp;to and nbsp;build and nbsp;and and nbsp;expand and nbsp;application and nbsp;functionality and nbsp;by and nbsp;writing and nbsp;highquality and nbsp;code and nbsp;using and nbsp;appropriate and nbsp;patterns. and nbsp;
• Ensures and nbsp;applications and nbsp;remain and nbsp;scalable and nbsp;while and nbsp;complying and nbsp;to and nbsp;standards and nbsp;and and nbsp;following and nbsp;best and nbsp;practices.
• Tests and nbsp;and and nbsp;debugs and nbsp;applications and nbsp;and and nbsp;ensures and nbsp;that and nbsp;software and nbsp;is and nbsp;properly and nbsp;documented. and nbsp;
• Collaborates and nbsp;clearly and nbsp;and and nbsp;professionally and nbsp;as and nbsp;part and nbsp;of and nbsp;a and nbsp;development and nbsp;team and nbsp;and and nbsp;communicates and nbsp;with and nbsp;clients.

and nbsp;

Mandatory and nbsp;Skills:

• Experience with the Microsoft suite of technology including: Azure Data Factory Azure SQL Database Azure Data Lake and Power BI
• Experience with developing data extraction transformation and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semistructured files relational and multidimensional data stores)
• Experience with developing implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
• Experience with data integration data cleansing and data analytics
• Experience with data modeling and design principles for data marts and data warehouses
• Experience in database management and administration
• Experience in constructing complex SQL queries and performance tuning
• Experience with Git and knowledge of source control strategies
• Experience creating technical documentation including ETL sourcetotarget mappings data model diagrams architecture artifacts detailed design documents etc.
• Experience in eliciting documenting and validating business requirements
• Experience in software development lifecycle from Development to Testing and Quality Assurance to Delivery
• Solid communications skills: the ability to understand comprehend and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.

Nice and nbsp;to and nbsp;have and nbsp;skills:

• Knowledge and nbsp;and and nbsp;understanding and nbsp;of and nbsp;Accessibility and nbsp;for and nbsp;Ontarians and nbsp;with and nbsp;Disability and nbsp;Act and nbsp;(AODA) and nbsp;and and nbsp;related and nbsp;regulations and nbsp;and and nbsp;standards
• Experience and nbsp;designing and nbsp;visual and nbsp;dashboards and nbsp;to and nbsp;highlight and nbsp;trends and nbsp;and and nbsp;Key and nbsp;Performance and nbsp;Indicators and nbsp;(KPIs) and nbsp;and and nbsp;developing and nbsp;canned and nbsp;reports and nbsp;(scheduled and nbsp;and and nbsp;adhoc)
• Experience and nbsp;with and nbsp;programming and nbsp;languages and nbsp;such and nbsp;as and nbsp;C# and nbsp;developing and nbsp;application and nbsp;code and nbsp;such and nbsp;as and nbsp;APIs and nbsp;Functions and nbsp;etc.
• Experience and nbsp;writing and nbsp;scripts and nbsp;with and nbsp;PowerShell and nbsp;and and nbsp;other and nbsp;scripting and nbsp;languages and nbsp;
• Experience and nbsp;in and nbsp;implementation and nbsp;of and nbsp;SaaS and nbsp;solution

and nbsp;

Software and nbsp;Developer and nbsp; and nbsp;Senior and nbsp; and nbsp;Evaluation and nbsp;Criteria

Description

Core and nbsp;Technical and nbsp;Skills: 50%

• Experience and nbsp;with and nbsp;the and nbsp;Microsoft and nbsp;suite and nbsp;of and nbsp;technology and nbsp;including: and nbsp;Azure and nbsp;Data and nbsp;Factory and nbsp;Azure and nbsp;SQL and nbsp;Database and nbsp;Azure and nbsp;Data and nbsp;Lake and nbsp;and and nbsp;Power and nbsp;BI
• Experience and nbsp;with and nbsp;developing and nbsp;data and nbsp;extraction and nbsp;transformation and nbsp;and and nbsp;load and nbsp;programs and nbsp;(daily and nbsp;and and nbsp;initial and nbsp;load) and nbsp;functionality and nbsp;on and nbsp;a and nbsp;wide and nbsp;range and nbsp;of and nbsp;data and nbsp;repositories and nbsp;(structured and nbsp;and and nbsp;semistructured and nbsp;files and nbsp;relational and nbsp;and and nbsp;multidimensional and nbsp;data and nbsp;stores)
• Experience and nbsp;with and nbsp;developing and nbsp;implementing and nbsp;and and nbsp;maintaining and nbsp;schedule/dependency and nbsp;logic and nbsp;for and nbsp;Extract and nbsp;Transform and nbsp;Load and nbsp;(ETL) and nbsp;scripts
• Experience and nbsp;with and nbsp;data and nbsp;integration and nbsp;data and nbsp;cleansing and nbsp;and and nbsp;data and nbsp;analytics
• Experience and nbsp;with and nbsp;data and nbsp;modeling and nbsp;and and nbsp;design and nbsp;principles and nbsp;for and nbsp;data and nbsp;marts and nbsp;and and nbsp;data and nbsp;warehouses
• Experience and nbsp;in and nbsp;database and nbsp;management and nbsp;and and nbsp;administration
• Experience and nbsp;in and nbsp;constructing and nbsp;complex and nbsp;SQL and nbsp;queries and nbsp;and and nbsp;performance and nbsp;tuning
• Experience and nbsp;creating and nbsp;technical and nbsp;documentation and nbsp;including and nbsp;ETL and nbsp;sourcetotarget and nbsp;mappings and nbsp;data and nbsp;model and nbsp;diagrams and nbsp;architecture and nbsp;artifacts and nbsp;detailed and nbsp;design and nbsp;documents and nbsp;etc.

and nbsp;

Other and nbsp;Technical and nbsp;Skills: 35% and nbsp;

• and nbsp;Experience and nbsp;designing and nbsp;visual and nbsp;dashboards and nbsp;to and nbsp;highlight and nbsp;trends and nbsp;and and nbsp;Key and nbsp;Performance and nbsp;Indicators and nbsp;(KPIs) and nbsp;and and nbsp;developing and nbsp;canned and nbsp;reports and nbsp;(scheduled and nbsp;and and nbsp;adhoc)
• Experience and nbsp;with and nbsp;programming and nbsp;languages and nbsp;such and nbsp;as and nbsp;C# and nbsp;developing and nbsp;application and nbsp;code and nbsp;such and nbsp;as and nbsp;APIs and nbsp;Functions and nbsp;etc.
• Experience and nbsp;writing and nbsp;scripts and nbsp;with and nbsp;PowerShell and nbsp;and and nbsp;other and nbsp;scripting and nbsp;languages
• Experience and nbsp;with and nbsp;Git and nbsp;and and nbsp;knowledge and nbsp;of and nbsp;source and nbsp;control and nbsp;strategies
• Experience and nbsp;in and nbsp;software and nbsp;development and nbsp;lifecycle and nbsp;from and nbsp;Development and nbsp;to and nbsp;Testing and nbsp;and and nbsp;Quality and nbsp;Assurance and nbsp;to and nbsp;Delivery

and nbsp;

Communications and nbsp;Skills: 10%

• Experience in eliciting documenting and validating business requirements
• Solid communications skills: the ability to understand comprehend and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.

and nbsp;

Standards and nbsp;and and nbsp;Best and nbsp;Practices: 5%

• Knowledge and nbsp;and and nbsp;understanding and nbsp;of and nbsp;Accessibility and nbsp;for and nbsp;Ontarians and nbsp;with and nbsp;Disability and nbsp;Act and nbsp;(AODA) and nbsp;and and nbsp;related and nbsp;regulations and nbsp;and and nbsp;standards

and nbsp;

Must Haves:

• Experience and nbsp;with and nbsp;the and nbsp;Microsoft and nbsp;suite and nbsp;of and nbsp;technology and nbsp;including: and nbsp;Azure and nbsp;Data and nbsp;Factory and nbsp;Azure and nbsp;SQL and nbsp;Database and nbsp;Azure and nbsp;Data and nbsp;Lake and nbsp;and and nbsp;Power and nbsp;BI
• Experience and nbsp;with and nbsp;developing and nbsp;data and nbsp;extraction and nbsp;transformation and nbsp;and and nbsp;load and nbsp;programs and nbsp;(daily and nbsp;and and nbsp;initial and nbsp;load) and nbsp;functionality and nbsp;on and nbsp;a and nbsp;wide and nbsp;range and nbsp;of and nbsp;data and nbsp;repositories and nbsp;(structured and nbsp;and and nbsp;semistructured and nbsp;files and nbsp;relational and nbsp;and and nbsp;multidimensional and nbsp;data and nbsp;stores)
• Experience and nbsp;with and nbsp;developing and nbsp;implementing and nbsp;and and nbsp;maintaining and nbsp;schedule/dependency and nbsp;logic and nbsp;for and nbsp;Extract and nbsp;Transform and nbsp;Load and nbsp;(ETL) and nbsp;scripts
• Experience and nbsp;with and nbsp;data and nbsp;integration and nbsp;data and nbsp;cleansing and nbsp;and and nbsp;data and nbsp;analytics