· Experience in design and development of SSIS packages.
· Working on Tasks such as Dataflow task, Execute SQL Task, Execute Package, Bulk insert, File system and Containers like for loop, for each loop in Integration services development.
· Expertise in creating SQL server Reports using SSRS.
· Designed different Types of reports like Drilldown reports, Drill through reports, Sub reports Parameterized reports.
· Worked on generating reports and publishing reports using SSRS.
· Having knowledge in Data warehouse Concepts.
· Having knowledge in SSAS.
· Having knowledge in POWER BI.
· Having knowledge tableau.
· Having knowledge GitHub & bit-bucket.
· Strong experience on creating tables and complex views.
· Strong experience on joins, sub quires, built in functions, Stored functions, stored procedures, Triggers, Indices, set operators ,CTEs.