We provide IT Staff Augmentation Services!

 etl Qa Engineer Resume

Frisco, TX

SUMMARY:

  • 6 Years of Software Test Life Cycle experience, which includes gathering test requirements, set - up test environment, write and execute test cases, report and follow-up defects in an agile and waterfall environment.
  • Experience in developing Test Cases, Test Scripts, Test Plans, Test Scenarios, Test Reports and documentation for both Manual and Automated tests.
  • Experience with tools including HP Quality Center/ALM and Quick Test Professional.
  • Experienced in testing Web-based and Client-Server applications.
  • Extensive experience in writing SQL and executing SQL Queries to validate data in the back end, in RBMS like Oracle.
  • Extensively worked in Client-Server application development using Oracle 12c/11g/10g
  • Involved in cross-platform testing. Experienced in using various Defect-tracking tools.
  • Experience in understanding the Business Requirement Document and Technical Design Document.
  • Performed extensive data validation against Data warehouse. Loading Flat file Data into Teradata tables using Unix Shell scripts.
  • Through understanding of software quality activities throughout the software development life cycle (SDLC).
  • Detailed understanding of QA methodology (Agile, Waterfall) to ensure quality control.
  • Proficient in different phases of Testing like Black Box Testing, White Box Testing, Functionality Testing, Unit Testing, Integration Testing, System Testing, Modular Testing, Backend Testing, Load Testing, Regression Testing and User Acceptance testing.
  • Good exposure to ETL testing with strong SQL skills.
  • Experienced in using Load Runner for performance test.
  • Good experience with writing and utilizing SQL queries for data verification in Oracle and other RDBMS.
  • Extensive knowledge and experience in all stages of the Software Development Life Cycle (SDLC) beginning from initiation and definition to deployment and support.
  • Experience in Black box testing with a complete QA cycle from testing, defect logging and verification of fixed bugs.
  • Tested transformation and business rules for ETL mappings
  • Experienced with various domains such as Financial, Health care, Retail and Insurance.
  • Ability to effectively communicate testing activities and findings in oral and written formats with Excellent Analytical skills.
  • Experience in writing the UNIX Commands.
  • Experience in working the technical developers to understand the data flow.
  • Expertise in using TOAD, SQL Developer.
  • Knowledge in SQL Query Tuning for long taking SQL’s.
  • Experience in using the code deployment tools like anthill.
  • Experience in understanding the oracle PL/SQL code and UNIX Shell scripts.
  • Experience in working on scheduling tools like autosys.
  • Experienced in data analysis, data modeling, testing and documentation of Projects.
  • Experience in SDLC methodologies.
  • Strong Trouble-shooting, Problem solving and Possess good communication skills and quick learning ability.

TECHNICAL SKILLS:

IDE: Microsoft Visual Studio, TOAD, Oracle SQL Developer

Programming languages: PL/SQL programming, SQL

Operating Systems: Unix, Solaris, Windows 98/XP/Vista/7, Windows Server 2003

Script Languages: UNIX shell scripting, XML, HTML, Job information language(jil)

Database: Oracle 12C/11G/10G, Microsoft SQL Server 2005, MS-Access 2000/2007/2010

Other Tools: Anthill, Pac2000, HP Quality Center, ALM and Quick Test Professional, HP Quick Test Professional (QTP), Rational Clear Quest, Load Runner, Putty, autosys.

Modeling Tools: UML, ERWIN

PROFESSIONAL EXPERIENCE:

Confidential, Frisco, TX

ETL QA Engineer

Responsibilities:

  • Responsible for Business analysis and requirements gathering.
  • Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
  • Performed complex defect reports in various environments like UAT, SIT to ensure the proper delivery of the application into the production environment.
  • Developed data quality test plans and manually executed ETL and BI test cases.
  • Designed and kept track of Requirement Traceability Matrix.
  • Assisted in kicking off Data stage ETL jobs using UNIX and analyzed the data in dimension and fact tables.
  • Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
  • Worked with the co-testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project.
  • Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
  • Used Quality Center for defect tracking.
  • Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files.
  • Performed data quality analysis using advanced SQL skills.
  • Tested slides for data flow and process flows using PowerPoint and Microsoft Visio.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
  • Extensively used the Report Inspector tool to change, multiple reports database schemas, scheduling multiple reports, deploying and publishing.
  • Tested the messages published by data stage and data loaded into various databases.

Environment: SQL, PL/SQL, HP Quality Center 10, Data stage, Rational Clear Quest, MS Excel, Business Objects Enterprise XI R3, Teradata 12.0, Teradata SQL Assistant, autosys, Korn Shell Scripting, Putty.

Confidential, Charlotte, NC .

Application Tester/ QA Engineer

Responsibilities:

  • Actively participated in gathering Business Requirements and System Specification from system users.
  • Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
  • Developed Test Plan and overall Test Strategy for the Application.
  • Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel.
  • Developed Test Scripts for System and UAT Testing.
  • Extensively used SQL queries to check storage and accuracy of data in database table.
  • Performed basic testing of security features using manual testing.
  • Responsible for creating Test Strategy for the Data Warehouse.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
  • Responsible for communicating Defect Status Reports to business in project meetings.
  • Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
  • Extensive user of Clear Quest for defect tracking, process automation, reporting and lifecycle traceability for better visibility and control of the SDLC.
  • Strong Windows operating-system background, with understanding of the key drivers and influences on performance.
  • Developed SQL Queries for Back end testing.
  • Involved in automation of test cases using HP ALM/QC.
  • Involved in testing meetings and creating the defects for the developers.
  • Reported bugs and tracked defects using Quality Center.
  • Responsible for tracking the defects and involved in creating the problem tickets.
  • Involved in the production support team for planning cycle after production implementation.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
  • Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
  • Actively participated in creating and scheduled autosys jobs for automation of PL/SQL wrapper scripts in UNIX.
  • Experience in creating the test autosys jobs in DEV.
  • Experience in understanding the job description.
  • Interacted with developers on creating the file watcher, command and box jobs.
  • Written several UNIX scripts for invoking data reconciliation.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Used SQL for Querying the Oracle database in UNIX environment.
  • Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.

