We provide IT Staff Augmentation Services!

Sr.etl Tester Resume

Richmond, Va

SUMMARY:

  • Over 8 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms. * Expertise in Automated Software Quality Testing & Manual Testing of Web based and Client - Server applications.
  • Experience in Data Warehouse applications testing using Informatica Power Center and Data stage on multiple platforms. * Possess excellent skills in Automation Testing using Mercury´s Quick Test Pro (QTP), Win Runner and Quality Center.
  • Perform Business Analysis, Data Analysis for diverse industries and technical environments including Business Intelligence for Data Mart and Data Warehouse and delivery of detail Project Documentation.
  • Well versed with various types Software Development methodologies- Waterfall, Agile, RUP, Iterative and Extreme Programming.
  • Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
  • Experienced in DW projects ETL testing against DW testing with data stage tools.
  • Experience with Agile Methodology.
  • Worked with SOAPUI for testing Web Services.
  • Strong testing Quality Assurance experience within agile environment.
  • Good Knowledge on Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process
  • Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
  • Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
  • Proficient in SQL, PERL, Shell Scripting and PL/SQL coding and experience in Performance Tuning of SQL and Stored Procedures.
  • Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center.
  • Experience in testing Business Report developed in Cognos
  • Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
  • Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
  • Well versed in GUI application testing, Database testing and Front-end testing.

TECHNICAL SKILLS:

ETL/DW Tools: Data StageOLAP Tools: Business Objects, Cognos, etc..

Data Modeling: Erwin, Microsoft Visio, Rational Rose (UML), ER Studio

Operating Systems: Windows NT/2000/2003/XP/2008, UNIX, Solaris and MSDOS

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2012, DB2, MS Access, Teradata V2R5.

Testing Tools: Quality Center, Test Director, JIRA, HP Quality Center 9.0/9.2/10.0, Doors, MS TestManager

Languages: XML, SQL, PL/SQL, C,C++, VB

PROFESSIONAL EXPERIENCE:

Confidential, Richmond VA

Sr.ETL Tester

Responsibilities:

  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0.
  • Experience in ETL Data Warehousing, database testing using DataStage for Workflow process
  • Create various test Batch jobs to run and monitor group of jobs with DataStage Director.
  • Worked on DataStage Version Control Tool for Migrating jobs from one environment to another environment
  • Extensively used DataStage Designer to develop the Parallel jobs and Server jobs
  • Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
  • Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
  • Use SQL, PL/SQL to validate the Data going in to the Data Ware House
  • Created test data for testing specific ETL flow.
  • Tested the ETL process for both before data validation and after data validation process.
  • Tested both the User Oriented and Service Oriented based on requirements and service contracts.
  • Tested both the Web Service Architecture and Service Oriented Architecture.
  • Extracted certain column of data from a number to files using PERL.
  • Used PERL for automating all the types of modules at a time.
  • Execution of QTP Script for automation testing, analyzing the automation result.
  • Developed test scripts using QTP for Functionality and Regression Testing.
  • Familiar with CMMI, the Rational Unified Process (RUP) methodology within the Software Development Life Cycle (SDLC) along with Agile and Scrum
  • Testing (that includes unit, integrated, regression, and UAT) a new .NET application which uses Microsoft Visual Studio under the Scrum (Agile) Methodology
  • Testing (that includes integrated and regression) an application which uses Microsoft Visual Studio under the Scrum (Agile) Methodology.
  • Responsible for Data mapping testing by writing complex SQL Queries using WINSQL.
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Validating the data passed to downstream systems.
  • Worked with data validation, constraints, source to target row counts.
  • Developed automated Test Scripts using QTP.
  • Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL
  • Load new or modified data into back-end Oracle database.
  • Conducted extensive database testing, passing SQL queries to the Oracle
  • Used data conversion to protect the data and prevent data loss.
  • Strong in writing SQL queries and makes table queries to profile and analyze the data in MS Access.
  • Formulate methods to perform Positive and Negative testing against requirements.
  • Performed Manual Testing of the application Front-End and Functionality. Identified the critical test scripts to be automated.
  • Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
  • Recommend solutions based on data analysis to increase business efficiency and/or improve existing processes.
  • Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
  • Worked on Clear Quest to log defects and track resolution till the closing of defect after retesting.
  • Created test cases and executed test scripts using Quality Center.
  • Used Microsoft excel and Word 2003 to document the test status reports and the Test Data.
  • Used Quality Center to track and report system defects.
  • Developed web-based business intelligence metadata search and analysis tools and automated SQL capture of static reports using ASP and MicroStrategy 7.2.1 web API
  • Tested both conditional formatting and threshold level testing for several reports developed in Microstrategy.
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Data Stage 8.0.1,DB2, Java, SOAPUI,Agile, SQL, SQL Server 2000/2005, PERL, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), MicroStrategy 7.2.1 web API, Win Runner, Load Runner Teradata SQL Assistant 7.0, XML, XSLT, XML Spy 2008, IBM AIX 5.3, UNIX, Shell Scripting, HP QTP v5.5/6.5, WinSQL, Ultra editor, Rumba UNIX Display, HP Quality Center 8.2

Confidential, Buffalo, NY

ETL Tester

