• Creating complex SSIS packages with error handling, using various tasks and transformations like Sequence Containers, For Loop and Foreach Loop Container, Script, Execute SQL, Execute Package tasks, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination, etc.• Transferring data from various OLTP data sources, MS Excel, JSON files, XML, Flat files, CSV files into SQL Server. • Configuring and scheduling SQL server agent Jobs to automate the business processes.• Creating and maintaining database mail to communicate reports to end-users.• Working on SSIS performance tuning using error handling, event handling, re-running of failed SSIS packages using breakpoints.• Troubleshooting, maintaining, and tuning database performance.• Troubleshooting T-SQL, SSIS package errors, and performance issues and addressing them as required.• Working with team members to gather business requirements, definition, and design of data source and data flows.