Etl Qa Analyst Resume
SUMMARY
- Automation Analyst with professional experience and a vast array of knowledge in front and back end languages, databases, responsive frameworks and best testing practices. My objective is to have a dynamic & challenging position with an agile & creative work environment. I am dedicated to perfecting my development skills by always learning new frameworks.
- I believe my bachelors and master’s degree in computer engineering, my extensive experience in test automation development and deep understanding of problem - solving skills will continue to contribute to my overall success as a QA Analyst.
TECHNICAL SKILLS
Operating Systems: Windows, Linux, UNIX and DOS 6.0
Programming Languages: C, C++, Java, C#.net, Asp.net, J2EE, DBMS, SQL and Operating System concepts, Scala
Testing Tools: Quality Center, Junit, UFT, Apache J-Meter, Selenium Web driver, Cucumber, Apache Spark, Postman, Karate
Database: Database management and analysis tool: DbVisualizer, MySQL, Oracle 10g & 11g, SQL
Applications/ Office tools: MS Project 2010, MS Office 2010 (Word, Excel ((VBA, Excel functions, add-in)), Power point, Visio), MS Share Point, Confluence
Web Application Testing: HTML, VB Script, ASP, Visual Studio, Junit, Java
Defect Tracking Tools: Microfocus ALM 12.5, Jira, BugzillaTesting QA Expertise: Web services Testing, ETL Testing, Functional Testing, Performance Testing, Database Testing, Dataware house testing, Security Testing
Web Technologies: Web services, Java, J2EE, HTML, XML messaging, JSP and Eclipse, SOAP UI, XML, React, Jenkins
Testing Frame works: Keyword Driven, Hybrid, Data driven frameworks.
Scripting Tools: VB Script, Java Script, Shell scripting, Perl Scripting.
PROFESSIONAL EXPERIENCE
Confidential
ETL QA Analyst
Responsibilities:
- Understood the logical flow of the project
- Analysed the specifications provided by BA
- Participated in the reviews of Requirements, Design Documents, Data Models
- Approved requirements and design specifications, technical documents, source to target mapping documents and other related documentation from testing perspective.
- Designed the test cases as per test plan and user specs
- Estimated the efforts required to design the test cases and execute the project
- Traceability of requirements to test cases
- Defined entrance and exit criteria for code and data migration into the test and production environment
- Created Test Plan, Test Scenario, Test Cases and Test Scripts to validate source and Target data
- Played a key role in the development/automation of SQL queries while preparing the test case scripts
- Test data creation for volumetric testing and any performance testing. This also includes the test cases for capacity planning.
- Created, maintained and executed re-usable scripts
- Executed test scripts including pre-requisites, detailed instructions and anticipated results
- Executed back end data-driven test cases
- Performed Root Cause Analysis of the failed test cases and provide the related data samples to dev team.
- Responsible for reviewing of test plans for team members to ensure high quality deliverables
- Incorporated UAT test cases into testing
- Identified the bugs/issues/problem and provide solutions for potential issues based on the knowledge acquired on the application
- Provided observations of the overall system which are not expected and could potentially be bugs.
- Helped with the analysis of issues and Data Reconciliation
- I was able to test each microapps with Automating the scripts using BDD approach using Cucumber and Selenium.
- Created API testing test scripts using Karate to make sure HTTP client Javascript library handles API request, auth token management.
- Created Test scripts for both mobile and desktop platforms
Technical Environment: IDE: STS 3.9.4, JDK: Java JDK 1.8+ version, Gradle: version 4.8, Selenium Web driver, karate-junit4, cucumber-reporting, junit 4.12, Bitbucket, Jenkins, Node.js, Confluence, Appium for Mobile testing, TestNG, karate-apache and Postman for API testing
Confidential
QA EngineerOracle SQL Developer
Responsibilities:
- Understood Business Requirements, Prepared Test Scenarios and Test Cases. Interacted with Project stakeholders, Coordinated with BA for clarifications. Prepared Test Strategy, Test Plan and Defect Management plan.
- Reviewed Test Scenarios and Test Cases Generating reports from HP ALM. Provided daily and weekly project reports to Delivery Manager and Senior QA manager. Provided release status reporting as required to the Release Manager and stakeholders.
- Arranged & coordinated meetings with project stakeholders for project issue resolution. Provided reports to Executives. Maintained and provided accurate testing status reports during testing phases and experienced at preparing & executing test cases using HP Quality Centre and enhanced them according to the requirements. Created testing & QA best practices and checklists.
- Participated in test planning, assisted in preparing various testing documentation (Test strategy, Test plan, non-functional test plan, defect management plan, involved in defect triage, test scenarios, test cases and test matrix etc.) and test results walkthroughs.
- Loaded data into the tables and validate data against the requirements.
- Validated the changes/requirements by loading the source files into SQL from UNIX flat files.
Confidential
Responsibilities:
- Developed test cases, test scripts, and other related test documents based on user stories.
- Created and updated documentations relating to the quality assurance processes and procedures using Team Foundation Server (TFS)tool.
- Participated in User Acceptance Testing (UAT) phases with customers, including local and remote test run use of relational and Structured Query Language (SQL) database-queries.
- Maintained the test suites with modified features, tracking script versions in Git source control systems and Team Foundation Server (TFS).
- Designed, created and maintained web services tests in Postman, Server Oriented Architecture (SOA) Test.
- Developed automated integration and smoke tests using Selenium, Soap UI.
- Implemented script and call flow changes as business needs arise
- Maintained and improved IVR application for customer experience and call containment
- Performed Interactive Voice Response (IVR) Testing, Web testing and Cisco ICM Testing.
- Performed Regression Testing.
- Working as an Offshore POC and handling the team effectively.
- Involved in raising the defect through Trac tool.