We provide IT Staff Augmentation Services!

Etl Test Lead Resume

SUMMARY:

  • 10 years of strong experience in carrying out Manual and Automation End to End Functional testing
  • Worked on different Domains BNFS, Logistics and Healthcare.
  • Excellent understanding of SDLC and STLC Concepts.
  • Experience in preparing Traceability Matrix, Test plan, Test estimation.
  • Having experience in automation testing using QTP, Selenium.
  • Experience in Functional Testing, ETL Testing, GUI Testing, Regression Testing, UAT.
  • Done data validation of the raw data getting from different sources.
  • Good experience in ETL testing, Desktop Application.
  • Good Experience in Defect Management Tools - Quality Center 10.0/ALM.
  • Well-versed with all the stages of Defect Tracking Life Cycle.
  • Good Knowledge of Data Warehouse & ETL Concepts and worked as ETL tester, having 5 years of relevant experience in ETL testing.
  • Participated in the Review meetings to discuss about ongoing project with Team Members and Test Manager.
  • Quick learner and excellent team player, ability to deliver on time and work efficiently.
  • Working as a Test Lead and handling a team of 5 resources.
  • Task allocation to the team members on daily basis and monitoring of tasks and reporting the status to onsite coordinators and managers.

TECHNICAL SKILLS:

Hardware: IBM Compatible PC, Mainframe, UNIX

Operating System: Windows 98, Windows XP

Programming Languages: C, C++, Java

Databases & Tools: Oracle 9i, SQL, Informatica cloud, JCL, DB2

Other Utilities: HP Quality Center, ALM, IBM Clear quest

PROFESSIONAL EXPERIENCE:

Confidential

ETL Test Lead

Responsibilities:

  • Worked as ETL Test lead and handling team at offshore
  • Compare data from source files & data stores to the target Data Warehouse or Big Data store.
  • Validate different transformation logics as per the mapping document, if found any discrepancy then log defect in ALM
  • Write store procedures
  • Testing using soap UI
  • System testing
  • Attending stand up meetings
  • Well versed with agile methodologies.
  • ETL automation using informatica DVO

Environment: ETL/ Informatica cloud, Windows XP, Java, SQL, Oracle10, HP ALM

Confidential, Mclean VA

ETL Test Lead

Responsibilities:

  • Worked as ETL QA on Mortgage domain
  • Loan origination and Functionality covering (Loan processing, verification of Mortgage, Credit checking, Enquiries.
  • Underwriting guidelines Mortgage Insurance
  • Compare data from source files & data stores to the target Data Warehouse or Big Data store.
  • Validate different transformation logics as per the mapping document, if found any discrepancy then log defect in ALM
  • Write store procedures
  • Done with Perl scripting so as to compare the source and target files,
  • Onshore- offshore coordination
  • Defect and test case management in ALM
  • Requirement analysis of the new tasks
  • Preparation of traceability matrix, Test plan and test case point estimation
  • Creation of Test Scenarios and Test cases
  • System testing

Environment: ETL/ Informatica cloud, Windows XP, Java, SQL, SQL server, Oracle10, Toad, ALM

Confidential, Charlotte, NC

Test Lead

Responsibilities:

  • Compare data from source files & data stores to the target Data Warehouse or Big Data store.
  • Validate different transformation logics as per the mapping document, if found any discrepancy then log defect in ALM
  • Onshore- offshore coordination
  • Defect management
  • Requirement analysis of the new tasks
  • Preparation of traceability matrix, Test plan and test case point estimation
  • Creation of Test Scenarios and Test cases
  • System testing
  • Reporting Daily and weekly status of ongoing projects with team members, Onsite coordinators, Project Leads and Project Managers.
  • Executing the test cases in ALM (Application life cycle management)

Environment: ETL/ Informatica cloud, SQL, Windows XP, Java, Talend, ALM

Confidential

ETL Test lead

Responsibilities:

  • Worked as test lead and handle team of 5
  • ETL testing using SQL and Informatica cloud as tool
  • Validate the target output in Informatica cloud and check if the transformations used displays the correct output as required in Target table
  • Validate different transformation logics as per the mapping document, if found any discrepancy then log defect in ALM
  • Clean the data into common data format
  • Done data validation (finding duplicate, null and blank spaces) from the raw data received.
  • Compare the source and target data using data comparator tool.
  • Execute the ETL job(s)/transformation(s).
  • Requirement analysis of the new tasks
  • Preparation of traceability matrix, Test plan and test case point estimation
  • Creation of Test Scenarios and Test cases
  • System testing
  • Reporting Daily and weekly status of ongoing projects with team members, Onsite coordinators, Project Leads and Project Managers.
  • Executing the test cases in ALM (Application life cycle management)

Environment: ETL/Informatica cloud, Windows XP, Java, SQL, SQL server, Oracle10, Toad, ALM

Confidential

ETL module lead

Responsibilities:

  • Work as module lead and have individual module working on.
  • ETL testing using SQL and Informatica as tool
  • Validate the target output in Informatica and check if the transformations used displays the correct output as required in Target table
  • Execute the ETL job(s)/transformation(s).
  • Done data validation (Duplicate, null and blank spaces) from the raw data received.
  • Clean the data and convert that data in common data format
  • Requirement analysis of the new tasks
  • Preparation of traceability matrix, Test plan and test case point estimation
  • Creation of Test Scenarios and Test cases
  • Integration Testing
  • System testing
  • Reporting Daily and weekly status of ongoing projects with team members, Onsite coordinators, Project Leads and Project Managers.
  • Executing the test cases in QC
  • Executing the Regression scripts using QTP 10.0

Environment: Informatica, ETL / Web, Windows XP, Java, Quality Center, QTP 10.0, SQL server, JIRA

Confidential

Test Analyst

Responsibilities:

  • Work as individual contributor and handle a module independently
  • ETL testing using SQL and Informatica as tool
  • Validate the target output in Informatica and check if the transformations used displays the correct output as required in Target table
  • Execute the ETL job(s)/transformation(s) and validate by writing SQL queries.
  • Validate reports in Cognos and verified as per the requirements
  • Requirement analysis of the new tasks
  • Preparation of traceability matrix, Test plan and test case point estimation
  • Creation of Test Scenarios and Test cases
  • Integration Testing
  • System testing
  • Reporting Daily and weekly status of ongoing projects with team members, Onsite coordinators, Project Leads and Project Managers.
  • Executing the test cases in ALM

Environment: Informatica, ETL / Web, Cognos, SQL Queries, Windows XP, Java

Confidential

Test Analyst

Responsibilities:

  • Work as team member and have a team of 7 people
  • Handle the task assign and report to my client manager
  • Requirement analysis of the new tasks
  • Preparation of traceability matrix
  • Creation of Test Scenarios and Test cases
  • Integration Testing
  • System testing
  • Reporting Daily and weekly status of ongoing projects with team members, Onsite coordinators, Project Leads and Project Managers.
  • Executing the test cases in QC

Environment: Mainframe / Web, Windows XP, C# .Net, Quality Center, ETL, QTP

Hire Now