We provide IT Staff Augmentation Services!

Etl Tester (manual Testing) Resume

VA

SUMMARY:

  • Over 6years of comprehensive experience in the field of Information Technology as Senior ETL QA Analyst, Senior QA Analyst & Data warehouse Test Analyst covering different areas of Testing.
  • Good understanding of the Software Development Life Cycle, Software Testing Life Cycle and Bug Life Cycle methodologies with working knowledge on AGILE, SCRUM methodology and waterfall.
  • Experience in Manual and Automated Testing using Selenium Web - driver (core Java).
  • Experience in creating Test Scenarios, Test Cases and Test Scripts through hands on designing test cases covering all test conditions and eliminating redundancy / duplications.
  • Experience in SQL to extract the needed Test data.
  • Used Visual Studio Team Foundation server 2013 (TFS) to monitor work, code, build and test phases of the team.
  • Updated the tasks from to-do to done in TFS as sprint progresses every day.
  • Experience in Designing, Developing, Executing and Generate Reports using Application life cycle management MTM and HP (ALM)/QC.
  • Experience in defect tracking tool Bugzilla.
  • Experience in interacting with business analysts, developers, technical support teams and helping them in base lining the requirement specifications.
  • Experience in maintaining support documents, QA Sign off Documents and maintaining Status Reports.
  • Experience in creating Requirements Traceability Matrix to ensure comprehensive test coverage of requirements.
  • Hands on experience on GUI, Functional, Integration, Regression, System, User Acceptance, Smoke, Sanity, Performance, Compatibility, Security, Database Testing and Cross Browser Testing.
  • Hands on experience on working with huge data using Excel Mapping / Excel Pivots / SQL queries.
  • Good knowledge on data warehouse concept, ETL lifecycle, BI reports and writing complex SQL query.
  • Experience in creating X-path to find dynamic objects.
  • Knowledge of Core Java concept.
  • Experience in writing Generic Scripts and Project Specific Scripts.
  • Knowledge on Web Service Testing using SoapUI.
  • Worked on applications developed for Healthcare, Insurance and Retail industries.
  • Used Requirement Management Tools like Visual Source Safe (VSS).

TECHNICAL SKILLS:

Testing Tool: QC/ALM, Postman, SoapUI, Rally, Jira, Clear Quest, Doors, QTP,TOAD, SQLDeveloper,Informatica, OBIEE,SharePoint

Programming Languages: .NET, SQL/PL-SQL, HTML, DHTML, Perl, PHP, Java, XML, CSS. Json

Databases: Oracle, DB2, SQL Server, Teradata, Vertica.

Operating Systems: Windows, Linux. Winscp

Packages: MS Office (Word, Excel, Power Point)

PROFESSIONAL EXPERIENCE:

Confidential, VA

ETL Tester (Manual Testing)

Responsibilities:

  • Created Test plan & Script, Defect Management Templates; Created Initial test plan and developed test cases and test scripts manually.
  • Used Quality center to store all testing results, metrics, created Test Cases, and Reporting.
  • Reviewed Business requirements, IT Design documents and prepared Test Plans which involved various Test Cases for all assigned module/projects; Review Test Requirements, Creating Test Plans and Test Strategy documents.
  • Developed a Defects Tracking Log for the SharePoint Site to track defects while testing.
  • Involved in UAT testing, SIT Testing, Regression Testing and Functional testing.
  • Prepared meeting notes on daily execution/highlight of the project and send out the reports to managements.
  • Interact with Developers and Business Analysts to perform various types of testing throughout Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC).
  • Wrote Structure Query Language (SQL) queries to check proper data population in application table and for data verification to perform Backend Testing against Oracle Database.
  • Provided weekly status updates showing the progress of the Automation testing effort and open issues to be resolved.
  • Updating tasks in version-one and proving all the evidence documents in time before the end of iteration.
  • Reviewing the evidence for Completed regression, positive, negative, integration and functional testing to produce a bug free product

Environment: SoapUI, HP-ALM, Rapid-SQL, XML-SPY, WinScp, Jenkins, Putty, Notepad++, Ms-Office LINUX.

Confidential, NY

QA Analyst (Manual Testing)

