Post Job Free


Sign in

Etl Tester Qa Automation

Brampton, ON, Canada
May 29, 2023

Contact this candidate


Rahul Vithlani




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.


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


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


TD Bank

Senior ETL Tester, Feb 2017 – Till Date

Project: IFRS 17 Program DaaS


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.


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


Bachelor of Computer Science, 2014

Mumbai University, India

**References available upon request

Contact this candidate