Description

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

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.
• Execute end-to-end software development, including data analysis and design activities.
• Perform unit testing, integration testing, and assist with release planning.

Required Skills

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

Preferred Skills

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

Key Skills

Education

Bachelor's degree