Senior Data Developer
- Mississauga, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
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.
Prepare technical documentation, build guides, configuration notes, release notes, and handover documentation.
Investigate incidents, perform root cause analysis, recommend fixes, and document corrective actions.Offshore Coordination and Delivery Support
Coordinate daily with offshore development and QA teams to assign tasks, clarify requirements, track progress, and resolve blockers.
Review offshore deliverables for quality, completeness, standards alignment, and deployment readiness."
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.
Prepare technical documentation, build guides, configuration notes, release notes, and handover documentation.
Investigate incidents, perform root cause analysis, recommend fixes, and document corrective actions.Offshore Coordination and Delivery Support
Coordinate daily with offshore development and QA teams to assign tasks, clarify requirements, track progress, and resolve blockers.
Review offshore deliverables for quality, completeness, standards alignment, and deployment readiness."
More about this job
Responsibilities
Design, develop, and maintain SQL Server database objects and SSIS packages for complex ETL workflows. Coordinate with offshore teams to deliver high-quality data integrations and provide production support through root cause analysis.
Requirements
Requires expertise in SQL Server, SSIS, and various enterprise file formats for data extraction and transformation. Candidates must be able to translate business requirements into technical specifications and manage end-to-end testing and deployment.
Skills
- SQL Server
- SSIS
- ETL Development
- T-SQL
- Database Design
- Data Mapping
- Performance Tuning
- File Processing
- XML
- CSV
- Unit Testing
- Root Cause Analysis
- Technical Documentation
- Offshore Coordination
- Integration Testing
- Regression Testing
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Consulting
- Engineering
Keywords
- SQL Server
- SSIS
- ETL
- DTS
- Stored Procedures
- Views
- Indexes
- Data Mapping
- CSV
- XML
- AFP
- Unit Testing
- Integration Testing
- Regression Testing
- Root Cause Analysis
- Technical Specifications
- Data Validation
- Data Reconciliation
- Offshore Delivery
- IT Services
- IT Consulting
- Database Optimization
- Data Migration
- Technical Documentation
- Release Notes
- Deployment
- Data Quality
- Enterprise File Formats
- SQL Queries