- The ETL developer will design, develop, and maintain solutions for ingestion, transformation, and loading data into our Enterprise Data Warehouse. The successful candidate will have strong experience developing configurable SSIS/T-SQL/Stored Procedures skills to load and extract data on SQL Server platform.
- ETL responsible for migrating our partners from one CRM system to ours, analyzing and understanding their data and primarily writing scripts to load their data into our Connect AMS. Need to fill position ASAP.
- Skill Set: SSIS, ADF or more often than not, simple SQL scripting for manual one-time loads.
Required Technical Skills:
- SQL Server 2008/2012/2014/2016/2019
- Transact-SQL (Creating stored procedures, views, functions)
- Light SQL Server DBA tasks: assign permissions, restore databases, identify error messages upon receiving failure notification of SQL Agent jobs, etc.
- Ability to troubleshoot and modify existing T-SQL scripts and procedures
- Strong experience developing and deploying configurable SSIS solutions
- Adherence to best practices for developing solutions using SQL Server.