SUMMARY

• 6 years and 7 months of experience in Software Testing.
• Hands - on Experience in ETL testing.
• Well versed in both Manual and Automated Testing.
• Experience in documenting and investigating software problems, and liaise with software developers to solve problems.
• Proficient in planning, implementing, and reporting on testing aspects of software products/projects.
• Strong SQL background, able to write complex SQL queries based on the test scenario.
• Strong experience working with large and complex data sets.
• Knowledge and work experience with Agile and Scrum Methodologies.
• Strong knowledge of Software Life Cycles, QA methodologies, tools and processes.
• Experience in collaborating with product and engineering teams to understand product requirements to ensure that they are implemented correctly.
• Proficient in managing testing projects from Requirement specs, Planning, Testing Effort Estimation, Configuration Management & Documentation and Post-production Support.
• Experience in leading project individually and ensuring that the business acceptance tests exit criteria are met prior to implementation.
• Experience in preparing the test strategy and the test plan and finalizing the QA test in-scope and out-scope documents based on Business Requirement Documents.
• Excellent in test case development based on the requirements, ensuring end to end test coverage.
• Experience in performing Smoke Testing, System Testing, System Integration Testing, Regression Testing, UAT Support and Post-production Support.
• Expertise in Testing of Data Warehousing/Business Intelligence applications & ETL (EDW).
• Good experience on Informatica, SQL server, Oracle, Teradata, Control-M.
• Worked on SQL scripts, complex SQL queries, Unix scripts, Testing of Source to target mappings, Testing of BI Reports.
• Run, Monitor jobs and Audit reference jobs and report any issues found.
• Report the testing results to project management and other stakeholders as required.
• Experience in developing and maintaining test specifications, test cases, test scripts and test data.
• Experience in implementing test practices, standards and processes, troubleshoot test issues, record test results, track and prioritize defects, participate in release decisions and establish measures of test efficiency, effectiveness and product readiness.
• Expertise in Behaviour Driven Development (BDD) scenarios writing in feature file format and execution for automation using Selenium.
• Knowledge on test management tools like Quality centre HP ALM, JIRA.
• Excellent communication and presentation skills with Strong interpersonal skills.

TECHNICAL SKILLS

Database: Teradata, SQL Server, Oracle

Programming Languages: Unix, MSSQL, Gherkin

Project/Test Management Tool: Jira, HP Quality Centre

Tools: Informatica, Teradata SQL Assistant, Qlikview, Cognos, Putty, Winscp, Bit Bucket

PROFESSIONAL EXPERIENCE

Confidential

ETL Tester

Environment: Oracle, Teradata, Informatica, Unix, Winscp, HP ALM, Control-M, Data Comparator tool

Responsibilities:

• Discussion with Business Analyst to get better understanding on QA requirements.
• Preparing the test strategy and the test plan and finalizing the QA test in-scope and out-scope documents based on Business Requirement Documents.
• Ensuring traceability matrix in ALM.
• Experienced in testing all stages of data ware house and proficient in data reconciliation techniques & preparation of SQL queries for data validation.
• This was an ETL Migration project from Oracle to Informatica, Ab Initio to Informatica.
• Created ETL test data for all ETL mapping rules to test the functionality.
• Experience in Metadata and Star schema/Snowflake schema.
• Analyzed Source systems, Staging area, Fact and Dimension tables in Target D/W.
• Worked on Informatica Power Centre tool. Triggering the workflow using workflow manager.
• Verifying the sessions log for success or failure in workflow monitor.
• Check whether the mapping is as per the mapping spec by logging into informatica Mapping designer.
• Validating different transformations in informatica transformation developer.
• Scheduled jobs using Control-M. Run, Monitor jobs and Audit reference jobs and report any issues found.
• Perform Data validation between File to File, File to Table, Table to Table and validate all the transformation logics.
• Worked on BI report validation which was developed using Cognos.
• Performing System testing and Regression testing.
• Reported test results to project management and other stakeholders as required.
• Defect Management Raise defect and keep a track on defect status.
• Setup defect triage calls and Work with development teams to investigate and fix software bugs/defects based on the test results
• Retesting the defect after the issue fixed.
• Sending the defect report summary.
• UAT/Production support Activities
• Ensuring that the business acceptance tests exit criteria are met prior to implementation.
• Supporting UAT/Production Acceptance testing activities.
• Coordination with stakeholders
• Interacting with the onsite/client/development teams to discuss and resolve the issues.
• Communicating the requirements on daily/weekly basis to offshore team.
• Knowledge Transfer to Offshore team on new or change requirements.
• Working with source providers, other vendors and SME’s on data issues pertaining to source data files and for issue analysis.

Confidential

QA Analyst

Environment: Manual UI Testing, Automation testing, Cognos, Qlikview Report Testing, HP ALM, JIRA tool, Eclipse, Selenium Webdriver

Responsibilities:

• Experience working in an Agile/Scrum development process.
• Actively participated in Sprint planning calls and discuss with BA and Product owners on requirements.
• Preparing the test strategy and the test plan, test estimates and contribute to ensure delivery on schedule with high quality.
• Developed and prioritized test coverage matrices to maximize testing efficiency.
• Reported test results to project management and other stakeholders as required.
• Backend database testing in different environments
• Executed and evaluated manual and automated test cases and report test results.
• Execute manual and technical test strategies, plans and procedures
• Ensured that validated deliverables meet functional and design specifications and requirements.
• Performing Smoke testing, System testing and Regression testing.
• Provided technical mentorship and peer review to other associates.
• Developed and applied testing processes for new and existing applications to meet client needs.
• Expertise in Behaviour Driven Development (BDD) scenarios writing in feature file format and execution for automation.
• Hands-on experience with automated testing tools (Selenium, Cucumber)
• Strong knowledge of software QA methodologies, tools and process.
• Identified Test Scripts for Regression testing.
• Reporting daily status and deck presentation to clients.
• Defect Management
• Raising defects and assigning the corresponding developer for the failed test cases.
• Setting up defect triage call.
• Checking the defect status.
• Retesting the defect after the issue fixed.
• Tracking the defect till closure.
• Sending the defect report summary.
• By end of the sprint, prepare root cause analysis.
• UAT/Production support Activities