We provide IT Staff Augmentation Services!

Dwh Etl Qa Tester Resume

0/5 (Submit Your Rating)

Madison, WI

SUMMARY

  • 5+ years of Experience in Quality Assurance and ETL/BI testing experience with extensive backend testing Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing..
  • Expert in Oracle database testing.
  • Expertise in designing the test scenarios and scripting the test cases in order to test the application.
  • Experience in developing the Manual Test Suites and Automated test suites.
  • Expertise in QA process and different levels of testing like unit, Functional, Regression, and Integration testing with business scenarios.
  • Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
  • Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Experience in testing and writing SQL and PL/SQL statements.
  • Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
  • Extensive experience in testing of Investment banking and Academic clients.
  • 5 years of strong data base experience in Oracle, SQL Server 2000, IBM DB2 and Sybase.
  • Strong experience in testing tools like TestDirector7.6, Quality Center, Quick Test Pro.
  • Expertise in writing SQL and PL/SQL statements.
  • Good expertise in using TOAD, SQL*Plus and SQL Advantage.
  • Experience in testing and writing complex SQL, T - SQL and PL/SQL statements.
  • Experience in all aspects of project development life cycle.
  • Experience with integration testing of the applications using various sources like flat files, Sybase and oracle databases.
  • Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
  • Experience in debugging the issues.
  • Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.
  • Involved in jobs scheduling, monitoring and application support in a 24/7 environment.
  • Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS

ETL Tools: Informatica 9.0.1/8.6.1/8.1/7.1/6.2 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), SSIS 9.0, Datastage 8.1, Ab Initio (GDE 1.15, CO>Op 2.15)

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000, DB2, Teradata V2R6

OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XI R2/6.x/5.x,SSRS 9.0, MicroStrategy9.0

Languages: SQL, PL/SQL, Unix Shell Script, Visual Basic, XML

Tools: Toad, SQL* Loader, SQL Assistant

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: QTP 10, Quality Center 9.2, Test Director 5.0

Rational Tools: Sharepoint, RUP, Rational Clear Case, Clear Quest, Test Manager, PVCS, Rational Requisite Pro, IBM Rational Manual Tester

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

DWH ETL QA Tester

Responsibilities:

  • Interacted with System Analyst to analyze business requirements, Gap Analysis, E2E flow of application and involved in impact analysis for changes business rules.
  • Designed and developed QA Test Plan/Test Cases using Testing methodology with all possible Use Case to cover all testable function in Positive & Negative Testing.
  • Provided Test metrics on the results of system testing activities; coordinated and collaborated with others in analyzing collected requirements to ensure system development and implementation plans meet customer needs and expectations.
  • Confirmed and prioritized project plans and deliverables per customer requirements and deadlines; and stayed current on emerging tools, techniques and technologies related to software testing.
  • Helped drive automation innovation (participated in testing tool analysis and/or reviews, assisted and/or trained other manual testers in automation, implemented recommendation to improve test automation).
  • Developed SQL Script (Developed complicated SQL Script in Toad) to validate data, automated UNIX based process.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Set up Test Environment including refresh database from production, maintained test environment with upcoming release.
  • Involved in key learning process after each release to implement process in future as a part of QA Process Management.
  • Tested test scenarios that were used to validate the ETL movement
  • Written complex SQL queries for validating the transformation rules for ETL mappings
  • Assisted in continually improving our software development process and the development environment.
  • Interacted with team to resolve daily issues in installation, code delivery, documentation, and defects.
  • Involved in testing of multiple applications with QA, SIT and UAT testing by documenting, reviewing, resolving defects, follow up with interface sign-off.
  • Supported Change Control by reviewing impact of all modules planned all release schedules, back out plan.
  • Supported production support team in production Trouble Ticket to analyze root cause of problems and resolved with team.
  • Involved in production support testing assisted team in staging testing, support in change control request.
  • Involved in different major and minor release testing by updating test plan with testing methodology, reviewed test results and analyzed defects and resolved with team.
  • Expertise with testing Quality Center and Toad for defect tracking and database use.
  • Strong Project Management skills like Test planning with LOE, test estimation and resource plans, Set up test environment.
  • Ability to multi-task effectively, Excellent verbal and written communication skills and attention to fine details.

Environment: Oracle 11g, SQL, TOAD, Informatica 9.0.1, IBM DB2, MVS, MainFrames, Agile, VSAM, XML Spy, Sharepoint, COBAL II, File-Aid, Flat Files, XML, XML SPY 2010, Quality Center

Confidential, Columbus, Ohio

ETL Tester

Responsibilities:

  • Understanding of Functional Requirement Specifications and System Requirement Specifications.
  • Preparation of test scenario’s and test cases based on FD and TD documents
  • Generating and validating theCognosreports based on functionality
  • Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.
  • Validating the data against staging tables and warehouse
  • Find report defects and subsequently validating the fix, repeating the process until done.
  • Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
  • Perform system testing to ensure the validity of the Report requirements and migration of risks prior to formal acceptance.
  • Performed Interface and Integration (SIT) Testing
  • Extensively use SQL queries for data validation and backend testing.
  • Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
  • Track Sheet Maintenance and map the use case to requirement.
  • Monitor Testing Activities within the team and report regular progress to the Test Manager.
  • Working with Tivoli job scheduler for submitting the jobs and monitoring the jobs
  • Preparing the SQL queries to fetch the data from databases.
  • Worked with job scheduler tool Tivoli for running the ETL batch jobs and monitoring the batch jobs
  • Execute theETLjobs sessions and workflows
  • Preparation of Requirement Traceability Matrix, Test Metrics and Deployment manual
  • Experience with Data profiling, Data Validation and Data Integrity andData Cleansing and ETL processes using Informatica
  • Perform User Acceptance Testing with UAT test scenarios.
  • Extract data from different source systems using Data Services tools.
  • Prepare the SQL queries to fetch the data from databases.

