Responsibilities:<\/span><\/b>
<\/p>
- Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.<\/span>
<\/span><\/li>
- Required to translate technical systems specifications into working, tested applications.<\/span>
<\/span><\/li>
- This includes developing detailed programming specifications, writing and\/or generating code, compiling data\-driven programs, maintaining, and conducting unit tests.<\/span>
<\/span><\/li>
- Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.<\/span>
<\/span><\/li>
<\/ul> <\/span>
<\/p>General Skills:<\/span><\/b>
<\/p>
- Experience in programming and analysis; specialized software package support at the specified experience level<\/span>
<\/span><\/li>
- Ability to collaborate with IT Professionals throughout the Software Development Life Cycle<\/span>
<\/span><\/li>
- Experience in structured methodologies for the development, design, implementation and maintenance of applications<\/span>
<\/span><\/li>
- Experience in design, code, test, debug and document applications<\/span>
<\/span><\/li>
- Experience in the use of object and\/or third generation language development tools<\/span>
<\/span><\/li>
- Experience in one or more programming languages<\/span>
<\/span><\/li>
- Experience in application design, latest design patters, deployment and troubleshooting<\/span>
<\/span><\/li>
- Experience with relational and hierarchical database technologies<\/span>
<\/span><\/li>
- Experience in the use of information retrieval packages using query languages<\/span>
<\/span><\/li>
- Experience with one or more communications protocols<\/span>
<\/span><\/li>
- Experience in structured methodologies for the design, development, implementation and maintenance of applications<\/span>
<\/span><\/li>
- Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts<\/span>
<\/span><\/li>
- Excellent analytical, problem\-solving and decision\-making skills; verbal and written communication skills; interpersonal and negotiation skills<\/span>
<\/span><\/li>
- A team player with a track record for meeting deadlines.<\/span>
<\/span><\/li>
<\/ul> <\/span><\/b>
<\/p>ETL Skills:<\/span><\/b>
<\/p>
- Knowledge and experience in gathering requirements and business process knowledge in order to transform the data in a way thats geared towards the needs of end users<\/span>
<\/span><\/li>
- Knowledge and experience maintaining and improving already existing processes.<\/span>
<\/span><\/li>
- Knowledge and experience ensuring that the data architecture is scalable and maintainable<\/span>
<\/span><\/li>
- Knowledge and experience working with the business in designing and delivering correct, high quality data<\/span>
<\/span><\/li>
- Experience investigating data to identify potential issues within ETL pipelines, notify end\-users and propose adequate solutions<\/span>
<\/span><\/li>
- Experience preparing detailed documentation for further reference.<\/span>
<\/span><\/li>
<\/ul> <\/span>
<\/p>Desirable Skills:<\/span><\/b>
<\/p>
- Knowledge and experience with programming Internet\-ready applications<\/span>
<\/span><\/li>
- Knowledge and experience in rapid application development (RAD) methodologies<\/span>
<\/span><\/li>
- Knowledge and understanding of Information Management principles, concepts, policies and practices<\/span>
<\/span><\/li>
- Experience with middleware and gateways<\/span>
<\/span><\/li>
- Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging<\/span>
<\/span><\/li>
- Ability to provide post\-implementation support and resolve any post\-implementation technical issues<\/span>
<\/span><\/li>
- Experience conducting design walkthrough sessions with project team<\/span>
<\/span><\/li>
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards<\/span>
<\/span><\/li>
- Ability to provide user and system documentation as required<\/span>
<\/span><\/li>
<\/ul>
<\/div><\/span>
Requirements<\/h3>
Experience and Skill Set Requirements:<\/span><\/u><\/b>
<\/p>Must have:<\/span><\/u><\/b>
<\/p>
- Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI
<\/span><\/li>
- Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi\-structured files, relational and multi\-dimensional data stores)
<\/span><\/li>
- Experience with developing, implementing, and maintaining schedule\/dependency logic for Extract Transform Load (ETL) scripts
<\/span><\/li>
- Experience with data integration, data cleansing, and data analytics
<\/span><\/li>
- Experience with data modeling and design principles for data marts and data warehouses
<\/span><\/li>
- Experience in database management and administration
<\/span><\/li>
- Experience in constructing complex SQL queries and performance tuning
<\/span><\/li>
- Experience creating technical documentation including ETL source\-to\-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.
<\/span><\/li>
<\/ul>
<\/div>
Skill Set Requirements:<\/span><\/u><\/b>
<\/div>Responsibilities\/Assignment Deliverables â Senior ETL Developer:<\/span><\/b>
<\/p>
- Designs, develops, and maintains database back end and ETL applications for Data Warehouse and Business Intelligence solutions.<\/span>
<\/span><\/li>
- Uses knowledge of ETL languages and development techniques to build and expand application functionality by writing high\-quality code using appropriate patterns.<\/span>
<\/span><\/li>
- Ensures applications remain scalable while complying to standards and following best practices.<\/span>
<\/span><\/li>
- Tests and debugs applications and ensures that software is properly documented.<\/span>
<\/span><\/li>
- Collaborates clearly and professionally as part of a development team and communicates with clients.<\/span>
<\/span><\/li>
<\/ul> <\/span>
<\/p>Mandatory Skills:<\/span><\/b>
<\/p>
- Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI<\/span>
<\/span><\/li>
- Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi\-structured files, relational and multi\-dimensional data stores)<\/span>
<\/span><\/li>
- Experience with developing, implementing, and maintaining schedule\/dependency logic for Extract Transform Load (ETL) scripts<\/span>
<\/span><\/li>
- Experience with data integration, data cleansing, and data analytics<\/span>
<\/span><\/li>
- Experience with data modeling and design principles for data marts and data warehouses<\/span>
<\/span><\/li>
- Experience in database management and administration<\/span>
<\/span><\/li>
- Experience in constructing complex SQL queries and performance tuning<\/span>
<\/span><\/li>
- Experience with Git and knowledge of source control strategies<\/span>
<\/span><\/li>
- Experience creating technical documentation including ETL source\-to\-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.<\/span>
<\/span><\/li>
- Experience in eliciting, documenting, and validating business requirements<\/span>
<\/span><\/li>
- Experience in software development lifecycle from Development, to Testing and Quality Assurance, to Delivery<\/span>
<\/span><\/li>
- Solid communications skills: the ability to understand, comprehend, and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.<\/span>
<\/span><\/li>
<\/ul> <\/span>
<\/p>Nice to have skills:<\/span><\/b>
<\/p>
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards<\/span>
<\/span><\/li>
- Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad\-hoc)<\/span>
<\/span><\/li>
- Experience with programming languages such as C#, developing application code such as APIs, Functions, etc.<\/span>
<\/span><\/li>
- Experience writing scripts with PowerShell and other scripting languages<\/span>
<\/span><\/li>
- Experience in implementation of SaaS solution<\/span>
<\/span><\/li>
<\/ul> <\/span><\/span>
<\/p>Core Technical Skills:<\/span><\/b>
<\/p>
- Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI<\/span>
<\/span><\/li>
- Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi\-structured files, relational and multi\-dimensional data stores)<\/span>
<\/span><\/li>