Environment: Oracle 12c,11g,, Toad, Oracle SQL Developer, Erwin, MS Outlook 2010, autosys, UNIX, MS Excel 2010, pac2000, HP QC/ALM.

Confidential, Schaumburg, IL .

ETL QA Engineer

Responsibilities:

  • Worked with QA Supervisor in estimating the testing effort of assigned projects based on the requirements.
  • Tuned SQL queries to improve response time.
  • Developed test cases and test steps from business requirements and documented in Quality Center in accordance with QA standards and processes.
  • Created test data and set up test environment, wrote test cases, executed them and tracked Defects in Quality Center and helped resolving technical issues with developers.
  • Provided status updates to QA Supervisor and attended Monthly Test case review Meetings.
  • Prepared test data, test environment, plan for test and production deployment; Conducted post deployment validation and regular health checks.
  • Written SQL queries to perform database testing and also to verify data using Advantage database and TOAD.
  • Worked closely with developers, business Analysts, product owner to open/resolve issues, troubleshoot issues, support for root cause analysis.
  • Creates test data for manual and automated testing when necessary to meet specific scenarios; Organized test case reviews and results walkthroughs with stakeholders, raise and maintain defects and obtain needed signoff as per standards.
  • Interacted with UAT testers and further modified the application based on the user requirements, recommendations.
  • Performed Regression testing to make sure that all the bugs have been fixed and the application is running properly.
  • Utilized HP Quality center as a test management tool for planning and executing Manual scripts and for defect reporting and tracking.

Environment: Oracle 10g/9i, SQL*Plus, SQL developer, TOAD, HP Quality center.

Confidential

QA Analyst

Responsibilities:

  • Worked closely with business management, development teams to understand the objectives for better results.
  • Participated in Sprint Planning and Grooming sessions of User Stories as part of agile methodology.
  • Participated in Daily Stand up meetings.
  • Provide the users/data to team for the testing.
  • Developed and executed several SQL queries in ETL Tester as a part of backend testing and involved in data validation and verifying data-integrity.
  • Performed additional data validation using custom SQL Extensively wrote and executed SQL queries to extract data from the target tables to prove the data mapping.
  • Extensively Used SQL to validate backend database changes, deletes and update.
  • Extensively used Toad to verify source data and target data after the successful workflow runs using SQL.
  • Tested data conversion from source table to target table Using ETL.
  • Writing SQL queries, to verify that the appropriate tables are populated with the data as expected.
  • Managed & scheduled all Manual scripts from HP Application Lifecycle Management (ALM) using the Requirements, Test Plan, Test Lab and Defects modules.
  • Responsible for Defect Tracking and Management Metrics.
  • Tested the Autosys job schedules every day, Notify to the users when job failures.
  • Deploy the builds in Test environment using IBM Clear Quest.
  • Testing various positive and negative test scenarios related to Schema, parsing exceptions and data format.
  • Attend and participate in project management/status/review meetings, facilitate defect meetings and provide issue resolution regarding project status and quality and risk management.
  • Ensured QA test documentation is reviewed by project stakeholders and get them signed off and update the documents in SharePoint.
  • Documented the daily defects status with the help of QA Metrics and Traceability.

Environment: HP ALM 11, TOAD,, Abinitio, Clear Quest, Share point, Oracle, Windows 10,MS-Word, MS-Excel, Putty, WinSCP.

Confidential

QA Analyst

Responsibilities:

  • Work with project team to define and create overall strategy and ensures quality.
  • Review Project Artifacts and Requirements, Define test process including required test activities and deliverables.
  • Analyze the business and functional requirement specifications for Testing.
  • Assist in decomposing high-level requirements identified in the documentation into testable, detailed requirements.
  • Verify Requirement Traceability Matrix constantly to determine if each and every Functional requirement is mapped to a test scenario.
  • Develop Test Plans and Test Strategy from design and requirements documents; consolidate scenarios and test cases.
  • Involve in Estimation and Resource Planning for the project.
  • Coordinate with development engineers and prepared test plans and endured functionality of all applications.
  • Coordinate with developers, business analyst to understand Business process.
  • Prepare test cases satisfying all the business requirements by going through the use cases and the designs in HP ALM 11.
  • Participate in all phases of the test cycle, including Integration testing, System Integration testing, Performance testing, Smoke Testing, Regression testing and User acceptance testing.
  • Involved in Cross Browser testing for different combination of OS and Browsers both Web and Mobile browsers.
  • Involved in Data Mining and test Data management in various environments using tool DMART (Data Mining & Reservation Tool).
  • Responsible for Defect logging and Management using HP ALM 11.
  • Responsible for running Defect Triage call with various development, testing teams and business stakeholders and ensure timely resolution of defects.
  • Creating Defect Reports using HP ALM and Status Reporting to senior management.

Environment: Windows 10, MS-Word, MS-Excel, Putty, UNIX, WinSCP, HP ALM.

Hire Now