Description
You will design and implement ETL solutions to move data between source, staging, and warehouse destinations.
Responsibilities
- Design and develop SQL Server stored procedures, functions, views, and triggers for ETL processes.
- Build data transformations using SSIS to import files and migrate data between database platforms.
- Debug and tune SSIS processes to ensure efficient and accurate data movement.
- Test and prepare ETL processes for deployment across production and non-production environments.
- Create documentation for ETL processes, deployment packages, and installation procedures.
Required Skills
- 12+ years of experience in ETL development.
- Expertise in Microsoft SSIS.
- Advanced SQL development skills.
- Experience designing strategies for data transfer between upstream systems and ODS/Data Warehouses.
- Proficiency in building data transformations for FP&A systems.
- Experience with system and acceptance testing, including test plan development.
- Ability to analyze and implement data import strategies.