We provide IT Staff Augmentation Services!

Sr. Etl Qa Dwh Tester Resume

Kansas City, MO

SUMMARY

  • 8 years of experience in Software Quality Assurance with expertise in Data warehousing, database testing and data analysis in Healthcare, Retail, Finance, Investment and Telecom domains.
  • Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process in a corporate - wide-ETL solution using Informatica 9.0.1/8.6/8.1/7.x/6.x & SQL Server Integration Services (SSIS 2005,2008,2008R2)
  • Experience in Functionality testing, Database Testing, GUI testing, System testing, Ad-hoc testing, Regression testing, E2E testing and Automation testing.
  • Expert in using the RUP, Agile/Scrum and Waterfall testing lifecycle Methodologies
  • Experienced in developing, reviewing, and Executing Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script.
  • Experience in manual testing process and in creating automation environment using Quick Test Pro (QTP), Test Director, and Quality Center/ALM 11.0.
  • Expertise in test strategy design based on the various types of testing including unit, integration, function, system, usability (UI), End to End, security, load, stress, capacity and performance testing.
  • Experience in testing of Data Warehouse/ETL Applications developed in Informatica, Ab initio using SQL Server, Oracle, DB2, and UNIX and ability to evaluate ETL/BI specifications and processes.
  • Experienced with ETL tools like Informatica, Abinitio, and Data stage and also using SSIS package.
  • Extensive experience is using Complex SQL queries using techniques like Sub queries, Correlated Sub queries and Stored Procedures for speedy and effective data analysis.
  • Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
  • Good experience in Cognos & Business Objects Reports testing and worked on different versions of Cognos for Report testing.
  • Used Informatica DVO for ETL Testing and Data Validation faster with 50% to 90% less time and resources.
  • ICD 9-ICD 10 Conversion knowledge -Worked in the analysis of the ICD 9 - 10 codes
  • HIPAA 4010 - 5010 Conversion Analysis -Involved in documentation of HIPAA 5010 changes to EDI 837, 834, 835, 276, 277 Transactions.
  • Extensively used HP ALM to track defects and to upload Test Plans and test cases
  • Extensively tested PL/SQL batch processes, PL/SQL programs - Packages, Functions, Stored Procedures, Collections, Cursors, and Triggers.
  • Extensive experience in writing SQL and PL/SQL, UNIX shell scripts to validate the database systems and for backend database testing and data validation.
  • Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
  • Proficient in SQL query and testing RDBMS such as Oracle, MySQL, SQL Server for Data validation.
  • Proficient in using SQL Queries using TOAD & SQL Plus to ensure data consistency of front-end and raw feed by developing and executed complex SQL queries for data base.
  • Strong experience in testing ETL applications and BI reports and strong testing experience in UNIX platform.
  • Expert in reviewing/reporting, tracking, & maintaining Defects with high level of detail, accuracy and informative recreation steps using Quality Center, Clear QUEST, Bugzilla, and Email (outlook).
  • Ability to learn and adapt to new tools and technologies very quickly.

TECHNICAL SKILLS

Platforms: UNIX, Linux, Windows (NT, 2000, XP, 2003, Vista), Macintosh, MS-DOS

Programming languages: SQL, T-SQL, PL/SQL, C, C++, Java, .NET Framework, C#

Database systems: Oracle, MySQL, Microsoft SQL Server, Teradata

Defect-tracking software: HP Quality Center/ALM11.0, TFS, JIRA, MLOP, Cubes

Tools and Utilities: Toad, SQL Navigator, Teradata SQL Assistant

ETL Tools: Informatica, Data Stage, AbInitio, SSIS 2005, 2008 R2

BI Tools: Business Objects, Cognos

Integration Tools: SSIS, SSRS

Job Scheduling Tools: Autosys

Office Tools: MS office MS word, Excel, Power point & Visio.

Data modelling tools: ERWIN, ERSTUDIO.

Methodologies: Agile, Scrum.

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Sr. ETL QA DWH Tester

