We provide IT Staff Augmentation Services!

Etl Tester Resume

2.00 Rating

Marlborough, MA


  • 7 years of IT experience in Quality Assurance and Software Testing for various business applications in Client/Server environment,ETLand Data Warehouse applications
  • Experience of System Development Life Cycle (SDLC)
  • Involved in preparation of the Test plan and Test strategy documents
  • Thorough understanding of the Defect Life - Cycle Process
  • Work experience reviewing and testing of data maps between various relational databases
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch
  • Experience in Dimensional data modeling, Star schema and snow flake schema.
  • Created mappings using slowly changing dimension (SCD) to load dimension tables
  • Proficiency in defect management, including defect creation, modification, tracking and reporting using tools like HP Quality Center
  • Expertise in developing, implementation and maintaining Test Plan, Test Script and Test Methodologies
  • Very good understanding and experience inData Warehousing Concepts
  • Efficiently worked with Oracledatabase, Teradata and built SQL queries to verify and validate data
  • Extract, Transform and load (ETL) software, which includes reading data from source, cleaning it up and formatting it uniformly, and tan writing to the target repositories. After extraction the data is transformed, modified, depending on specific business logic involved so dat it can be sent to the target repository
  • Expert in writing Sql queries.
  • Experience in Integration and extraction of data from various sources like Oracle, SQL server, Teradata and MS Access into staging area
  • Expertise in understanding of Functional testing, System testing, Performance testing, Integration testing, Regression testing, Black Box testing, Stress Testing, Smoke testing
  • Understanding of continuous Integrations tools like maven and svn
  • Experienced in preparation of Traceability Matrix, Defect reports and Weekly status reports
  • Knowledge on UNIX commands
  • Ability to multi task and provide expertise for multiple development teams across concurrent project tasks
  • Strong Problem Analysis and Resolution skills and ability to work in multi-platform
  • Dedicated to maintain high quality standards and strong domain noledge


QA Methodologies: SDLC, Agile, Waterfall and Spiral Methodology

Databases: Oracle: 11g, 10g, 9i and 8i,Teradata 13.0

Microsoft: MS Access, SQL Server 2005/2008.

ETL Tools: Informatica Power Center 9.5/8.x/7.x,Data Stage

Reporting Tools: Business Objects, IBM Cognos

Programming Languages: SQL, PL/SQL, C, C++.

Operating Systems: Microsoft Windows - 7, Vista, XP, 2000, NT 4.0 MS-Dos,UNIX, LINUX

Management tools: HP ALM/Quality Center, Rational - Clear Quest

Browsers: Internet Explorer,Firefox, Chrome


Confidential,Marlborough, MA

ETL Tester


  • Gathering requirement documents and analysis.
  • Understanding, Testing and Validation of the developed Informatica Mappings.
  • Study and analysis of the mapping document indicating source tables, columns, data types, and transformations required, business rules to be applied, target tables, columns and data types.
  • Tested entire ETL flow from source 2 target.
  • Tested Slowly changing dimension type -2 .(SCD type 2)
  • Data Quality Validation- Check for missing data, mismatch, negative and consistency.
  • Field by field data verification need to be done to check the consistency of source & target data.
  • Verify the source column data and target column data after loading data into data base.
  • Executed the test scripts and validated the rules according to the mapping documentation
  • Developing various test scripts, test execution using Quality Center based on Functional Specifications
  • Developed SQL queries for backend or data base testing.
  • Validated the source system data with the staging data using SQL
  • Reached testing goals by doing data completeness, data transformation, data quality, performance and scalability
  • Analyzed functional and business requirements to develop test plans and test cases.
  • Prepared Traceability Matrix with requirements versus test cases.
  • Expertise in System Testing, Functional testing, Smoke testing, Regression testing, and Integration Testing.
  • Involved in identifying the defects and developed Defect Tracking report using HP Quality Center which involved Bug Life Cycle.
  • Conduct defect tracking meetings.
  • Provided daily and weekly status reports.
  • Coordinates activities between onsite and offshore testing team.

Environment: HP Quality Center 9.0, Informatica Power Center 9.0, MS Office, Oracle 10g/9i, SQL, Windows 2007,TOAD 8.0, Data Warehouse ETL Environment


ETL Tester


  • Test Planning, analysis and test data creation
  • Transfer the noledge to the individual team members
  • ETL testing in Data warehousing environment /projects
  • Written SQL queries for checking the Data transformation and Database Integrity in Teradata
  • Responsible for Data Mapping testing by writing complex SQL Queries.
  • End-to-End data validation for ETL and BI systems
  • Responsible for executing the Test Cases using Quality Center.
  • Scheduling and monitoring ETL jobs in TWS (Tivoli Workload Scheduler)
  • Test Planning, test execution and reporting. Interact with functional and technical team on mitigating risks and closing issues.
  • Understanding of continuous integration tools like maven and svn
  • Tracking defects in HP ALM.
  • Conduct defect tracking meetings.
  • Coordinates activities between onsite and offshore testing team.

Environment: HP Quality Center, Informatica Power Center 9.5, Java,MS Office, Oracle,Teradata 13.0, UNIX, TWS (Tivoli Work Load Scheduler), Windows 7

Confidential, TX

Quality Assurance/ETL Tester


  • Tested ETL process across multiple client teams
  • Utilized INFORMATICA Power Center designer to analyze mapping, sources, source transformations, expressions, sequencers, normalizes, filters and targets
  • Verified data for ETL Packages using SQL Queries
  • Utilized INFOMRATICA Data Warehouse for testing ETL process
  • Validated workflows, sessions and WORKLET to check in and check out
  • Analyzed functional and business requirements to develop test suites, test plans and test cases
  • Created test plan and estimation to share with the business team
  • Defined testing process for functional and usability testing
  • Performed functional, regression and integration testing for web-based Dashboard application
  • Creating defects in Team Foundation Server (TFS) and coordinated with business and development team to resolve defects through defect triage meetings
  • Develop standardized matrix reports

Environment: Oracle 11i, Toad, INFORMATICA, Team Foundation Server (TFS), Unix, Microsoft Office


QA Tester


  • Understanding requirements and preparing the test cases and test scenarios with test data
  • Involved in functional requirements and test design discussions of the project
  • Collecting data from different databases and making reports.
  • Understanding UML Charts
  • Involved in designing of test plan, Test Case reviews, test reports Summary
  • Involved in preparation of weekly status reports
  • Performing Smoke, BVT, System, Regression Testing
  • Prepared Traceability Matrix with requirements vs test cases.
  • Bug reporting and tracking the bugs to closure using Quality Center
  • Preparation of Final Test Report and publishing the same day
  • Delivering the status reports to onsite team (Test summary report, Defect status reports)
  • Participating In Defect Triage calls
  • Maintaining and implementing the pure process oriented and coordinating the same.

Environment: HPQuality Center 9.2, Oracle 10g, Sql, Excel, Windows, Linux


Jr QA Tester


  • Understanding requirements and preparing the test cases and test scenarios with test data
  • Involved in functional requirements and test design discussions of the project
  • Understanding UML Charts
  • Optimizing the test cases for effective test execution
  • Understanding the use case documents and preparing the test cases
  • Prepared Traceability Matrix with requirements vs test cases.
  • Logging the defects in QC and assigning to associated person
  • Preparation of traceability matrix
  • Understanding of continuous Integration tools like Hudson, SVN
  • Delivering the test summery report Defect status report
  • Optimizing the test cases for effective test execution
  • Supporting user acceptance testing

Environment: HP Quality Center 9.2, Java, Oracle, Excel, Windows

We'd love your feedback!