SUMMARY

• 5+ years of experience in Software Quality Assurance specialized in ETL Testing, Database Testing, Automation Testing, Manual Testing of client server and web - based applications.
• Extensive working experience on different phases of Software Development Life Cycle (SDLC),its methodologies such as Scrum, Agile and Waterfall Model.
• Extensive ETL testing and Automation experience on Amazon Web Services platform and Expertise in ETL tools such as Red Point Data Management, Red Point Interactions,IBM Data Stage (Ascential data stage/Info sphere data stage) and Neolane.
• Experience in using test automation tools such as Selenium web driver and maintain an automation framework, creating automated tests, executing and analyzing test results for ETL jobs and web-based application.
• Experience in BDD framework using Python, groovy script and Data driven approach via (JSON) Automation Framework.
• User Acceptance Testing (UAT), Functional Testing, Positive/Negative Testing, System Integrated testing (SIT), Regression Testing, GUI Software Testing, Adhoc Testing, Cross Platform Testing, UI validations, Boundary value Testing.
• Worked extensively with ZEPHYR, JIRA, HP ALM to track business requirements, test cases, test traceability matrix and defects to ensure effective Test Management.
• Expert using open source tool GitHub, BitBucket for version controlling of source code and Atlassian Confluence for updated testing docs and daily status .
• Good working Knowledge on web services (XML) testing using SOAPUI
• Hands on experience in writing SQLscripts to validate the databases tables and reports data for backend database testing.
• Experience in Oracle (PL/SQL), SQL SERVER 2014 MANAGEMENT STUDIO, My SQL and Data warehouse Concepts and Normalization concepts.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema, Fact table and Dimension tables.
• Actively involved in User Acceptance Testing (UAT) and provide training to end users. Participated in cross-functional teams to reengineer and improve business processes.
• Excellent Knowledge in Ms-Office (Word, Excel, PowerPoint).
• Hands on experience in Java, Python, JavaScript, HTML, XML, CSS, Soap UI and Web services.
• Provided timely communication through status mails to testing and development team and Participate in audit reviews of test artifacts, ensure they meet Business standards and audit requirements, and are stored in the Project site.
• Good Track record of producing High Quality results under pressure and able to work independently or as a part of team.

TECHNICAL SKILLS

Platforms: Amazon Web Services (AWS), Mac OS, Windows, Unix.

Programming: SQL, JAVA, Python, JavaScript, XML, HTML, CSS.

Database: MY SQL, Oracle,Sybase,SQL Server Management Studio

Automation Testing Tool: Selenium Web Driver, Cucumber, Maven, Junit, Test-NG

Automation Framework: BDD, Data driven

Continuous Integration Tool: BitBucket, GIT, SourceTree

Web Testing Tools: Firebug, XPath, DOM Inspector

Bug Tracking: Jira, Zephyr, Bugzilla, Quality center/HP ALM

Browsers: Internet Explorer, Firefox, Chrome, Safari.

ETL Tools: RPDM, RPI, DataStage

Reporting Tool: Tableau, Allure

Other: Citrix, Autosys, SQL Developer, Toad

PROFESSIONAL EXPERIENCE

Confidential

ETL QA Analyst

Responsibilities:

• Worked with Business Analyst to understand High Level / System Requirements in order to transform business requirements to Functional specification.
• Attended requirement SCRUM meetings to update daily status and ensure that system meets all primary requirements.
• Analysed source to target mapping document indicating source tables, columns, datatypes, transformation required, business rules to be applied and target tables.
• Performed End-to-End data validation for ETL and Reporting tool Tableau.
• Involved in creation of Test Plans, Test Cases, and Test Execution based on Requirement Doc and Mapping specs to validate the platform data.
• Involved in extensive data validations using SQL queries for Back-end Testing.
• Comparing unique values of key fields between source data and data loaded to the data Warehouse.
• Performed the data checks on the various Business rules as well the different error messages.
• Compare record counts between source and target. Check for any rejected records. If rejected, check the reasons for the error codes and whether it is an appropriate error code
• Identifying duplicate records in the staging area before data gets processed
• Ensured that the jobs are running successfully and all expected data is loaded in to target table.
• Defects identified in testing environment are communicated to developers using Defect tracking tool JIRA .
• Tuned ETL jobs/procedures/scripts, SQL queries, procedures to improve the system performance .
• Verified the SQL Stored Procedures against the Business Requirements document.
• Worked on Reporting tool Tableau dashboard to make sure all the data populated correctly as per BRD.
• Exposure on python behave BDD and Data driven framework for AWS services and test data.
• Testing all test files by creating the new branches in Atlassian and making pull request commit by using GIT Bash and source Tree on local branching.
• Experience in using Confluence. BitBucket, Source Tree for commit, Pull and Push Request.
• Worked on CI/CD Jenkin for automating the jobs and Allure report for test data details,
• Provided technical support and knowledge transfer in specialized areas of Software and Testing to new QA team members.

