ETL QA Tester
Resume:
VISHVA P
**********@*****.***
PROFESSIONAL EXPERTISE
Around 6+ years of experience in Software Testing focusing on Quality Assurance and Quality control projects of client/server, Data warehouse, Mainframe, Web Application based using manual and automated testing procedures.
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.
Extensively worked on Ab Initio Tool using various components like rollup, join reformat and techniques like parallel processing, component folding etc
Extensive experience performing Data warehouse testing with ETL and reporting tools like Informatica, Ab initio and Cognos.
Extensively worked on Fitnesse Tool which supports automating various kinds of application, scripting test cases and also integrating the modules.
Knowledge of installing, upgrading and configuring business intelligence and OBIEE tools
Experience in ETL methodology for supporting Data Extraction, Transformations and Loading Process in a corporate-wide-ETL solution using IBM Datastage8.0,7.X/6.X (Manager, Designer, Director, Administrator), Parallel Extender, Data Mining, OLTP, OLAP.
Handling all the aspects of administration tasks such as day-to-day site monitoring and maintenance, Installation, Configuration, Clustering, Deploying Applications, Troubleshooting, Load Balancing, Performance Tuning and Maintenance of WebLogic Server.
Participated in initial MDM implementations and future rollouts.
Experience with Customer Master Data Management (MDM) software tools (e.g., IBM Initiate, Informatica Siperian MDM) a plus.
Tested the setup of the Cloud development, test, and production environments.
Strong experience in Data Warehousing and ETL using Informatica Power Center 8.6.
Skilled in analyzing user requirements and building front-end BI applications.
Extensive experience using Informatica MDM Hub Console tool
Extensive experience using Informatica Power Center, Data mart, OLAP and OLTP tools.
Proficient with RDBMS and Data Warehousing concepts and Web Applications with about 8 years of experience using Oracle, DB2, Teradata, MS SQL Server.
Experience in using Automation Tools: Quick Test Professional, Quality Center in Client/Server and Perl, Python.
Performance tune the Weblogic Server resources such as Connection Pool, JMS servers, and to Configure the Weblogic Server for SSL communication.
Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
Provide support in the development of OBIEE components and solutions
Maintained existing data migration program with occasional upgrades and enhancements.
Utilize Lowes based software Genesis, Sterling, Click, Siebel etc.
Have good understanding of Tableau architecture, design, development and end user experience.
Tested complex mappings using Mapplets and reusable transformations.
Familiarity with different aspects of Facets implementation lifecycle.
Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting.
Experience with Star and snowflake schema.
Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
Install, upgrade and configure database solutions through OBIEE tools
Performed data migration enforcement tasks.
Tuning of Ab Initio Graphs for better performance.
Created reusable email tasks in Workflow manager for process exception handling.
Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.
Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
Knowledge in architecture design of Extract, Transform, Load environment using Informatica Data Director, Informatica MDM Hub.
Upgradation of WebLogic servers in development, testing and production environment and applying patch and service packs
Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Oracle XMLTYPE data type to store XML files.
WebLogic Administration, Monitoring and Troubleshooting using Admin Console.
Experience in testing reports developed by tools like Cognos and Business Objects report.
Experience in testing mainframe applications which are developed using COBOL II, DB2, IMS and CICS. Worked on Both Online and Batch systems.
Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings.
SKILL MATRIX:
Quality Assurance
DOORS, Agile, Waterfall, SCRUM, Test Plan, Test Strategy, Defect Tracking
QA/Test Management
HP ALM 11/HP Quality Center 10, Test Director 7.5, QTP 10, Gensis, sterling, selenium.
Databases
Oracle 11g/10g/9i/8i/8.0/, SQL Server 2012/2008, PL/SQL, IBM DB2, Teradata 13, MS Access 7.0/97/2000, MS Excel 2007
Database/GUI Tools
SQL *Loader, SQL*Plus, TOAD, SQL Assistant 13.0
ETL/Datawarehouse Tools
Informatica 9/ 8.6.1 (Power Center/ Power Mart, Ab initio, DataStage 8.1
Database Modeling
Star Schema, Snowflake schema, Fact and Dimensions Tables, Physical and Logical Data Modeling, Dimensional Data Modeling, Erwin4.5/4.0/3.5/3.0
BI/Reporting
SAS 9.1, Business Objects XIR4, Cognos 8.4, OBIEE 10.1.3, MS Access Reports, Pivot Tables
Programming
Unix Shell Scripting, C, SQL, Java PL/SQL, HTML, XML, Perl, Python
Environment
Windows NT/95/98/2000/XP, UNIX, MS DOS, RED HAT LINUX
PROFESSIONAL EXPERIENCE:
OPTUM/ United Health Group, MN January 2017 - Present
QA/ETL Tester
Responsibilities:
Involved in envisioning phase calls with business users, SME's and source teams to understand the requirements, identifying the sources to build the NAR data mart and generate business campaigns.
Validated the DMCMs (data model change management) with business requirements and logged defects for data model inconsistency.
Worked with business analyst, requirement analysts, mappers (MDW), developers and other testers to resolve issues with requirements/mapping transformations.
Designed, developed test cases/scenarios based on ETL Source-to-target (MDW) mapping document and NAR application functional requirements.
Collaborated with lead and customer to develop the test and acceptance plan criteria for Performance and data testing.
Analyzed & helped in fixing the ETL load issues and debug the UNIX scripts.
Tested different sources such as flat files, main frame legacy flat files, DB2 and XML to load data into the DB2 data mart.
Worked in Service Oriented Architecture (SOA) with UI Interface (front end), Services Interface (Middle Tier) and Database Interface (backend).
Maintaining knowledge of Medicare and Medicaid rules and regulations pertaining to the Facets configuration and evaluating the impact of proposed changes in rules and regulations.
Performed Black Box testing including Smoke, Functional and Regression testing.
Used CA Technologies Rally for creating and executing all test cases.
Also used Rally for logging defect using Agile Standards.
Created and executed XML scripts to validate the data in SQL Server to that of the front end.
Performing End to End testing of the application including Black box testing, Functionality testing using manual testing and Regression testing using Automation testing QTP/UFT.
Tested user interface and navigation controls of the application using QTP.
Participated in moving the application from QTP/UFT to Selenium.
Also participated in creating automated test cases using Selenium WebDriver.
Used Selenium Grid to run test cases in multiple browsers and Platforms.
Attended weekly/Daily QA, Agile Scrum meeting.
Created and maintained SQL Scripts and UNIX Shell scripts to perform back-end testing on SQL Server database.
Environment: Rally (CA Agile Central), SQL Server 2012, QTP 9.2, Selenium Web Driver, Agile/Scrum Methodology, Linux/Unix
OPTUM/ United Health Group, NC November 2015 – December 2016
QA/ETL Tester
Responsibilities:
Attended meetings with the Business Team, and Build Teams to gather the information about the project and the design methodology and the testing requirements.
Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
Participate in weekly meeting with the management team and walkthroughs.
Worked in Rally by CA technologies to manage all the user stories and defects in the project.
Good hands on experience with the Web application with testing at different levels both manual and automation.
Developed and Tested Various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
Tested data models and data maps (extract, transform and load analysis - DTL analysis) of the Data Mart's and feeder systems in the aggregation effort.
Coordinating with source system owners, day-to-day ETL progress.
Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.
Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Data Director, Informatica MDM Hub, SSIS & Data Stage
Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center.
Designing Test cases for the User stories for functional testing.
Executing the test cases as per the acceptance criteria.
Verifying the data in the database along with the functionality in the UI.
Identified the root cause of bad data ie source issue, history issue or ETL issue.
Grooming sessions for the user stories for functional testing.
Agile methodology meetings regarding the project.
Support in the Regression, hardening, UAT and Production for testing the functionality.
Ensure that quality processes are carried out through all phases of the Software Development Lifecycle.
Develop and implement efficient and effective testing strategy, test conditions and test scripts.
Ability to develop database testing queries using complex SQL.
Work closely with the Business and Developers to test business critical functionality of the reports.
Partner with the Business and the Development Teams to fix defects.
Ability to test the flow of data between the databases and the reports.
Worked on issues with migration from development to testing.
Work with project team to identify risks if quality assurance process is not followed.
Own and manage test environments and processes.
Reporting, tracking and resolving quality issues.
Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
Worked on Fitnesse Tool to automate various test cases, scripting different modules based on the application requirements and also designed the work flow of the components.
Created temporary tables for validations after understanding the transformation logic.
Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
Developed and executed the test scripts with fitness tool and java.
Created and enhanced numerous test scripts to handle changes in the objects, in the tested application's GUI and in the testing environment using fitness.
Environment: Informatica 7.1, PL/SQL, Fitnesse, Oracle 9i, SSIS, SQL server Management studio, Quality Center 9.2, QTP 9.2, Rally (CA Agile Central), HP ALM, IBM InfoSphere DataStage.
Bimbo Bakeries, NY May 2014 – October 2015
ETL/QA Tester.
Responsibilities:
Prepared Test Plan, Estimation and Overall project tracking for every release.
Involved in Gathering requirements from Business and Preparation of Test Scenarios and Test Cases.
Performed Functional Testing, Smoke Testing, Integration Testing, System testing, User acceptance testing and Regression Testing.
Created Test data to work with centralized DB creation which flows for all the dependent products.
Used Ab Initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases
Created Reusable Transformations, Work lets and made use of the Shared Folder Concept using shortcuts wherever possible to avoid redundancy.
FTP the New & Existing Ab Initio applications to the Local Host.
Developed test cases for ETL coding and mapping standards based on design spec document
Experience in creating UNIX scripts for file transfer and file manipulation.
Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing Involved in extensive DATA validation using SQL queries and back-end testing.
Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
Tested warehouse metadata, naming standards and warehouse standards for future application development.
Perform Data Integration, Data comparison and Data Validation for Back End Testing of Parallel production.
Developed startup and shutdown scripts for the Weblogic servers.
Implemented Database Checkpoints for Back-end Testing.
Involved in extensive DATA validation using complex SQL queries and back-end testing.
Validated the data flow from centralized database to different products by executing sql scripts.
Wrote complex Sql scripts to generate daily reports in order to check the data flow in different environments.
Worked with Data masking validation between different schemas using Toad for oracle and Sql server.
Developed Cubes, Reports and Dashboards in Micro Strategy as per Business requirement.
Experience with Customer Master Data Management (MDM) software tools (e.g., IBM Initiate, Informatics Siperian MDM) a plus.
Verified backend to frontend UI flow of data under different modules.
Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
Monitor and managing the Weblogic server instances using WSLT and also for the automation purpose.
Directed testing effort of eleven build iterations of a distributed Java middleware application, which utilizes MQ Messaging and SOAP XML web services.
Validated cube and query data from the reporting system back to the source system.
These were system-to-system functional, regression, integration and performance tests.
Tested PL/SQL statements to verify the output and compared against ETL Output
Written several UNIX scripts for running test loads for regression testing purpose.
Responsible for testing Business Reports developed by Business Objects XIR2.
The reports that were created in Business Objects were testing by running the SQL statements.
Used Quality Center for bug reporting.
Involved Execution of Test Cases and reporting Defect and tracking them to Closure.
Preparing and analyzing daily, Weekly and Monthly status reports.
Environment: Informatica 9.1, Informatica Power center 8.6.1, Ab Initio, Oracle 11g, OBIEE,HP Quality Center 10.0, QTP 10.0, Business Objects Enterprise XI R2/ R3, SQL,PL/SQL, Windows 2000, UNIX, Excel.
MVP healthcare, Buffalo, NY September’13 – March’14
Sr ETL QA Test Engineer
Responsibilities:
Experience in translating business requirement to functional requirements and prepared use cases. Involved in defining business context, stakeholders need, requirement management, vision and scope of the system and feasibility analysis.
Created, implemented and executed Test Plan, Test Cases, Test Scripts, Test Scenarios, Test Data based on the on the Technical Design Document and Requirements Specification Document.
Connected remotely to UNIX servers using PUTTY and FTP files across different test environments by using Hummingbird and Command prompt.
Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center.
Involved in Identifying of the unused test cases in the Test Plan in Quality Center and prepared a consolidated doc to delete the test cases.
Documented all PL/SQL procedures and user guide for different processes followed.
Used T-SQL for Querying the SQL Server2005 database for data validation and data conditioning.
Performed Functional Testing and Back-end Testing using the database comparable results Manually.
Involved in extensive DATA validation using SQL queries and back-end testing.
Extensively Queried through SQL to check the database records.
Developed SQL scripts to perform Backend Testing.
Verify the presence and location of required medical devices, according to the applicable product documentation (drawing, assembly procedures, bill of material, etc).
Used SQL for Querying the DB2 database in UNIX environment.
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.
An extensively used Complex SQL statement for retrieving data using TOAD and it is used in T-SQL scripts.
Verified the Business Scenarios on new builds to allow extended testing by the QA team.
Involve in setting up Test Environment, Test Data Source, Test Cycle, Release Cycle, for functional, Integration, System, UAT and Regression testing of the application.
Report defect issues into the bug reporting/tracking systems and followed up with the development team until resolved the status of the defect accordingly using Quality Center.
Involved in testing Data Marts and Mapping Sources and Targets, performed data validation while dealing with missing data and reconciling during extracts and loads.
Done research on validating the quality of Data Extracts from the source system before loading it to the database.
Involved in the validation of data at various levels (source, Staging, Warehouse)
Wrote complex Teradata SQL Queries to comply with the conditions specified in extracting data from the TD Warehouse.
Interacted with Business users and developers collected business information and their requirements to test reports.
Developed reports using Ad-hoc reporting.
Environment: Informatica 8.1(Repository Manager, Repository Sever Administration Console, Designer, Workflow Manager, Workflow Monitor), PL/SQL, SQL Server 2005, SQL, SQL Server Reporting Server (SSRS), UNIX, Perl,T-SQL,HP Quality Center 9.2, QTP 9.2, Oracle 9i, TOAD, DB2 7.0, Putty Client, XML, Windows 2000.
Birlasoft, India June’11 - August’13
QA Tester
Responsibilities:
Creating Business Test Plan using Requirements.
Conducted Regression testing for subsequent versions of the same application.
Performed various phases of testing to ensure an acceptable level of performance of the prudential product, phases included unit, regression, smoke, integration, system and acceptance testing.
Involved in the preparation of test plan specifying an overview of testing approach, testing strategy, roles, and responsibilities and testing scope.
Wrote complex SQL queries to perform the backend testing of the Oracle database using PL/SQL developer and UNIX shell commands.
Developed test scripts for data-driven tests using win runner.
Performing queries on the database using ‘SQL’ to check successful Transaction and to create particular test cases.
Configured Quick Test Pro with Quality Centre and Maintained the project information in Quality Centre.
Called WinRunner scripts into Quick Test Pro.
Extensively conducted Back-End Testing using which involved complex SQL Queries.
Writing new shell scripts and modifying existing shell scripts.
Automating the shell scripts using Autosys Job Scheduler.
UNIX shell scripting to run the Informatica workflows and store header and footer information in flat files. Writing UNIX functions to run different steps of jobs to load and validate data.
Writing wrapper script in UNIX shell to run the whole process, rename/moving flat files for archiving and emailing the flat files to clients.
Logging, Tracking defects, and Version Control using Test Director.
Environment: UNIX, QTP, Quality Center, Windows XP, Oracle, Toad
Contact this candidate