Description

You will build and maintain ETL solutions to move data from upstream systems into the data warehouse.

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 and other ETL processes to ensure data accuracy and efficiency.
• Implement and maintain database objects including tables, views, indexes, and security settings.
• Develop strategies for transferring data between source, staging, and ODS/Data Warehouse destinations.

Required Skills

• 3 years of experience in data integration or ETL development.
• Proficiency with Microsoft SSIS.
• Strong experience designing and developing SQL Server stored procedures, functions, and triggers.
• Experience managing database objects such as tables, views, and indexes.
• Ability to analyze and implement data transfer strategies between source and staging layers.
• Experience with system and acceptance testing, including test plan development.
• Working knowledge of .NET.

Key Skills

Education

Not specified