Senior Data Developer – ETL-5

4 hours ago

Mississauga, Ontario, Canada Realign Llc Full-time

Free with email or Google

Save this job and keep your search organized

Create a free account to save jobs, create alerts and return to this listing from your dashboard.

Free with email or Google

By continuing, you agree to our Terms & Privacy Policy.

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.

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.

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.