We provide IT Staff Augmentation Services!

Etl Developer/ Test Automation Developer Resume

SUMMARY:

  • Over 12 Years Experience in Information Technology Industry in several roles such as Test Automation Developer, Onsite Offshore coordinator, Test Automation Lead, Business Intelligence Quality Assurance, ETL Informatica Developer.
  • Excellent working knowledge of System Development Life Cycle SDLC, Software Testing Life Cycle STLC and Defect Life Cycle.
  • Experienced in Functional testing, System testing, Application testing, Integration testing, Regression testing, Black Box testing, Smoke testing, UAT and GUI testing.
  • Expertise in writing Test Plans, Test Strategy, Test cases, Test scripts, Defect status reports, Test Summary report, Requirement Traceability Matrix.
  • Over 6 years Expertise in Automated testing using Test Automation tools like Cucumber, Ruby 1.9, Rspec, Watir, RAutomation
  • Over 7 Years expertise in Test Automation using Quick Test Professional (QTP)
  • Over 4 Years Experience in ETL processes using Informatica Power Center and Informatica Data Quality and IBM MDM
  • Experience with creating Db2 extracts for Business Partners with ETL using Informatica Power center
  • Automated, Redesigned and tuned several ETL Process for optimal utilization of Time and resources.
  • Experience working closely with the project team in user story planning, user story development using Gherkin, and participating in retrospective meetings
  • Excellent communication skills, an energetic and positive attitude, strong team skills and an ability to mentor and coach people in Ruby, Cucumber, and Gherkin
  • Experience identifying areas for testing improvement and working with the teams to implement appropriate agile QA practices
  • Experience facilitating communication between developers, Business Analysts and Automation resources, driving a shared understanding of the domain
  • Experience with test automation in an agile development environment implementing ATDD with Ruby and Cucumber.
  • Good exposure on Automation Frameworks Such as Data Driven, Keyword Driven, Library Architecture.
  • Good knowledge of Test Management Tools and Defect Tracking Tools like HP Quality Center (ALM), Rational Test Manager
  • Extensive interaction with developers, configuration management teams while handling production issues with development and business analyst teams.
  • Expertise in applying sound software testing techniques and principles to reduce number of defects, improve quality and enhance business success.
  • Self - starter, versatile team player, proactive and extremely detail-oriented with a proven capability of working under high pressure.
  • Confident and comfortable with both independent and team work.
  • Always keen to learn new technologies and look for advancement.

TECHNICAL SKILLS:

ETL: Informatica Power Center 9.5, Designer, Repository Manager, Workflow Manager & Workflow Monitor, Informatica Developer (IDQ)

Testing Tool: QTP 10/9.5, RubyMine, SoapUI, Rational Robot 2003.06

Scripting Languages: VBS, SQA Basic, Ruby 1.9,Perl

Database: Teradata, Oracle, SQL server, DB2, Denodo

Test Management Tools: HP-ALM (Quality Center), Rational Test Manager

Software life cycle management: Rational Team Concert and Rational Requirements Composer, HP-ALM

PROFESSIONAL EXPERIENCE:

ETL DEVELOPER/ TEST AUTOMATION DEVELOPER

Confidential

ENVIRONMENT: IBM MDM, DB2, INFORMATICA, LINUX

TOOLS: RUBYMINE 8, RUBY, CUCUMBER/ RSPEC, INFORMATICA POWER CENTER, IDQ

RESPONSIBILITIES:

  • Extensively developed Low Level Designs (Mapping Documents) by understanding different source systems.
  • Designed complex mappings in Informatica to interact with IBM MDM.
  • Designed complex Business rules in IDQ.
  • Developed complex Informatica mappings, sessions and workflows.
  • Developed complex IDQ rules which can be used in Informatica and as well in Online
  • Extensively used transformations like router, lookup, source qualifier, joiner, expression, sorter, XML, Update strategy, union, aggregator, normalizer and sequence generator.
  • Created reusable mapplets and reusable transformations.
  • Responsible for code migration during deployments.
  • Created and performed Unit tests over Informatica code.
  • Responsible for providing daily status report for all Informatica applications to customer.
  • Responsible for Monitoring and tracking the critical daily applications.
  • Worked on Performance tuning of Informatica designs and mappings.
  • Develop functional/regression automated testing solutions using RubyMine, Cucumber and data driven techniques.
  • Design and Architect modular and reusable automated testing solutions that satisfy testing requirements.
  • Responsible for closing user tickets and incidents.
  • Assist in estimating testing efforts and providing status updates
  • Lead teams - Direct and assist junior developers in their work

SQA - TEST AUTOMATION - ANALYST

Confidential

ENVIRONMENT: COBOL MICROFOCUS, MAINFRAMETOOLs: RUBYMINE 6.3, RUBY, CUCUMBER, SVN

RESPONSIBILITIES:

  • Created or updated, and reviewed business and technical requirements, functional specifications, and test cases to understand application solution requirements in order to test the application and verify successful implementation
  • Write structured test plans, create test strategy documents for manual and automated testing
  • Worked with development team to insure test coverage for all functionality plus analyzed and resolved defects. Worked with project teams to insure test coverage for all functionality.
  • Develop functional/regression automated testing solutions using RubyMine, Cucumber and data driven techniques.
  • Manage and create test data and object repository.
  • Develop detailed documentation to support the automation effort.
  • Execute test script, report detailed defects description through defect tracking tool.
  • Worked with application development team to participate in solution design to ensure testability of functions and applications. Identified areas for improving efficiency, shortening of test cycles, and automation of test scripts.
  • Facilitated implementation of automated test scripts with significant interaction with internal customers.
  • Continually review and improve testing process and implementation.
  • Assist in estimating testing efforts and providing status updates
  • Lead teams - Direct and assist junior automation developers in their work.
  • Train/mentor junior automation developers and test automation end users.

