Etl/ Qa Test Analyst Resume
Tampa, FL
PROFESSIONAL SUMMARY:
- Over 8+ Years of Professional Experience in Software Quality Assurance (QA) and Testing in different environments and platforms including Data Warehousing, Business Intelligence, Client/Server and Web based applications.
- Experience in Data Warehouse applications testing using Informatica, Ab Initio, DataStage and SSIS on multiple platforms.
- Experience in DBMS Utilities such as SQL, PL/SQL, TOAD, SQL Server, SQL*Loader, Teradata SQL Assistant.
- Involved in gathering requirements, developing Test Plans, Test Scripts, Test Cases & Test Data using specifications and design documents.
- Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
- Involved in all phases of the QA Life Cycle and SDLC, with timely Delivery against aggressive deadlines, with QA methodologies such as Waterfall, Agile, etc.
- Extensive experience in writing SQL and PL/SQL scripts to validate the databases systems and for backend database testing.
- Extensive working knowledge in UNIX/Linux operating systems.
- Experience in User Acceptance Testing, Performance Testing, GUI Testing, System & Functional Testing, Integration Testing, Regression Testing, Data Driven, Keyword driven Testing and both Manual as well as using automated testing tools including Win Runner, Load Runner and QTP.
- Experience in testing Business Intelligence reports generated by various BI Tools like Micro Strategy, Cognos and Business Objects.
- Experience in UNIX shell scripting and configuring cron - jobs, Autosys for scheduling.
- Involved in front-end and back-end testing. Strong knowledge of RDBMS concepts
- Having good knowledge on Oracle Data Integrator. Worked on Data files & label parameter of data file, strong in writing UNIX Korn shell scripting.
- Worked with XML feeds from multiple sources systems and loaded the same into EDWH.
- Solid experience in Black box & White box Testing techniques.
- Excellent understanding of the System Development Life Cycle. Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
- Performed Manual and Automated Testing on Client-Server and Web-based Applications.
- Extensive experience in drafting Test Flows, Test Plans, Test Strategies, Test Scenarios, Test Scripts, Test Specifications, Test Summaries, Test Procedures, Test cases & Test Status Reports.
- Strong knowledge of test methodologies: Object Oriented test methodology, Service Oriented Architecture, Top to bottom and Bottom to top test methodology, QA Validations & QA Compliances to ensure the Quality Assurance Control.
TECHNICAL SKILLS:
ETL Tools: Informatica, SSIS, DataStage, Ab Initio (GDE 1.14, Co>Operating System)
Programming: SQL, PL/SQL, UNIX Shell Scripting, PERL, XML, XSLT
Operating Systems: Windows 95/98/NT/2000, UNIX (Sun Solaris2.6/2.8, Linux 2.4,HP-Unix, IBM AIX 5.5)
Databases: Oracle 11g, 9i/10g, IBM DB2 9.x, Sybase 12.5, SQL Server 2008, TeradataV2R6 and Informix.
Testing Tools: HP Quality Center 10, 11 Rational Clear Quest
Version Control Tools: Clear Case, Ab Initio EME, CVS, PVCS 7.0
Tools: XML Spy 2010, TOAD, Putty, WinSCP3, Scorex,AppEdit v8.2, Ultra Editor, Control - M, TWS, FileZilla
PROFESSIONAL EXPERIENCE:
Confidential, Tampa, FL
ETL/ QA Test Analyst
Responsibilities:
- Created Test Plan for System Testing.
- Responsible for performing various types of process evaluations during each phase of the Software Development Life Cycle, including Review, Walk Through and hands on system testing.
- Identify & record defects with required information for issue to be reproduced by development team.
- Tested complex ETL DataStage jobs based on Business requirements and Business rules to load data from source files to target tables.
- Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
- Written several complex SQL queries for validating 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.
- Responsible for Data mapping testing by writing complex SQL Queries using TOAD.
- Experience in creating UNIX scripts for file transfer and file manipulation.
- Validating the data passed to downstream systems.
- Wrote complex SQL Joins, Unions and Nested Queries on various data tables for Data validation using DB2.
- Worked with Data Extraction, Transformation and Loading (ETL).
- Worked with business team to test the reports developed in Cognos
- Tested whether the reports developed in Cognos are as per company standards.
- Used HP Quality Center for writing the test cases and logging the defects.
- Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
Environment: DataStage, ALM/HP Quality Center 11.0/ALM, DB2, TOAD, Oracle 11g, Cognos, SQL, PL/SQL, SQL Server 2008, XML, XSLT, Autosys
Confidential, Alpharetta, GA
QA Analyst
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.
- Defined testing criteria, planned, created and executed test plans in a mainframe environment.
- 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.
- Validated all the applications and successfully executed and unit tested the jobs with DataStage director.
- 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.
- Extraction, Transformation and Load (ETL) of data from Legacy systems using DataStage.
- 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 XIR2 to XIR3.
Environment: SQL, PL/SQL, HP Quality Center 10.0, XML, Oracle 10g, Tibco, Mainframes, DataStage, Business Objects XIR3, TOAD for Oracle
Confidential, Baltimore, MD
Quality Assurance Tester
Responsibilities:
- Responsible for Business analysis and requirements gathering.
- Performed complex defect reports in various environments like UAT, SIT, and QA etc to ensure the proper delivery of the application into the production environment.
- Expertise in SQL queries for cross verification of data.
- Involved in extensive DATA validation using SQL queries and back-end testing.
- Used SQL for Querying the DB2 database in UNIX environment
- Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
- Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
- Used Ab Initio to extract, transform and load data from multiple input sources like flat files, Oracle 10g database to the Teradata database.
- Developed/Modified test graphs based on business requirements using various Ab Initio Components like Filter by Expression, Partition by Expression, reformat, join, gather, merge rollup, normalize, denormalize, replicate etc.
- Involved in testing data mapping and conversion in a server based data warehouse.
- Involved in testing the UI applications
- Created SQL Queries using SQL*Plus for dropping indexes prior to the load graph execution to be able to perform direct loads on the database tables.
- Involved in prepare the documentation and manuals for User Acceptance testing.
- Validated the Autosys jil scripts for dependencies, owner, description and other attributes.
- Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
Environment: Ab Initio GDE 1.15, Co-Op 2.15, EME, UNIX, Shell Scripting, XML Files, XSD, XML Spy 2010, Oracle 10g, Quality Center 10, BEA Web Logic 8.1, Autosys, Toad, Tivoli, QTP.
Confidential, Round Rock, Texas
ETL QA Tester
Responsibilities:
- Translate business-reporting requirements into data warehouse architectural designs and analyzing source and target data models and makes necessary changes.
- 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.
- Identify the primary key (logical / physical) and put update or insert logic.
- Deleting the target data before processing based on logical or physical primary key.
- Design and execute the test cases on the application as per company standards.
- Preventing occurrences of multiple runs by flagging processed dates.
- Written Test Cases for ETL to compare Source and Target database systems.
- Testing of records with logical delete using flags.
- Interacting with senior peers or subject matter experts to learn more about the data.
- Identifying duplicate records in the staging area before data gets processed.
- Extensively written test scripts for back-end validations.
- Ensured that the mappings are correct.
- Extensively used Toad to verify records that has been populated by ETL process.
- Responsible for de-duping and consolidating customer records from various sources to create master customer list.
- Prepared and implemented data verification and testing methods for the Data Warehouse as well as to design and implement data staging methods and stress testing of ETL routines to make sure that they don’t break on heavy loads.
- Involved in performing Functionality testing, Validation testing and System testing, testing manually on the first release of the application.
- Extensively used QTP as automation tool for automating the scripts for regression testing
- Used Test Director as a defect-tracking tool to keep track of defects during the testing process.
- Performed End-to-End testing after bug fixes and modifications.
- Used Tivoli as a scheduling software to schedule the Informatica jobs.
Environment: Test Director, Informatica 7.1, SQL, XML Files, XSD, DTD, XSLT, PL/SQL, SQLPlus, UNIX Scripts, TOAD, Clear Quest, Clear Case,QTP.
Confidential, Hopkinton, MA
Quality Analyst
Responsibilities:
- Involved in Data Analysis and Database Designing.
- Used MS Visio to develop the database design.
- Extensively involved in developing Data Dictionary.
- Created tables and various database objects.
- Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
- Involved in performing validation of datasets, tables and triggers by performing White Box Testing and code walk-through.
- Performed Data Profiling to improve search abilities by using tags and aliases.
- Dynamically adjusted price breaks in accordance with client pricing groups and allowed editing/addition of customer information to rapidly assemble on-screen, printed and database-recorded quotes.
- Developed test reports and participated in testing prioritization and archived test results and user signoff
- Involve with Design and Development team to implement the requirements.
- Performed execution of test cases manually to verify the expected results.
- Involved in creation of tables, writing stored procedures and Triggers.
- Developed user interface screens using VB, ADO to connect to backend and stored procedures to manipulate data.
- Handling user defined exceptions.
- Involved in testing, implementation & maintenance.
Environment: MS Visio, Crystal Reports 9.0, Metadata Repository, Visual Basic 6.0, SQL Server 2000, SQL, T-SQL, UNIX and Windows NT