Technical Skills:
- Extensive knowledge of Relational and Multidimensional Data Modeling, including dimensional modeling, star schema, and snowflake schema.
- Strong expertise in T-SQL programming, including SQL queries, stored procedures, triggers, views, functions, and query optimization.
- Expert-level experience with SQL Server Integration Services (SSIS), including:
- SSIS error handling and troubleshooting.
- SSIS Catalog management.
- Package deployment and configuration.
- Version control and documentation.
- Performance tuning and optimization.
- Strong experience in Data Warehousing and ELT processes, including data extraction, transformation, loading, and data validation.
- Reporting and analytics experience using IBM Cognos, SSRS, and Tableau.
- Experience creating and maintaining Data Dictionaries, Data Flow Diagrams (DFDs), and technical documentation.
- Strong ad-hoc data warehouse troubleshooting and problem-solving skills.
- Experience gathering data warehouse requirements, analyzing business needs, and translating them into technical solutions.
- Hands-on experience with Microsoft Azure Synapse Analytics.
- Experience developing and managing data integration pipelines using Azure Data Factory (ADF).
- Strong experience with Snowflake Data Warehouse, including data integration, ELT, and data processing.
Mandatory Skills for Resume Screening
Skill
Priority
T-SQL / SQL Server
Mandatory
SSIS
Mandatory
Data Warehousing / ELT
Mandatory
Relational & Multidimensional Data Modeling
Mandatory
Azure Synapse
Mandatory
Azure Data Factory
Mandatory
Snowflake
Mandatory
Cognos / SSRS / Tableau
Required
Data Validation / DFD / Data Dictionary
Required