We provide IT Staff Augmentation Services!

Sr. Etl Qa Tester Resume

Vernon Hills, IL

SUMMARY

  • 7+ years of widespread experience as an ETL QA Analyst involving in the entire SDLC and working with Client Server, DWH ETL/BI Reports, API’s, Web, Backend, Database applications, Amazon Cloud Services,, Linux, Snowflake, Oracle database, Cloud databases, Control - M, JIRA, TFS, Azure DevOps.
  • Extensive experience in the Information Technology industry, involving analysis, ETL and BI testing of Data warehouse applications, and reporting applications, API testing.
  • Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts, and Test Scenarios.
  • Proficient in Azure DevOps, TFS, Jira and Quality Center/ALM for Defect Tracking.
  • Experienced in testing requirements that were developed in ETL and BI tools and reviewed scripts for Positive and Negative test scenarios, and prepared Test Summary reports.
  • Possess extensive experience performing Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration and User Acceptance Testing.
  • Extensive experience in Agile, Scrum Methodology and waterfall methodologies of SDLC.
  • Well experienced in writing complex SQL queries for extracting data from multiple sources.
  • Excellent experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
  • Proficient in HP Quality Center/ALM for Test Designing, Requirement Mapping, Reports and Defect Tracking.
  • Extensive experience working with ETL tools like DataStage, Informatica, SSIS.
  • Good experience in SSRS, Cognos, TFS and Business Objects Reports testing. Hands on expertise in Data warehousing concepts and tools.
  • Experience working in UNIX environment for file/data manipulation and configuring jobs for Informatica sessions schedule
  • Experience in Dimensional Data Modeling using Star and Snowflake Schema and working with slowly changing dimensions Type I II and III.
  • Ability to work independently or in a team environment or in a rapid pace environment.
  • Possess strong interpersonal skills, communication and presentation skills with theability to interact with people at all levels.

TECHNICAL SKILLS

Test Analysis: Functional Requirement Gathering & Analysis, Analyzing Business RulesTest Flows, Test Planning, Causal Analysis of DefectsSystem Change Request, Impact Analysis

Test Management: MS Project Test Scheduling, Test Director, Quality Center Traceability Matrix for Requirements and Defects

Testing Methodologies: Object Oriented, Keyword Driven and Data Driven testing, Requirement based, Risk based, Priority based test methodology

Mercury Interactive: Quick Test Pro, Business Process Testing, Test Director, Quality Center

ETL Tools: Informatica 7.1/8.x, SSIS 2008

Bug Reporting: HP Quality Center/ALM, Zephyr

Version Control: Rational Clear Case 7.1/7.0.1/7.0.0

Scripting languages: VB Script, HTML, Shell Scripting

Operating Systems: Windows XP/NT/2000/Vista/7, DOS, UNIX

Databases: NoSQL, Oracle 10g/9i, MS SQL Server, IBM DB2, Teradata, MS Access

MS Suite: MS Office 2007 (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Vernon Hills, IL

Sr. ETL QA Tester

Responsibilities:

  • Participate in Scrum meetings and provide daily QA status updates.
  • Involved in gathering and analyzing the user requirements in coordination with Project Team.
  • Analyze all the documents and understand what needs to be tested.
  • Develop test cases and prioritize testing activities for projects in hand.
  • Test case execution and defect reporting define severity and priority for defects.
  • Tested new and existing ETL Processes (Data Warehouse Testing) written several complex SQL queries for validating
  • Involved in testing reports generated by Cognos. Tested the functionalities Drill down/Drill Up.
  • Worked with the DW Architecture team in Testing complex Delta processing loads.
  • Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
  • Involved in proof of concept process for acquiring new automation tool
  • Tested API’s using tools like Soap/UFT/Tricentis Tosca.
  • Technologies: SSIS, Azure Devops, TFS, SSIS, SOAP UI, Tricentis Tosca.

Environment: HP ALM, TFS, ETL Informatica, BI, Cognos reporting, SQL Server management, Azure Devops, Tricentis Tosca.

Confidential, Rosemont, IL

Sr. ETL QA Tester

Responsibilities:

  • Participate in Scrum meetings and coordinate with Business Analysts to understand the business needs and implement the same into a functional design.
  • Involved in developing Test Strategy, Test planning, writing test cases/Test scripts, Traceability Matrix.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing) written several complex SQL queries for validating.
  • Interacted with the Data Warehouse team to verify all the information is sent in correct format
  • Involved in gathering and analyzing the user requirements in coordination with Business.
  • Worked with the System test lead in developing the Test Plan and Testing Strategy for ETL, for Business Reports and executed the test process, using Agile Methodology.
  • Write Source code, prepare test data, tests and debug programs; revise and refine programs to improve performance of the application software.
  • Worked with the DW Architecture team in Testing complex Delta processing Loads. Performed performance tuning by optimizing Target, Source, Mapping and Session.
  • Organize and participate in various department coordination meetings and assist project managers to prioritize all development process, validate test results.
  • Involved in migration of ETL Informatica mappings / workflows from Development to Testing and to production.
  • Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
  • Contributed to design, analyzed and conducted back-end testing using SQL scripts on a database developed from Data Mining.
  • Worked with the DW Architecture team in Testing complex Delta processing Loads. Performed performance tuning by optimizing Target, Source, Mapping and Session.
  • Technologies: Amazon Cloud Services, Linux, Snowflake, Oracle database, Cloud databases, Control-M, JIRA, Informatica