Responsibilities:

  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Created several SOA test cases for validations which were based on the behavior of a specific service.
  • Tested SOA application interface and communication paths.
  • Testing (that includes integrated and regression) an application which uses Microsoft Visual Studio under the Scrum (Agile) Methodology.
  • Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
  • Utilized DataStage Manager to store and manage reusable Metadata and created custom routines and transforms for the jobs.
  • Utilized DataStage Director to validate, run, schedule and monitor DataStage jobs.
  • Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing)
  • Wrote complex SQL queries for querying data against different data bases for data verification process.
  • Back-end testing using SQL queries and Involved in writing PL/SQL quires
  • Validated the data of reports by writing SQL queries in PL/SQL Developer against OD
  • Use SQL, PL/SQL to validate the Data going in to the Data Ware House
  • Designed the data flow diagrams using MS VISIO.
  • Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
  • Preparation of technical specifications and Source to Target mappings.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Helped the Testing team by writing SQL statements to validate the reports
  • Used multiple data providers, Master/Detail, cross tab, Charts.
  • Created several Ad-hoc reports in Business Objects XI R2 to validate the data.
  • Written test cases to test the application manually in Quality Center and automated using Quick Test Pro.
  • Used TOAD, DB Artisan tools to connect to Oracle Database to validate data that was populated by ETL applications
  • Strong testing Quality Assurance experience within agile environment
  • Good understanding of agile software development lifecycle (iterative and incremental)
  • Performed tests on various features of agile development process
  • Involved in testing Unix Korn Shell wrappers to run various ETL Scripts to load the data into Target Database (Oracle).
  • Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
  • Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
  • Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
  • Written Test Plans and Test Cases on Mercury’s Test Director Tool.
  • Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
  • Responsible for different Data mapping activities from Source systems to Teradata
  • Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
  • Created survival graphs in Excel by transporting SAS data sets into Excel spreadsheets.
  • Effectively prepared and published various performance reports and presentations.
  • Generated graphs using SAS/Graph and the SAS Graphic Editor.
  • Imported data from mainframe flat files with copybooks and relational database (Oracle) files into SAS files per detailed specifications.
  • Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
  • Designed and supported SQL 2000 Reporting services, Integration services and Analysis services.
  • Creating test cases for ETL mappings and design documents for production support.
  • Setting up, monitoring and using Job Control System in Development/QA/Prod.
  • Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
  • Scheduling and automating jobs to be run in a batch process.
  • Effectively communicate testing activities and findings in oral and written formats.
  • Reported bugs and tracked defects using Test Director 6.5
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Worked on issues with migration from development to testing.
  • Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

Environment: Data Stage7.5, Mercury Quality Center, SOAPUI, PERL, Agile,UNIX Shell Scripting, Operating System 2.15, GDE 1.15, Business Objects XIR2, Mercury Test Director 6.5, QTP 7.2, SQL *Loader, Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, Teradata V2R4

Confidential, Wilimgton DE

ETL Tester

Responsibilities:

  • Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports
  • Performed back-end testing on the Oracle database by writing SQL queries.
  • Collected, analyzed and reported testing metrics, executed SQL queries
  • Built and maintained effective QA test lab environments
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
  • Used Query Studio to test ad hoc reports
  • Developed SQL queries in Toad and DB Artisan to achieve the data transformations
  • Participated in various meetings and discussed Enhancement Request issues
  • Conducted Regression testing after the bugs have been fixed by the development team
  • Generated reports from Test Director.
  • Responsible for source control, versioning, and configuration management of test scripts, test results, defects
  • Developed Test Strategy, Test plan, Test cases, and Test scripts
  • Created test plan and executed test cases using Rational Test Manger
  • Conducted Functionality, Security, and End to End testing
  • Reported bugs using Test Director and generated the defect reports for review
  • Defect reporting and tracking was also done using Test Director.
  • Maintained the test traceability matrix
  • Performed Regression Testing on weekly builds.

Environment: Data Stage 6.1,Windows 2000 Server, SQL Server, Oracle 9i, Documentum 5i, Rational Test Manager, Rational Requisite Pro, Rational Clear Case, Rational Robot, Cognos 7.3 Series, Test Director, Toad, Java, J2EE, JSP

Confidential, Chicago IL

ETL Tester

Responsibilities:

  • Tested all the DataStage jobs and ETL flow for data validation.
  • Did data reconciliation for all the DataStage jobs for testing needs.
  • Wrote test cases based on ETL mapping document for testing the entire ETL wokflow.
  • Involved in understanding of business processes to learn business requirements.
  • Extracted data from different systems into Source. Mainly involved in ETL developing.
  • Defined and implemented approaches to load and extract data from database using DataStage.
  • Worked closely with data warehouse architect and business intelligence analyst in developing solutions.
  • Used Erwin for data modeling (i.e. modifying the staging and SQL scripts on Oracle and MS Access Environments).
  • Conducted System testing for each phase of the application.
  • Involved in preparing Test Scripts and Test cases based on the functional specifications.
  • Executed backend testing of the application by writing SQL queries.
  • Used Defect Tracking System Test Director to report bugs found in different testing stages.
  • Executed Test Procedures and documented Test Results
  • Involved in design, source to target mappings between sources to operational staging targets, using DataStage Designer.
  • Performed ETL coding using Hash file, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign Data Stage jobs for performing the required integration.
  • Executed jobs through sequencer for better performance and easy maintenance.
  • Involved in unit, performance and integration testing of Data Stage jobs.
  • Used Data Stage Director to run and monitor the jobs for performance statistics.
  • Involved in performance tuning of the jobs.
  • Used T-SQL for validating the data generated at OLAP server.

Environment: Data Stage 5.0.1,Oracle 8.0, Data Stage 6.x, SQL*Plus, SQL, Test Director, Rational Clear Quest, Clear Case, SQL Server 2000, PL/SQL, Visual Basic 6.0, Windows 95, Test Director, XML, XSD, XSLT, Java and UNIX, Korn Shell scripting, PERL

Hire Now