- SSIS Packages migration experience from development server to production server using package configuration.
- Should have involved in the development, re-design, and deployment of new data extractions using SSIS.
- Should have solid experience in transferring data from heterogeneous databases.
- Should have hands-on experience in merging data from heterogeneous data sources (Oracle, MS Access, other ERPs like SAP, Siebel) to SQL Server latest editions using SSIS packages.
- Should have performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses for reporting purposes.
- Good experience in using control flows, FTP components, For Each loop and various flow tasks.
- Strong in handling Script Task component for meeting various business needs.
Database :
- Experience in analyzing Data Base and Data warehouses for optimal performance by creating appropriate indexing strategies, partitions and SQL code optimization.
- Experience redesigning and tuning existing stored procedures, triggers, views that ultimately to improve the performance of the queries using T- SQL.
- Should have worked with BCP Utility and Bulk Insert to load data from different data sources to SQL Server.
- Should have performed data profiling, cleansing, validation, and verification utilizing SSIS tasks and SQL stored procedures.
You received this message because you are subscribed to the Google Groups "Thivya Jothi" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thivyajothi284+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/thivyajothi284/CALXtW0si1i_iQuihBZFp3jUjFL58GAKGZtN%2BLiDq4cn0Cqq8bw%40mail.gmail.com.