
Automated and scheduled the Informatica jobs using UNIX Shell Scripting and Good at Unix Shell scripting and Automation of ETL process.Experience in Performance Tuning of SQL and Stored Procedures.Worked with Informatica transformations such as multi joins of heterogeneous flat files, connected/unconnected lookups, procedures, routers etc.Highly experienced with different RDBMS such as Oracle 10g, MS SQL Server 2000, Teradata.Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications and Teradata SQL Assistant for Teradata.Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Ab Initio, Informatica and SSIS.Experience in UNIT Testing, Integration Testing, System Testing Functionality, Regression, Performance Testing and User Acceptance Testing.Experience in preparing Test strategy, Developing Test plan, Test cases, and Writing test Scripts by Decomposing business Requirements and Developing Test scenarios to support quality deliverables.

Strong understanding of Test Methodologies and Test Plans in Project Life Cycles.Proficient in Data warehouse and Backend application Testing Life cycle.

