NOTE : HYBRID work model, 2-days / week in office. Office located in Mississauga, Ontario.
Type : 6 Month Contract, 8 hours / day, 40 hours / week
Work Experience : 5-7+ years ETL Developer, MS Access, SQL, T-SQL, SSIS, Data Mapping, SQL Stored Procedures
Industry : Healthcare
DESCRIPTION :
- Design, develop, and maintain ETL processes focused on SQL Server for data migration
- Perform development lifecycle tasks, including : Analyze and understand data sources and targets to create effective data migration strategies.Develop data migration solutions from scratch or adapt existing components.Implement data pipelines, schedule and orchestrate jobs, and automate migration tasks.Design, code, and debug according to pre-determined standards; participate in code reviews as required.Perform unit testing, integration, and performance testing to ensure data accuracy and integrity.Promote ETL processes to different environments using SSIS
Document ETL processes, data mappings , and migration solutions.
Be proactive and provide status of effort accomplished, estimates of remaining effort, and issues impacting progressCollaborate with internal (architect, analyst, DBA and others) and / or external stakeholders where needed to solve problemsParticipate in the evaluation and identification of new technologiesREQUIREMENTS :
Bachelor’s degree in Computer Science / Computer Engineering5-7+ years of hands-on experience as a ETL Developer in a data warehouse environment, including ETL design, development, testing, and deploymentSolid understanding of database migration and experience and knowledge of Databases and ETL SQL Server, T-SQL, Stored Procedures, Performance Tuning, Debugging, Optimizing Stored Procedures SSIS Data Mapping MS Access Converting business logic into SQL codeAbility to work independently or in a group under a limited degree of supervisionAbility to work efficiently under pressure and manage multiple assignmentsTagged as : CI / CD, Data Mapping, Databricks, Developer, DevOps, ETL, ETL Strategy, Excel, GitHub, integration, Jira, MS Access, PowerShell, Salesforce, snowflake, SSIS