Description

Lead ETL design and development within a Business Intelligence and Data Warehousing environment.

This role is on-site.

Responsibilities

• Design and develop ETL processes using SSIS and T-SQL on MS SQL Server databases.
• Translate business requirements into technical data integration solutions.
• Manage data migration and integration projects end-to-end.
• Execute data analysis, design, unit testing, and integration testing.
• Assist with release planning and ensure data quality.

Required Skills

• 15+ years of overall professional experience.
• 12+ years focused on BI/DW and ETL design.
• Expertise in SSIS, T-SQL, and SQL Server.
• Strong proficiency in writing complex SQL queries.
• Hands-on experience with data migration workflows.
• Experience performing Unit Testing and Integration Testing.
• Bachelor's degree in a related field.

Preferred Skills

• Experience with Informatica, DataStage, or Discovery Hub.
• Background working within the Banking or Financial domain.

Key Skills

Education

Bachelor's degree