We provide IT Staff Augmentation Services!

Sr. etl/qa tester Resume

NJ

SUMMARY:

  • Over 7+ years of experience in ETL Testing/ QA Analysis and Testing with excellent skills in client interfacing, testing, user support, quality assurance, problem solving, and documentation.
  • Expertise on back end testing using SQL on Oracle, Teradata, MS SQL server environments to verify data integrity & knowledge of ETL testing.
  • Well capability to work as a team player or to work independently in a time sensitive environment.
  • Experience in testing of applications which use integrated databases using, Business Objects , Oracle and SQL Server.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide- ETL Solution.
  • Have experience working in Agile/Scrum Methodology.
  • Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
  • Worked in multiple responsibilities such as reviewing of ETL architecture, ETL design , and analysis and ETL technical specifications.
  • Expertised in using Informatica and Abinitioas an ETL Tool for validating data in the the Data Warehouse.
  • Excellent skills in writing Test Plans and Test Cases.
  • Experience in testing Client/Server and Web-based Applications.
  • Good experience in test management tools like Quality Center (ALM), IBM ClearQuest , and Rational Quality Manager.
  • Proficient in manual and automated testing of applications in Windows environment.
  • Hands on experience on various kind of testing such as Positive, Negative, Integration, System, end to end, Back End, Sanity, Smoke, User Acceptance ( UAT ), Security and Regression Testing.
  • Conducted usability and user acceptance testing ( UAT ) on behalf of end users.
  • Experienced in analyzing business requirements at all stages of software development life cycle ( SDLC ).
  • Expertise in translating user requirements into System Specifications and mapping the process design, work flows for SDLC with documenting and managing business requirements.
  • Strong analytical skills, ability to link strategies and objectives to develop a plan.
  • Excellent communication skills, ability to send and receive information clearly and concisely.
  • Strong teamwork skills possess exceptional group facilitation skills, negotiating and building consensus.
  • Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports , and Weekly Status Reports.
  • Strong planning/organizing skills, capable of managing major projects simultaneously.
  • Able to establish and attain high standards for self and team; able to make decisions, solve problems and produce results.
  • Hands on experience writing SQL queries.
  • Familiar with different methodologies like Water fall and agile .
  • Knowledge and implementation experience of Quality Assurance , Testing Principles, and Configuration and Change Management Disciplines.
  • Expertise in preparing Test Strategy, Test Plan, Risk Assessment Document, Test Summary Reports, Test Cases, Test Scripts and Test Harness for Manual and Automated Testing based on the User Requirement Document and System Requirement documents for the Functional, System, Performance, Integration, Regression, GUI, UAT, Database, and UAT testing.
  • Develop full life cycle Test Plans including business rule and business model testing with full function testing; develop User interfaces and requirements sessions.
  • Experience in end-2-end ETL testing, including Unit, System, Integration and UAT testing.
  • Have the ability to evaluate an ETL /BI specification, verify it with Systems experts and data architects, and assess if it complete and fully understand EDW and ETL Architecture .
  • Extensive experience in manual testing the ETL, Business Intelligence , Client/Server, and Web applications.
  • Hands on experience in writing test scripts, preparing test data, testing ETL Mappings and creating SQL scripts.
  • Extensive Experience in Validating BI reports which is created based on IBM Cognos, SAP Business Objects etc.
  • Good expertise in using TOAD, DB Visualizer, Oracle SQL Developer, SQL*Plus .
  • Good experience in writing SQL/PLSQL in order to data validation in migration as part of backend testing. And comparing data from Flat files to database for the feeds.
  • Extensively used SQL queries to interact with ORACLE/DB2/SQL Server databases.
  • Performed Manual , Unit, Integration, System, Regression, and Acceptance Testing.
  • Define the Test Process identify the Risks, Test Stage definition, Baseline Acceptance Criteria, and Test Deliverables.
  • Experience in HP Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually , Defect Logging, Defect Reporting.
  • Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings.
  • Work individually, as well as in team environment, to achieve desired project quality goals.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center 9.2/8.0, Test Director, Clear Quest, HP ALM 12.00/11.52/11.00, JIRA 7.1.9/7.3.4, Polarion ALM 17.1, Load Runner.

Databases: Oracle 8i/9i/10g/11i/11g, SQL Server 2012/2008/2005, MS Access, DB 2 9.7/8.0/7.0/6.0, Teradata 14.0/V2R5/V2R6/15.10, Netezza 7.0.2/3.0.5, SAS 9.4

Utility Tools: Agility Workbench 4.3, TOAD 8.5, Teradata SQL Assistant, DB2 client, SQL Server Management Studio, SQL*Plus, SQL*Loader, SQL Developer and SQL Query Analyzer, Advanced Query Tool, WRQ Reflection, Ultra Edit, Win merge, SAS Enterprise Guide 4.3.5