Responsibilities:

  • Developed Test Plans, Test Cases, and Test Scripts for SIT and support for UAT tests.
  • n Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
  • Extensively used Informatica to load data from Flat Files to SQL Server, SQL Server to Flat Files and SQL Server to SQL Server.
  • Executing and monitoring jobs through Tidal.
  • Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
  • Reviewed Informatica mappings and test cases before delivering to Client.
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Testing of records with logical delete using flags.
  • 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.
  • Used Informatica DVO for avoiding writing manual SQL Queries and reduces the programming complexity.
  • Validating the Archive process to purge the data that meet the defined business rules.
  • Written complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in SQL Server.
  • Compare the tables before and after a move / transformation to ensure that the data is correct and as expected using Informatica DVO.
  • Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008 and Oracle 10g.Managed and conducted System testing, Integration testing and Functional testing.
  • Responsible for testing packages using Informatica (ETL) to verify data and Involved in testing data migration.Worked on SQL scripts to load data in the tables.Used Mainframes for the daily data from the production to SIT environments
  • Experience testing on XML documents.
  • Experience working with Rational ClearCase for Version controlling and ClearQuest for defect tracking tool.
  • Prepared status summary reports with details of executed, passed and failed test cases.
  • Interacted with developers, Business & Management Teams and End Users.
  • Participated in regular project status meetings & Scrum related to testing.

Environment: Data warehouse ETL Informatica- 9.1, BI Cognos, Oracle 11g, SQL, PL/SQL, BRIO Portal, Mainframes, UNIX, TOAD, XML Files, XSD, SSIS, DVO, DTD, HP Quality Center 10 and UNIX.

Confidential, Eden Priare, MN

ETL QA DWH Tester

