Nafees Farooqi

Senior Consultant Ms Sql Etl Ssis Engineer @Capgemini

Interfacing with business clients to clarify business requirements for technical design. • Building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server. • SSIS Advanced component experience required (transformation objects in data flow). • Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation, and long-term preparedness. • Implementing ETL Packages using Data Transformation Services (DTS) and SSIS 2005/2008. • Writing complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views. • Tuning T-SQL queries (DDL, DML and DCL) to improve the database performance and availability. • Objects creation such as Tables and Views, Table Normalization, User Created Data Types, User Profiles, Data Dictionaries, Data Integrity, Performance Tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency. • Developing to those technical specifications candidates must display the ability to develop solutions which are able to be leveraged across multiple platforms. • Documenting steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production. • Ability to create new and modify existing reports and using Data Transformation Services (DTS). • Remediation of issues found during testing candidates need to be problem solvers and troubleshoot existing code based on specifications provided. • Providing Production support responsibilities for the existing SSIS Packages. • Experience in using Data Transformation Services (DTS) converting DTS packages to SSIS 2008.