Strong RDBMS concepts and experience in creating and maintaining database objects like Tables, Stored Procedures, Triggers, Indexes and Views using SQL Server, T-SQL
Experience in implementing business transformation logic using ETL Tools, Stored procedures
Good experience in data testing, build data validation
Experience in Test case preparation for data validation, execution, Defect Tracking & develop Test Reports and defect Reports.
Experience in using SSIS tools like Import and Export Wizard, Package Installation and SSIS Package Designer On On-Premise and MS Azure databases
Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS utility
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Pivot, Un-Pivot, Script task, Fuzzy Lookup etc.
Experience in designing and developing Dashboards and Analysis Flows using Power BI, SSRS, Tableau
Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability. Optimizing queries by creating clustered, non-clustered indexes and indexed views
Created SSIS Packages to extract data from various data sources like Oracle, SQL Server, SFDC, SharePoint using various data connectors & plug-ins (OData, ADF, ODBC, etc.)