Etl/dw/qa Tester Resume
VA
PROFESSIONAL SUMMARY:
- Over 7+ years of experience in Software Quality Assurance and Testing of Stand Alone, Client Server, Web Based applications (GUI), Data Warehousing and ETL Testing & Automation.
- In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
- Experienced in testing Web applications and client/server applications
- Experienced in automated testing and used browser integration tools like Selenium
- Developed and executed test scripts through automation tools.
- Working knowledge on Xpath to identify web elements in UI and maintained test scripts
- Experienced in DW projects ETL testing against DW testing with Ab Initio tools.
- Good Knowledge on Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process
- Strong technical Knowledge of UNIX Utilities, automate process.
- Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
- Knowledge of and ability to apply a wide range of software test engineering concepts: testing principles (Testing Methodology) and concepts, building a test environment, tracking defects n Quality Center
- Expert in review and analyze requirements, use cases, technical specifications and database designs.
- Expert in Develop Master Test Plans, Test Designs, Test estimations, Specifications, Test Cases, Test Scenarios, Requirement traceability matrix, Test closure summary and Production checkout documents.
- Maintained QA documentation in sharepoint site.
- Experienced in documenting defects, generate defect and test progress graphs with overall test summary/closure summary document.
- Well versed with various types Software Development methodologies - Waterfall, Agile, Iterative and extreme Programming.
- Experience in Software QA and Testing Methodologies, verification and validations in all phases of the SDLC.
- Excellent Technical, Interpersonal and solid communication skills with the ability to interact with end-users and managers and Experience in requirement gathering and End-users
TECHNICAL SKILLS:
Database: Oracle 11g/10g/9i,sybase 12.5, SQL Server 2005/2008/7.0 , IBM DB2, Teradata V2R6
Change Mgt Tools: Quality Center 11/10/9.2, Test Director 8.0, Rational Clearquest,TFS
Data Warehouse Tools: Ab Initio, Informatica
Test Automation Tools: Quick Test Pro 8.2/8.0, Selenium
Performance Tools: Loadrunner, Performance Center
BI Tools: Cognos 8.0 Series & Business Objects XIR3
Languages: PL/SQL, T-SQL, SQL,, Shell Scripting
Office Tools: MS Office Suite, MS Project, Microsoft Sharepoint
Operating System: UNIX, LINUX, Windows, MS-DOS
Rational Tools: Requisitepro, Clearcase, Clearquest 7.1, Manual Tester
Tools: TOAD 11.6, Win SQL,SSIS,SSMS, Teradata SQL Assistant, Bugzilla, JIRA,TFS,Rally
Web Technologies: XML, HTML, JavaScript, Xpath, VBScript
PROFESSIONAL EXPERIENCE:
Confidential, VA
ETL/DW/QA Tester
Responsibilities:
- Responsible for testing packages using SSIS to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
- Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting
- Developed SQL scripts to perform END to END testing as part of Integration.
- Involved as part of Support team for Prod Defects & tested several cleanup scripts
- Developed several mockup files for all subject areas as part of Integration & END to END.
- Developed test files, scenarios SQL Scripts and performed Smoke Test along with documentation.
- Developed Test Cases & Executed them using SSMS & Reported bugs and tracked defects using Rally &
- Analyzed the Functional requirements using Scenarios.
- Developed several SQL test cases both positive & Negative test scenarios to verify data Extraction, Error handling & loading from STG to DBO & Reports.
- Involved in UI Front End Application Testing for several client’s data.
- Performed backend to frontend testing & loaded several data files across STG to DBO as part of END to END.
- Involved in extensive DATA validation using SQL queries and backend testing
- Developed files, SQL Scripts to Performed Regression testing & Smoke Test.
- Wrote Test Strategy/ Test Script/Test Plan and Test Cases, Reported Bugs and Tracked Defects using TFS, Rally.
- Worked in an Agile technology with Scrum
- Worked closely with business analyst and developers in setting up test data for QA/UAT Environments
- Created and executed test cases for jobs to upload master data to repository.
- Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules & Transformations.
- Involved as part of Integration testing across multiple subject areas.
- Created Test scripts for Smoke & Sanity testing.
- Involved in Sprint planning & Grooming for releases.
- Prepared various test documents for ETL & END to END process.
- Document and publish test results, troubleshoot and escalate issues
Environment: Quality Center, Agile/Scrum, SSMS, SSIS, SQL Server, MS PowerPoint, MS Excel, MS Word, MS-Visio 2007, MS Access, Rally, TFS
Confidential, Rockville, MD
QA/Data Warehouse Tester
Responsibilities:
- Involved in understanding Requirement Documents.
- Wrote Test Plan, Test Strategy, Test Script, and Test Cases. Reported bugs and tracked defects using Quality Center
- Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detail, Drill Down and Score Cards
- Worked in an Agile technology with Scrum
- Worked with business analyst and developers in setting up test data
- Involved in requirements analysis by interacting with analysts for the creation of Data marts using Informatica.
- Extensively used Informatica power center for extraction, transformation and loading process.
- Writing complex SQL queries for data validation for verifying the Mviews, Reports.
- Involved in extensive DATA validation using SQL queries and backend testing
- Involved in testing the Cognos reports by writing complex SQL queries.
- Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
- As a Test lead participated in Automation/UI & backend coverage meetings to develop front end and backend test scenarios, Test cases
- Created Test Plan, Test scripts for system validation and user acceptance testing (UAT)
- Worked with Automation tool Jenkins.
- Involved in Test scripts migration from Loadrunner to Performance Center.
- Tested ad hoc and standard reports for Cognos.
- Tested several dashboards and deployed them across the organization to monitor the performance
- Performed Input Validations, User Interface Validations, Browser Compatibility testing and Navigation testing.
- Used Selenium as browser integration tool for testing
- Developed test scripts to automate process of testing through Selenium WebDriver
- Executed automated Selenium scripts and reproduced failures manually
- Worked on xpath to find web elements
Environment: Informatica Power center, TOAD 11.6, HP ALM Quality Center 11.0, Agile/Scrum, SQL Developer 3.1, Oracle 11g, IBM DB2, MS PowerPoint, MS Excel, MS Word, MS-Visio 2007, MS Access, Jenkins, Loadrunner, Performance Center,Selenium,eclipse, JIRA,DOORS
Confidential, Richmond, VA
ETL Developer/tester
Responsibilities:
- Involved in understanding Logical and Physical Data model using Erwin Tool
- Prepared the guides for UAT & Production readiness for entire Ab Initio ETL testing efforts.
- Prepared Execution procedure document format to prepare the Test cases based on mapping document.
- Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
- Worked in an Agile technology with Scrum
- Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
- Ensured that the mappings are correct and Conducted data validation testing
- Worked with business analyst and developers in setting up test data
- Developed several SQL queries for data retrieval from TERADATA and used every utility available in including MLOAD, FLOAD, FASTEXPORT, BTEQ AND TPUMP
- Conducted walk through and reviews of the documentation and Involved in daily scrum meetings for all iterations
- Writing complex SQL queries for data validation for verifying the Ab Initio ETL Mapping Rules
- Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
- Tested several dashboards and deployed them across the organization to monitor the performance
- Used SQL tools to run SQL queries and validate the data loaded into the target tables
- Involved in user sessions and assisting in UAT (User Acceptance Testing)
- Promoted Unix / Ab Initio application releases from development to QA and to UAT environments
- Working on Data Migration, Data Extraction, Data Cleansing, Data Profiling, Data Standardization and Data Quality for various business data feeds..
- Written extensive UNIX Shell scripting for error logging, cleanup, data archiving & job / Graph scheduling
- Preparing manual test cases and test data for Scenarios
- Developed Test Plans, Test Cases and Test Scripts for Data Validation testing.
- Implemented SDLC, QA methodologies and concepts in the Project
- Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
- Coordinating with DBA team for DB trace and workflow system
- Performed end-to-end testing of applications and coordinated with other teams.
- Experienced Batch Scheduling in theControl-M / Autosystool.
- Investigate root cause analysis of batch scheduling
- Created Test Plan, Test scripts for system validation and user acceptance testing (UAT)
- Used workflow manager for session management, database connection management and scheduling of jobs / Graph
- Used VBScripts in QTP to access webpage script variables
- Identified the test cases to be automated and performed data driven testing and GUI Checkpoints using QTP and enhanced the overall functionality of the application.
Environment: Ab initio GDE 1.14, Cognos, XML, Windows NT 4.0, SQL Server 2005, Agile/Scrum, Quality Center 10.0, DTS, Control-M, Autosys 4.5, SQL, Teradata V2R5 (BTEQ, MLOAD, FLOAD, TPUMP), TOAD, Teradata SQL Assistant 6.0, Oracle 10g, IBM DB2, MS PowerPoint, MS Excel, MS Word, MS-Visio 2007, MS Access, Flat Files, Korn Shell Scripting,QTP