We provide IT Staff Augmentation Services!

Etl/dwh Tester Resume

Raleigh, NC

PROFESSIONAL SUMMARY:

  • 7+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
  • Solid Back End Testing experience by writing and executing SQL Queries
  • Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
  • Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices
  • Expertise in designing the test scenarios and scripting the test cases in order to test the application and Test Data Management Plan.
  • Worked with technologies like WSDL, SOAP, SOAP UI, XML, XPath and Web Services
  • Expert in PERL, UNIX Shell Scripting&SQL writing for several technology needs
  • Involved in Developing Data Marts for specific Business aspects like Marketing & Finance
  • Creation of test data and Automation of test cases for system and analyzing bug tracking reports
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using ETL tools like Informatica and Data Stage
  • Extensively strong on databases including Oracle, MS SQL Server, and Teradata
  • Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
  • Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
  • Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C JavaScript, Shell Scripting

Databases: Oracle, MS SQL Server, MS Access, Teradata, DB2, Informix

Reporting Tools: Business Objects, Cognos, Crystal Reports, Microstrategy, SSRS

Tools: TOAD, Win SQL, Teradata SQL Assistant, BTEQ, XML Spy 2008

Operating Systems: Windows, UNIX

Tools: MS-Office suite (Word, Excel, Project and Outlook)

Testing Tools: Quality Center, Quick Test Professional, Performance Center

ETL Tools: Informatica, Data Stage, Ab Initio, SSIS

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

ETL/DWH Tester

Environment: Informatica Power Center, .Net, Teradata, ALM/HP Quality Center, SOAP, SOAP UI, QTP/UFT, Agile, MICROSTRATEGY, SQL Server, Perl

Responsibilities:

  • Prepared test data based on data mapping document.
  • Have experience in validating the business transformations by writing complex SQL queries.
  • Executing Autosys jobs and validating the source and the target files.
  • Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins using Rapid SQL.
  • Tested Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.
  • Involved in testing all the reports that were generated through MicroStrategy.
  • Review each PBI with the Product Owner as part of Definition of Done.
  • Hands on experience in using Autosys scheduling.
  • Onsite/offshore coordination on daily bases.
  • Involved in generating Test Scripts using QTP/UFT for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing.
  • Validated various Reports, Custom filters, Prompts, Custom groups, Consolidations and Drill paths developed in MicroStrategy.
  • Extracted certain column of data from a number to files using PERL
  • Used PERL for automating all the types of modules at a time
  • Tested data migration to ensure that integrity of data was not compromised.
  • Coordinating data movement and validation with third party vendors.
  • Implementing ATDD Test concepts for defined User Stories.
  • Responsible for coordinating Integration testing, UAT and Regression testing with Business Consultants and Offshore team members, as applicable.
  • Extracted data from various sources like Oracle, flat files and SQL Server
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning
  • Managed and executed the test process, using Agile Methodology.
  • Involved in web services testing using SOAP UI, validated request and response XML.
  • Developed several SQL queries for data retrieval from TERADATA and used every utility available in including MLOAD, FLOAD, FAST EXPORT, BTEQ AND TPUMP
  • Strong Informatica and data loading experience
  • Worked with PERL control structures & Regular Expressions for substitutions based on matches
  • Worked with PERL for file manipulations, text processing, data parsing and Converted SQL queries results into PERL variable
  • Used Toad for query Oracle, SQL Assistant for Teradata and SQL Management studio for SQL Server
  • Developed test scripts using QTP/UFT for Functionality and Regression Testing.
  • Validated various MicroStrategy reports such as ad hoc, grids, graphs.
  • Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
  • Actively participate in production deployment check-out activities and communication.
  • Work on Test Strategy for each sprint and help refine the Acceptance Criteria for all PBI’s.
  • Draft and review test plans every sprint.
  • Performed Web Service testing using HP Service Test and SOAP UI.
  • Identify business rules for data migration and Perform data validations.
  • Used MicroStrategy Web to offer interactive reporting to the end users.
  • Involved in various testing phases like Integration Testing, System Testing, Regression testing and Inactive prod testing.
  • Ensure defect management activities for all bugs identified, reported and worked upon.

Confidential, Phoenix, AZ

ETL/DWH Tester

Environment: Informatica Power Center, Oracle, SQL, PL/SQL, SOAP, SOAP UI, Teradata, ALM/HP Quality Center 11, TOAD, MICROSTRATEGY, Perl, SQL Server, MS Excel, Agile, .Net, XML, XSD, XSLT, XML Spy

