We provide IT Staff Augmentation Services!

Etl Data Warehouse Tester Resume

Omaha, NE

SUMMARY:

  • Experienced DWH and BI Tester/Analyst with strong background in design, development, and support of databases and information products as well as data analysis / reporting / processing.
  • Experienced in testing Web applications and client/server applications
  • Over 7 years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
  • Experience in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatch.
  • Tested Cognos reports to check whether they are generated as per the company standards
  • Solid Back End Testing experience by writing and executing SQL Queries.
  • Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica.
  • Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
  • Extensive working experience in RDBMS technologies like Oracle 8.x/9.x/10g/11i, DB 2 8.0/7.0/6.0, MS SQL Server 2008/2005/2000/7.0/6.5, Dbase, Excel and MYSQL. SQL Developer, TOAD, SQL Plus, Win SQL, Quest Central for DB2. Good at working with SQL Assistant 7.1 in Teradata environment.
  • Experience in UNIX shell scripting and configuring cron - jobs for ETL Loads.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Data Stage.
  • Expertise in Testing Complex Business rules by creating mapping and various transformations.
  • Experienced in working with HP Quality Center 10.0, Rational Clear Quest & Test Director.
  • Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.
  • Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
  • Experience with Agile Methodology.
  • Experienced in running SQL queries using Toad and SQL Server.
  • Experience in Performance Tuning of SQL and Stored Procedures.
  • Extensive experience in manual testing the ETL and Business Intelligence Applications.
  • Strong working experience on data warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
  • Developing and Delivering System Documentation and Training; Testing and Auditing
  • Excellent problem solving, interpersonal, and communication skills.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
  • Extensive experience in manual testing the ETL and Business Intelligence Applications.

TECHNICAL SKILLS:

ETL Tools: Informatica 8.1/7.1/6.2/6.1/5.1, Data Stage 8.x, Ab Initio (GDE 1.15, Co>Op 2.15), SSIS

Testing Tools: Quality Center, Win Runner, Test Director, Load Runner, QTP, Manual Testing

Database Management: Oracle 8i/9i/10g, SQL Server 2000/2005, MySQL, ODBC, DB2, TOAD 8.5, MS Access, Teradata V2R5/V2R6, Netezza

Reporting Tools: Cognos 8.0 Series, OBIEE, Business Objects 5.1 /6.1/XIR2

Operating Systems: Window 2003 Server, Windows 2000 Advanced Server, Windows 98, Windows XP, Linux and UNIX(AIX), MVS

Version control: Visual Source safe, WINCVS, PVC

Web Programming: HTML, XML, JSP, Java Script

Programming languages: C/C++, PL/ SQL, VB 6.0, ABAP

PROFESSIONAL EXPERIENCE:

Confidential, Omaha, NE

ETL Data Warehouse Tester

Responsibilities:

  • Involve in Business analysis and requirements gathering.
  • Responsible for testing packages using SSIS to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing
  • Created the Regression Test cases and automated them for the purpose of regression testing using QTP.
  • Worked in an Agile technology with Scrum. Conduct QA scrum call to gather status of the offshore team. Communicate or KT the project details as and when needed. Provide QA testing timelines understanding the project requirement and scope of testing.
  • Develop Validation plan and Quality summary report for the project
  • Draft test plans based on test strategy. Reviewed, created and executed test cases and test scripts based on test strategy and test plans based on Product Requirement Document.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
  • Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting Managers.
  • Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings
  • Effectively communicate testing activities and findings in oral and written formats.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Involved in Performance testing to ensure the load and stress capability of the application. Validated documented user requirements.
  • Written several complex SQL queries for validating Cognos Reports.
  • Preparing daily status reports and defect reports.
  • Wrote SQL scripts to perform database testing and to verify data integrity.
  • Focused on Data Quality issues, problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
  • Extensively worked on designing various output and management reports Using SQL Server
  • Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables.
  • Extracted Data using SSIS from DB2, XML, Oracle and flat files, Excel perform transformations and populate the data warehouse
  • Tested the outgoing links from all the web pages from specific domain.
  • Created Short-cut joins, aliases and contexts to make the universe loops free.
  • Reported bugs and tracked defects using Quality Center (Test Director)
  • A test reporting environment was established to combine Distribution Work Management and
  • PeopleSoft information into a consolidated place to allow combined reports to be generated.
  • Tested and worked on creating open document reports for business.
  • Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
  • Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
  • Involved in testing the Cognos reports by writing complex SQL queries
  • 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. 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.
  • Analyzed test cases for automation and created scripts for regression testing using QTP Automated Test cases for the purpose of regression testing.
  • Tested data warehouse ETL process using SSIS (Integration Service)
  • Managed and executed the test process, using Agile Methodology
  • Review the test cases and bug reports.

Environment: Informatica 8.6.1/8.1, MS SQL Server 2005/2008, QTP, Oracle 10g, PL/SQL, TOAD 8.0, SQL, Linux, Agile, Remedy, Test Director/Quality Center, Power Connect, PowerAnalyzer4.1, Cognos, WEBLOAD

Confidential, MN

ETL Data Warehouse Tester

