We provide IT Staff Augmentation Services!

Etl Qa Tester Resume

2.00/5 (Submit Your Rating)

Manhattan, NY


  • 7+ years of experience in the Information Technology industry, involving analysis, ETL and BI testing of DWH applications and reporting applications in the Banking, and Financial Domains and Telecom domains
  • Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios
  • Experienced in testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports.
  • Possess specific experience performing Regression and Functional Testing.
  • Proficient in Mercury s Quality Center for Test Designing, Requirement Mapping, Reports and Defect Tracking
  • Good skills in SQL and PL SQL and Unit testing.
  • Hands on expertise in Data ware housing concepts and tools.
  • Involved in the ETL processes using Datastage, Informatica, Abinitio, SSIS, SSRS and Autosys tools.
  • Experienced working with end to end system testing in distributed SOA enabled environment.
  • Developed Ab Initio test environment for UAT testing and used all Ab Initio components while testing the graphs and ran the jobs on back ground.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs
  • Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing)
  • Expertise in possess specific testing including Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration Verification and Validation End - to-end and User Acceptance Testing.
  • Extensive Experience in Agile Methodology of SDLC.
  • Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling
  • Good experience in Cognos & Business Objects Reports testing
  • Well experienced in writing complex SQL queries for extracting data from multiple tables.
  • Experience in Performance Tuning of SQL and Stored Procedures.
  • Excellent experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
  • Proficient in Rational Clear Quest and Quality Center for Defect Tracking
  • Defined and Implemented Processes and Procedures for QA Departments
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Expert knowledge in UNIX shell scripting (Korn shell/Bourne shell)
  • Ability to work independently or in a team environment or in a rapid pace environment.
  • Possess strong interpersonal skills, communication and presentation skills with theability to interact with people at all levels


Web Technologies: XML, HTML, Java 1.4/1.5, J2EE, XSLT, Java Script

App Servers: Java Web Server, Apache Tomcat, Web Logic 8.x, IBM Websphere 7.x

Databases & RDBMS: ORACLE 7.X, 8, 9i, 10g, MY SQL, MS Access 2003, DB2, SQL Server 2005,SQL Server 2008, Teradata V2R5/V2R6, IBM DB2 8.x, Sybase 12.3

Languages: C, C++, Java, SQL, PL/SQL, VB Scripting

Defect Management Tool: Test Director, Quality Center

Data Warehousing Tools: Informatica Power Center, Data Stage, Ab Initio

BI Tools: Business Objects 6.5.1/6.0/5.1. x/4.0 (Supervisor, Designer, Reporter), Web Intelligence, ZABO, InfoView, 3 Tier Business Objects, BCA, BO XI R2

Main Frame: MVS, JCL, COBOL II, VSAM, OS/2, ES 9000, IMS DB/DC, Copy Books


Confidential, Manhattan, NY

ETL QA Tester


  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources.
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
  • Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs.
  • Involved in system-to-system functional, regression, integration and performance tests and tested numerous SOA XML web services projects using Soap Sonar tool
  • Participated in reporting summary documents reviews.
  • Developed Test Cases and Test Scripts for System and UAT Testing
  • Worked closely with developers and report planners/analysts to insure that an acceptance criterion is complete and accurate for desired report capability.
  • Extraction of test data from tables and loading of data into SQL tables.
  • Helped the System test lead in developing the Test Plan and Testing Strategy for ETL/BI
  • Managed and executed the test process, using Agile Methodology.
  • Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts
  • Worked with Teradata SQL Assistant for data retrieval and data validation.
  • Written several complex SQL queries for validating Cognos Reports.
  • Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
  • Coordinate very closely with the developers regarding functionalities and defects.
  • Conducted manual back-end testing on a reconfigured sales application system.
  • Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
  • Contributed to design, analyzed and conducted back-end testing using SQL scripts on a database developed from Data Mining.
  • Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
  • Raised defects in HP Quality Center defect tracking system.
  • Worked with all kinds of components with Ab Initio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine, Sort, Joiner, XML Read, XML Write, FBE, Partition Components.
  • Tested Ab Initio graphs and used Ab Initio as an ETL tool to load the final loads.
  • Designed Traceability Matrix to match the test scripts with the Functional design document.
  • Provided the Test status to the Tech lead, Project lead and the team mates.
  • Effectively communicated testing activities and findings in oral and written formats.
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Tested data from various sources like Oracle, flat files and SQL Server

