• Around five years of experience in IT industry.
• Strong knowledge of Software Development Lifecycle (SDLC) including requirements gathering, analysis, design, development, Reporting, Testing and implementation.
• Have programming skills in T-SQL, PL/SQL and experience in Oracle and SQL server databases.
• Strong understanding of Data warehousing concepts and ETL approach.
• Extensive experience in utilizing developmental tools like SQL Server management studio and SQL Server integration (SSIS).
• Expertise in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.
• Experience in creating Database Objects, writing of SQL Commands, Stored Procedures, Functions and creating Indexes.
• Expertise in creating ETL packages, building, deploying and validating them using SQL Server Integration Services (SSIS).
• Extensively used various SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.,
• Extensively worked on various control flow tasks such as Sequence container, execute process task, Execute package task, File system and XML tasks etc.,
• Knowledge of C# scripting that is used in SSIS Script task and Script components.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and performing root cause analysis for Data Mismatch.
• Extensive experience in data validation by writing complex SQL Queries.
•