Closed listing
SQL Server / SSIS ETL Developer
- Toronto, ON, Canada
Contract
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Contract
- Closing date
- Posting language
- English
- Posted
Similar jobs hiring now
Added
Technical Analyst, Database
Michael Garron Hospital · Toronto, ON, Canada
Added
Solution Designer Generative AI Applications
CIBC · Toronto, ON, Canada
Added
Solution Designer Generative AI Applications
CIBC · Toronto, ON, Canada
Added
Data Engineer
MCAP · Toronto, ON, Canada
Original job description
Archived listing. The details below describe a past opening.
Role: SQL Server / SSIS ETL Developer
Location: Toronto, ON – Hybrid
Contract Role
Job Description
Database and ETL Development Analyze business requirements and convert them into technical specifications, data mappings, ETL rules, and implementation tasks. Design, develop, and maintain SQL Server database objects including tables, stored procedures, functions, views, indexes, and scripts. Develop, enhance, and troubleshoot SSIS packages for data extraction, transformation, loading, validation
SQL Developer with strong expertise in writing and optimizing complex SQL queries. The candidate will be responsible for performance tuning, database development, and ensuring efficient data retrieval to support business applications and reporting needs.
Key Responsibilities
Develop, write, and maintain complex SQL queries, stored procedures, and functions Perform query optimization and performance tuning Analyze and improve slow-running queries and execution plans Design and implement efficient database structures and indexing strategies Work closely with application and data teams to understand data requirements Troubleshoot data-related performance issues Support ETL processes and data transformations (if applicable) Ensure data integrity, consistency, and security Document database designs, logic, and optimization techniques
Required Skills
Strong expertise in SQL (Oracle / SQL Server ) Hands-on experience in:
Complex joins, subqueries, and CTEs
Window functions (ROW_NUMBER, RANK, etc.) Stored procedures, triggers Experience in query optimization and performance tuning
More about this job
Responsibilities
Develop and maintain SQL Server database objects and SSIS packages, translating business requirements into technical specifications, data mappings, and ETL rules. Optimize queries and database structures, troubleshoot performance and data issues, support data transformations, and document database designs and logic.
Requirements
Requires strong SQL expertise with Oracle or SQL Server and hands-on experience writing complex queries using joins, subqueries, CTEs, and window functions. Experience with stored procedures, triggers, query optimization, and performance tuning is required.
Skills
- SQL
- SQL Server
- Oracle
- SSIS
- ETL Development
- Complex Queries
- Stored Procedures
- Functions
- Triggers
- Query Optimization
- Performance Tuning
- Execution Plans
- Database Design
- Indexing Strategies
- Data Mapping
- Data Integrity
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
Keywords
- SQL
- SQL Server
- Oracle
- SSIS
- ETL
- Database Development
- Stored Procedures
- Functions
- Triggers
- Views
- Tables
- Indexes
- Complex Joins
- Subqueries
- Common Table Expressions
- Window Functions
- Query Optimization
- Performance Tuning
- Execution Plans
- Data Extraction
- Data Transformation
- Data Loading
- Data Validation
- Data Mapping
- Data Integrity
- Data Security
- Database Structures
- Business Requirements
- Technical Specifications