Senior ETL Data Migration Developer
2 days ago
Toronto ON, Toronto Census Division, ON; Ontario, Canada
S M Software Solutions Inc
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.
Lead ETL development and data migration onsite in Toronto, applying complex SQL and Azure Data Factory to legacy modernization. This senior assignment is onsite five days weekly.
The Senior Software Developer – ETL supports the Ministry of Public and Business Service Delivery and Procurement. You will develop documented ETL processes, analyze legacy data, and oversee data and file migration to modernized solutions. The work includes Oracle, MS SQL Server, Azure SQL Database, and migration planning.
Key Responsibilities
Provide best-practice data and file migration solutions Profile legacy data and recommend cleansing activities Complete mapping, interfaces, mock conversions, and actual conversions Define testing strategies and verify data integrity Perform post-migration audits and reconciliation
Requirements:
Seven or more years developing and documenting ETL processes Experience with Azure Data Factory or Informatica Proficiency with complex SQL and PL-SQL queries Knowledge of Oracle, MS SQL Server, and Azure SQL Understanding of information management and master data concepts Apply senior ETL expertise, complex SQL, and migration planning skills to support Toronto public-sector modernization. #J-18808-Ljbffr
Key Responsibilities
Provide best-practice data and file migration solutions Profile legacy data and recommend cleansing activities Complete mapping, interfaces, mock conversions, and actual conversions Define testing strategies and verify data integrity Perform post-migration audits and reconciliation
Requirements:
Seven or more years developing and documenting ETL processes Experience with Azure Data Factory or Informatica Proficiency with complex SQL and PL-SQL queries Knowledge of Oracle, MS SQL Server, and Azure SQL Understanding of information management and master data concepts Apply senior ETL expertise, complex SQL, and migration planning skills to support Toronto public-sector modernization. #J-18808-Ljbffr