We provide IT Staff Augmentation Services!

Qa/etl Tester Resume

Columbus, OH

SUMMARY

  • 5 years of experience in manual testing on web based, Client/Server and data warehousing applications.
  • Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Professional experience in Integration, Functional, Regression, System Testing, Load Testing, Black Box and GUI testing.
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solution using Informatica Power Center, AbInitio and Data Stage.
  • Thorough understanding on Business Intelligence tools like MicroStrategy, Crystal Reports and Cognos.
  • Experience with Creating test plan, test cases and executed test cases and reported defects using in HP QC/ALM.
  • Experience in SQL and PL/SQL scripting.
  • Proficient in Test Automation using Selenium Tools Suite and preparation of automation test framework.
  • Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
  • Have a good experience in functional testing tools such as SOAP UI testing and QTP Automation testing.
  • Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
  • Extensively worked on Batch scheduling tool Autosys to run and monitor ETL jobs.
  • Tested the ETL Abinitio Graphs and Informatica mappings other ETL Processes (Data Warehouse Testing)
  • Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
  • Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements and developing Test Scenarios to support quality deliverables.
  • Experience in using Test Director and HP Quality Center for Bug Tracking and Defect Reporting.
  • Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement and observed design inconsistencies.
  • Test Automation skills and knowledge test tools for online applications e.g. Selenium ( ideallally including basic knowledge of java)
  • Good knowledge of JIRA defect tracking tool
  • Performed different testing task using various test scripts on selenium web driver for writing automated scripts.
  • Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
  • Strong working experience in Windows NT/2000/XP and UNIX environments
  • Clear understanding of business procedures and ability to work as an individual and as a part of a team.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/00/XP, NT, MVS, IBMMAINFRAMES MS-DOS, UNIX (Solaris 2.8), Linux, Lotus Notes

