ETL Testing and Automation Testing

Ravi Chandana

*******************@*****.*** C:980-***-****

SUMMARY:

Over 5 Years of QA experience in Database, ETL, Automation, Functional Testing and API Testing.

Experience working as QA Engineer for Software Development and Testing life Cycle including preparation of Test Strategies, Test Plans, Test Cases, RTM, Test summary reports.

Experience in Front End, Back End, Functional, End to End, Regression, Smoke Testing.

Good understanding of Software Development Life Cycle from project definition to post-deployment documentation in Agile as well as Waterfall development methodologies.

Good understanding of the QA life cycle - From test plan, test execution to reporting bugs.

Experience in database testing by writing and executing Complex SQL statements for verification and testing.

Experience in automation framework using Selenium and TestNG.

Experience in writing automation test scripts, well versed with handling Elements.

Experienced in using Apache POI to read data from external sources to feed the test data and dynamic locators into the test script.

Experienced in using Jenkin as a Continuous Integration to configure with GitHub and Maven.

Experience in using IBM CTD to generate feature files and knowledge on IBM Ignite to automate feature files.

Knowledge on Automation Testing Using UFT.

Experience in ETL testing using Informatica Power Center and SSIS(MSBI) to validate data from source to target.

Experience in validation data as per transformation logic and mapping documents.

Experience in Validating Commercial card statements verification processing (TSYS).

Experience in Functional Testing and Content Management (Flex pub).

Hands on experience in testing the Big Data using Hadoop (HIVE).

Hands on experience in Database testing and writing complex SQL queries.

Experience in working of reporting tools like SSRS and Tableau.

Experience on creating visualizations and dashboards using Tableau.

Experience in API Testing Using Postman.

Experience in working with IBM MDM and MQ.

Experience in working of Data Migration projects.

Experience in working of multiple databases like Oracle, MySQL, Netezza, Postgress, Hive.

Knowledge on working with Unix commands.

Experience in running Autosys jobs and monitoring the logs.

Experienced in preparing Test Plan and RTM and Test signoff Documents.

Exposure to multiple tools like HP QC/ (ALM), JIRA.

Expertise in Testing methodologies like Waterfall and Agile-Scrum.

Extremely dedicated, Self-motivated, Proactive and Skilled at learning new concepts.

Highly adaptive to a team environment and proven ability to work in a fast-paced teaming environment with good communication skills.

TECHNICAL SKILLS:

Operating Systems

Linux, Windows.

Programming Languages

SQL, PL/SQL, Java, HTML, XML.

Databases

Oracle, SQL Server, MS-Sql, Postgress and Hadoop (HIVE), Netezza, IBM MDM

Datawarehouse tools

Informatica, Sql-server2008 MSBI (SSIS), Reporting tools(Tableau, SSRS)

Testing Tools

Selenium,

UFT, Jenkins, Eclipse,

Cucumber, FirePath,

Postman.

Issue Tracking Systems

JIRA,

Quality Center, Zypher

PROFESSIONAL EXPERIENCE:

Client: Wells Fargo, Charlotte NC Jan ’20 – Aug ‘20.

Role: Systems QA Analyst

CCDMS (commercial card data management system): After each statement generation cycle, three times per day, the commercial card Billing Team is required to manually verify the outgoing statements from JH. In a smaller number of cases, there could be misdirected transactions or missed payment adjustments which can cause statements to indicate an incorrect amount due. This manual verification is labor-intensive process. Furthermore, it occurs after a statement has been sent to the customer, so if a correction is needed the statement must be cancelled, data adjustments made, and another statement generated and sent out in the next cycle.

Responsibilities:

Extensively involved in all stages of Testing life cycle using Agile Methodology.

Perform the statement verification using code in the new CCDMS statement process, without manual intervention.

Preform the statement verification before a statement sent out to the customer, so if an issue is found, the statement will not be produced and sent out at all.

Perform statement verification for all customers, even those not set to statement today, so the billing team can take proactive measures to correct issues.

QA team will perform testing and validation in SIT and UAT before moving code to production.

Monitoring Autosys Jobs during 3 cycles in a day.

Checking Error logs for failed workflow and report those issues to the team.

Checking the Availability of all files coming from/going to upstream and downstream applications.

Validating Statement reports w.r.t available data while writing SQL queries.

Migrating files into different locations in lower environments.

Involved in Development of Test automation scripts, update the scripts based on changes.

Coded in Java programming language with Selenium WebDriver Test automation framework.

Worked on Automating Web Application using Selenium WebDriver and TestNG.

Handled multiple browsers, alert boxes, checkboxes, dropdowns etc.

Handling web elements on a page using identifiers.

Expertise in writing Xpath for the elements on the webpage.

Good knowledge in developing framework.

