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.