Senior Data Developer - ETL

Job Role : Senior Data Developer ETL

Location : Mississauga, ON (Hybrid)

Job Type : Full time Permanent

Job Description

"Skills and Responsibilities:

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, and reconciliation.

Analyze legacy DTS packages and support migration or remediation into modern SSIS-based

workflows.

Optimize SQL queries, troubleshoot performance issues, and support database upgrade or

compatibility validation activities.File Processing and Integration

Build and support file processing workflows involving inbound files, outbound files, parsing logic,

transformation rules, and validation checks.

Work with CSV, XML, delimited, fixed-width, report files, PDF/AFP-related outputs, marker files, control

files, and other enterprise file formats.

Perform end-to-end execution checks, output validation, reconciliation, and issue analysis across data

and file-processing stages.

Coordinate with upstream and downstream teams to resolve file transmission, integration, data

quality, and environment-related issues.Testing, Release, and Support

Perform unit testing, integration testing, regression support, baseline comparison, and defect

remediation.

Support QA, client acceptance testing, production deployment, and post-deployment warranty

support activities.