• Having around 5.5 years of experience of Professional experience in IT industry, Involved in projects with extensive usage of ETL tool like SQL Server Integration Services (SSIS) and SQL Server, Dataware House and Data Modelling• Experience in Data Modeling, data warehousing, data descriptive analysis.• Experience in data model creation technologies.SQL and TSQL:• Develop high-quality database solutions,Use T-SQL to develop and implement procedures and functions.• Review and interpret ongoing business report requirements.• Analyze existing SQL queries for performance improvements.• Develop procedures and scripts for data migration.• Provide timely scheduled management reporting.Data warehousing concepts:• Have a good knowledge on data warehousing concepts.• Good at data warehouse architecture• Good at identifying dimensions and facts.• Good at OLAP types and its operationsSSIS (ETL TOOL):• Good exposure to building ETL solutions using SSIS.• Used transformations for building data flows as per business requirements.• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into data warehouse.Tableau:• Good in creating visualizations based on requirement. • Experience in development of Sheets, Dashboards. • Good experience regarding creation of different types of graphs and charts. • Have a good experience on different data source formats such as excel etc. Data Modelling:• Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and MSSQL) and data tools (reporting, visualization, analytics).• Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models.• Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.• Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.• Hands-on modelling, design, configuration, installation, performance tuning, and sandbox POC.• Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
