We provide IT Staff Augmentation Services!

Etl And Db Tester Resume

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

Hire Now