About the job RQ07956 - Sr Software Developer - ETL

Responsibilities

- Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
- Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven 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.

General Skills

- Experience in programming and analysis; specialized software package support at the specified experience level
- Ability to collaborate with IT Professionals throughout the Software Development Life Cycle
- Experience in structured methodologies for the development, design, implementation and maintenance of applications
- Experience in design, code, test, debug and document applications
- Experience in the use of object and/or third generation language development tools
- Experience in one or more programming languages
- Experience in application design, latest design patterns, deployment and troubleshooting
- Experience with relational and hierarchical database technologies
- Experience in the use of information retrieval packages using query languages
- Experience with one or more communications protocols
- Experience in structured methodologies for the design, development, implementation and maintenance of applications




- Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts
- Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
- A team player with a track record for meeting deadlines

ETL Skills

- Knowledge and experience in gathering requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end users
- Knowledge and experience maintaining and improving already existing processes.
- Knowledge and experience ensuring that the data architecture is scalable and maintainable
- Knowledge and experience working with the business in designing and delivering correct, high quality data
- Experience investigating data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions
- Experience preparing detailed documentation for further reference
- Knowledge and experience with programming Internet-ready applications
- Knowledge and experience in rapid application development (RAD) methodologies
- Knowledge and understanding of Information Management principles, concepts, policies and practices
- Experience with middleware and gateways
- Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging




- Ability to provide post-implementation support and resolve any post-implementation technical issues
- Experience conducting design walkthrough sessions with project team
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
- Ability to provide user and system documentation as required

Skills Experience and Skill Set Requirements

Core Technical Skills - 45%

- Demonstrates 5 - 10 years of experience designing, developing, and implementing ETL solutions using Azure Data Factory.
- Demonstrates development and solution design experience in an workplace where Azure Data Factory, and PowerBI are used together
- Experience in designing data warehouses and data marts for databases such as Oracle, SQL Server, Azure Blob, Azure SQL Database as well as having a strong understanding of the architectural implications associated with each platform in regard to ETL
- Experience in debugging mappings, transformations, mapplets, source qualifier files and queries
- Demonstrates experience with developing ETL solutions to populate data warehouses and create data extracts for the purpose of business intelligence reporting
- Demonstrates experience developing star schema multi-dimensional models
- Experience with developing, debugging and enhancing the performance of complex SQL queries
- Demonstrates experience using Power Designer to review data models, as well as make changes and generate DDL scripts
- Demonstrates experience developing application code package using Azure DevOps
- Demonstrates

📌 Sr Software Developer - ETL (Toronto)
🏢 Rubicon Path
📍 Toronto