Environment: HP ALM, Zephyr, JIRA, ETL Informatica, BI, Oracle, Tandem, Tibco, SOAP UI, SOAP & REST services

Confidential, Richfield, MN

Sr. ETL QA Tester

Responsibilities:

  • Participate in the analysis of business requirement, functional and technical design.
  • Involve in developing detailed test plan, test cases and test scripts for functional, system and regression testing.
  • Test complex ETL mappings and sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Tested data from various sources like Oracle, DB2, flat files, XML’s, and SQL Server.
  • Review test plan, test cases, test results for functional, system with the development, BA’s and SA’s.
  • Involve in data mapping specifications to create and execute detailed system test plans.
  • Demonstrated experience in QA, SIT and UAT testing for a large data warehouse.
  • Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
  • Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
  • Performed extensive DATA validation using SQL queries and back-end testing. Used SQL for Querying the SQL server database in IT and UAT environment.
  • Used Teradata SQL Assistant for Querying Teradata and Advanced query tool for querying DB2. Performed quality assurance reviews on all System Development Life Cycle.
  • Participated in defect review meetings with the team members. Used MS-Word for documentation.
  • Involved in other test planning meetings and submitted test metrics daily to the management.
  • Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
  • Involved in migration of mappings / workflows from Development to Testing and to production.
  • Worked on validating REST API services using SOAP UI.

Environment: BI Cognos, Salesforce lightening, HP Quality Center/ALM, DB2, SQL, PL/SQL, Oracle, SOAP UI, XML, IBM, QTP, Teradata, XML, web services.

Confidential, Whitewater Drive, MN

Sr. ETL QA Tester

Responsibilities:

  • Participate in the analysis of business requirement, functional and technical design.
  • Involve in developing detailed test plan, test cases and test scripts for functional, system and regression testing.
  • Provide test documentation and reports to test and project management.
  • Test complex ETL mappings and sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Tested data from various sources like Oracle, DB2, flat files and SQL Server.
  • Review test plan, test cases, test results for functional, system with the development, BA’s and SA’s.
  • Involve in data mapping specifications to create and execute detailed system test plans.
  • Run jobs using IBM Tivoli Workload Scheduler in stage, development and in production environment.
  • Demonstrated experience in QA, SIT and UAT testing for a large data warehouse.
  • Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
  • Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
  • Performed extensive DATA validation using SQL queries and back-end testing. Used SQL for Querying the Oracle database in UNIX environment.
  • Used Teradata SQL Assistant for Querying Teradata and Advanced query tool for querying DB2.
  • Performed quality assurance reviews on all System Development Life Cycle.
  • Participated in defect review meetings with the team members. Used MS-Word for documentation.
  • Involved in other test planning meetings and submitted test metrics daily to the management.
  • Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
  • Involved in migration of mappings / workflows from Development to Testing and to production.

Environment: ETL DataStage, BI Cognos, HP Quality Center/ALM, DB2, SQL, PL/SQL, Oracle, Shell Scripting, SOAP UI, XML, UAT, IBM, QTP, Teradata, XML, web services and UNIX.

Confidential, Marshall, MN

Graduate Assistant - Technology Research Center

Responsibilities:

  • Installing and configuring hardware and software components to ensure usability.
  • Troubleshooting hardware and software issues.
  • Ensuring electrical safety standards are met.
  • Repairing or replacing damaged hardware.
  • Upgrading the entire system to enable and compatible software on all computers.
  • Installing and upgrading anti-virus software to ensure security at the user level.
  • Performing tests and evaluations on new software and hardware.
  • Providing support to users and being the first point of contact for error reporting.
  • Establishing good relationships with all departments and colleagues.
  • Conducting daily backup operations.
  • Managing technical documentation.
  • After our contract was over for the ticketing software, I was a crucial part of recreating a new ticketing system using Microsoft Teams by using all the plugins, for ex. Flow, OneNote, and Tasks.
  • Migrated the current inventory from excel files to Ubuntu’s in-built inventory software along withadding multiple functionalities and making it structured.
  • Ticketing system is a software used by most customer service companies to create a case/claim for an issue and then assigning it to different team members to accomplish the tasks mentioned in the claim/case
  • Volunteered to help my supervisors install a new Raspberry Pi lab on campus. I worked on everything from mounting them behind monitors to setting up the network for the lab.

Hire Now