ETL Tools: SSIS, Informatica 9.5/9.0, DataStage 8.7/8.0/7.1, Ab Initio 3.0.4

Reporting Tools: Cognos 10.2.2, SSRS, Business Objects, Micro Strategy, OBIEE

Operating Systems: Windows 95/98/2000/XP, Vista, 7, Linux and UNIX, Touch Point.

Microsoft Office: Excel Access, Outlook and Power Point, MS Visio, Word, Lotus Notes, Clear Case, SQL, MS Visual Studio.

Programming Languages: SQL, PL/SQL, T-SQL, C, C++, Java, Unix Bash Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis

Sr. ETL/DWH/QA Analyst

Responsibilities:
  • Analysis, Design, Development, Testing of ETL applications.
  • Involved in the various stages of Data warehousing life cycle development, database logical and physical design, ETL processes and Performance Tuning.
  • Extensively worked on the Informatica Power Center 9.0 tools -Designer, Workflow Manager, Workflow monitor.
  • Worked in up gradation of Web focus project to test the reports as a part of internal project in the company.
  • Involved in Informatica Administration such as creating and configuring Repository, folders, users and groups using Informatica Power Center Repository Manager.
  • Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
  • Worked on Web Focus reports analysis.
  • Worked with development teams on the Web Focus reports in the production support team.
  • Work with testing teams and resolve issues in Quality Center.
  • Developed and tested Informatica mapping to extract data from different source systems (like Oracle, SQL Server, Fixed Width and Delimited Flat Files) and load into Teradata data warehouse.
  • Implemented SCD methodology including Type 1, Type 2 changes to keep track of historical data.
  • Extensively worked on transformations like Lookup (Connected and Unconnected), Aggregator, Expression, Router, Filter, Update Strategy and Sequence Generator, Sorter, Joiner, Expression, Union.
  • Used Repository Manager for moving the mappings and sessions from one environment to another, such as from a development environment to Test and UAT environments.
  • Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
  • Used the Workflow manager to create workflows, work lets and tasks.
  • Analyzed session Log files in case the session failed to resolve errors in mapping or session configurations.
  • Created stored procedures, packages, triggers, tables, views and synonyms in Oracle.
  • Made Scheduling changes as per Client's Requirement such as defining a new job, modifying an existing job, calendar updates, adding predecessors and successors to the existing job in TWC/Maestro scheduler.
  • Involved in Trouble shooting problems by checking session log files also used debugger for complex troubleshooting.
  • Used debugger to test the mapping and fixed the bugs.
  • Documented Informatica mappings, design and validation rules.
  • Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and USER testing.
  • Maintained extensive documentation for design, implementation and testing informatica mappings.
  • Worked with the components of Data Warehousing like components model, ETL tools.
  • Tested Abinitio graphs for File to Table and Table to file conversions required for EBCIDIC format and XML files.
  • Maintained the Requirement Traceability Matrix using Mercury Quality Center .
  • Executed test cases and test scripts manually and using automation tools.
  • Performed Functional, Regression and Integration testing.
  • Responsible for designing and managing UAT test scenarios.
  • Used QTP and RAID automation tools for Functional, Regression and Data Driven testing .
  • Used SQL tools such as SQL Query Analyzer for creating SQL queries to verify the integrity of the data.
  • Performed extensive back-end testing and database auditing using SQL Server.
  • Used Quality Center as a release management tool.
  • Provided production support for the releases.
  • Validated the Data warehouse ETL Informatica scripts for data conditioning, transformation, validation and loading.
  • Performed smoke and sanity testing while deploying the reports from Dev system to QA to prod box.
  • Tested Sets, Metrics, Productive Analysis and Enterprise Performance Management (Scorecard and Dashboard).
  • Involved in understanding the service request and making the relevant changes to the Business Objects universe and reports functionality.
  • Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
  • Designed the Data Driven tests in Quick Test Professional ( QTP ) script to validate with different sets of test data.
  • Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities.
  • Performed data validation by writing SQL queries and creating ad hoc reports using desktop intelligence and web intelligence.
  • Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects.
  • Used Mercury Quality Center and JIRA to house all test documentation, report/track all issues and defects.
  • Provided clear concise feedback to development team on recurring errors both on an individual and team basis.

Environment: Informatica Power Center 9.1, Web Focus, Murex, Oracle 11g, Teradata 13/12, SQL Server 2005, Toad, SQL Plus, PL/SQL, UNIX (Korn) Shell Scripting, TWC/Maestro scheduler, Windows XP, MS Visio, QTP, Load Runner, Quality Center.

Confidential,NJ

Sr. ETL/QA Tester

