SUMMARY

• Over 10+ Years of Extensive experience in IT Industry with emphasis on Quality Assurance Automation & Software ETL Testing.
• More than 5 years of experience in ETL Testing within the environment of Oracle, Informatica PowerCenter 9.1/ (Repository Manager, Server manager, Mapping Designer, Mapplet Designer, Transformation Developer and Warehouse designer).
• Extensive experience in testing and reviewing of dimensional modeling (Star and Snowflake) of data warehouse.
• Experience in developing BDD tests using cucumber.
• Expertise in use of HP ALM for writing test cases, test execution and JIRA for defect management, defect tracking and bug reporting.
• Experience in working in Offshore - Onsite model. Mentoring offshore and new team members on new processes and updated the Confluence page with project processes.
• Experience in Preparation of Automated Tests using Data Driven Framework with Squish & Selenium Framework.
• Good experience in Test Data Management for better data quality, Test Coverage, Masking Sensitive data, and Test Automation.
• Possess a sound knowledge on defect prevention processes and participated in project audits.
• Good Experience in Data masking techniques like Data substitution, Data Shuffling and Data Nulling as per different Compliance and Security requirements.
• Experience includes testing of applications which use integrated database using Informatica, Data Stage, Qlikview, Tableau and Business Objects.
• Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
• Possess sound knowledge ETL/Database management, Telecommunications, Retail and Banking Education.
• Good experience of Quality Assurance methodologies like Waterfall, V-Model, Agile, Scrum, RUP.
• Experience in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for manual, automated & bug tracking tools.
• Excellent knowledge of Agile & Scrum development environment
• Good experience in working with Agile mode and working on user stories and scrum calls.
• Working with all stake holders to ensure that the quality metrics is reviewed, closed and agreed upon. Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
• Expert in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT).
• Have thorough knowledge in Project Management process areas and Agile Software methodology processes. Lead SCRUM meetings, prepared burn-down and velocity charts, SCRUM retrospectives.
• Experience with version control, configuration management and change control procedures using tools such as Share point and PVCS.
• An effective communicator with strong analytical abilities combined with skills to plan, implement & presentation of projects.
• Knowledge on the ETL automation tools like Query surge.
• Experience on Testing REST API using Robot Framework and SOAP UI.

TECHNICAL SKILLS

Defect Tracking: Quality Center, Mantis, JIRA

Databases: Oracle 11g, 10g, 9i, IBM DB2, MYSQL

Data Warehouse & ETL Tools: Informatica (PowerCenter 9.1, PowerPlug and PowerConnect), Oracle Designer 10g, 9i, 6i/2000, Qlikview,Business Objects, DataStage, Tableau, Test Data Management 9.3 (TDM), Informatica Life Cycle Management(ILM), Informatica Data Replication

Configuration Management: SharePoint, PVCS, GIT

Automation Testing Tools: Selenium RC, Selenium Web Driver

Programming Languages: Java, Java script

BDD Framework: Cucumber, BDD Squish framework

Methodologies: Waterfall, Agile, RUP, Scrum

Operating Systems/ Products: Windows - 7, Vista, XP, NT, 2003, 2000, 98, Unix

PROFESSIONAL EXPERIENCE

Confidential

Automation test Lead/Onsite Test Lead

Responsibilities:

• Understand the new features in the Feature Design Specification file.
• Involved in Requirement analysis with BA developers and product owners.
• Coordinated with cross-functional teams to evaluate project requirements. Raised queries and ambiguities for the requirements and get that documented in the clarification document.
• Analyzed and understood Conditions that mapped to requirements.
• Understand the approach for Test Design phase.
• Understand the usage of technologies across the existing Confidential products.
• Participate in design discussions pertaining to the Automation Framework.
• Creation of Automation framework using Squish IDE.
• Develop new classes and test suites as per the requirements and add new tests.
• Writing the test scripts in Squish IDE using Gherkin statements. Step definitions are implemented in JavaScript.
• Followed JS DOC and other best practices as well as coding guideline standards as provided by Confidential HC compliance.
• Support Continuous Test Integration for Automation tests to run against nightly builds on simulators and bays.
• Investigate the Test Results and Sanity failures. Proactively looking at the logs and identify the preliminary root cause for the issue.
• Raise defects in Clear quest for the bugs found during the Test execution with sufficient evidence and the steps to replicate the problem.
• Submit merge requests through GIT repository.
• Updating the test status to various stakeholders.
• Streamline the Test activities by documenting the procedures involved in a complete test cycle on Confidential 's Confluence.
• Co-ordination and interaction activities with offshore teams. Conduct Knowledge Sharing sessions and respond to their queries.
• Responsible for updating and maintaining existing Squish scripts.
• Responsible for conducting peer reviews.
• Proactively approach the scrum team and inquire about the new Software features that are going to be developed. Make use of this information to design the tests appropriately keeping in mind of the future enhancements.

Environment: AGILE methodology, Rally, HP ALM QC, JavaScript, Junit, Jenkins, Squish IDE, BDD, Gitlab, Confluence

Confidential

ETL Test Lead

Responsibilities:

• Coordinated with teams working on the different projects, completing the QA tasks. The tasks included performing Manual, Performance and Automated Testing of the functionalities. The projects were managed in Application Lifecycle Management (ALM, which is Quality Center's version 11.x).
• Leading TDM & QA Team and Setting quality standards and metrics for the current project.
• Writing the BDD test scripts using Gherkin statements. Step definitions are implemented in JavaScript.
• Data Requirements gathering from the Test Leads, BA's; create Data creation and delivery plan.
• Analyzing the test scripts & finalizing the test data required (Test Data Matrix) to run the tests across various systems & DB's.
• Planned, delegated and supervised the daily activity of TDM team according to Project/Test Priorities.
• Audit defects, performed root cause analysis, diagnosed them to underlying issues with requirements, data or the process.
• Developed and Executed SQL queries in Toad to retrieve data, to check storage and accuracy of data in database tables.
• Validated the data through various stages/systems of data movement from Banking Systems (DB2) to Customer View to Core Trading Platform.
• Involved in Automating the Data Creation process with Selenium with TestNG.
• Assisted business analysts to clarify requirements' ambiguities, define user stories, and generate test data.
• Worked with development & Testing teams to assist with their troubleshooting, resolution and validation.
• Participated in Defect Triage meetings to review defects at the Program level while working with Cross Functional Teams.
• Aided in planning Data Migrations between Test Beds/Environments for parallel testing of different sprints and validating the rightness of migrated data for Test Purposes.
• Prepared detailed status reports and update the status to the business and technical teams during weekly review meetings.