We provide IT Staff Augmentation Services!

Data Warehouse Etl Qa Tester Resume Profile

Professional Summary:

  • Around 7 years of professional experience in Software Industry, Expertise in all kinds of testing Manual and Automation with focus on Business Intelligence, ETL, Data warehouse, DataMart, Databases, Web services, Client-Server applications
  • Extensive knowledge on all phases of Software Development Life Cycle SDLC .Experience in Agile, Scrum and Waterfall models of SDLC.
  • Extensive experience in Software Testing Life Cycle STLC and Defect Life Cycle DLC . Participate in complete testing Lifecycle, Test Plan, Test Cases, Test Execution, Defect Report.
  • Extensive use of defect tracking tools like Quality Center and Test Director. Experience in functional testing tools such as SOAP UI testing QTP Automation testing
  • Wrote complex SQL and PL/SQL queries to validate DataMart and Data warehouse Backend Testing
  • In-depth knowledge of all QA Phases that include Manual, Functional, System, Integration, Regression Testing End-to-End testing
  • Experienced in Integrating and coordinating testing activities into software development activities
  • Proficient in designing, reviewing and documenting system test plans, defining test procedures and creating test cases on the basis of product release features, client's requirements and related technical documents.
  • Worked with different RDBMS Oracle, SQL Server, Teradata, MySQL, IBM DB2 and their GUI utilities like SQL Loader, Oracle SQL developer, Teradata SQL Assistant, WinSQL to do transaction of data
  • Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
  • Worked heavily on testing various Data warehouse ETL process with tools includes Informatica, DataStage, Ab Initio, SSIS as well as many reports developed used various BI tools includes Business Objects, Cognos, Microstrategy, OBIEE, SSRS and Crystal Reports
  • Excellent knowledge of HIPAA standards, EDI Electronic data interchange , transaction syntax like ANSI X12, Implementation and Knowledge of HIPAA code sets, ICD-9, ICD-10 coding and HL7
  • Excellent in writing SQL and PL/SQL queries and UNIX shell scripts to perform Backend testing
  • Coordinated Proficient in querying various RDMS like Oracle, Teradata, DB2 and SQL server Using TOAD, WinSQL, SQL Loader, Oracle SQL Developer, SQL server Management studio
  • Designed the Data Driven tests in Quick Test Professional QTP script to validate with different sets of test data. Used Quality Center for defect tracking.
  • Strong working experience in the Data Centric Testing, Data Analysis, Design and Development
  • Supporting multiple projects, while maintaining strong quality and ability to meet deadlines
  • Proficiency using Rational Clear Case for Documentation and used Clear Quest for Defect tracking.
  • Excellent analytical skills, documentation skills and presentation skills
  • Self-starter and ability to present ideas in a concise, logical and well organized format

Technical Skills:

Bug Tracking/Test Management

HP ALM/Quality Center/ Clear Quest/Clear Case/ Load Runner

Data warehouse ETL Tools

Informatica 9.6, Data Stage, AbInitio, SSIS

Reports Business Intelligence

Business Objects, Cognos, SSRS, Microstrategy, Crystal Reports, Hyperion , SAS

Relational Database RDBMS

SQL Server, Oracle, Teradata, MS Access, MySQL, IBM DB2

Operating Systems

Windows, Vista ,UNIX, Linux

Methodologies

Scrum, Agile, Spiral, Waterfall and Kunban

Business Tools

SQL, PL/SQL, TOAD, QTP, SOAP UI, web services,

Programming Languages

Java, .Net, XML, HTML, C/C , VB Java Script

Microsoft Tools

Microsoft Excel, Word, Power point, MS Project , Visio

Professional Experience:

Confidential

Sr. Data warehouse ETL QA Tester

Responsibilities:

  • Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
  • Designed and executed various Test scripts for Regression tests
  • Validated ETL Informatica test data for all transformation rules and covered all the scenarios required for implementing business logic.
  • Backend testing of the Data Base by writing SQL queries to test the Integrity of the application and SQL Server databases.
  • Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
  • Proficient in validating the transformation and edits on claims as required by the CMS.
  • Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
  • Extensively used ETL Informatica methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
  • Have programming skills in SQL and PL/SQL and experience in SQL Server and Oracle databases on UNIX and Windows platforms.
  • Tested reports developed by Business Objects Universes for both Adhoc Canned Reporting users of Business Objects XI R3
  • Written Complex SQL Queries. To do manual testing in my feature on the SDM tool for every release and check the configurations
  • Use Business Objects OLAP Intelligence to natively access and analyze OLAP servers. OLAP Intelligence tool helps to Slice, dice, and drill directly on multidimensional sources and deliver workflows via the Web, Windows, and Microsoft Excel
  • Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.

Environment: Data warehouse ETL Informatica, BI Business Objects, SQL, PL/SQL, SQL SERVER 2008, Quality Center 9.0,TFS, XML, XSLT, EDI, TOAD, IBM DB2, HL7, EDI, HIPPA, ICD, UNIX, PERL , MS Access, Flat Files.

Confidential

Sr. Data warehouse QA Analyst

