Software Developer – ETL – Senior

Job Title: Software Developer – ETL – Senior
Location: Hybrid – Toronto, Ontario, Canada
Security Clearance: Required – Must be a Canadian Citizen or have 5+ years of Permanent Residency
Contract

About the Role
We are seeking an experienced Senior Software Developer – ETL to join our data migration team. In this role, you will be instrumental in validating the quality of data migration from a legacy application to Dynamics 365 CE in preparation for go-live. You’ll work closely with project managers, solution vendors, and stakeholders to ensure clean, accurate, and reliable data migration.

Key Responsibilities
Data Analysis: Assess and understand data in legacy applications, including structure, quality, and relationships.
Data Mapping & Transformation: Interpret existing migration code to understand mappings from legacy systems to Dynamics 365 CE entities and fields.
Data Testing & Quality Assurance: Define test cases, perform reconciliations, resolve discrepancies, and develop KPIs to track migration progress and quality.
Test Plans & Cases: Develop comprehensive test plans, test scripts, and validation processes covering extraction, transformation, loading, and verification.
Data Fix Development: Update migration code to address issues and ensure smooth transfer.
Documentation: Maintain detailed, accurate records of test plans, results, and updates.
Ongoing Support: Provide post-migration support, address data issues, and optimize processes in the new environment.
Compliance: Follow security procedures, architecture standards, and confidentiality guidelines; transfer knowledge to internal teams.
Mandatory Qualifications
5+ years in an ETL role with a deep understanding of data extraction, transformation, and loading principles.
Strong SQL skills with experience in Azure SQL Databases and Dataverse.
Knowledge of Microsoft Dynamics 365 Customer Engagement (CE).
Azure certifications (e.g., Azure Fundamentals, Azure Data Engineer Associate, Azure Database Administrator Associate).

Desired Skills & Experience
Experience with Azure ETL tools such as Synapse.
Knowledge of DataVerse/CDS, Data Entities, and APIs.
Strong data transformation skills (cleansing, enrichment, normalization).
Understanding of data governance, privacy regulations, and high-sensitivity data management.
Experience with Azure storage concepts, T-SQL, database design, and query performance tuning.
Familiarity with Azure Repos, Azure DevOps, CI/CD processes, and Synapse workspaces.
Tools: SQL Server Management Studio, Azure data tools, XRM Toolbox.
Application

Please send your resume to jim.nickolson@noramtec.com.
Only candidates selected for further consideration will be contacted by our recruitment team.