ETL Salesforce Integration Developer HYBRID
- Mississauga, ON
- Permanent
- Full-time
Work Experience: 5-7+ years ETL Developer, MS Access, SQL, T-SQL, SSIS, Data Mapping, SQL Stored Procedures, Salesforce Data Integration
Industry: HealthcareDESCRIPTION:
- 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 progress
- Collaborate with internal (architect, analyst, DBA and others) and/or external stakeholders where needed to solve problems
- Participate in the evaluation and identification of new technologies
- Bachelor's degree in Computer Science/Computer Engineering
- 5-7+ years of hands-on experience as a ETL Developer in a data warehouse environment, including ETL design, development, testing, and deployment
- Solid 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 code
- Salesforce Data Integration experience
- Ability to work independently or in a group under a limited degree of supervision
- Ability to work efficiently under pressure and manage multiple assignments