SQL Server / SSIS ETL Developer
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
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; no education requirement is stated.
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 Server
- SSIS
- ETL
- Oracle
- SQL
- Stored Procedures
- Functions
- Views
- Tables
- Indexes
- Complex Joins
- Subqueries
- Common Table Expressions
- Window Functions
- ROW_NUMBER
- RANK
- Triggers
- Query Optimization
- Performance Tuning
- Execution Plans
- Database Development
- Data Mapping
- Data Transformation
- Data Validation
- Data Integrity
- Data Security
- Database Structures
- Business Requirements
- Technical Specifications