Responsibilities:

  • Review the Business requirements and ensure the testability of these requirements.
  • Developed QA project plan, Test Plan, Test cases for the QA Phase of the Global Data Warehouse.
  • Performed Data warehouse ETL testing and extensively used SQL functionalities. Used TOAD to connect to Oracle Database.
  • Developed SQL scripts to validate the data loaded into Data warehouse and Data Mart tables using ETL Informatica.
  • Used Informatica DVO in business critical prod environments, where data must be validated before it is moved to production.
  • Involved in Functional testing, Web service testing, Regression testing, Backend database testing.
  • Scheduling and automating jobs to be run in a batch process.
  • Reported defects and status of the defects in HP Quality Center.
  • Extensively used Quality Center for test planning and Used Rational Clear Quest for bug tracking and reporting.
  • Involved in testing the Cognos reports by writing complex SQL queries.
  • Worked with software testing methodologies with all phases and stages of testing desired (Functional, System, Integration, Regression, Data Validation, User Acceptance (UAT).
  • Involved in Back End Data warehouse ETL Testing using UNIX Utilities and automated Regression Testing using Shell Scripting.
  • Queried test database results using a variety of internal tools, SQL statements, and Quest's Toad database UI product to verify back-end results.
  • Customized the QTP Test as per the Test Case by using the VB-Script.
  • Validated the data transformations developed by DB2 stored procedures and Informatica.
  • Created reports utilizing vlookup of both internal excel worksheet and external data.
  • Developed complex SQL queries to verify the data loaded into the target tables.
  • Validate the test data using MS access, TOAD, UNIX & MS Excel.
  • Performed Querysurge to compare millions of rows and columns of data in minutes.
  • Connect to telnet to the UNIX environment and download, transport test data files
  • Created ETL Test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
  • Communicate QA progress, % of test cases executed per day to the supervising authority.
  • Used Querysurge for automating the testing of each data element based on business requirements to ensure defects are discovered prior to deployment.
  • Tested whether the reports developed in Cognos are as per company standards.
  • Worked with business team to test the reports developed in Cognos.
  • Involved in analysis Health Care Claim Acknowledgement for HIPAA Version 4010.
  • Performed database integrity check using SQL and Unix Shell Scripts.
  • Maintain the health information management system as per HIPAA compliance.
  • Involved in backend testing with SQL to check the data integrity and referential integrity.
  • Gather feedback from the manager to incorporate changes as required for the QA process documentation.
  • Written several complex SQL queries to validate the Cognos reports.
  • Tested the ETL process for both before Data validation and after Data validation process. Tested the messages published by ETL tool and data loaded into various databases.
  • Tested the Dashboard reports using Cognos Report Studio and Metric Studio.
  • Perform automated QA reports using Quality Center and Start Team dashboards.

Environment: Data warehouse ETL Informatica- 9.1, BI Cognos, Oracle 11g, SQL, PL/SQL, BRIO Portal, XML Spy 2011, UNIX, TOAD, XML Files, XSD, SSIS, DVO, DTD, HP Quality Center 10 and UNIX.

Confidential, San Ramon, CA

ETL QA Tester

Responsibilities:

  • Involved in developing detailed Test plan, Test cases and Test scripts using Quality Center for Functional and Regression Testing.
  • Designing SQL queries while performing database 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.
  • Developed Test Cases and Test Scripts for System and UAT Testing.
  • Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports.
  • 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.
  • Worked with Teradata SQL Assistant for data retrieval and data validation.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • 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.
  • Used Informatica Data Validation which reduces the time required for data validation and production data auditing and verification.
  • 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.
  • Designed Traceability Matrix to match the test scripts with the Functional design document.
  • Worked with ETL group for understating mappings for dimensions and facts.

Environment: Informatica 8.5.1, IBM DB2, Oracle, XML Files, CSV, VSAM Files, SQL Server 2008, ASP.NET, ADO.Net, C#, XML, COM, SSIS, 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, Seattle WA

ETL QA Tester

Responsibilities:

  • Review and understand the ETL processes, functionality & identify test requirements and coverage.
  • Involved in creating Test plans/Test cases based on BRDs and FSDs, we got from Business and Development teams.
  • Reviewing Test cases and scripts based on client requirements in HP Quality Center.
  • Reporting and tracking the defects in Quality Center.
  • Wrote very complex SQL to validate several BI Reports.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Used SQL Plus tool to write SQL commands in Oracle database.
  • Tested whether the reports developed in Cognos are as per company standards.
  • Developed Test Plans, Test Cases, and Test Scripts for SIT.
  • Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
  • Created Test Cases and developed Tractability Matrix and Test Coverage reports.
  • Managed and conducted System testing, Integration testing and Functional testing.
  • Extensively used Teradata and Putty for the entire project.
  • Worked on SQL scripts to load data in the tables in Test environment.
  • Used the Informatica monitor to schedule the jobs, validating and debugging its components, and monitoring the resulting executable versions.
  • Running of ETL mappings in Informatica and test data setup, Quality check for test data.-Transformation logic verification, RCA for defect found.
  • Written several complex SQL queries for validating Cognos Reports.
  • Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables
  • Tracked the defects using Quality Center tool and generated defect summary reports.
  • Uploaded test cases from excel documents to Quality center, and validate the same using Quality Center.
  • Involved in extracting the test summary from Quality Center.
  • Worked with Data Warehousing developers who extensively used Informatica, to design.
  • Mapping to move data from source to target database-using Stages to do the functionality.
  • Testing of Data Mapping documents between source and target databases as per the transforming logic.
  • Reviewing Test cases and scripts based on client requirements
  • Manual Functional, User Interface test and Regression test.
  • Involved in Execution of test cases to verify actual results against expected results.
  • Prepared bug and defect reports.
  • Preparing the SQL script to verify data and validating data from source and target Through Toad 9.0.1.

Environment: Data warehouse ETL Informatica 8.X, BI Business Objects, HP Quality center10.0/ALM11.0, QTP 9.2, Oracle 9i/10g, SQL/PLSQL, SSIS, Teradata V2R6, Windows 2000, SQL, SQL Plus, Rational Clear Case, DB2 8.x, MVS, ISPF, VSAM Files, Flat Files, XML Files

Confidential, Chicago, IL

ETL QA Tester - Retail Data Mart

Responsibilities:

  • Tested all phases of Data warehouse ETL Data stage jobs testing including Extraction, Transformation and Loading.
  • Tested various Business Objects Drill down reports and alerts. Business Intelligence reports using Web Intelligence module.
  • Extensively used Data warehouse ETL jobs 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.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Worked on issues with migration from development to testing.
  • Used and altered UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Worked with business team to test the reports developed in Cognos.
  • Used Data warehouse Data Stage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the testing
  • Managed data utilizing Excel, pivot tables, vlookup, conditional formatting and graphs
  • Created automated functional regression test scripts using QTP and scheduled, organized and executed the test scripts in QC-QTP integrate environment and documented the test results.
  • Tested Test scenarios that were used to validate the ETL Data warehouse movement
  • Written complex SQL queries for validating the transformation rules for ETL Jobs.
  • Tested Korn Shell scripts and cron jobs to refresh the load on weekly basis.
  • Tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
  • Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.

Environment: ETL Data stage, BI Business Objects, Oracle 9i/10g, SQL, PL/SQL, Stored Procedures, XML, XSD, Unix Shell Scripting, Teradata V2R5, SSIS, SQL Assistant 6.0, QTP9.2, Business Objects 6.5.

Hire Now