Environment: Ab Initio CO>OP 2.15, GDE 1.15, IBM DB2, Agile, Oracle, XML Files, CSV, VSAM Files, SQL Server 2008, ASP.NET, ADO.Net, C#, XML, COM, JavaScript, Visual Source Safe 6.0,QTP 9.0, Quality Center 10.0, SQL, PL/SQL, PERL, Shell Scripting, SQL, PL/SQL, PERL, Visual Studio, .NET 2008, Teradata V2R6, Cognos 8.0 Series.

Confidential, SALT LAKE CITY, UTAH

ETL/BI Tester


  • Identifying business rules and processing logic and creating and defining requirements to be used across all inbound interfaces.
  • Obtained a detailed knowledge of the business process being followed in the project environment
  • Tested several data validation graphs developed in Ab Initio environment.
  • Worked with all kinds of components with Ab Initio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine, Sort, Joiner, XML Read, XML Write, FBE, Partition ComponentsUsed SQL for Querying the DB2 database in UNIX environment
  • Wrote complex SQL scripts in DB2 for testing data quality and validation.
  • Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL Test loads.
  • Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
  • Designed and developed Oracle PL/SQL scripts for test data Import/Export
  • Involved in testing Web Services Using SOAPUI
  • Extensively worked with TOAD for querying Oracle Database
  • Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
  • Familiar with CMMI, the Rational Unified Process (RUP) methodology within the Software Development Life Cycle (SDLC) along with Agile and Scrum.
  • Tested Cognos reports to check whether they are generated as per the company standards
  • Totally involved with data validation and data conditioning process for testing the quality of the data. Performed white box and black box testing.
  • Extensively worked with Quality center for Uploading test cases and defect tracking and reporting defects
  • Extracted the business requirements from the end users keeping in mind their need for the application, and documented it for the developers
  • Prepared several test scenario for the work flow of the entire ETL cycle
  • Prepared test conditions and Test Cases for modules assigned
  • Conducted Defect tracking according to status and Priority and maintenance of defects
  • Involved in Documenting/Executing business test cases
  • Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
  • Performed detailed analysis of data issues encountered during business acceptance testing
  • Actively involved in the daily testing status meeting in which the defects identified were discussed
  • Worked with Data Extraction, Transformation and Loading (ETL)
  • Involved in testing data mapping and conversion in a server based data warehouse
  • Developed and executed test cases and verified actual results with expected results
  • Worked with developers in understating the ETL code for writing several complex test plans for testing both front-end and backend

Environment: IBM DB2, Ab Initio CO>OP 2.14, GDE 1.14, Cognos 8.0, Agile, UNIX AIX, DB2, Windows XP, XML, XSD, Oracle 10g, TOAD, PL/SQL, Mercury Quality Center

Confidential, Monterey Park, CA

Data warehouse/ETL QA


  • Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
  • Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
  • Wrote complex SQL queries to validate EDW data versus EDM source data including identification of duplicate records and quality of data based on Mapping/Transformation rules.
  • Initiated and developed new techniques to improve the testing process and improve the performance of the test scripts.
  • Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, and Nulls/Defaults/Trim spaces rules as per the design specifications.
  • Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts
  • Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
  • Verified correctness of data after the transformation rules were applied on source data.
  • Coordinated the execution of User Acceptance Testing, regression and integration testing with multiple departments.
  • Employed data modeling, table normalization (de-normalization for Adhoc) in establishing data and application integrity.
  • Identified appropriate test data in relevant source systems and incorporated this data into test scripts.
  • Updated the status of testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
  • Performed Regression testing of the fixed issues in the new build until no new issues are identified.
  • Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
  • Submitted Final Test Report and required documentation for the entire project within the assigned time frame.
  • Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional, Security and Regression Testing.
  • Validated all kinds of transformations used in every work flow, used to transform data.
  • Validating the data flow from source to target.
  • Checking the data flow from one end to another by using SQL queries
  • Worked with technical staff to create, interpret and implement business requirements into technical specifications.
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Developed automated test scripts using QTP to perform Functional and Regression testing.
  • Created Test input requirements and prepared the test data for Data Driven testing.
  • Used Test Director to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
  • Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Ab initio, Java, SQL, PL/SQL, Oracle 8i+9i, HTML, TOAD, XML, UNIX, Test Director, Quick Test Pro, Quality Center, Shell Scripting, MVS, COBOL II, VSAM, JCL, ISPF, CSV files, Flat Files