Responsibilities:
  • Performed manual testing, functional testing and usability testing Responsible for Smoke Testing for the Build on Daily basis.
  • Participated in the Requirement understanding discussion with Business and IT teams. Scheduling Requirement Clarification meeting with BA team.
  • Responsible for documenting the functional requirements in Quality Center within Requirement module and providing linkage to the respective Test Scripts.
  • Prepared high level System Test Scenarios and Test Conditions for various functional segments. Worked on the Test schedules, Test estimates for the Test Script development and execution.
  • Written Test Cases for various functional segments based on the Detailed Business Requirement (DBR) documents, Detailed Technical Design (DTD) documents and Use Cases in Quality Center.
  • Responsible for Test Case Design, Test Scenarios walkthrough with Business and IT teams as part of review process and receive the Signoff approvals.
  • Developed test scripts using QTP for Functionality and Regression Testing.
  • Manually performed Smoke testing for basic functionality checking as Entry criteria for the System Testing.
  • Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Data Report testing in Business Objects.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting Tested SQL queries to validate the data and performance of the database Wrote complex SQL queries between sources and target for validating ETL jobs.
  • Functional Testing, Regression Testing and Acceptance Testing.
  • Working with different customers and work with center of excellence groups in taking key decisions.
  • Involved in extensive data validation using SQL queries and back-end testing.
  • Performed job monitoring testing using Control-M.
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Provided the UAT and Production support for End to End Test Script execution and Defect retest.
  • Good experience in onsite model work.
  • Schedule and Co-ordinate testing tasks in QC.
  • Organize defect triage calls Development and Business team to resolve outstanding issues. Worked on Informatica Workflow monitor to run workflows.
  • Validated the BO Reports by checking the summary records in the cube equal the total of the detail records in the report when queried using the same parameters.
  • Gathering detailed business requirements and Technical requirements.
  • Analyzing and solving problems for change requests/ Enhancements.
  • Maintained Test Logs and Test Summary Reports and prepared Weekly Status Reports.
  • Developed test cases to accomplish ETL data migration.
  • Designed the data for interpreting the positive/negative Scenarios.
  • Performed MS SQL Server T - SQL Queries, creating Tables, and Views by following Teradata Best Practices.
  • Experience in using Automation Tool Quality Center (QC) in Client/Server.
  • This work will include loading of historical data onto the Teradata platform, as well as reference data and metadata.
  • Tested the Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
  • Tested the ETL Informatica mappings and other ETL Processes ( Data Warehouse Testing ).
  • Tested the Oracle PL/SQL testing programs.
  • 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 XIR2 to XIR3.

Environment: Informatica, Oracle 11g, TOAD, SQL Server, QTP, Oracle 10g, Teradata, Agile, SQL, HP Quality Center, PL/SQL, Business Objects, UNIX, Rational Clear Quest, Autosy, PL/SQL, Informatica Power Center.

Confidential, New York

Sr. BI/QA /ETL Tester (DWH)

Responsibilities:
  • Understanding the end to end Buisness Flow and respective changes in-order to create the Test Scenarios, Test Plan and Test cases.
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for reporting purposes.
  • Created ETL execution scripts for automating jobs.
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process.
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
  • Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.
  • This work will include loading of historical data onto the Teradata platform, as well as reference data and metadata.
  • Involved in Designing Logical and Physical Data model using Erwin Tool Responsible for different Data mapping activities from Source systems to Teradata.
  • Experienced using database query tools for Oracle, SQL and UNIX such as Toad, Teradata SQL Assistant and SQL Plus.
  • Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
  • Used Toad and SQL plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
  • Performed extensive Database Testing by writing complex PL/SQL Queries in TOAD to test different scenarios of the application.
  • Experience in using Automation Tools Quick Test Professional, Win Runner and Quality Center in Client/Server.
  • Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting.
  • Creating test scripts using Quality Center and performing regression testing on new versions of the software.
  • Used SQL tools to run SQL queries and validate the data loaded in to the target table.
  • Extensively Queried through SQL to check the database record.
  • Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL.
  • Involved extensively in doing back end testing of the data quality by writing complex SQL.
  • Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
  • Extensively used SQL queries to extract the data from different fiscal week, fiscal quarter for different stores as required for analysis from the Oracle databases.
  • Create the Oracle Workflow processes or procedures and packages.
  • Ran SQL Statements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
  • Tested the data from different sources sources to the target.
  • Designed SQL queries and fine tuned SQL queries for better performance.
  • Wrote complex SQL, PL/SQL testing scripts for Backend Testing of the data warehouse application.
  • Worked with users & analysts to understand requirements.
  • Participated in client meetings to review Integrated Data approaches and to interpret results.
  • Closely involved in gathering requirement, design, development and implementation of the project.
  • Defined the testing requirement documents.
  • Worked with Development Team to draft the Development Checklist and Plan for Iteration Releases.
  • Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
  • Performed database validation according to the business logic by comparing the source to the target in Spreadsheet.
  • Work with source system personnel on source data delivery issues.
  • Interacted with DBA for setting up test environment.
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources.
  • Extraction of test data from tables and loading of data into SQL tables.

