Talent.com
Acestack
Senior Data Developer - ETLAcestack • Mississauga, ON, Canada
Senior Data Developer - ETL

Senior Data Developer - ETL

Acestack • Mississauga, ON, Canada
5 hours ago
Job type
  • Full-time
  • Quick Apply
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.
Create a job alert for this search

Senior Data Developer - ETL • Mississauga, ON, Canada

Similar jobs

Senior ETL Developer - Hybrid Data Pipeline Lead

Randstad DigitalOakville, ON, CA
Full-time

A leading insurance firm in Canada is seeking a Senior ETL Developer to join their hybrid team.The role involves building efficient data pipelines and operationalizing high-quality data solutions.C... Show more

 • Promoted

Lead Full-Stack Data Engineer — ETL & Insights

Chord StrategyMississauga, Peel Region, CA
Full-time

A dynamic growth strategy consultancy in Metro Vancouver is seeking a Data Engineer to improve and maintain ETL processes.The ideal candidate is a leader comfortable with ambiguity and able to work... Show more

 • Promoted

Algebra Private Tutoring Jobs Maple

SuperprofMaple, Canada
CA$20.00 hourly
Full-time +1

Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi... Show more

 • Promoted

Food Delivery - Weekly Pay

Uber eatsKing, ON, CA
Full-time +2

Delivering with Uber is an alternative to a part-time or full-time job and can get you earning cash quickly.Delivering with Uber allows you to earn quick cash while maintaining the flexibility your... Show more

 • Promoted

Senior Data Engineer at BDO Digital

BDO CanadaOakville, Ontario, Canada
Full-time

Step up as a Senior Data Engineer at BDO Digital, specializing in Databricks and Azure.Lead impactful data projects and refine scalable data processes in a collaborative environment.In this promine... Show more

 • Promoted

Senior Data Analyst

Super.comMississauga, Peel Region, CA
Full-time

For our employees, our promise is that Super.We are more than a fast‑paced, high‑growth tech company; we care about our people and take career progression seriously.This is your career and our aim ... Show more

 • Promoted

Remote Senior Data Engineer: Scalable ETL & Data Platform

LumenaltaMississauga, Peel Region, CA
Remote
Full-time

A leading data engineering firm is seeking a Senior Data Engineer who can design and maintain effective ETL pipelines.The ideal candidate will have over 7 years’ experience and be proficient in Pyt... Show more

 • Promoted

Capital Markets Bigdata/ Sql Developer

Open Systems TechnologiesMississauga, Peel Region, CA
Full-time

We are looking for a Capital Markets Big Data/SQL Developer for a hybrid contract role in Mississauga.If you possess all the required skills, please apply with an updated resume and contact details... Show more

 • Promoted

Senior Data Engineer - Cloud ETL & BigQuery Expert (Remote)

ShyftLabsMississauga, Peel Region, CA
Remote
Full-time

A growing data product company in Canada is looking for an experienced Data Engineer to join its dynamic team.The candidate will design and maintain scalable ETL pipelines, oversee data infrastruct... Show more

 • Promoted

Senior Big Data Engineer: Spark & SQL | Mississauga Hybrid

AccuroMississauga, Peel Region, CA
Full-time

A leading technology firm in Mississauga is seeking a Big Data Engineer with strong SQL skills and extensive experience in Apache Hadoop and Spark.As part of a hybrid work environment, you will be ... Show more

 • Promoted

Senior Data Engineer

IKO North AmericaMississauga
Full-time

IKO is a Canadian owned and operated business with production facilities worldwide and has many years of unparalleled success in the roofing materials industry.Quality, integrity, and trustworthine... Show more

 • Promoted

CRM and Data Management Advisor - Spanish Required

Cuso InternationalVaughan, Ontario
Permanent

This Volunteer Placement is Located in:.Please submit a Spanish Resume and Statement of Interest.Open to Canadian Citizens and Permanent Residents of Canada only.This placement is an opportunity to... Show more

 • Promoted

Online Survey Participant: Work Remote and Earn Up To $25 Per Survey

Earn HausBradford West Gwillimbury, ON, CA
Remote
Full-time +1

Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion.You will help influence brand decisions on se... Show more

 • Promoted

Senior Developer

AdeccoMississauga, Peel Region, CA
Temporary

Recruitment Consultant @ Adecco | Human Resources, HRM, Training and Development | CHRP in process.Adecco is currently recruiting for a Senior Developer.This is a 6-month contract opportunity with ... Show more

 • Promoted

Blue Yonder/JDE Senior Analyst

Tom OlthoffMississauga, Peel Region, CA
Full-time

Blue Yonder/JDE Senior Analyst.Remote (Local to Toronto is a plus).Background Check & Drug Screen required.Oxford strategic client acquired a business unit and they will need some BlueYonder resour... Show more

 • Promoted

Finance Data ETL Lead (SSIS/SQL) – Contract

Signature IT World IncMississauga
Full-time

An IT services and consulting firm in Mississauga is looking for a US IT Recruitment Executive with at least 5 years of experience in data integration and ETL development.The ideal candidate should... Show more

 • Promoted

ETL/ELT Data Integration Engineer - Market Risk

Compunnel, Inc.Mississauga
Full-time

A technology solutions company based in Canada is looking for an experienced Data Integration Developer to enhance market risk IT systems.The ideal candidate will have over 6 years of IT experience... Show more

 • Promoted

Elder Care Provider Wanted - Experienced Elder Care Provider Needed In Vaughan, Ontario Competitive

ElderCare.comVaughan, Ontario, Canada
CA$20.00 hourly
Part-time

We are a family in Vaughan, Ontario, searching for a dedicated elder care provider to join us.This role is perfect for someone who can offer companionship and personal care on a part-time basis.The... Show more

 • Promoted

Senior Cloud Data Engineer: PySpark, Snowflake & ETL

ALLTECH CONSULTING SVC INCMississauga, Peel Region, CA
Full-time

A leading consulting service firm is seeking a Cloud Data Engineer to optimize data pipelines and design data solutions in a Databricks environment.The ideal candidate will have strong programming ... Show more

 • Promoted

Senior Data & Analytics Engineer

WagepointMississauga, Peel Region, CA
Full-time

Senior Data & Analytics Engineer.This range is provided by Wagepoint.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.At Wagepoint, we’re good pe... Show more