SQA - TEST AUTOMATION - ANALYST

Confidential

ENVIRONMENT: COBOL MICROFOCUS, MAINFRAMEAUTOMATION TOOL: QTP 10

RESPONSIBILITIES:

  • Gather and analyze system and product requirements
  • Write structured test plans for manual and automated testing
  • Develop functional/regression automated testing solutions using Quick Test Pro and data driven techniques.
  • Design and Architect modular and reusable automated testing solutions that satisfy testing requirements.
  • Manage and create test data and object repository.
  • Develop detailed documentation to support the automation effort.
  • Execute test script, report detailed defects description through defect tracking tool.
  • Monitor and report status
  • Continually review and improve testing process and implementation.
  • Assist in estimating testing efforts and providing status updates
  • Lead teams - Direct and assist junior automation developers in their work.
  • Train/mentor junior automation developers and test automation end users.

LEAD CSA ANALYST

Confidential

RESPONSIBILITIES:

  • Assessment of Testing Requirements / Areas of concern within GDOS
  • Assessment of Application / Technology landscape within GDOS
  • Assessment of Testing Tools and Frameworks
  • Existing Stakeholder Management
  • Recommendations and Prioritization
  • RAG Chart Report
  • Implementation Strategy and Roadmap Confidential application level

LEAD AUTOMATION TESTER/ONSITE COORDINATOR

Confidential

ENVIRONMENT: SQL SERVER 2000, VB.NET, ASP.NET

AUTOMATION TOOL: QTP 9.5, FITNESS, SOAPUI

RESPONSIBILITIES:

  • Understand application solution requirements in order to test the application and verify successful implementation
  • Write structured test plans for manual and automated testing
  • Develop functional/regression automated testing solutions using QTP, and data driven techniques.
  • Design and Architect modular and reusable automated testing solutions that satisfy testing requirements.
  • Develop detailed documentation to support the automation effort.
  • Execute test script, report detailed defects description through defect tracking tool.
  • Perform Web service testing using SoapUI
  • Performance and Load testing using Load Runner on need basis.
  • Continually review and improve testing process and implementation.
  • Assist in estimating testing efforts and providing status updates
  • Lead teams - Direct and assist junior automation developers in their work.

AUTOMATION TESTER

Confidential

ENVIRONMENT: SQL SERVER 2000, VB.NET, ASP.NET

AUTOMATION TOOL: QTP 9.5

RESPONSIBILITIES:

  • Requirement Analysis, Query Resolution with Client BA
  • Effort estimations for automated testing.
  • Test Case Review
  • Test execution and defect reporting through Quality Center.
  • Test automation through QTP 9.5
  • Performance and Load testing using Load Runner on need basis.
  • Adhere defect life cycle.
  • To resolve and troubleshoot problems based on analysis.
  • Participate in Internal Process compliance through Work Product audit, Work Process Audit, SMR etc.

AUTOMATION TEST ENGINEER

Confidential

ENVIRONMENT: LOTUS NOTES, VB.NET, ASP.NET.

AUTOMATION TOOL: QTP 9.2

RESPONSIBILITIES:

  • Prepare Estimation and plan for automation.
  • Prepared automated test scripts and maintained regression test suite using QTP (VBScript) according to application requirements
  • Developed automated tests using script modularity framework.
  • Prepared Bi-weekly test status reports for higher management and development team.
  • Help developers with writing unit test cases, ad-hoc manual testing to verify bug fixes

LEAD TEST AUTOMATION DEVELOPER

Confidential

ENVIRONMENT: SQL SERVER 2000, VB.NET, ASP.NET, MAINFRAME

AUTOMATION TOOL: QTP 8.2/9.2

RESPONSIBILITIES:

  • Identification of the test cases for automation and prepare Estimation and plan for automation.
  • Prepared automated test scripts and maintained regression test suite using QTP (VBScript) according to application requirements
  • Streamlined the automation process and enhanced the performance by creating modular reusable scripts which were called by other scripts.
  • Developed data driven tests including importing data using SQL
  • Prepared weekly test status reports for higher management and development team and Bug Tracking.
  • Created the Requirements traceability matrix, Functionality coverage matrix
  • Help developers with writing unit test cases, ad-hoc manual testing to verify bug fixes

TEST ENGINEER

Confidential

ENVIRONMENT: JAVA, ORACLE 10G

AUTOMATION TOOL: QTP 8.2

RESPONSIBILITIES:

  • Study of the application.
  • Identification of the test cases for automation.
  • Recording and Enhancement of the scripts.
  • Written utility functions whenever required for the application.
  • Execution of the scripts and reporting bugs & verifying fixes.
  • Prepared weekly/monthly test status reports for the client management and development team.

TEST ENGINEER

Confidential

ENVIRONMENT: JAVA, ORACLE 10G

AUTOMATION TOOL: RATIONAL ROBOT 2003.06

RESPONSIBILITIES:

  • Identification of the test cases for automation.
  • Recording and Enhancement of the script using SQA Basic Language with proper exception handling.
  • Written utility functions whenever required for the application.
  • Develop and Maintenance of Scripts for Business Scenarios.
  • Reporting & Verifying Bugs through Defect Tracking System on Intranet.
  • Interaction with client, transferring project as well as technical knowledge to team members.

TEST ENGINEER MANUAL TESTING

Confidential

ENVIRONMENT: PHP, APACHE, MSSQL

RESPONSIBILITIES:

  • Study of the application.
  • Identification of the test cases.
  • Execution of the test cases and reporting bugs & verifying fixes.

Hire Now