Senior Data Developer - ETL

Acestack; Mississauga; On-site; CAD 90,000 - 130,000; Full time

Job summary

Acestack in Mississauga, ON is seeking a Senior Data Developer - ETL to design, develop, and optimize data integration workflows using SQL Server and SSIS. You will coordinate with offshore development and QA teams to deliver reliable ETL solutions.

The role focuses on database development, file processing, validation, and production support, including performance tuning, testing, and documentation to ensure smooth data movement across systems.

Qualifications

• Strong hands-on experience with SQL Server and SSIS.
• Expertise in database development, SQL query optimization, and performance troubleshooting.
• Strong understanding of ETL processes, data mapping, transformation, validation, and reconciliation.
• Experience with legacy DTS packages and migration to SSIS.
• Experience with enterprise file processing and multiple file formats.
• Strong testing, production support, troubleshooting, and root-cause analysis skills.

Responsibilities

• Analyze business requirements and translate them into technical specifications, data mappings, ETL rules, and implementation tasks.
• Design, develop, and maintain SQL Server objects, including tables, stored procedures, functions, views, indexes, and scripts.
• Develop, enhance, and troubleshoot SSIS packages for data extraction, transformation, loading, validation, and reconciliation.
• Analyze legacy DTS packages and support migration or remediation to modern SSIS-based workflows.
• Optimize SQL queries and troubleshoot database performance issues.
• Support database upgrades and compatibility validation activities.

Skills

SQL Server

SSIS

Database dev

ETL

DTS migration

File processing

Data quality

Testing

Offshore coordination

Job description

• Job Title: Senior Data Developer - ETL


• Location: Mississauga, ON


• Work Model: Onsite


• Job Type: Full Time (FTE)

Job Description

We are seeking an experienced Senior Data Developer - ETL with strong expertise in SQL Server, SSIS, database development, and enterprise file processing. The ideal candidate will be responsible for designing, developing, optimizing, testing, and supporting data integration workflows while coordinating with offshore development and QA teams.

Key Responsibilities

Database & ETL Development

• Analyze business requirements and translate them into technical specifications, data mappings, ETL rules, and implementation tasks.


• Design, develop, and maintain SQL Server objects, including tables, stored procedures, functions, views, indexes, and scripts.


• Develop, enhance, and troubleshoot SSIS packages for data extraction, transformation, loading, validation, and reconciliation.


• Analyze legacy DTS packages and support migration or remediation to modern SSIS-based workflows.


• Optimize SQL queries and troubleshoot database performance issues.


• Support database upgrades and compatibility validation activities.

File Processing & Integration

• Build and support inbound and outbound file-processing workflows, including parsing, transformation, and validation.


• Work with CSV, XML, delimited, fixed-width, report, PDF/AFP, marker, and control files.


• Perform end-to-end execution checks, output validation, reconciliation, and data-quality analysis.


• Coordinate with upstream and downstream teams to resolve transmission, integration, data-quality, and environment issues.

Testing, Release & Production Support

• Perform unit, integration, and regression testing, including baseline comparisons and defect remediation.


• Support QA, client acceptance testing, production deployments, and post-deployment warranty activities.


• Investigate incidents, perform root-cause analysis, recommend solutions, and document corrective actions.


• Prepare technical documentation, build guides, configuration notes, release notes, and handover documents.

Offshore Coordination & Delivery

• Coordinate with offshore development and QA teams to assign tasks, clarify requirements, track progress, and resolve blockers.


• Review offshore deliverables for quality, completeness, standards compliance, and deployment readiness.


• Support effective communication between onsite stakeholders and offshore teams to ensure timely delivery.

Required Skills

• Strong hands-on experience with SQL Server and SSIS.


• Expertise in database development, SQL query optimization, and performance troubleshooting.


• Strong understanding of ETL processes, data mapping, transformation, validation, and reconciliation.


• Experience with legacy DTS packages and migration to SSIS.


• Experience with enterprise file processing and multiple file formats.


• Strong testing, production support, troubleshooting, and root-cause analysis skills.


• Experience working with distributed/offshore development and QA teams.


• Strong communication, documentation, and problem-solving skills.