Environment: Informatica 9.0, OBIEE 10.1.3.x, PL/SQL, SQL, Oracle 11ig, HP ALM, HP Quality Center, UNIX Shell Scripting, (MS Access, and MS Excel PowerPoint Outlook).

Confidential,Carolina

Sr.QA Analyst

Responsibilities:
  • Developed and execute test cases, test scenarios and followed-up defects.
  • Studied User Requirement Specifications (URS) and converted them to Functional Requirement Specifications (FRS) and Software Requirement Specifications (SRS) for application modules.
  • Used ALM to import test data, defects and test cases.
  • Bug reporting, tracking and documentation on the Bug tracking System using ALM.
  • Analyzed the results of manual and automated tests.
  • Integration and Regression testing and System testing.
  • Conducted functional and regression testing using QTP.
  • Extraction of test data from tables and loading of data into SQL tables.
  • Participated in daily defect tracking conference calls with developers, Product manager, and Project manager.
  • Participated in requirement walkthroughs and creation of test plan.
  • Conducted Gap Analysis to ensure all Business Requirements was covered by test cases.
  • Performed Sanity Testing and Smoke Testing.
  • Developed SQL Queries to perform database testing.
  • Performed Backend Testing using Toad.
  • Experience in testing and writing SQL and PL/SQL statements.
  • Involved in testing the databases using complex SQL queries.
  • Involved in extensive data validation using SQL queries and back-end testing.
  • Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.
  • Responsible for providing testing effort estimation, defining the test scope and creating test data for user stories.
  • Identifying the test scenarios to be added to the test suite for effective and reusable test execution.
  • Responsible for defining the test strategy and creating the test plan and executing the test within the functional scope and the Regression scope.
  • Created Test cases, Test Procedures, Test Scripts and created input data values for both positive and negative testing.
  • Performed Black box testing, functional testing, UI testing, integration, end-to-end testing, Regression Testing, cross browser testing, and performing build acceptance (smoke) testing after each build and Conducted User Acceptance testing.
  • Extensively involved in testing like Retest, Regression, Functional, Integration, Smoke, user acceptance, Sanity, SQL report, End to End and Business logic.
  • Experience in Agile Methodology by using Jira test management tool.
  • Experience in all aspects of the software development life cycle ( SDLC ) with specific focus on testing.
  • Involved in Data Validation testing by using SQL server for backend testing.
  • Create and validate datasets as per dataset requirement and specification.
  • Create and performed database system testing and integration testing.
  • Involved in testing Schema, data validation, ETL data on (OLTP) transaction database store, source and staging table.
  • Experience in validation of user activities, restriction, rules, and number of session.
  • Experience source data to verify completeness, accuracy and quality check activities including store procedure, user defined functions, views, triggers and other common database objects.
  • Prepared the traceability matrices to fill the gap between the requirement and test case covered.

Environment: Xcelys, ALM, QTP /UFT, SQL, SQL Server 2008, Oracle 11g, Excel, Power point, Share point.

Confidential

Sr.QA Tester

Responsibilities:
  • Involved Manual testing, Functional Testing, Black box testing, Regression testing, System testing, Integration testing and end-end testing, User Interface testing and Data Driven Testing.
  • Gathered test data requirements for data conditioning from Business Units to test total application functionality.
  • Responsible for testing Remedy Incidents (production defect tickets), regression testing existing functionality of the application and features.
  • Created test scenarios for System testing and Regression testing.
  • Prepared test plans, test cases for both positive and negative scenarios and mapped the same to requirements.
  • Executed test scripts, and analyzed the test results.
  • Used Test Director as a central repository for all the test activity.
  • Attended meetings with developers in the discussion on resolving the issues, priority of bugs and updating the status of bugs once they are fixed.
  • Responsible for writing the SQL queries to verify GUI front-end results and to extract and to manipulate the data to satisfy test cases/ requirements.
  • Tested Web page presentation manually for different browser compatibility.
  • Tested broken links and inter application links in Development, Test, and Production environments.
  • Bug tracking and defect logging tools like Bugzilla, Jira, remedy, HP Quality Center/ALM.
  • Executed test cases before and after bug fixes for each build for User acceptance testing.
  • Tested the application for third party vendor confirmation and client reports as peruse cases.

Environment: Test Director, Win Runner, J2EE, Tomcat, HTML, UNIX Oracle and Toad.

Hire Now