Confidential

ETL QA Analyst

Responsibilities:

• Analyzed Business Requirements documents to get a better understanding of Business Perspectives.
• Involved in Writing Test Cases and Test Plans based on Source to Target Documents in JIRA and using the Business Requirements Document.
• Performed tests on Web based application such as ODM and SDM
• Involved in extensive data validation using SQL queries as a part of Back-end Testing.
• Performed Manual and backend checks on applications like On Demand Marketing and Service Demand Marketing Campaigns(quarterly).
• Validated various coupon data and input values on CMS.
• Performed manual copy validation on Direct mail and Email creatives against the approved copy decks and validated Header, Footer.
• Performed Mobile compatibility tests on various mobile versions using LITMUS.
• Conducted Data driven Testing to test various sets of data.
• Involved in performing Black Box Testing.
• Performed Cross-Browser testing on various platforms and versions and multiple browsers.
• Used ETL Data management tools such as RPDM and Neolene (Adobe).
• Performed Web Service testing extensively using SOAPUI.
• Prepared Test Defect Metrics on a weekly basis to know status of the application
• Status reporting on daily and weekly basis to QA manager.

Confidential

ETL QA Analyst

Responsibilities:

• Analyzed Business requirements to get a better understanding of business Perspectives.
• Tested complex RPDM ETL WFs and jobs for daily data loads..
• Involved in writing test cases with the Requirements and Mapping document in Jira.
• Developed SQL Queries for backend testing and perform end to end testing.
• Validated the source system data with the staging data using SQL/Pl/SQL scripts.
• Performed the data checks on the various Business rules as well the different error codes that should be populated.
• Logged the defects in JIRA and worked in co-ordination with developers on fixing the same.
• Used RedPoint Interaction to generate the automatic emails to the various customers on Daily and weekly basis.
• Attending the client calls and updating the status reporting on daily and weekly basis to QA-Manager.
• Interacting with senior peers /subject matter experts to learn more about the data and functionality
• Coordinated with different users in UAT process.

Confidential

ETL QA Analyst

Responsibilities:

• Tested complex RPDM ETL WFs and jobs based on business requirements and business rules to load data from source flat files and SQL tables to target tables.
• Developed ETL test cases for various lines of business based on the Requirements and Mapping document in Jira.
• Expertise in writing SQL queries in database to make sure whether data is populated in data warehouse according to Business Rule..
• Extensively used ETL for testing and supporting data extraction, data transformations and loading processing in Corporate-wide-ETL solution using RPDM tool.
• Performed the data checks on the various Business rules as well the different error codes that should be populated.
• Raised the defects in JIRA and assigned to Dev team and get it fixed as per priority.
• Used RedPoint Interaction to generate the automatic emails to the various customers on Daily and weekly basis.
• Automated and scheduled the RPDM jobs using Script.
• Reviewed test cases before delivering to Client.
• Actively participated in Stand-up meetings, walk-through meeting .
• Interacting with senior peers /subject matter experts to learn more about the data and functionality
• Coordinated with different users in UAT process.

Confidential, San Francisco

QA Engineer

Responsibilities:

• Tested Confidential system ecommerce Web Application GUI testing and Functional Testing.
• Performed installation, configuration and troubleshooting hardware and software parts of Confidential stores
• Was responsible for writing test cases, testsuites, test plans and work flows using JIRA and Confluence (as wiki) documentation
• Performed bug verification, regression, smoke, functional, UI, usability testing of WEB and main Java based applications
• Performed installation and testing of Ghost images
• Executed test cases, recorded, logged results on jira daily basis
• Tested integrity of submitted reports and logs data in SQL database.
• Working on sanity Testing to test different Cart system, promo code and other functionality of System.
• Worked on Payment Receipt, E-mail Receipt and Coupon Code system and did Regression, Ad-Hoc and Sanity testing.
• Back end testing and Generate Report from Database (MySQL) about the previous transaction.
• Testing database updates for all Transaction against QA and Prod environment-using MySQL.
• Also testing Experience with Payment System with HTTP with apache Tomcat Server.