Consultant
Capgemini India Pvt Ltd
Total years of experience :12 years, 4 Months
Experience in Autosys Testing and Database Migration Testing from SQL server to Oracle
•Knowledge of SCD1, SCD2, SCD3, Schema’s (Star, Snow-Flake) in Informatica.
•Involved in Data Analysis, Data Validation, Data Cleansing, Data Verification, identifying data mismatch, review of Designing and mapping done by Dev.
•Excellent Knowledge of Database Systems - Oracle, SQL server, DB2 and Data ware house concepts.
•Validate the Data against source and target on various platforms / layers.
•Have Experiences in Waterfall Model, Agile Model for Banking Domain Project.
•Expertise in Test Management Tool - HP ALM (12.55) and JIRA.
•Experience in Metrics components to measure product quality.
•Good knowledge on Testing Life Cycle, Bug/Defect life cycle, Defect tracking and management.
•Actively involved in User Acceptance Testing (UAT) and Training of the end users. Participated in cross-functional teams to reengineer and improve business processes.
•Ability to quickly adapt to new environments and learn new systems, process and technologies, hunger for knowledge & self-initiatives.
Core Competencies:
•Scripting Language: SQL, UNIX
•Database: Oracle 11g, DB2 v11, SQL Server 2008
•ETL Tool: Informatica 9.5.1
•Scheduler Tool: Autosys
•Test and Defect Management Tool: JIRA, HP ALM 12.55, GIT/GITHUB
•STLC: Requirement Analysis, Test Scenario, Test Case Preparation, Test Execution and Defect Logging.
•UI Testing: - Component Testing, Sanity Testing, Smoke Testing, System Integration Testing, Regression Testing and End to End Testing.
•ETL Testing includes:
•Metadata testing
•Data completeness testing
•Data quality testing
•Data transformation testing using black box approach
Major Responsibilities and Tasks:
•Responsible for doing UI Testing as well as ETL testing in Agile Scrum model.
•UI Testing includes, Functional testing, System integration testing, Regression Testing and End to End Testing to ensure the quality deliverable in every Sprint.
•Prepared Test plan, Test Scenario, Test cases, executing them in HP ALM and logging the defects in JIRA.
•Validating source tables by creating test data through UI to cover all negative and positive test scenarios.
•Running the ETL jobs and loading the data to warehouse, once the data is loaded verifying the target tables with business rules using SQL queries.
•Wrote SQL queries to compare the counts and data from source to target.
•Verified column mapping between source and target.
•Bug fixes verification and validations.
•Extensively interacted with UI developers, ETL developers, BA & product Owners to understand the project business requirements and ETL design document specifications.
•Written test cases to test the application in Quality Center 12.55(ALM)
•Defects identified in testing environment are communicated to the developers using JIRA.
•Provided daily status reports with details of executed, passed, and failed test cases and defect status in Daily Scrum call.
•Actively participated in Sprint Planning meeting, Sprint Retrospective meeting and Backlog grooming meeting.
Achievement:
•Got appreciation from client for zero defect leakage to UAT and Prod.
•Awarded with ‘’Star of the Month’’ award.
•Validation Studio- ORD
Major Responsibilities and Tasks:
•Responsible for doing UI Testing as well as database testing in Agile Scrum model.
•Carried out complete Regression Testing for Infrastructure release (Upgrade Pega version 7 to Pega version 8).
•Created module flow diagram in Agile Requirement Designer tool to create Gherkin Statements.
•UI Testing includes, Functional testing, System integration testing, Regression Testing and End to End Testing to ensure the quality deliverable in every Sprint.
•Prepared Test plan, Test Scenario, Test cases, executing them in HP ALM and logging the defects in JIRA.
•Validating source tables by creating test data through UI to cover all negative and positive test scenarios.
•Bug fixes verification and validations.
•Extensively interacted with UI developers, BA & product Owners to understand the project business requirements.
Achievement:
•Got appreciation from client for successfully delivering three major releases (pega upgrade release, DB2 Upgrade release and Functional Release) at the same time with zero defect count in Prod.
•Travel and Expense
Major Responsibilities and Tasks:
•Requirement analysis and gathering
•Prepare and Execution of test cases as per requirement.
•Involved in preparing the traceability matrix.
•Preparing Defect Report and assigning the defects to developer.
•Leading the defect triage calls.
•Involved in System and Functional testing.
•Interaffiliate Artifact Repository
-