SUMMARY OF PROFESSIONAL EXPERIENCE
• Having closed to 6 years of relevant experience in SQL, SSIS & ETL Development.
• Having 5 years of work experience in SSIS
• Experienced in creating objects such as Tables, Views, Indexes, Stored Procedures and User Defined Functions in observing Business Rules.
• Strong RDBMS concepts and experience in creating, maintaining, and tuning Stored Procedures, User Defined Functions using SQL Server, T-SQL.
• Extensive experience in T-SQL using SQL Server 2016/2014/2012 platforms.
• Experience in the implementation of Temporary tables, CTE and Table variable
• Hands on Experience in using Joins and Sub queries
• Familiar to work with String, Date, Aggregate and analytical functions
• Very Good experience in Building the Relationships using Constrains
• Extensively Worked on creating Views and Indexes
• Worked on Triggers to maintain the audit information
• Good experience in writing the store procedure, user defined functions and understanding of existing functionality or existing code
• Good knowledge on backup and restore the database
• Implemented error handling, Transaction
• Experience in design and development of SSIS packages.
• Working with various transformations such as Lookup, Conditional Split, Multicast, Derived column, merge, merge join and Tasks such as Dataflow task, Execute SQL, Execute Package, Bulk insert, File system, Data profiling task, For loop, for each loop etc., in Integration services development.
• Implemented event, error handling, package configuration and logging.
• Created Unit test cases and implemented Unit test results
• Having good knowledge on data warehousing concepts.
• Critical thinker and problem-solving skill.