Senior Etl Qa Analyst Resume
RI
SUMMARY
- Skilled professional having 9 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, Informatica).
- 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 and 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.
- Experience in validation of the Cognos Report/Query/Analytical Studio Report.
TECHNICAL SKILLS
ETL Tools: DataStage, Informatica
BI Tool: Cognos
Operating Systems: Windows XP/NT/2000, UNIX (HP, Solaris, AIX)
Databases: Oracle 10g/9i/8i, SQL-Sever
Testing Tools: Quality Centre (HP ALM), Beyond Compare
Web Languages: HTML & XML
Order Management System: IBM sterling commerce
PROFESSIONAL EXPERIENCE
Confidential, RI
Senior ETL QA Analyst
Responsibilities:
- Understanding the Business Requirements.
- Written the High level test scenarios and test cases to meet the business Requirement.
- Involved in Peer Review of the test cases, test condition and test scenarios.
- Execution of Test Scripts, Defects reporting and tracking by using ALM.
- Running the Batch jobs using the Control-M.
- Test Data preparation as per requirement.
- Preparation of SQL scripts to check the Data flow from the Source to Targets.
- Attended the triage calls with stake holders.
- Preparation of WSR/DSR
- Off shore /on site Co-Ordination.
- Used API's to validate IBM Sterling Commerce and validated Inventories in IBM Sterling Commerce web console.
- Coordinated the business team for UAT testing.
Environment: Informatica 9.0.1, Oracle 10g, HP ALM, Control-M, Oracle SQL Developer, UNIX, IBM Sterling Commerce
Confidential, Buffalo, NY
ETL /Data warehouse Test Analyst
Responsibilities:
- 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 Test data as per business scenario's.
- Preparation of SQL scripts to check the Data flow from the Source to Staging, Staging to Target Tables.
- Validated Cognos reports by preparing SQL queries.
- Preparation of WSR.
Environment: Data Stage 8.1, Cognos, Oracle 10g, QC 11(HP ALM), Control-M, Toad, UNIX
Confidential
ETL /Data warehouse Test Analyst
Responsibilities:
- 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.
Confidential
Manual Test Engineer/ Database Tester
Responsibilities:
- 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
Confidential
Manual Test Engineer
Responsibilities:
- 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 training at client site, also provide the timely training 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.
Confidential
ETL/Data Stage Test Engineer
Responsibilities:
- 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
Confidential
ETL/Data Stage Test Engineer
Responsibilities:
- 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