Confidential, Newark, New Jersey

Data Warehousing Tester


  • Involved in Business analysis and requirements gathering.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Validated the data in the reports by writing simple to complex SQL queries in the transactional system
  • Managed multiple projects and schedule the timelines for testing process for entire data warehousing projects.
  • Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
  • Oversaw the historical loads in UAT and PROD environments.
  • Also worked on Integration of all the processes in UAT/PROD.
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Generated test data (on UNIX box using Perl scripts) to support development.
  • Experience in Data Inspection/analysis of tables as well as outbound files (data files in EBCIDIC & ASCII format).
  • Tested Business Objects reports and Web Intelligence reports
  • Verified layout of data files and control file entries as per business requirement.
  • Based on the generated test data wrote test cases to demonstrate testing approach with detailed explanation of the cases for SORs.(System Of record)
  • Did Unit Testing for all reports and packages.
  • Tested the entire data reconciliation process for multiple source and target systems.
  • Extensively used test management tools like Quality Center, and QTP to carry out test case documentation, execution, and defect logging
  • Involved in creating the test data for generating sample test reports before releasing to production.
  • Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
  • Provided input into project plans for database projects providing timelines and resources required.
  • Maintained the data integrity and security using integrity constraints and Data base triggers.
  • Involved in the application tuning of database by identifying the suitable Indexes.
  • Worked on UNIX Shell wrapper scripts
  • Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts
  • Worked on Autosys which involved in creation of Autosys jobs, execution.
  • Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
  • Strong testing Quality Assurance experience within agile environment
  • Worked on issues with migration from development to testing.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Validated cube and query data from the reporting system back to the source system.
  • Tested analytical reports using Analysis Studio

Environment: Ab initio, SQL, PL/SQL, TOAD 7.0, Quality Center 8.2, Test Cases, Test Scripts, Test Plan, Traceability Matrix, Test Director, Agile, SAS/BASE 9.1.2, SAS/Access, SAS/Connect, IBM DB2, COBOL, Flat Files, Copy Books, MVS, TSO, JCL, IMS DB/DC, ISPF, SQL *Loader, Oracle8i, QTP, SQL Server 2000/2005, Erwin 3.5/4.0


Software Test Engineer


  • Understanding of complex financial business requirements
  • Writing test plans and test scripts
  • Maintained Progress Report of team members for update on individual work during test execution cycle
  • Written PL/SQL procedures and numerous SQL queries to go ahead with testing for the data against the requirements
  • Performed testing in mainframe environment
  • High Level Test Case Design and writing detailed test cases
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Reported periodic project status and updates to the QA Lead and QA Manager
  • Heavily involved in interacting with UNIX Shell scripts
  • Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
  • Exporting test cases to Test Director
  • Preparation of Data Requirements
  • Accessing mainframes and validating the data
  • Identify & record defects with required information for issue to be reproduced by other teams.
  • Worked with high-volume, real-time DB2 database applications and systems
  • Conducted Bug Review meetings for update on defects from development team & retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application
  • Experienced in coordinating resources within Onsite-Offshore model
  • Conducted Training Sessions and Knowledge Transfer Sessions on new applications
  • Managing testing documents in Test Director
  • Understanding of Business Logic and data flow

Environment: Windows, SQL, PL/SQL, Mainframes, SAP BP, SAP XI, JCL, .Net, DB2, ASP.Net, Test Director

We'd love your feedback!