Robust experience in data warehousing and ETL design patterns
Technical skills:
Expert in Microsoft SQL Server and SSIS
Solid T-SQL programming and query optimization
Experience with SSRS and/or Power BI (preferred)
Knowledge of data modeling (Dimensional & OLAP)
Experience with performance tuning of ETL packages
Familiarity with Azure Data Factory or cloud ETL tools is a plus
Version control tools (e.g., Git, Azure DevOps)
key responsibilities:
Design, develop, and deploy SSIS packages for BIS BACH project
Analyze source systems and define ETL mappings
Ensure data quality, validation, and reconciliation processes
Optimize existing ETL workflows for performance and scalability
Troubleshoot ETL failures and production issues
Collaborate with business analysts, DBAs, and stakeholders
Document ETL processes and technical specifications