8+ years of IT experience focusing on o Data warehousing, Data modelling, Data integration, Data Migration, ETL process and Business Intelligence
- Data analysis and/or reporting along with strong knowledge of database and related technologies (SQL, OLAP, etc.)
- Analysing the multiple source systems and based on the business requirements build the transformation rules to extract, transform and load the data into target systems
- SQL Server database with ETL (SSIS, SSAS) and reporting tools (SSRS).
- Developing complex SSRS reports using SSIS packages.
- Implementing .Net, C# script tasks in SSIS o Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
- Strong understanding of Data Modelling (Relational, dimensional, Star and Snowflake Schema), Data analysis, and implementations of Data warehousing o Strong skills in ETL mappings to load the data from various sources into the Data warehouse with different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
- Developing stored procedures, functions, Views and Triggers, Complex queries using SQL Server and TSQL
- Database Development and Analysis
- Scheduling ETL and Data Refresh scripts
- Strong communication, decision making and organizational skills along with outstanding analytical and problem-solving skills to undertake challenging jobs. Able to work well independently and also in a team by helping to troubleshoot technology and business-related problems Technical Skills
- Database – Microsoft SQL Server 2018
- ETL tools - Microsoft SSIS, SSAS, SSRS
- BI & Reporting - Microsoft Power BI Tools
- Data Modelling - Logical Modelling, Physical Modelling, Relational Modelling, ER Diagrams, Dimensional Data Modelling (Star Schema Modelling, Snowflake Schema Modelling, FACT and Dimensions Tables), Entities, Attributes, Cardinality
- SQL Stored procedures, Functions, Views and triggers