Job Title: Software Developer - ETL - Senior

Location: Toronto

Work Model: Onsite

Duration: 9 months

Extension: 2 Times

Must Haves

- Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI
- Experience with Databricks Platform
- Experience with the Amazon Web Services (AWS) suite of technology including: Amazon Aurora, Amazon Relational Database Search, Glue, OpenSearch, etc.
- 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)
- 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 source-to-target 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.

Description / Responsibilities / Skills

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.
- Resolves and troubleshoots technical problems which arise during the use and operation of software packages.
- Knowledge and experience ensuring that the data architecture is scalable and maintainable.
- Experience investigating data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions.
- Experience preparing detailed documentation for further reference.

Deliverables

- Designs, develops, and maintains database backend and ETL applications for Data Warehouse and Business Intelligence solutions.
- Uses knowledge of ETL languages and development techniques to build and expand application functionality by writing high quality code.
- Ensures applications remain scalable while complying to standards and following best practices.
- Tests and debugs applications and ensures that software is properly documented.
- Collaborates clearly and professionally as part of a development team and communicates with clients.

Experience & Skill Set Requirements

Other Technical Skills – 35%

- Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad-hoc)
- Experience with programming languages such as C#, developing application code such as APIs, Functions, etc.
- Experience writing scripts with PowerShell and other scripting languages

Standards and Best Practices – 5%

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

📌 Software Developer - ETL - Senior (Toronto)
🏢 InnosysTech
📍 Toronto