Responsibilities:

  • Developing test scripts for execution using functional design document and unit design documents for New York Health Exchange (NY-HX) for very complex and large web based application (portal).
  • Building and maintaining test scenarios, test cases, defects, test scripts and Traceability Matrix.
  • Development of expected entry/exit criteria into test cases.
  • Prepared Test Schedules, Test data and Detailed test scripts according to the Release schedule.
  • Used Visual Studio Team Foundation server 2013 (TFS) to monitor work, code, build and test phases of the team.
  • Updated the tasks from to-do to done in TFS as sprint progresses every day.
  • Review test cases, monitor quality of the test cases and upload the test cases into MTM.
  • Defect logging using MTM and retesting of defect fixes.
  • Worked closely with DOH users and UAT Testers.
  • Documenting the test procedures and issues.
  • Conduct Smoke, Black box, Functional, Negative testing for release and Enhancements.
  • Verification of notice generation for various eligibility results and plan selection at database level.
  • Developing various eligibility scenarios.
  • Production support to perform regression testing and test defect fixes.
  • Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Java, Data studio 3.1, MS Office, TFS, MTM, Web-sphere, SQL Server, DB2LUW, Windows7.

Confidential, WI

ETL Tester

Responsibilities:

  • Analyzed the business process workflows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
  • Developed high level ETL test matrix based on business requirements, ETL functional and ETL technical specifications, and development standards for assigned projects/applications
  • Created test cases based on test matrix including test data preparation for Data Completeness, Data Transformation, Data Quality, Performance and scalability
  • Created SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations
  • Performed data quality analysis using advanced SQL skills
  • Executed ETL Test Cases and ETL Test Scenarios
  • Perform testing on Execute Package Task, Conditional Split, Data flow, and Derived column, Look Up and Merge Join Transformation and Task
  • Executed Quality ETL Test Plans and ETL Test Cases to verify reliability, accuracy and Compatibility of application
  • Extensive SQL querying on Staging, Data warehouse and Data Marts
  • Ensured Error logs and audit tables are generated and populated properly
  • Performed UAT and Regression Testing.
  • Tracked and reported the issues to project team and management during test cycles.
  • Updated and maintained existing ETL test Matrix and ETL test cases based on code changes and enhancements to assigned applications

Environment: MS Access, Informatica 9.6, SQL, PL/SQL, Autosys, Flat Files, OBIEE 11.1/10, Mercury Quality Center, Oracle 10g, 11g, HP Quality Center/ALM, Jira

Confidential

ETL/QA Tester

Responsibilities:

  • Wrote the SQL queries for landing table, staging tables and Masters table validate the data results
  • Working in Agile environment attend daily stand up, sprint planning, backlog grooming refinement and retrospective meeting.
  • Load the test cases in the ALM under test plan and execute the test cases in the test lab
  • Create task, update the task and input actual work
  • Reviewed Informatica mappings and run the job in workflow manager and to check in the workflow monitor to validate
  • Extensively used Informatica power center for extraction, transformation and loading process
  • Write the test cases and update as per the design documents and follow the mapping doc for the system Integration region
  • Write SQL queries to validate that actual test results match with expected results
  • Responsible for monitoring data for porting to current versions
  • Checked the reports for any naming inconsistencies and to improve user readability
  • Identify the complete test scenario for report testing and ETL testing.
  • Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source
  • Performed backend database testing by writing SQL scripts to verify data integrity
  • Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle
  • Involved in all testing phases: Smoke Testing, Functional Testing, System Testing, Performance Testing, Regression Testing, Integration Testing, and Quality Assurance Testing
  • Involved in validating the aggregate table based on the rollup process documented in the data mapping
  • Assisted in creating test data and test cases and execute function system tests as needed.
  • Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing

Environment: Informatica 10.0 SQL, PL/SQL, Flat Files, Csv file, Text file, UNIX, Winscp, ALM, Rally, Oracle 10g, 11g and ESP work station.

Confidential

QA Analyst (Manual Testing)

Responsibilities:

  • Review the entire flow of application to have knowledge on the functional flows
  • Understanding the requirement documents like BDD, UCD etc.
  • Involved in Test Case design-Identifying Test Scenarios & Test cases.
  • Involved in GUI Testing, Functional, Positive, Negative, Re-Testing, Regression Testing and Sanity Testing.
  • Reporting and tracking of Bugs using Bugzilla.
  • Involved in preparation RTM.
  • Participated in weekly meetings, monthly meetings etc.

Environment: Java, Bugzilla, VB, MS SQL Server and DB2, Windows XP.

Hire Now