Responsibilities:

  • Analyzed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.
  • Created complex SQL queries for querying data against different data bases for data verification process.
  • Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
  • Executed test cases for web-based MicroStrategy reporting application.
  • Tested new Data migration tool used in the mapping of data to new system.
  • Data migration of raw data to excel documents for clients
  • Participated in defining and executing test strategies using agile methodology.
  • Tested several complex reports generated by MicroStrategy including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • 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 Test cases for Data Acquisition and Data Delivery and tested the data accuracy for all the transformations.
  • Used T-SQL for Querying the SQL Server database for data validation and data conditioning
  • Performed database testing with SQL queries to verify data integrity using QTP/UFT.
  • Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
  • Extracted certain column of data from a number to files using PERL
  • Used PERL for automating all the types of modules at a time
  • Conducted backend testing by querying databases to synchronize testing databases and checked for data integrity and proper routing based on workflow rules at each step.
  • Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
  • Prepared reusable function in QTP/UFT to use across the automation scripts.
  • Generated the detailed Bug reports and Defects were tracked, reviewed and analyzed.
  • Involved in meetings to discuss the findings in the executed tests and decide the next steps.
  • Developed and Performed execution of Test Scripts manually to verify the expected results.
  • Validated that application meets requirements and functioning as per the technical and functional specifications.
  • Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.
  • Tested the functionality and performance of web services using SOAP UI.
  • Used Quality Center to state requirements, test plan, test cases, and update test run status for each iteration and to report the defects.
  • Worked on issues with migration from development to testing
  • Involved in recording change requests on the Change Requests.
  • Created Requirement Traceability Matrix by mapping the requirements with test cases to ensure that all requirements are covered in testing
  • Used TOAD & SQL Navigator GUI tools for Querying Database.
  • Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
  • Involved in testing the MicroStrategy reports by writing complex SQL queries.
  • Developed the detail ETL Test Plan, Test Resource Utilization and Close Down document for multiple products.
  • Developed complex queries to test the reports developed.
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging table
  • Tested the data and data integrity among various sources and targets.

Confidential, Charlotte, NC

ETL QA Test Engineer

Environment: Informatica Power Center, XML, XSLT, XPath, XQuery, MICROSTRATEGY, SQL Server, ALM/ HP Quality Center, SQL, TOAD, Teradata SQL Assistant, Oracle, PL/SQL

Responsibilities:

  • Involved in understanding Logical and Physical Data model using Erwin Tool
  • Prepared the guides for UAT& Production readiness for entire ETL testing efforts.
  • Prepared Execution procedure document format to prepare the Test cases based on mapping document.
  • Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
  • Ensured that the mappings are correct and Conducted data validation testing
  • Worked with PERL control structures & Regular Expressions for substitutions based on matches
  • Worked with business analyst and developers in setting up test data
  • Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.
  • Extensively tested several MicroStrategy reports for data quality, fonts, headers & cosmetic
  • Writing complex SQL queries for data validation for verifying the ETL Mapping Rules
  • Extensively test the reports for data accuracy and universe related errors
  • Tested several dashboards and deployed them across the organization to monitor the performance
  • Used SQL tools to run SQL queries and validate the data loaded in to the target tables
  • Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
  • Involved in user training sessions and assisting in UAT (User Acceptance Testing)
  • Have review meetings with project members to gain system understanding and identify business, system and functional requirements.
  • Monitored the workflow transformations in Informatica work flow monitor
  • Preparing manual test cases and test data for Scenarios
  • Developed test plans, test cases and test scripts for data validation testing.
  • Huge experience on testing MicroStrategy Reports. Validated the underlying Sql query, Report layout and the naming conventions against the requirement, Formatting Properties like alignment, scroll bar, decimal places etc, Export/ Print functionality.
  • Performed end-to-end testing of applications and coordinated with other teams.
  • Created and executed Test scripts for system validation and user acceptance testing (UAT)
  • Did database backup and recovery mechanism Using PERL
  • Created ETL execution scripts for automating jobs
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
  • Tested Operation Data Store process of ODS/DWL product
  • Used workflow manager for session management, database connection management and scheduling of jobs

Confidential

ETL Tester

Environment: PERL, UNIX Shell Scripting, Oracle, Informatica, QTP, SQL *Loader, Cognos, SQL Server, Windows, TOAD, PL/SQL

Responsibilities:

  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements
  • Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document
  • Written complex SQL queries for querying data against different data bases for data verification process
  • Performed UAT testing
  • Designed the data flow diagrams using VISIO
  • Prepared the Test Plan and Testing Strategies for Data Warehousing Application
  • Preparation of technical specifications and Source to Target mappings
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
  • Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director
  • Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans
  • Written several complex SQL queries for validating Cognos Reports
  • Worked with business team to test the reports developed in Cognos
  • Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
  • Extensively used Informatica power center for extraction, transformation and loading process
  • Creating test cases for ETL mappings and design documents for production support
  • Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
  • Scheduling and automating jobs to be run in a batch process
  • Effectively communicate testing activities and findings in oral and written formats
  • Reported bugs and tracked defects using Test Director
  • Worked with ETL group for understating mappings for dimensions and facts

Hire Now