SUMMARY

• 10 years of experience in Quality Assurance and Testing especially in ETL, Database, Data warehouse and Business Intelligence Testing.
• Application testing that includes manual and automation testing
• Good knowledge on Banking, Financial, Investment Banking, Gaming and Energy, Oil and Gas domains.
• Worked in largescale, multi projects/applications environments.
• Good hands - on experience in SQL/Programming Languages like Python, Java Script.
• Experience in ETL testing using Teradata and DB2.
• Strong experience in data warehousing, ETL testing including cloud domain, AWS
• Experience in testing with cloud environments
• Strong SQL, Python and Scripting skills
• Experience in Core Java.
• Experience in Building Framework for Jmeter Web Services Functional Testing.
• Experience in Migrating all Parasoft SOA tool (License tool) Test cases into Jmeter (open source tool) which has Java and Python scripts
• Experience in Database Testing using SQL Developer.
• Experience in Parasoft SOA Tool and Jmeter for Web services (Rest Services and limited SOAP Services) Automation Testing.
• Experience in different types of Software testing techniques like Functional, Regression, Integration, Compatibility and Acceptance testing.
• Experience in Bug Tracking using Bugzilla, Jira and test Management using Quality Center.
• Experience in working on Windows and familiar with UNIX
• Experience in Agile Methodology.
• Customizing the Automation Framework
• Design Test Scenarios, Test Cases in Test Plan referring the Use Cases and /or BRD
• Selecting Manual Test cases for Automation
• Provide complete Automation solution for the application - identification, Scripting, execution, maintenance, documentation and reporting each release.
• Prepared CR’s for Data Cleanup in Database for one of the applications
• Work experience reviewing and testing of data maps between various legacy Systems and relational databases.
• Very strong knowledge of star, snowflake schema
• Tested different phases in ETL process like reconciliation testing, data quality testing, failover testing.
• Very strong SQL, PL/SQL knowledge.
• Working knowledge of Defect Life Cycle, Defect Reports and execution Test Reports
• Working knowledge on Scrum Meetings

TECHNICAL SKILLS

Tools: Atlassian JIRA, QC, Bugzilla, Parasoft SQA, Jmeter, JIRA Cloud, Service Desk, ConfluenceGIT, Azure Dev Ops, AWS CI/CD, Bit Bucket, Jenkins. Perforce (P4), Documentum, CVSConfluence, X-Ray, Bamboo, Alteryx, Airflow, CVS, etc.

Cloud Platforms: AWS Cloud, Microsoft Azure

Operating Systems: Microsoft Windows, Linux

Programming: JQL, SQL, Python, Java, P/L SQL, Java Script, Shell Script

Database: IBM DB2, Snowflake, Oracle, SQL Server, PostgreSQL, Snowflake, RedshiftOthersTableau, Data Stage, Power BI, SAP Business Objects, Web I, Desk I, Lumira

PROFESSIONAL EXPERIENCE

Confidential

ETL and DB Tester

Environment: AWS, Redshift, Snowflake, JIRA, DevOps, etc.

Responsibilities:

• Involved in load and performance testing of ETL and Data warehouse
• Did Data quality test and performed data reconciliation test
• Performed data lineage testing
• Tested several BI application and data validations in reports and dashboards
• Performed ETL load performance testing
• Test plan preparation
• Regression test, reload test, full load, incremental load test
• Testing type-1,2 dimension and different types of fact tables and aggregate tables
• Performance Testing of ETL runs
• BI and Dashboards testing with performance and quality of data. Comparing historical data
• Testing SAP BO Reports and Tableau Dashboards and comparing the outputs with DWH and OLTP DBs for reconciliation process.
• Created several SQL statements and Python code for test purpose.
• Involved in Reconcile Testing for the data loads - quality and quantity checks
• Performed Failover tests when data center failover to backup and primary data centers
• Performed Reports testing and data validation against source data
• OLTP and OLAP comparison testing
• Written several SQL, Python scripts and code to test and automate the data flow
• Simulation testing for production size data using several data generation tools
• Involved in the execution of Regression Test Suit and Report Preparation
• Involved in the preparation of Defect reports.
• Automated reconciliation Testing using python and java scripts

Confidential

ETL and BI Tester

Responsibilities:

• Understanding the requirements of several project managers and their strategies for agile project management
• Understanding Confidential ’s data model and ISA standards to meet regulatory compliances
• Involved in load and performance testing of ETL and Data warehouse
• Did Data quality test and performed data reconciliation test
• Performed data lineage testing
• Tested several BI application and data validations in reports and dashboards
• Performed ETL load performance testing
• Involved in Reconcile Testing for the data loads - quality and quantity checks
• Performed Failover tests when data center failover to backup and primary data centers
• Performed Reports testing and data validation against source data
• OLTP and OLAP comparison testing
• Written several SQL, Python scripts and code to test and automate the data flow
• Simulation testing for production size data using several data generation tools
• Involved in the execution of Regression Test Suit and Report Preparation
• Involved in the preparation of Defect reports.

Confidential

ETL & BI Tester

Responsibilities:

• Provided end to end testing coverage to the product
• Story point analysis, Test Plan, Test Cases creation and execution
• Automation suit execution using the Selenium Framework
• Analyzing the requirements and discuss with business
• Involved in the preparation and execution of Test cases for Rest Services using Jmeter Tool.
• Involved in the execution of Performance Test Suit using Jmeter and Visual VM Reports
• Involved in the execution of Regression Test Suit and Report Preparation
• Involved in the preparation of Defect reports.
• Take ownership of the projects and perform all necessary follow ups on the bugs, update the status on the effort required, testing completion with the peers

Confidential

ETL Tester

Responsibilities:

• Data integration testing
• Provided end to end testing coverage to the product
• Story point analysis, Test Plan, Test Cases creation and execution
• Involved in the preparation of Automation scripts using Selenium
• Analyzing the requirements and discuss with business whenever required
• Involved in the preparation and execution of Test cases for OTA and Legacy XML services using Jmeter Tool.
• Involved in the execution of Regression Test Suit and Report Preparation
• Involved in the preparation of Defect reports.
• Involved in the Test cases review process prepared by Peers
• Testing of data in Customer environment to uncover environment issues