About the role

Salesforce ETL Developer role focusing on SQL Server data migration for healthcare. Requires 5-7+ years ETL experience with SSIS, T-SQL, Salesforce Health Cloud, and data analysis.

Responsibilities

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 an 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, SQL Server database, Data analysis, Data migration, Salesforce Health Cloud, SOQL, PL SQL scripting. Ability to work independently or in a group under a limited degree of supervision. Ability to work efficiently under pressure and manage multiple assignments.