Executed Selenium Test Cases and Reporting defects.

Experience in automating testcases related to smoke and regression suite.

Identified the defects through automation scripts which were missed during manual testing and retesting the fixes.

Very quick learner with highly positive attitude and helpful nature.

Environment: Oracle, Informatica Hotfix 10.2, Autosys, Unix, WinSCP, ALM, Jira, Agile, Selenium WebDriver, Java, TestNG, Maven, Jenkins, JIRA, GIT.

Client: Ahold Delhaize, Salisbury, NC May 2018- DEC 2019

Role: Test Specialist

Ahold Delhaize, is a Dutch-Belgian retail company, operating supermarkets and e-Commerce

businesses. Its 21 local brands employ more than 375,000 associates at 6,500 stores in 11 countries.

RBS (Ahold Delhaize) has identified the need for a more efficient method of consuming customer data, which is currently spread across several legacy systems. The company wants to create a single unified, trusted view of customer data which can help meet its broader business strategy and establish a foundation for new technology areas

Responsibilities:

Performed Functional Testing of the Application (DSC UI).

Performed API Testing using Postman to Post or Get data through IBM MDM.

Involved in Working of Database Migration Project.

Performed Validation, and Transformations on the Input data after loading into target database.

Perform System and Integration testing and regression testing.

Worked on IBM CTD Tool to write Test Cases (Feature Files).

Knowledge on Writing SQL Queries using Joins and Sub Queries.

Using Jira/ALM to create Test-cases and Execute Test-cases

Worked on Jira/ALM to log defects and track resolution till the closing of defect after retesting.

Working on Preparing High level Test scenarios and Preparing Test Cases

Working on Preparing DSR (Daily status Report) and WSR (weekly Status Reports)

Performed Positive testing, Negative testing, Functional testing, Navigational testing, System Testing and Regression testing in different phases.

Time to Time discussions with business analyst to know more details of the project.

Train other junior team members on new requirements for the project.

Providing directions in peer review to ensure that the product deliverables meet the deadlines

Hosting the defect triage calls with developers and project support teams.

Worked on POSTMAN to manually test the API response, Status Codes, Headers.

Experience in generating feature files using cucumber.

Knowledge on using IBM Focus to automate feature files.

Developed the Automation scripts using WebDriver for functional testing.

Used Maven, GIT Repository for source code Management, Jenkins for Continuous Integration and Continuous Development.

Experience in BDD framework (Page Object Model, Data Driven, cucumber, TestNG).

Involved in providing the efficient locators strategy like XPath to run Selenium WebDriver script in stable condition.

Worked on POSTMAN to manually test the API response, Status Codes and Headers.

Executed the test cases to validate the expected outcome with the Actual outcomes created and tracked the defects using JIRA.

Environment: IBM MDM, Postman, dB Visualizer, Jira, Windows XP, selenium, Java, TestNG, Jenkins, Maven, cucumber, CTD, IBM Focus.

Client: Classmates, Woodland Hills, CA Jan ’12 – Dec’ 15

Role: Senior Software QA

Classmates.com is the online home for your high school class. With the largest directory of high schools and class lists available anywhere, covering 57 million people and including maiden names, Classmates makes finding, reconnecting and staying up with your high school class fun and easy. Classmates also has over 200,000 digitized high school yearbooks available for you to view and share photos.

Responsibilities:

Performed Manual Testing of the application Front-End and Functionality.

Performed Verification, Validation, and Transformations on the Input data after loading into target database.

Monitored the Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions.

Perform Functional, Data Validation, Integration and regression testing.

Involved in testing Unix shell scripts to run various ETL Scripts to load the data into Target Database.

Worked on Jira to log defects and track resolution till the closing of defect after retesting.

Worked on data migration while migrating the data from Netezza to HDFS.

Worked closely with users and program developers to ensure application development meets to user s expectations.

Actively participated in analyzing test plan as per the business requirements.

Organized Test Cases, bugs, tracking of defect in the QC tool, through connectivity of QC.

Performed Backend testing to validate the data using Toad, added SQL queries to the required Test cases.

Performed Positive testing, Negative testing, Functional testing, Navigational testing, System Testing and Regression testing in different phases.

Worked closely with development team to resolve the defects and testability issues throughout Software Test Life Cycle.

Participated in the team meetings to discuss the issues arising out of testing

Developed Automation Test cases after reviewing the manual test cases.

Executing the daily smoke test cases.

Experience in preparing sanity Suite and Regression Suite

Environment: Informatica 8.6.1, PL/SQL Developer for Oracle, UNIX, Putty, Windows XP, Postgress, Hadoop, TestNG, Selenium.

Educational Qualification:

Bachelors (Information Technology) from Andhra university.

Contact this candidate