Senior Data Developer – ETL-5

Realign Llc; Mississauga; On-site; CAD 80,000 - 110,000; Full time

Job summary

Realign Llc is seeking a skilled ETL/SQL Developer to analyze business requirements and translate them into robust technical specifications and data mappings. The role involves designing and maintaining SQL Server objects, developing SSIS packages, and migrating legacy DTS processes into modern workflows.

You will optimize queries, participate in data validation, and collaborate with upstream/downstream teams to ensure smooth file processing and end-to-end data integration.

Responsibilities

• 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/outbound files, parsing logic, transformation rules, and validation checks.
• 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.

Job description

• 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.