We provide IT Staff Augmentation Services!

Etl Tester Resume

West Chester, PA


  • 7 years of IT experience with emphasis onQuality Assurance in Manual testing on web based applications, Data Validation, Data Analysis, Data Quality and Data Warehousing testing experience. .
  • Good understanding of Software Development Life Cycle, Testing Methodologies and Testing Life Cycle
  • Proficient in analyzing and translating business requirements to testing requirements and creation of Test Specifications, Test Scenarios and Test Cases.
  • Experience in Black-box testing and White-box testing
  • Strong in writing SQL queries for data verification and backend testing
  • Expertise in identifying defects and Bug tracking
  • Good working experience with Business Intelligence tools Cognos & Micro Strategy
  • Excellent debugging and problem solving skills
  • Extensive experience working with Cross Functional Teams
  • Excellent communication and interpersonal skills, self starter, quick learner, team player


Testing Tools : Mercury QTP, Quality Center,Load Runner
ETL : Informatica Power Center
Reporting Tools : Cognos, Micro strategy, OBIEE
Scripting Languages : HTML, JavaScript, VBScript, SQL, XML, CSS
Web Servers : Web Sphere, IIS, Apache, Web Logic, VMWare
Defect Reporting Tools: Quality Center, Rational Clear Quest, Jira
Database : Oracle 9i/10g/11i, Sybase, DB2, SQL Server2005, Teradata
Operating Systems : Windows 9x/NT/XP, Vista, UNIX
Office Applications : MS Office (MS Word, MS Excel, MS Paint, MS Project, MS Outlook), Eudora, MS Visual Source Safe, Visio


ETL Tester Confidential, West Chester, PA
Sep 2010 to Present

  • Reviewed the Business requirement documents and developed test plan, test scenarios and detailed test cases.
  • Participated in business requirement walk through, design walk through and analyzed Business requirements
  • Worked with Development team and Business Analysts to analyze test scenarios and ensure that test cases are correct and complete.
  • Involved in Code review meetings.
  • Monitored the Informatica workflows using Power Center monitor, Checked session logs in case of aborted/failed sessions
  • Performed Verification, Validation, and Transformations on the Input data before loading into target database
  • Performed Full Load and Incremental Load Data Validations
  • Used SQL Assistant tool to connect to Teradata Database to validate data that was populated by ETL applications
  • Data validated between Source and Target by using DCB studio tool
  • Load target Teradata tables and validate using SQL statements
  • Worked on Quality Center to execute test cases, log defects and track resolution till the closing of defect after retesting
  • Participated in review, Scrum, Defect and status meetings

Environment: Informatica Power Center 8.6, DCB Studio, AMDOCS, CSG, Oracle 11g, Toad, Teradata, SQL Assistant, UNIX, Golden Gate

ETL & Report Tester Confidential, Chicago, IL
May 2010 to August 2010

  • Reviewed the Business requirement documents and developed test plan, test scenarios and detailed test cases.
  • Test Cases were incorporated both positive and negative test conditions.
  • Performed System, Integration, Regression and Performance Testing
  • Used Bugzilla for Defect Reporting and Defect Tracking
  • Tested Source and Target validations.
  • Written and executed SQL queries on database using TOAD to verify the report values
  • Participated in review, Scrum and status meetings
  • Tested different types of Reports
  • Performed Functional and Load Testing on Reports

Environment: Informatica Power Center 8.1, Micro Strategy 9, DART, Bugzilla, Load Runner 9, Oracle 11g, Toad, Windows XP

ETL & Report Tester Confidential, Glendale, CA
Sep 2009 to Apr 2010

  • Reviewed the Business and functional requirement documents and prepared test scenarios.
  • Created detail Test cases for each Subject Area.
  • Test Cases were incorporated both positive and negative test conditions.
  • Worked with Development team to create a suite of test data to exercise data validation and actual ETL functionality.
  • Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage in the Mercury Quality Center.
  • Executed Test cases and Submitted Defects in Quality Center.
  • Good experience in testing Source and Target validations.
  • Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful
  • Performed System, Workflow Integration, Regression and Performance Testing
  • Good experience in coordinating with offshore team
  • Written SQL Queries and executed them using Squirrel
  • Participated in review, Scrum and status meetings
  • Tested different types of Reports

Environment: Informatica Power Center 8.1, Micro Strategy 9, HP Quality Center 9.2, Sybase, DB2, UNIX, Windows XP

QA Engineer Confidential, Round Rock, TX
Sep 2008 to Jun 2009

  • Reviewed and analyzed the requirements to understand the functionality of the application and prepared Test Plan and Test Cases.
  • Interacted with developers and users to understand the functional specifications, Business rules and work flow of the project
  • Performed Smoke, Functional, Integration, Regression, Browser Compatibility(IE, Firefox, Netscape) on the application
  • Created and executed SQL Queries for Back-end testing
  • Responsible for identifying, reporting and tracking defects using Quality Center.
  • Actively participated in Defect Review Meetings and Weekly Status meetings.
  • Maintained IT standards regarding documentation and testing
  • Created Periodic Status Reports and Test Metrics and reported to the manager

Environment: C#, .Net, Java, Oracle 11i, TOAD, IBM Main Frame Tandem, HP Quality Center 9.2, XML, HTML, HTTP, HTTPS, Windows

QA Engineer Confidential, San Diego, CA
Oct 2007 to Aug 2008

  • Reviewed the Business Requirements document, System Design document and prepared the Test Plan.
  • Identified and preparedtest cases in HP/Mercury Quality Center
  • Participated in Design review meetings and Weekly Status Meetings
  • Performed Functional, Integration, Regression and End-To-End testing
  • Performed Positive, Negative and Adhoc testing
  • Performed database testing for verification of data integrity
  • Implemented the automate test suite for regression testing using Descriptive Programming in Quick Test Pro
  • Identified and submitted defects in defect tracking tool JIRA
  • Reported Test Execution status to the manager on daily basis

Environment:Java, Adobe Flex, Jira, Quality Center 9.0, QTP 9.2, SQL Server 2005, MS Excel, MS Word, HTTP, HTTPS, Unix, Windows XP

Software Tester Confidential, India
Mar 2005 to Jun 2007

  • Involved inFunctional Testing, Regression and Integration Testing
  • Performed back-end testing using SQL queries for data validations
  • Logged & Tracked Defects using Test Director.
  • Carried out Integration tests to check the interfacing between sub modules
  • Ensured that all Change Requests and defects are tested and approved before the release.
  • Worked with customers to develop user acceptance tests

Environment: Test Director, UNIX, Java, J2EE, Java Script, HTML, XML, PL/SQL and Oracle8i


  • Bachelors.

Hire Now