Environment: Informatica Oracle SQL Developer, .Net 4.0, ASP.net 4.0, Web Methods and Web Services, UNIX, IBM COGNOS, HP Quality Center, Tivoli, SQL, PL/SQL, SOUPUI

Confidential, Los Angeles, CA

ETL/BI Tester/Database Tester

Responsibilities:

  • Responsible for Business analysis and requirements gathering.
  • Tested several UNIX shell scripting for File validation, Data Parsing, Cleanup and job scheduling.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Participated in business requirement walk through, design walk through and analyzed Business requirements.
  • Involved in creating Test plan, Test Cases, and Test scenarios
  • Involved in Scenario based testing & Field level validation.
  • Developed test cases bases on Requirement Specifications and Design Documents and executed using Quality Center.
  • Executed batch processing and verified job status and data in database tables.
  • Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
  • Performed Verification, Validation and transformations on the Input data (Text files, XML files, and database) before loading into target database.
  • Validating transformed data by using transformation rules given in requirement document.
  • Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
  • Executed Stored Procedures and Triggers using PL/SQL to validate the data.
  • Written several PL/SQL stored procedures. Tested the output of Stored Procedures vs. ETL output.
  • Performed Functional, Data validation, Integration, Regression, and System testing.
  • Used Oracle 9i to validate data that was populated by ETL applications.
  • Executed UNIX commands to run the jobs.
  • Designed and tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Prepared extensive set of validation test cases to verify the data
  • Escalated issues in Issue register as necessary for meeting deadline.
  • TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
  • Defects were tracked, analyzed, and documented using Quality Center
  • Involved in Defect Triage meetings.
  • Logged defects in Quality Center and worked with the developers to resolve any issues.
  • Reported the daily status of test cases executed/failed, defects status.
  • Worked with business analysts to assure new functionality changes were reasonable regarding existing physical design.
  • Preparation of weekly and monthly status reports.

Environment: Business Objects XIR3/XIR2, SQL, PL/SQL, SQL Server 2008, XML, XSD, XSLT, XML Spy 2010,, KORN SHELL SCRIPTING, Informatica 8.6/7.1/6.2, Teradata V2R6 (SQL Assistant, Fast Load, Multi Load, TPUMP, BTEQ, FEXPORT), HP Quality Center 10, Oracle 10g, Erwin 4.0, UNIX, TOAD, WinSQL, Mercury Test Director 8.0

Confidential, Washington, DC

ETL Test Analyst

Responsibilities:

  • Created Test Strategy and Test cases for the testing effort.
  • Responsible for finding the indicators and writing the test scripts for testing the test cases.
  • Conducted Smoke, Non Functional, Functional, System, Regression and Integration testing.
  • Developed SQL to achieve the data transformations.
  • Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
  • Performed back-end testing on the Oracle, DB2 and Teradata databases by writing SQL queries
  • Conducted backend testing using SQL Assistant.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
  • Responsible for testing all the four entities Group Batch, Group Real-time, Member Batch and Member Real-time.
  • Participated in daily stand-up meetings with the management team
  • Responsible for testing the staging tables and Look-up spreadsheet.
  • Worked on UNIX commands and shell scripting for scheduling the jobs from command line.
  • Developed shell scripts for finding the XML’s for each member from the files.
  • Worked with clients to demonstrate agile techniques for software development, explained and implemented unit testing, created coding standards based on IBM recommendations.
  • Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Performed Quality Analysis on problem reports against software and the production system in order to confirm that problems truly exists and can be recreated for testing
  • Responsible for executing the test cases for Batch and Real-time that included both Member and Group data.
  • Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
  • Responsible for the ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Executed the scenarios and analyzed the results through monitors and graphs.
  • Tested and worked on creating open document reports for business.
  • Actively communicated with the end users and business users to create realistic test cases.
  • Batch testing development and execution and done analysis of batch works.
  • Participated in various meetings and discussed Enhancement Request issues.
  • Review the test cases written based on the Change Request document.
  • Testing has been done based on Change Requests and Defect Requests.
  • Conducted Regression testing after the bugs have been fixed by the development team
  • Generated reports from Quality Center.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting
  • Responsible for source control, versioning, and configuration management of test scripts, test results, defects

Environment: Informatica 7.1/6.2/5.1,7.X/6.X, SQL, PL/SQL, Teradata, IBM DB2, TOAD 9.2, Oracle 10g,MS SQL Server, Teradata SQL Assistant, XML, XML Spy 2008, UNIX, HP Quality Center 10.0, BI Reports, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting, Windows NT/XP/2003.

We'd love your feedback!