Responsibilities:

  • Developed and Designed Test Cases based on the Business requirements.
  • Written several complex SQL queries for validating Cognos Reports.
  • Extensively tested the reports generated in Cognos by writing SQL queries to validate the data on the report and compare with the TPW data.
  • Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
  • Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
  • Used SQL for Querying the database in Linux environment for testing the business rules imposed on data movement with Informatica ETL tool.
  • Used the ETL processes of Informatica tool to load data from MS SQL Server and Oracle, into the target Oracle database.
  • Attended walkthrough meetings with the Business Analysts and development to get a clear understanding of the business and the applications being used in house.
  • Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
  • Developed automation test scripts to test the database by retrieving the data from the tables using HP QTP 10 and VB Scripting.
  • Validated that design meets requirements and function according to technical and functional specifications.
  • Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iteration, defects. Also link defects with requirements.
  • Involved in recording change requests on the Change Request Form (Remedy) Participated in meetings.
  • Performed all aspects of verification and validation
  • Worked with other members of the QA and Development teams and offshore team in improving the processes, methods, effectiveness and efficiency
  • Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
  • Generate data requirements and system specifications in an organized fashion for business solutions and for the developers to follow on.
  • Worked with business team to test the reports developed in Cognos
  • Used TOAD & SQL Navigator GUI tools for Querying Database.
  • Participated in walkthrough and defect report meetings periodically.
  • Documented and reported various bugs during the Testing process.
  • Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
  • Tested the Front-End Web Applications developed in J2EE for data portal for matching
  • Developed PL/SQL procedures & triggers.
  • Retesting the resolved defects/issues after the developers fix the defects
  • Involved in preparing test data for UAT and participated in UAT signoff
  • Prepared strategies for analyzing the data for ETL Team
  • Worked in an agile technology.
  • Involved in testing the Cognos reports by writing complex SQL queries
  • Created and executed SQL queries in ORACLE and MS SQL server
  • Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: Cognos 8.x, Informatica 8.1/ 7.1.4 (Power Center Designer, workflow manager, workflow monitor), MS SQL Server 2008, Oracle 10g, PL/SQL, TOAD 8.0, QTP, SQL, Linux, Netezza, Maestro 8.0 (Tivoli Work Scheduler), Charm, Agile, Remedy, Test Director/Quality Center, Power Connect, PowerAnalyzer4.1

Confidential, San Francisco CA

ETL QA Tester

Responsibilities:

  • Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
  • Provided support to sales team management and sales operations support groups in the receipt, warehousing and reporting account level sales information.
  • Extremely involved in using Test Director for identifying the bugs with the help of SQL queries.
  • Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
  • Responsible for Mini specifications document that describe the functionality of each subject area.
  • Used T-SQL for Querying the SQL Server database for data validation and data conditioning
  • Reported software mismatches (from the test planning), to the development team using Quality Center
  • Implemented Database Checkpoints for Back-end Testing
  • Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
  • Managed and executed the test process, using Agile Methodology
  • Analyzed the Data Dictionary developed by the Systems Analyst for developing test scripts to test the Policy and Claims systems.
  • Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts.
  • Extensively used Informatica Power Center 8.1.1 to load data sourcing from Source to Target databases.
  • Executing ETL - Informatica Workflows for updating test Databases from the Production servers.
  • Worked rigorously with developers to create test scripts in regards to the Informatica ETL.
  • Used Quality Center to track and report system defects
  • Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering.
  • Tested all the internal links and tested links jumping on the same Web page
  • Tested several reports developed in MS Reporting Services which were migrated from Business Objects XI R2.

Environment: Informatica 8.1.1, Business Objects Xi R2, Windows XP, Oracle10G, Sybase, IBM DB2, TOAD for Oracle, UNIX, MS SQL Server 2008, Reflections, Agile, Mercury Quality Center.

Confidential, Seattle WA

QA Test Engineer

Responsibilities:

  • Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
  • Reported periodic project status and updates to the QA Lead and QA Manager
  • Performed Integration Testing of different modules.
  • Heavily involved in interacting with UNIX Shell scripts.
  • Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases Involved in Business analysis and requirements gathering.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Identified the Test Cases to be automated and lead the effort for automating the product.
  • Used Test Director to organize the Win Runner Scripts and schedule test execution.
  • Used Test Director for Bug Reports and Defect Tracking.
  • Tested User Interface inconsistency and application functionality.
  • Developed test scenarios for testing Enterprise Data warehouse and Credit Data Mart data in DB2 environment.
  • Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
  • Developed Reports and Graphs to present the results to the management.
  • Preparation of test data for various levels of testing
  • Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
  • Load new or modified data into back-end Oracle database.
  • 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.
  • Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
  • 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: Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), OBIEE, Oracle 9i, Agile, HP Quality Center, TOAD 7, SQL *Loader, SQL Server 2000, QC, Test Director, Erwin 3.5, Windows 2000

Confidential,

QA Analyst

Responsibilities:

  • Developed Test Cases and Test Design using Quality Center.
  • Automated the scripts using QTP by developing VB scripts. Developed functions in QTP.
  • Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
  • Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
  • Conducted Functional, GUI, Regression and User-Acceptance (UAT) testing.
  • Developed XML test files based on XML schema.
  • Generated XML data files using XML Spy.
  • Validated the Web Services (SOAP), both Request and Response messages.
  • Tested the Source and Target databases and ETL process.
  • Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).
  • Created Traceability between Requirements and Test Cases.
  • Conducted Data Driven testing to test various sets of data. Worked with UNIX Shell Scripts.
  • Tracked the defects using Test Director and generated defect summary reports.
  • Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.
  • Configuration management / Version control was done using Visual Source Safe.

Environment: Mercury Tools, QTP 8.0, VB.NET, ASP.NET, IIS, XML, SOAP, Windows XP, SQL Server, Mainframes (DB2, JCL, CICS), MS-Office.

Hire Now