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,  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.