Software Languages: JAVA, J2EE, C, C++, XML, HTML, SOA, MQ Series, VB Script, .NET technologies (C#, ASP.NET, VB.NET)

Databases: Oracle 8.x/9.x/10.x, SQL Server 6.0/7.0/2000 , My SQL, Teradata

GUI: MS FrontPage, Visio, SharePoint Designer, Visual Studio

Bug Tracking Tools: Quality Centre, Test Director

Packages: MS Word, MS Excel, MS Power Point, MS Visio 2003.

Web Server: Apache Server, IIS 7.0 and Tomcat, Web Sphere Customer Centre, Web Server IIS

Reporting Tools: MicroStrategy, Crystal Reports, Cognos.

ETL Tools: Informatica, Data Stage, AbInitio

Data Modeling Tools: Erwin 3.5.1/4.x

DB Tools: TOAD, SQL*PLUS, SQL*Loader, SQL Navigator, AQT

Protocol: HTTP and FTP, SOA

Other Tools: Lotus Notes, SQL *Loader, TOAD, CVS, PVCS, Clear Case, Web methods, EAI, FTP, DVO, Web Methods

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

QA/ETL Tester

Technical Environment: Informatica Power Center, MicroStrategy, HP ALM, Autosys, Soap UI, Oracle, SQL, PL/SQL, DB2, SQL*Plus, Java, UNIX, Shell Scripting

Responsibilities:

  • Responsible for creating complete test cases, test plans, test data and reporting status ensuring accurate coverage of requirements and business processes. Analyzing requirements and creating and executing test cases.
  • Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
  • Worked in automating regression test cases using Selenium WebDriver and developed SQL queries to validate ETL mapping.
  • Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
  • Tested mapping for extracting, cleansing, transforming, integrating and loading data using Informatica ETL Tool.
  • Working with the Development team for process improvement and release planning.
  • Analyzed application data using the SQL to identify the ETL processes.
  • Executed workflows created in ETL Informatica by the developers then compared before and after transformation of data generated to ensure that transformation was successful.
  • Tested the entire compliance reports generated using MicroStrategy BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
  • Involved in test data creation for all the ETL mapping rules in migration of document Metadata.
  • Tested code from source to staging, staging to transform and transformed data to Migration into target DB.
  • Coordinated the testing activities with QA team for Functional and GUI testing, ETL Testing and defect tracking using HP ALM.
  • Generating Test Execution Report and Defect report from HP ALM.
  • Tested ETL applications in relational databases and flat files using Informatica and tested UNIX shell scripts written for ETL Processes to schedule workflows on Autosys.
  • Tested Web services (SOAP and REST) using SOAP UI and applications complete business flow.
  • Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
  • Extensively worked on Project Variables, Project Parameters to extract only the additional data added during that period.
  • Involved in writing Shell Scripts to load and extract information from files and Wrote complex queries to compare the counts and data from source to target. Performing database testing to verify backend database transactions.
  • Coordinating user acceptance testing activities for business groups and IT.
  • Participates in application release planning and status sessions.
  • Involving in formulating the test plan, procedures and Wrote test cases.
  • Involved with the automation team for automating the web application using selenium.
  • Developed automation test plans, high-level test cases based on business requirement specifications and design documents.

Confidential, Tempe, AZ

QA/ETL Tester

Technical Environment: HP Quality Center/ALM, Informatica Power Center, MicroStrategy, SOAPUI, Teradata, Oracle, SQL, PL/SQL, DB2, SQL*Plus, UNIX, Shell Scripting

Responsibilities:

  • Responsible for creating complete test cases, test plans, test data and reporting status ensuring accurate coverage of requirements and business processes.
  • Created, maintained and executed test scripts from Quality Center/ALM.
  • Maintained requirements and created traceability between requirements and test cases.
  • Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
  • Extracted Data from Oracle using Informatica Power Center ETL to the target database including SQL Server and used the data for Reporting purposes.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
  • Defects were tracked and prioritized using the HP Quality Center (QC)/ALM and analyzed variation between Expected and Actual results.
  • Analyzed application data using the SQL to identify the ETL processes.
  • Worked on Informatica to resolve production issues perform testing and debugging of mappings and reports Extraction of test data from tables and loading of data into SQL tables.
  • Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
  • Created the requirements Documentation for the MicroStrategy projects and also documented the MicroStrategy Environment. Tested data and cosmetics of MicroStrategy reports.
  • Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
  • Tested web services by generating XML SOAPUI Requests and validated the corresponding XML SOAPUI Responses.
  • Ensured data integrity and verified all data modifications and calculations during database migration.
  • Wrote and modified SQL validation scripts and writing scripts in SQL to validate the outputs.
  • Extensively worked on Project Variables, Project Parameters to extract only the additional data added during that period. Wrote complex queries to compare the counts and data from source to target.
  • Performing database testing to verify backend database transactions.
  • Relationship between requirements in the same module and also between different modules.
  • Extensively used Quality Center for documenting, organizing and tracking requirements.
  • Involving in formulating the test plan, procedures and Wrote test cases.

Confidential, Bedford, MA

ETL Tester

Technical Environment: SQL, PL/SQL, AbInitio, WinSQL, Quick Test Pro 8.0, Test Director, Unix (Solaris), Unix Shell Scripting, Windows NT/2000

Responsibilities:

  • Wrote Test Plans, which detailed the testing scope, testing requirements, success criteria, milestones and necessary resources. Manually performed Ad-Hoc testing, end-to-end testing and system testing.
  • Performed manual testing by entering positive values, negative values and boundary values to the application.
  • Performed Black box, Integration, Regression, Systems and Backend testing.
  • Created, maintained and updated regression suites upon receiving new build.
  • Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX shell scripting.
  • Involved in writing SQL statements to create test data for test cases and data validation tests to extract data from the tables. Used Teradata utilities to load the sample test data in to target tables.
  • Used to play with the queries in the Teradata SQL assistant.
  • Compared SQL results with application results by writing SQL queries.
  • Used SQL queries to test the migrated database for Back End Testing.
  • Wrote and modified required UNIX scripts and other SQL validation scripts and writing scripts in SQL to validate the outputs.
  • Backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases using TOAD.
  • Involved in writing Shell Scripts to load and extract information from files and tested the back end for data integrity in UNIX.
  • Involved in exporting the test cases form Microsoft Excel to Test Director and running the cases remotely in different hosts.
  • Tracking the Defects used the tool Test Director. Performed Black Box, Integration and Regression Testing. Investigated and reported bugs to the developers.

Hire Now