We provide IT Staff Augmentation Services!

Test Engineer / Lead Engineer Resume

CAREER OBJECTIVE:

Would like to pursue a challenging career with the technical knowledge and analytical skills to help organization achieve strategic objectives and have cutting - edge solutions. Looking forward for an active involvement and upgrading with advanced technology in the field of Testing Delivery.

PROFILE:

  • ISTQB certified Tester
  • Having 8+ years of experience in IT Industry
  • Currently working as Lead Engineer in Confidential.
  • Have experience on writing queries using Teradata, DB2, SAS SQL/Proc SQL.
  • Working Experience in ETL & Migration testing.
  • Have Knowledge on Data Warehouse and ETL concepts.
  • Working Experience in TERADATA 13.0 and SAS Enterprise 9.2 & JIRA.
  • Well acquainted with the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Working Experience in writing Test cases based on the Requirement Specification
  • Experience in writing and executing Test cases based on Business Requirements and Technical Specifications.
  • Effective in bug reporting, defect tracking and it’s reporting, in Bug tracking tool resulting in effective communication and reducing delays.
  • Defect tracking through Quality Center 9.2 & ALM 11
  • Previously worked with Genpact, Bangalore from Sept 2006 to Nov 2010.
  • Having Experience in BI Report Development & Report Testing.
  • Managed team size of 10.
  • Good communication skills and an ability to work individually or in a team environment
  • Persuasive, approaching all projects with a positive attitude and an uncompromising commitment to operational integrity.

PROFESSIONAL EXPERIENCE:

Confidential

Test Engineer / Lead Engineer

Testing Tools: Advanced Query Tool 8.2.8, Teradata SQL Assistant Quality Center 11, SAS 9.2, JIRA V6

Responsibilities:

Responsibilities:

  • Review Business users question on Report variances/Issues between DB2 reports vs Teradata Migrated reports or Production Data or Semantic data.
  • Analyzing data from Source Confidential Semantic DIM/FACT to provide mismatch analysis.
  • Providing facts on mismatch and resolution suggestion to Business users.
  • Review JIRA on regular intervals to identify new stories and changes.
  • Update the Team tracker with new Stories.
  • Review new stories and determine team involvement required/not.
  • Communicate with BDQ(Team) owners as often as needed to understand status.
  • Determine if they need your help facilitating data loads, defect resolution, etc.
  • Determine who has knowledge and/or bandwidth to own new stories. If complex, may need both onshore and offshore resources to ensure proper coverage.
  • Communicate ASAP with BDQ owner(s).
  • Provide details where needed including Jira story number, view/table names, summary of story, etc.
  • Take lead on implementation plan walk through.
  • Several days prior to implementation, review plan to ensure it aligns with expectations. Determine if stories are missing, or if unexpected objects are on the plan. Communicate discrepancies ASAP to implementation team.
  • Ensure a call is scheduled - with advance notice and during onshore working hours.
  • Represent BDQ on daily implementation status calls. Be prepared before calls with status, issues, etc.
  • Communicate BDQ status to implementation team as often as needed.

Confidential

TEST ENGINEER

Operating Systems: AIX 5.0, Windows XP Professional.

Testing Tools: Advanced Query Tool 8.2.8

Responsibilities:

  • Review HLD,LLD & Metrics mapping document b)Develop Test Scenarios and test cases for semantic Layer Physical tables and Dimensions and Facts
  • Validate the Metadata between HLD, LLD and TD. validate Valid records are moved to Confidential tables / Dim/Facts validate is there any duplicate record validate is there any Invalid records are moved to Confidential tables/Dim/Facts validate is there any record present in Confidential tables/Dim/Facts which is not valid in foundation
  • Validate week end dates are correct and review distribution of flags, dates and codes.
  • Validate derived metrics value is correct.
  • Count check between expected and actual count of records.
  • Testing flow in Test Environment and Production environment after Implementation.
  • Creating Monitors and scheduling SAS - Cron tab file.
  • Defect Calls with Onshore and Dev team
  • Post implementation Validations by monitoring the Scheduled monitor results

Confidential

TEST ENGINEER

Testing Tools: Advanced Query Tool 8.2.8

Responsibilities:

  • Requirement Doc review
  • HLD, LLD and STM review
  • Prepared Visio for Data flow
  • Developed test scenarios & Test Cases for Migration & Incrmental Load
  • Test execution from Quality Center 9.2.
  • Count, Data, Trending
  • Business code validation
  • ETL Transformation Validation
  • I/U/D records flow testing
  • EFF D, EXPR D,ACTV F and DEL F validation
  • Rejected Records validation - with Error table (FK,BC)
  • Rejected Records Reprocessing Testing
  • Purge Validation
  • Junk Value Testing
  • Mock up data preparation, Mock up done on Landing(source) tables and Mock up data flow in Warehouse
  • Reinserts and False Deletes
  • Flags, Nullability and Default values validation
  • Defect Calls with Onshore and Dev team.
  • SAS application is used to run Monitors and comparing Src to Tgt data.
  • Scheduling Monitors in SAS for automated validation - Crontab Job scheduling

Confidential

TEST ENGINEER

Testing Tools: Advanced Query Tool 8.2.8

Responsibilities:

  • Requirement Doc review
  • HLD, LLD and STM review
  • Prepared Visio for Data flow
  • Developed test scenarios & Test Cases for Migration & Incrmental Load
  • Test execution from Quality Center11.
  • Count, Data, Trending
  • Business code validation
  • ETL Transformation Validation
  • I/U/D records flow testing
  • EFF D, EXPR D,ACTV F and DEL F validation
  • Rejected Records validation - with Error table (FK,BC)
  • Rejected Records Reprocessing Testing
  • Purge Validation
  • Junk Value Testing
  • Mock up data preparation, Mock up done on Landing(source) tables and Mock up data flow in Warehouse
  • Reinserts and False Deletes
  • Flags, Nullability and Default values validation
  • Defect Calls with Onshore and Dev team.
  • SAS application is used to run Monitors and comparing Src to Tgt data.
  • Scheduling Monitors in SAS for automated validation. Crontab Job scheduling

Confidential

TEST ENGINEER

Testing Tools: Advanced Query Tool 8.2.8

Responsibilities:

  • Requirement Document review HLD, LLD and STM review Develop test scenarios for UAT Wrote Test cases for UAT in below areas Business code Validation Business Rules validation Content of Email & Formula Data Usability Default Values and Flags and dates ETL Transformations Row Completeness Views & Dimensions Uploading all Test cases to Quality Center through Excel Export.
  • Testing done for 8 source tables and logged defects in Quality center.
  • Project kept on hold due to Teradata Migration hence moved into Teradata project (PARS).

Hire Now