Etl Tester Qa Automation
Resume:
Rahul Vithlani
**************@*****.***
https://www.linkedin.com/in/rahul-vithlani-29a276250/
Toronto,ON
OBJECTIVE
A self-motivated and goal-oriented QA Automation Test and Solution Developer with demonstrated success in designing and implementing solutions which improves business functionality. Proven ability to implement a variety of technologies to decrease costs, increase performance and positively impact the bottom line. Solid history in manual, ETL and Automated testing.
SUMMARY
Overall 8 years of experience in all phases of Software Development Life Cycle (SDLC), Developing Test Strategy, Test Cases, Test Plan and Automation test scripts using Selenium.
Diversified experience in Automation and Manual testing serving various domains.
Experience in Agile & Waterfall methodologies.
Experience in Automation Testing using Selenium WebDriver and Postman.
Extensive involvement with client during requirement gathering, Design, Development and Testing.
Proficient in writing SQL automation scripts in Python using Behave.
Experience in developing UNIX shell scripts to test referential integrity and data manipulation
Experience in writing code to communicate with Relational Database Management System, PL/SQL.
Expertise in determining customer needs and effectively translating those needs into software solutions.
Experience in designing and implementing SQL queries for QA testing and data validation.
Experienced in continuous integration tool Jenkins.
Worked with Project Management tools such as JIRA, QC.
Experience in version control tools such as GIT, SVN.
Excellent Analyzing, Problem solving, and negotiation skills as well as fast learner with good people skills
Experience with handling of teams in different geographical locations
TECHNICAL EXPERTISE
Processes / Methodologies: Agile, WaterFall.
Automation Testing Tools: Behave
Test Management Tools: HP ALM, Testlink, TestRail, Jira-Xray
Test Frameworks: BDD (Behave)
Bug Tracking Tools: Bugzilla, Jira
Languages: Python, Java, C, C++, .Net, PHP
Scripting Languages: Unix Shell Script, Java Script, VB Script
Databases: MySQL, Oracle, SQL Server
Operating System: Windows, Unix, Mac
CI and Build Tool: Jenkins, ANT, Maven
Source Control tool: Git, SVN
PROFESSIONAL EXPERIENCE
TD Bank
Senior ETL Tester, Feb 2017 – Till Date
Project: IFRS 17 Program DaaS
Responsibility:
Effectively used Python, Behave, JTMF and Impala to develop test automation framework.
Wrote Features, Test Scenarios, Tests Steps, Scenario Outline, Background using Gherkin from User Story / Acceptance Criteria with minimum supervision.
Created Test plans and Test cases
Strong knowledge of complex SQL concepts
Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
Experienced building and executing, using SQL queries for Backend testing against SQL Server and Oracle Databases.
Experienced in writing complex SQL scripts for ETL testing with in SCD (slow change dimensions) scenarios including tests cases in Hadoop for hive to hive load, hive to oracle Exadata and vice-versa
Tested several UNIX shell scripts for manipulation of data and move data from production to test environment
Involved in DRB (Defect Review Board) during multiple customer release, also was involved in Developer Tech scrum to adopt new ATDD practices.
Involved in regression testing for the modified builds. Raised defects by giving validations and doing negative testing on applications.
Used JIRA-Xray for bug tracking, documentation management.
Attended Tester Tech Scrum meetings and applied the thoughts and ideas shared across the teams.
Attended Daily Stand ups, Sprint Planning, Project Increment planning, Weekly scrum, and retrospective.
Well conversant with software testing methodologies including developing Test plans, Test scenarios, Test cases, Test procedures, Test reports and documenting manual and automation tests
Environment: Python, Behave, Database Testing, ETL, Agile Methodology, JIRA-Xray, Hadoop, Hive, MySQL, Debeaver, Shell Scripting
CGI - LotLinx Canada, Inc. Hamilton
QA Automation Engineer, Jun 2014 – Nov 2016
Project: Online web Portal
LotLinx is the leading inventory marketing technology company for the automotive industry. Our proprietary /AI/ platform helps dealerships Sell Cars Smarter™ by aligning sales objectives to marketing strategies with unparalleled efficiency and precision.
Responsibility:
Understanding the business requirements, application and its components.
Developed UNIX scripts to validate the flat files.
Developing Test Matrix to give a better view of testing effort.
Involved in writing complex SQL queries to verify data from Source to Target
Involved in knowledge transfer to the newly recruited personnel.
Performed data validation testing writing SQL queries.
Experienced in retesting the existing test cases with the different kind of source systems for different periods of data.
Wrote SQL queries extensively, queried database and generated test reports.
Identified weaknesses in QA Processes, Web testing, Python Automation. Suggested & implemented improvements
Reviewed the Test Reports and Preparing Test Summary Report.
Involving in giving daily and weekly status reports to clients
Environment: Python, UNIX, Windows, Shell scripting, DB2, Oracle, SQL, Jira
EDUCATION & CERTIFICATIONS
Bachelor of Computer Science, 2014
Mumbai University, India
**References available upon request
Contact this candidate