-> 7+ years of expertise in information technology with an emphasis on data warehousing, data modeling, data integration, data migration, ETL process, and business intelligence.
-> Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
-> Excellent knowledge in Data Warehousing SDLC and architecture of ETL, reporting and BI tools, gathering requirements and analysis, dimensional modelling, metadata management and implementation of STAR, Snowflake schemas, Incremental loads/Change Data Capture and slowly changing dimensions.
-> Created tables, running ETL jobs, writing dynamic scripts to generate stored procedure, creating tables etc., Creating packages in the solution explorer (In EXTRACT, TRANSFORM AND LOAD) and writing SQL query in data flow task, creating variable, error handling process and writing functions.
-> Experience in Microsoft C# in script component of SSIS.
-> Strong experience with client interaction, understanding business applications, business data flow and data relations
-> Ability to interact with various levels of management to understand the requests and validate job requirements