Responsibilities:

  • Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
  • Designed and executed various Test scripts for Regression tests
  • Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
  • Different Data Stage components especially are used effectively to develop and maintain the database
  • Developed ETL test cases for various lines of businesses based on ETL Infornmatica mapping document.
  • Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
  • Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
  • Extensively used WinSQL for querying SQL queries against DB2 database to validate the Data Driven results.
  • Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System End to End and Backend Database .
  • Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using ETL Informatica Power center.
  • Involved in investigating the errors by tracking the root cause for the error.
  • Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
  • Extensively used ETL Informatica methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
  • Have programming skills in SQL and PL/SQL and experience in SQL Server and Oracle databases on UNIX and Windows platforms.
  • Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
  • Perform data mining activities using WinSQL tool for our own testing needs as well as client's testing
  • Created ETL test data for all ETL Informatica mapping rules to test the functionality of the SSIS packages.
  • Tested several different types of reports including Report Layout, Naming Conventions, Totals, Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters using Business Objects.
  • Used BO Info View for testing the scheduled reports and viewing the history.
  • Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
  • 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.
  • Good experience in writing SQL in order to data validation in migration as part of backend testing worked with ETL group for understating mappings for dimensions and facts.
  • Assisted in promotion of ETL Informatica Power center code and UNIX from UAT to Production.
  • Worked on issues with migration from development to testing.

Environment: Data warehouse ETL Informatica 9.6.1, Business Objects, WinSQL, DB2, Quality Center 11.0, XML, XSLT, WinSQL, SQL Server 2005, DTS, SSIS, T-SQL, SQL, TOAD, SQL Assistant 6.0, Oracle 9i/10g, PL/SQL, IBM DB2,UNIX, PERL, , MS Access, Flat Files.

Confidential

Data warehouse ETL Tester

Responsibilities:

  • Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
  • Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
  • Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
  • Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
  • Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
  • Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
  • Tested the XMLs feeds received from another source which is a third party for data consistency.
  • Tested the ETL with XML as source and tables in the data warehouse as target.
  • Tracked defects to closure by coordinating with the dev team.
  • Tested source data for data completeness, data correctness and data integrity.
  • Performed End to end testing starting from the source to the report.
  • Conducted and coordinated integration testing and regression testing.
  • Participated in business requirements gathering and in modifications of the requirements based on the scope.
  • Worked with the DSO team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
  • Prepared test data to cover all the test scenarios.
  • Prepared UNIX scripts to run the Informatica ETL jobs from command line.
  • Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
  • Tested the migration of reports from Business objects.

Environment: Data warehouse ETL Informatica 8.6, Business Objects, SQL, PL/SQL, HP Quality Center 9.2, XML, Oracle 10g, QTP, ALM, SOAP UI, JavaScript and TOAD for Oracle

Confidential

ETL QA Tester

Responsibilities:

  • Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
  • Responsible for creating Test plan, development of test scripts, execution and validate Test results and document test evidence.
  • Comparing/analyzing mainframe test data with the front end.
  • Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
  • Involved in various kinds of testing like functional testing, system testing and integration testing.
  • Running SQL queries on the mainframe servers to retrieve test data.
  • Creating and running automated scripts through Mercury Win runner.
  • Reviewed Functional and Integration requirements.
  • Develop Functional and integration test cases and review Test Cases wrote by peers.
  • Created Test Cases, and got reviewed those by peers
  • Tested a number of complex ETL mappings and reusable transformations for daily data loads.
  • Designed the Data Driven tests in Quick Test Professional QTP script to validate with different sets of test data.
  • Discuss issues/defects with the business and development teams.
  • Testing/Verifying/logging defects.
  • Written complex SQL queries for querying data against different data bases for data verification process.
  • Developed UNIX Shell scripts to automate repetitive database processes
  • Performed application setup in test environment and enhancing the documentation.
  • Worked with internal and external developers/quality assurance staff to understand and resolve issues.

Environment: DWH ETL Informatica, SQL, PL/SQL, Quality Center, SOAP UI, Java, J2EE, SQL Server /Oracle 8i, TOAD, windows XP.

Confidential

ETL QA Analyst

Responsibilities:

  • Assist entry-level tester s on reviewing requirement, preparing and executing test cases and report software defects. Performed black box, Functional, Integration, Stress and Regression testing of the Website.
  • Performed Regression Testing to verify various sections of the system to ensure that changes or fixes in the system not only work, but also do not adversely affect the remainder of the system.
  • Created and executed SQL queries to validate the data and used data manipulation language.
  • DML to update the data in the database and verify with front end that application handles the changes correctly.
  • Initiated defects and assigned to Development teams with appropriate severity levels.
  • Actively participated to setup the test environment for the application s needs to be deployed on test environment.
  • Used Quality Center to maintain Test Case and Reports Repository.
  • Executed the Test cases using Test Director Tool for Web based application and checked the functionality of the application for every release.
  • Prioritized and reported defects using QC to present documents and reports in weekly team meetings.
  • Participated in weekly status meetings, conducted walkthroughs, documented proceedings. Modified and maintained test cases with changes in application interface and navigation flow. Conducted weekly batch testing to incorporate changes in new builds.
  • Provided the management with test metrics, reports and schedules.

Environment: Test Director 7.5, Oracle 9i, SQL, T-SQL, SSIS, SQL Server 2005, MS Excel 2003, Shell scripting, UNIX, Windows NT

Hire Now