Experience

Aspen University

• United States
• Higher Education
• 100 - 200 Employee

• sr. ETL Tester

  • May 2018 - Present

  • Working as a Sr. ETL tester handling multiple projects within the organization. • Have driven QA team in multiple Projects with excellent knowledge of the DWH architecture. • Analyzed functional and technical requirements (Use Cases), mapping documents, and transforming them into a test plan. • Implemented testing with ability to develop complex and optimized SQL Queries. • Used Azure devops for test plan development and defect tracking. • Created and executed test plans, and test cases to test packages, tables, and BI reports. • Worked on different test environments SIT, Staging and PROD while executing Test Cases effectively. • Implemented and maintained solutions to support multiple teams and mapped business requirements to testing needs. • Created test plan, mapping documents using Business Requirements Documents. • Created Test data when Source data is not available to test Business requirements. • Created detailed Test Cases using Microsoft Excel and Azure devops to test ETL data warehouse component. • Created test scripts on Notebooks and use pipelines to schedule validations. • Executed data-driven testing with good knowledge of Type 1, Type 2 SCD load strategies. • Did trouble shooting and provided solutions for potential issue. • Dealt with SQL server, Blob storage accounts migrating data and maintaining on-prem integrity through to azure. • Tested multiple data storage formats including SQL server tables, views, external table, temporary tables on Orc files, Parquet files, Delta files. • Built personalized notebooks, pipelines, for importing and validating data frames. • Handled testing teams under onshore / offshore model. • Proactively communicated and collaborated with development team to analyze requirements and deliver the test artifacts as needed. • Prepared Test Cases and Test Data for all the ETL testing stages. • Attended weekly and monthly Walkthroughs to review project status with Manager, Developers, and offshore team. Show less



Shoppers Drug Mart

• Canada
• Retail
• 700 & Above Employee

• Software Tester

  • Sep 2015 - Feb 2018

  • Analyzed functional and technical requirements (Use Cases), mapping documents, and transforming them into a test plan. • Implemented testing with ability to develop complex and optimized SQL Queries. • Used HP ALM for test plan development and defect tracking. • Created and execute test plans, test harnesses and test cases. • Worked on different test environments SIT, UAT while executing Test Cases effectively. • Implement and maintain solutions to support multiple teams and mapped business requirements to testing needs. • Participated in creation of Test Plan using Business Requirement Documents. • Created detailed Test Cases using Microsoft Excel and imported onto HP ALM to test ETL data warehouse components. • Did trouble shooting and provided solutions for potential issue. • Proactively communicated and collaborated with business analyst team and development team to analyze requirements and deliver the test artefacts as needed. • Prepared Test Cases and Test Data for all the ETL testing stages. • Performed defect advocating and tracking till the defect is fixed by the developers. • Involved in converting complex business logics into Test Cases using SQL queries. • Performed Regression, Functionality, and data mapping testing. Show less



Saskatchewan Government Insurance

• Canada
• Insurance
• 1 - 100 Employee

• Software Test Engineer

  • Mar 2013 - Sep 2015

  • Performed end-to-end testing of the application as a part of QA team while collaborating with automation team. • Analyzed BRD and design documents to prepare test plans to perform effective testing of the application. • Analyzed business requirements identified gaps and reported to the author. • Created detailed Test Cases and Test condition by applying equivalency partitioning and Boundary value analysis. • Used HP ALM as centralized Test Management and Defect tracking tool. • Created traceability matrix by mapping the requirements to the test cases to ensure test coverage. • Mapped all the Test Cases into the test lab of HP ALM and executed in the test lab module. • Participated in test advocating meetings to discuss defects identified with developers and business analysts. • Performed Smoke/sanity testing of the application to ensure it is ready for extensive testing. • Performed functional, Integration, System testing by executing all the functional test cases by validating and tracking the results in Quality Center. • Performed Retesting and Regression Testing of application after defect is fixed by the developer. • Test plan, test cases, test data are provided as test deliverables after test closure. Show less