We provide IT Staff Augmentation Services!

Sr. Etl/data Warehouse Test Analyst Resume

0/5 (Submit Your Rating)

Buffalo, NY


  • Skilled professional with over 8 YEARS of experience in IT industry with experience in Manual Testing and ETL Testing.
  • Excellent Testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies and disciplines.
  • Good understanding of Data Warehousing concepts, Data Model (Star Flake and Snow - Flake Schemas).
  • Expertise in ETL/DWH testing concepts and Good understanding of the ETL tool (Datastage).
  • Proficient in Designing Test Cases, Execution of Test Cases, Logging bugs, tracking of bugs with module wise till closure.
  • Good knowledge on Bug/Defect life cycle, Defect tracking and management.
  • Types of Testing involved for various projects are Sanity Testing, Functional Testing, Regression Testing, Integration Testing, GUI Testing, Compatibility Testing, UAT.
  • Involved from the Initiation of the Testing Project to the Closure Reports.
  • Involved in the creation of Test plans and Test schedules.
  • Proficient in coding using SQL.
  • Knowledge on UNIX environment.
  • Quick learner and excellent team player with good communication skills.
  • Having Knowledge on Cognos Reporting tool.


ETL Tool: DataStage

Operating Systems: Windows XP/NT/2000, UNIX (HP, Solaris, AIX)

Databases: Oracle 10g/9i/8i, SQL-Sever, DB2

Testing Tools: Quality Centre

Web Languages: HTML & XML


Confidential, Buffalo, NY

Sr. ETL/Data warehouse Test Analyst


  • Understanding the Business Requirements and writing the test scenarios and test cases based on the business Requirement.
  • Interacting with BA’s for any clarifications on the functionality.
  • Involved in Peer Reviewing the test cases, test condition and test scenarios.
  • Execution of Test Scripts, Defects reporting and tracking by using QC.
  • Running the Batch jobs using the Control-M.
  • Preparation of SQL scripts to check the Data flow from the Source to Staging, Staging to Target Tables.
  • Preparation of WSR.

Environment: Data Stage 8.1,Oracle 10g, QC 11(HP ALM), Control-M, Toad, UNIX


Sr ETL /Data warehouse Test Analyst


  • Reviewed the HLD and BRD Documents to understand the Requirements.
  • Prepared the test plan and Test Schedule Documents.
  • Created and Executed Test cases using QC.
  • Prepared complex SQL Queries to validate source and target Tables.
  • Validate the source (SAS) Interface Files by using Unix Commands.
  • Prepared reports such as status report, defect report for Project manager to track the project progress.
  • Interacted with the development team to get the Defects resolved.
  • Regular interaction with Onsite Coordinator to update testing status.
  • Performed the Sanity, Regression Testing after every code release.
  • Conducted team meetings to resolve issues during testing.
  • Created Test Data to cover all the functional/Business test scenarios.

Environment: Data Stage 8.1, DB2 9.5, QC 9.2, Citrix Client, UNIX.


Manual Test Engineer/ Database Tester


  • Understanding Use Case Scenarios of Project UNO
  • Prepared Business and Test Cases/Scripts.
  • Created simple and complex SQL queries to validate Source and Target tables.
  • Executed TC scripts using QC.
  • Managed Defect life cycle and follow up in QC
  • Interacted with onsite people on regular basis for project updates.
  • Conducted the system testing successfully.
  • Given KT to the new team members.

Environment: Aqua Data Studio 4.5, IBM DB2 8.1, IBM Data Studio 2.2.1, QC 9.2


Manual Test Engineer


  • Involved in writing the test scenarios and test cases against the business Requirement.
  • Involved in Peer Reviewing the test cases, test condition and test scenarios against the business Requirement.
  • Execution of Test Scripts and Preparation of Daily status Report.
  • Defect Management.
  • Responsible for providing at client site, also provide the timely on new functionalities received in change Request to team members.
  • Running the SOD and EOD jobs using the UNIX.
  • Prepared SQL scripts to check the back end database.
  • Interacting with BA for any queries related to functionality.
  • Interacting with Development team for timely resolve of issue.
  • Query resolving of UAT team.

Environment: Oracle 9i, QC 9.2, Citrix Client, Toad, UNIX.


ETL/Data Stage Test Engineer


  • Understanding Functionalities as per the Client.
  • Verifying the data in target database by ETL process
  • Verified column mapping between source and target
  • Prepared test data for functional & Integration testing
  • Interactions with BA & Dev teams to resolve the issues.
  • Reporting daily testing status.
  • Designed, Reviewed & Executed Test cases.
  • Identified Test cases for Regression testing
  • Defect Analyzing and Reporting in QC
  • Communication with client for Data management.
  • Test case execution.

Environment: Data Stage 7.5.1EE, Oracle 9i, Sun Solaris, Quality Center 9.2


ETL/Data Stage Test Engineer


  • Analyzing the ETL Job flows and preparing test cases
  • Running the jobs in Datastage6.0 and 7.5.1 versions taking screenshots
  • Prepared TPD (Test plan document) and Test Cases
  • Preparing Test plan based on Source to Target mapping sheets
  • Involved in generating Test Scripts for System Testing, Integration Testing, Regression Testing and Acceptance Testing.

Environment: Ascential Data Stage EE 7.5.1(PX), Oracle, UNIX Script, Citrix Client, Quality Center 8.2

We'd love your feedback!