We provide IT Staff Augmentation Services!

Datawarehouse/ Etl Tester Resume

Troy, MI

SUMMARY:

  • Over 7 years of experience as a Quality Assurance Test Analyst / Quality Assurance Engineer, performing Manual, Automation and ETL (Data warehousing) testing of applications and Data in the client server, web and mobile applications in internet/intranet environments using Unified Functional Testing (UFT), Mercury IT Governance center, IBM data Studio, Oracle SQL Developer, Data Stage, Main Frames, HP ALM etc.
  • Exposure in Finance, Banking, Automotive and Health Care industries.
  • Involved in Software Testing Lifecycle including Black Box, system, integration, database, performance, GUI, Functional, Regression, Unit testing, User Acceptance, Smoke testing and Sanity testing of both client - server and web-based applications.
  • Hands on experience with all phases of Software Development Life Cycle (SDLC) in Agile & Waterfall methodologies.
  • Well conversant with software testing methodologies including developing Test Plans, Test scenarios, Test Cases, Test procedures, Test reports, Requirements Traceability Matrix and documenting manual and automation tests.
  • Expertise in Manual/Functional Testing, Automation, ETL & Data warehouse Testing.
  • Creation and execution of Synchronization, parameterization, looping statements and Checkpoints in Automation testing.
  • Experience working with platforms and Databases like Oracle 11g, IBM data studio, DB2, Teradata, Mainframe, SQL Server, Informatica, DataStage and TOAD.
  • Proficient in using Microsoft Office tools and Well versed with SQL, PL/SQL and T-SQL queries to run the data integrity tests.
  • Excellent communication and interpersonal skills with problem solving abilities, effective in working independently and exceptional team player.

TECHNICAL SKILLS:

Operating Systems: MS Windows7-8-9-10, Unix, Linux Ubuntu

Testing Tools: UFT 12.5, QTP, IBM Data Studio, Toad, Oracle SQL developer, Data Stage, Tidal, & Quality Stage Director.

Languages: VB Script, JAVA, XML, UNIX, SQL, T-SQL & PL-SQL

Database Testing Platforms: SQL Server, Oracle, DB2, IBM DATA STUDIO, Mainframe, Teradata

Methodologies: SDLC, STLC, Agile, Waterfall, V Model

Bug Tracking & Management Tools: HP ALM 12.21, HP Quality Center, Version One, RTMs, MS Office Works, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Troy, MI

Datawarehouse/ ETL Tester

Responsibilities:

  • Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
  • Responsible for creating the Test Plans and given sign offs.
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules.
  • Validated the data in the reports by writing SQL queries in the transactional system.
  • Oversaw the historical loads in UAT and PROD environments.
  • Worked on Integration of all the processes in UAT/PROD.
  • Optimized/Tuned several complex SQL queries for better performance and efficiency.
  • Prepared the Test Cases after thorough analysis of each requirement.
  • Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
  • Conducted and actively participated in reviews, walk-throughs of Test Cases.
  • Reviewed the ETL mappings to ensure the transformation rules are applied correctly.
  • Executed the workflows in the workflow manager, to start the ETL process.
  • Created and executed SQL queries to perform source to target testing on DB2 database. Performed the following tests: Data Completeness, Validity, Uniqueness, Data Integrity, Data Transformation, Data Quality, Initial and incremental load tests
  • Coordinated with different users in UAT execution.

Environment: Oracle 11g, Version One, Agile, Data Stage, Unix, MS Work, Mainframe, Alpha, Advantage, Windows OS

Confidential, Auburn Hills, MI

QA Test Manager

Responsibilities:

  • Analyzed requirement documentation, functional specification, design documentation and identified test scenarios.
  • Created Test Plan, test strategy, Test Cases, scripts based on functional specification, prepared test data for testing.
  • Performed all types of manual testing including Functional, GUI Testing, Smoke, System, and Regression testing.
  • Created Defects and tracked the defects using HP ALM
  • Developed Traceability matrix, mapping Test Cases to the Requirements.
  • Plan, Schedule and Co-ordinate testing tasks in Quality Center.
  • Developed Automation Driver Component Scripts, common and application common reusable library functions, Configuration files and Recovery Scenarios using VB Script for UFT V12.5
  • Involved in executing SQL queries to verify database was updated.
  • Implemented QA best practices and required tools.
  • Extensively worked with all QualityCenter10 modules Management, Requirements, Test Plan, Test Lab, Defects and Dashboard.
  • Expertise working with Requirements Traceability Matrix in Quality Center.\

Environment: HP UFT 12.5, VBScript, Quality Center, Water Fall, HP ALM

