We provide IT Staff Augmentation Services!

Etl/dw/qa Tester Resume

4.00/5 (Submit Your Rating)

Reston, VA

SUMMARY:

  • Nearly 7 years of experience in Software Quality Assurance and Testing of Stand Alone, Client Server, Web Based applications (GUI), Data Warehousing, ETL Testing, Reporting, Performance & 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
  • Working knowledge of XPath to identify web elements in UI and maintained test scripts
  • Performed Integration, Regression & End to End testing
  • Developed complicated SQL scripts for Regression, END to END and report based testing.
  • Developed and executed test scripts through automation tools.
  • Experienced in DW projects ETL tests against DW testing with Ab Initio/Informatica tools.
  • Good Knowledge of Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process
  • Experienced in verifying the data completeness, data transformation, data quality, integration testing, UAT & regression testing
  • Involved in user training sessions and assisting in UAT (User Acceptance Testing)
  • Knowledge Informatica power center for extraction, transformation and loading process.
  • Strong technical Knowledge of UNIX Utilities, automate process.
  • Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures, wrapper scripts.
  • 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 in Quality Center
  • Expert in review and analyze requirements, use cases, technical specifications and database designs, Preparing manual test cases and test data for Scenarios
  • Expert in Develop Master Test Plans, Test Designs, Test estimations, Specifications, Test Cases, Test Scenarios, Requirements traceability matrix, Test closure summary and Production check out documents.
  • Experience in performance testing by developing scripts using Vugen & identified bottlenecks Experienced in performing prod validation based on enhancement change request along with sanity check
  • Maintained QA documentation on 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 (Scrum/Kanban), 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 Training 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, Reston, VA

ETL/DW/QA Tester

Responsibilities:

  • Involved in requirements and solution spec analysis,design test cases and test data by mocking several files.
  • Responsible for testing xlms to verify the data completeness, data transformation, data quality and integration.
  • Involved in preparation of data sets for various complex scenarios as per the business logic.
  • Involved in web services, testing for requests and response using Postman
  • Prepared test data in both manual and automation test cases, including positive and negative Scenarios
  • Document and published test cases and results in ALM and logged defects using Rally.
  • Worked closely with system analyst and developers in setting up test data & scenarios as per business logic.
  • Executed scripts for various test scenarios to verify data transformation & Error handling
  • Involved in processing several data files to perform END to END testing.
  • Modified several data sheets, feature files for new enhancements as part of Automation.
  • Involved in identifying xpaths, web elements for new fixes and enhancements
  • Worked in an Agile Scrum Involved in Sprint planning, Grooming & Daily standup.

Environment: ALM 11.5, Agile/Scrum/Kanban, TOAD, MS PowerPoint, MS Excel, MS Word, MS-Visio 2007, MS Access, XML, Winscp, unix, Rally, Informatica, DOORS

Confidential, VA

ETL/DW/QA Tester

Responsibilities:

  • Responsible for testing packages using SSIS to verify the data completeness, data transformation, data quality, integration testing, UAT & regression testing.
  • Develop test scripts for the application and Involved in metrics gathering, analysis and reporting
  • Analyzed requirements, technical specifications and Prepared mock up files, manual test cases and test data, Scenarios for testing
  • Document and published test cases, test results in Rally along with defects.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and requirements, including identifying the tables and columns from which data is extracted
  • Coordinating with DBA team for DB trace and workflow system
  • Developed SQL scripts to perform a smoke test, END to END, Integration & Regression test
  • Worked closely with business analyst and developers in setting up test data for QA/UAT Environments
  • Developed several mock up files to perform Functional/Regression & Integration testing.
  • 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 front-end testing & loaded several data files across STG to DBO as part of the END to END.
  • 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 the Automation / UI, back-end coverage meetings to develop front end and backend test scenarios, Test cases
  • Wrote Test Strategy/ Test Script/Test Plan Reported Bugs and Tracked Defects using TFS,Quality Center
  • Developed test cases using Rally & maintained resulting in Sharepoint.
  • Worked on Data Extraction, Data Cleansing, Data Standardization and Data Quality for various business data feeds..
  • Worked in an Agile technology with Scrum & Kanban, Involved in Sprint planning, Grooming & Daily standup.
  • Created and executed test cases for jobs to upload master data to a repository.
  • Used Selenium as browser integration tool for testing
  • Identified web elements and xpaths as part enhancements for features files
  • Develop test scripts to automate the process of testing through Selenium WebDriver
  • Executed Automated Selenium script and reproduced failures manually

Environment: Quality Center, Agile/Scrum/Kanban, 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
  • 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 & Tested several complex reports generated by Cognos, including Dashboard, Summary Reports, Master Detail, Drill Down and Score Cards
  • Extensively tested several ad hoc and standard reports for data quality, fonts, headers & cosmetic in Cognos.
  • 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
  • Created Test Plan, Test scripts for system validation and user acceptance testing (UAT)
  • Tested and debug new enhancements and change requests using SQL, pl/SQL
  • Involved in Test scripts migration from Loadrunner to Performance Center.
  • 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.
  • Develop test scripts to automate the process of testing through Selenium WebDriver
  • Involved in querying using SQL and updating records and validate database records as expected.

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, SQL Loader, Jenkins, Loadrunner, Performance Center,Selenium,eclipse, JIRA,DOORS

Confidential, Richmond, VA

ETL Developer/ETL/DW tester

Responsibilities:

  • 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 including Dashboard, Summary Reports, Master Detail, Drill Down and Score Cards
  • Worked in an Agile technology with Scrum
  • Ensured that the mappings are correct and Conducted data validation testing
  • Worked with business analyst and developers in setting up test data
  • Developed graphs using GDE for cleansing and loading process by applying transformations
  • Developed wrapper scripts for jobs execution as part of ETL process
  • 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
  • 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 training 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 the Control-M / Autosys tool.
  • 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, 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

We'd love your feedback!