SUMMARY

• Data driven Quality Assurance professional over 14 years of experience in Information Technology, involving BI Reports testing and BIG DATA / Testing
• Extensive experience in various domains - US Healthcare Insurance, Telecommunications and P&C Insurance.
• Strong knowledge of Agile and Waterfall Software Development Life Cycle
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the developed business requirements
• Excellent understanding of Data Warehousing concepts, HDFS architecture, Hadoop ecosystem components
• Hands on experience in Big Data validation - Running Sqoop Jobs, HiveQL scripts
• Leaded a team of QA’s and mentored them in QA activities. Prepared and circulated daily test status reports to management team
• Extensive testing ETL experience using SSIS/ Informatica and performed Production reconciliation, Source to target testing, Application upgradation, Data Migration & ETL testing
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing
• Actively involved in User Acceptance Testing (UAT) and end user training
• Extensive knowledge in applying Relational Database Concepts, Entity Relation diagrams and Normalization concepts
• A very good team player with excellent communication, presentation and reporting skills

TECHNICAL SKILLS

Testing Tools: HP Quality Center 9.0/11.0 (ALM)

Databases: Oracle 8i/9i/10g/11g, DB2 8.0/7.0, SQL Server 2005/2008, Teradata, Netezza

Utility Tools: SQL Developer, TOAD, DBeaver, DBvisualizer and SQL Assistant

ETL Tools: Informatica 9.6.1, Datastage, SSIS

Web services: SOAPUI, Postman

DevOps: Jenkins, GIT Repository, GIT Desktop

Operation Systems: Windows XP/2000/2007, Linux and UNIX

Tracking tools: Rally, TFS, Azure Devops, Jira, Salesforce

Scripting Language: Python Pyspark

PROFESSIONAL EXPERIENCE

Confidential

ETL Test Lead

Responsibilities:

• Lead a team of ETL Automation Testers and perform ETL Automation tasks using python
• Prepared Test Plan and Testing Strategies for Data Warehousing Application
• Extensively interacted with developers, business & management stakeholders to understand the project business requirements and ETL design specifications
• Created Hive tables out of shared parquet files by deploying the build in UCD
• Actively participated in regular project status meetings and QA status meeting
• Created SQL Queries for ETL mappings and design documents for test execution in QA, staging and production environment
• Mentored the junior test resources in validating the data integration and ETL workflow
• Developed ETL test scripts based on technical specifications/Data design documents and source to Target mappings
• Created CI/CD pipelines to deploy the test automation code package to remote server
• Defects identified in testing environment are communicated to the developers using Devops tool
• Prepared and circulated test status reports to the project and management team
• Verified BI Reports and raised big accordingly for the fix
• As a part of ETL activity, Supported the UAT and post production support activities

Confidential

ETL Test Lead

Responsibilities:

• Coordinated with project managers, product owners to understood the project scope and performed requirement analysis
• Leaded a team of testers to perform the ETL testing workflow activities
• Prepared Test Plan and Testing Strategies for Data Warehousing Application
• Extensively interacted with developers, business & management stakeholders to understand the project business requirements and ETL design specifications
• Actively participated in regular project status meetings and QA status meeting
• Created test cases for ETL mappings and design documents for test execution in QA, staging and production environment
• Mentored the junior test resources in validating the data integration and ETL workflow
• Developed ETL test scripts based on technical specifications/Data design documents and source to Target mappings
• Executed API testing using Postman and validated XML
• Extensively used and developed SQL scripts/queries in validation of data in Database level testing
• Defects identified in testing environment are communicated to the developers using Devops tool
• Prepared and circulated test status reports to the project and management team
• Verified BI Reports and raised big accordingly for the fix
• As a part of ETL activity, Supported the UAT and post production support activities

Confidential

ETL Test Lead

Responsibilities:

• Developed high level and detailed test matrix based on the provided functional and technical specifications
• Developed test plan and test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability
• Developed 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
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration
• Extensive SQL querying on Staging, Data warehouse and Data Marts
• Used Python Script in building this automation framework
• Ensured Error logs and audit tables are generated and populated properly
• Performed UAT, performance and Regression Testing
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality
• Tracking and reporting the issues to project team and management during test cycles
• Performed Business Intelligence testing and maintained defect backlog for the fix
• Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications
• Mentored team members and coordinated with management team for the execution of testing activities

Confidential

ETL Tester

Responsibilities:

• Reviewed User Stories and prepared the test strategies for the preparation of test cases
• Worked closely with Business stakeholders in understanding functionality of the output
• Participated in the Scrum daily standup, planning, story time and retrospective meetings
• Worked with cross functional team for the data gathering, data preparation and validated data transformations to validate the ETL flow
• Created the use cases, activity diagrams and sequence diagrams for the complex workflows
• Created detail test cases for the assigned user stories and validated test cases were incorporated both positive and negative test conditions
• Maintained traceability matrix to track the requirements to the test cases to ensure complete test coverage
• Worked with IT Development team to ensure feasibility user requirements and developed ETL workflow
• Developed related SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle
• Performed Data Analysis and developed Data Mapping documents for ETL projects
• Executed Test Cases with respect to Source and Target database tables in QA, staging and production environment
• Written SQL queries to validate dashboards and reports against the database
• Analyzed and validated various reports generated by SSRS