ETL Test Lead

Confidential

Responsibilities:

  • Involved in analyzing system design specifications and developed Test Scenarios and Test Cases to cover overall quality assurance testing.
  • Worked on data validation of more than 1.3 million records using SQL in IBM Data Studio from Loans and deposits side.
  • Identified defects and errors in data prior to data processing.
  • Mitigated existing issues and provided solutions.
  • Collaborated with Back end and database developers.
  • Also, validated data writing macros.
  • Checked whether Data mapping is done correctly and matches the data.
  • Export requirement, Test Cases into the Quality Center, run manual and automation Test Cases from test lab and log defects from defects module.
  • Participated in peer review meeting for creating Test Plan, Test Cases and analyzing various testing documents and defined Testing strategy, scope, objectives, methodology, timeline, resources, environment.
  • Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
  • Updated RTM in daily, send status report and daily tracking report to test manager.
  • Involved in solving the production issue in mortgage ware house application (wire transfers system was crashing). So was playing a part as an automation tester for 3 weeks.

Environment: IBM Data Studio, HP ALM, MS Excel, SQL, TOAD, UFT, DB2

Confidential, Houston, Texas

Test Engineer

Responsibilities:

  • Involved in analyzing requirement documents to create Test Cases .
  • Prepared both positive and negative Test Cases for Functional , System , End-to-End Testing.
  • Conducted Peer Reviews to find and correct bad Test Cases .
  • Executed Test Cases manually to check GUI and Functional features of the application.
  • Prepared automated test scripts for Functional, UAT , and Regression testing using UFT .
  • Reported all defects to the appropriate individual(s) for resolution using Quality Center .
  • Performed browser compatibility testing on different platforms.
  • Performed back-end testing to ensure data consistency on front-end by writing and executing SQL queries.
  • Attended weekly update meetings with QA Manager to discuss the status of Projects.
  • Enter tasks in Microsoft Project and important milestones.
  • Performed knowledge transfer with teammates, as appropriate.

Environment: Windows XP, Quality Center, UFT, Visual Basic, SQL, PL/SQL, MS Office

Confidential, Herndon, VA

Quality Analyst

Responsibilities:

  • Involved in analyzing system design specifications and developed Test Plan s, Test Scenarios and Test Cases to cover overall quality assurance testing.
  • Perform both manual and automation testing and created various test results to track the testing results.
  • Export requirement, Test Cases into the Quality Center , run manual and automation Test Cases from test lab and log defects from defects module.
  • Followed up with standard software testing life cycle ( STLC ) to perform different types of testing for the projects.
  • Participated to create Test Analysis reports (TAR) and stored them into the Quality Center .
  • Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
  • Performed Functional Testing using Quality Center .
  • Developed automation scripts in QTP to automate smoke and regression testing.
  • Used Quality Center to execute automation scripts in batch mode or unattended mode.
  • Assisted the scripts in QTP by applying checkpoints, parameterizations, synchronization point, data driven tests and creating modular tests.
  • Met with client to present future functionality of the application, gather information from them to know about their need and send this information to test manager.
  • Assisted in smoke testing, Functional, Integration, System, user interface testing of the bank loan information web based application.
  • Experienced and worked in Agile environment

Environment: HPQC, QTP, Oracle, SQL, Windows, Agile Environment

Confidential, Chicago, IL

Manual/ Automation Test Engineer

Responsibilities:

  • Developed Test Plan s and documented Standard Testing Procedures for manual testing.
  • Played a key role in developing overall quality processes, metrics collection and change management.
  • Developed and executed Test Cases and Test Plan s for Functionality.
  • Executed, wrote, maintained test case script procedures, and documented test results.
  • Involved in creating traceability matrix to map requirement and Test Cases .
  • Reported software anomalies in accordance with the internal procedures.
  • Developed automation scripts in QTP .
  • Provided testing the GUI consistency against different browsers (running on windows) against various screen.
  • Performed Database Validation and Integration Testing and manipulations using SQL
  • Performed manual testing and maintained documentation on different types of testing like positive and Negative testing.

Environment: Quality Center, QTP, Windows, SQL, Water Fall Environment

Confidential, Houston TX

Manual Tester

Responsibilities:

  • Created and executed Test Cases for new features, while analyzing and documenting the test outputs
  • Managed result defects through re-testing cycles
  • Involvement in Manual testing methodologies
  • Involved in Graphical User Interface Testing ( GUI ) of the application
  • Preformed End-to-End Testing of the application

Environment: HP Quality Center, QTP, SQL, MS Office, Water Fall

.

Hire Now