We provide IT Staff Augmentation Services!

Etl Tester Resume

3.00/5 (Submit Your Rating)

Deerfield, IL

SUMMARY:

  • 7 + years of experience as an ETL tester.
  • Experienced in all stages of Software Development Life Cycle and Software Testing Life Cycle.
  • Good knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and dimension tables in Target D/W.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
  • Professional experience in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing.
  • Collaborating with project team to discuss and resolve issues
  • Experience in Web based applications like online banking, transactions applications, healthcare, and telecommunication.
  • Tested the ETL Informatica mappings and other ETL Process (Data Warehouse Testing)
  • Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
  • Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
  • Extensive worked on HP Quality Center 10.0 & HP ALM Quality Center 11.0 to upload Test Cases, Execute Test Cases, Log Defects, Track Defects, and Track Progress Status.
  • Experience in working with Software Development team in resolving Defects, presenting the Defects status reports, resolving requirement, and observed design inconsistencies.
  • Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
  • Experience in Reports testing in Crystal Reports XI Environment.
  • Tested Web Services /XML /SOAP services using SoapUI tool.
  • Validated WSDL, request and response XML. Added Assertions to validate the response xml with database.
  • Strong working experience in Windows NT/2000/XP and UNIX environments
  • Clear understanding of business procedures and ability to work as an individual and as a part of a team.
  • Experience in interacting with business analysts, developers, and technical support and help them base line the requirement specifications.

TECHNICAL SKILLS:

Operating Systems: Windows, LINUX, UNIX

Languages: SQL, PL/SQL, XML

Test Management: HP ALM, JIRA

ETL Tools: Informatica 9.5 DataStage 8.7/8.1, Informatica

Web Services: Soap UI

RDBMS/ Databases: Oracle 11g/10g, SQL Server 2008/2005, Teradata

BI Tools: Tableau, Cognos

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

ETL Tester

Responsibilities:

  • Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
  • Involved in complete life cycle activities like pre - testing phase and testing phase.
  • Created Test Procedures and Test Cases to perform the system testing and Regression testing.
  • Used Jira to log the bugs
  • Participating in business discussions with business, product owner, BA and Tech lead to define test requirements and to provide test estimations to satisfy the business objectives.
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica
  • Ran workflows created in Informatics by developers then compared before and after transformation of data generated to ensure that transformation was successful.
  • Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
  • Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability.
  • Created various User Defined Functions for script enhancements and to verify the business logic.
  • Extensively used SQL queries to perform database validation
  • Responsible for reviewing complete test plans, test cases, test data and ensuring accurate coverage of requirements and business processes for the Big data warehouse
  • Manage the Test data, Test environment and resolving QA environment issues.

Environment: HP ALM 11.0, Informatica Power Center 10, MS Excel, Oracle 11g, SQL, PL/SQL, Teradata utilities, TOAD, UNIX, Windows, Cognos 10.2

Confidential, Deerfield, IL

ETL Tester

Responsibilities:

  • Involved in Business analysis and requirements gathering
  • Involved in Preparation of Test Plan and approach based on the Business requirements
  • Experienced in Data warehouse testing, in all the phases of Data warehouse life cycle.
  • Expertise in Writing, Executing and Maintaining Test Plans, Test Procedures, Test Cases, Test data in all phases of SDLC
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Analyzing complex reports and to improve the performance of those reports by adding some new filters to filter the data.
  • Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s using Oracle Analysis Services.
  • Optimized the queries by creating various clustered, non-clustered indexes and indexed views.
  • Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
  • Strong experience using Oracle, MS SQL Server, Teradata.
  • Experienced in Database / Data warehouse testing life cycle.i.e., Conversion Testing, Integration testing, System & Acceptance testing and Regression testing.
  • Validating the complete source to target mappings along with transformation rules.
  • Implemented data verification procedures for ETL processes in load testing.
  • Used Data Stage ETL tool to load data from various sources into target database and validated different transformations to move data from source to target.
  • Extensively used SQL scripts to perform backend database testing and Tested Data Stage Mappings.
  • Reviewed requirements and mapping documents to identify gaps analysis.
  • Worked with developers in understating the ETL code for writing several complex test plans for testing both front-end and backend.
  • Prepared several test scenarios for the work flow of the entire ETL cycle.
  • Developed Test Plans/Test Cases to Validate Key Business Requirements.
  • Written and executed complex SQL queries to validate accuracy of the reports.
  • Extensively used ETL tool to extract data from Oracle database and loaded into SQL Server database.
  • Tested Web Services /XML /SOAP services using SoapUI tool.
  • Validated WSDL, request and response XML. Added Assertions to validate the response xml with database.
  • Participated and conducted Agile Scrum Daily project meeting and planning using the AGILE process.

Environment: SQL, PL/SQL, SQL SERVER, Oracle 11g, Unix, Jira, DataStage 8.5, XML, Jira, Agile, SoapUI, Cognos 8.4.

Confidential, Texas

DWH TESTER

Responsibilities:

  • Worked on creating Test plan, Test Design, Test scripts and responsible for implementation of Test cases as Manual test scripts.
  • Proficient in testing several data migration application for security, data protection and data corruption during transfer.
  • Responsible for testing packages using (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT and regression testing.
  • Created test cases and executed test scripts using HP ALM/Quality Center.
  • Tested the data and data integrity among various sources and targets.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
  • Involved in preparing test data for UAT and participated in UAT signoff.
  • Involved in Data migration and Data distribution testing.
  • Worked on testing the Application in UNIX Environment and collecting the Test data from the Business Team.
  • Involved in testing the Cognos reports by writing complex SQL queries.
  • Performed Functional, Data Validation, Integration, regression and User Acceptance testing.
  • Participated in defining and executing test strategies using agile methodology.
  • Used TOAD, DB Visualizer tools to connect to Oracle Database to validate data that was populated by ETL applications.
  • Developed Oracle SQL test scripts from test procedures and expected results and executed them in various test environments.
  • Responsible for integration testing activities with other Data Warehouse teams and upstream/downstream application test teams.
  • Adopted Agile/scrum methodology for - Risk Mitigation, Monitoring and test Management (risk analysis) at every stage of the project Cycle with transparency in planning and module development.

Environment: SQL, PL/SQL, SQL SERVER Oracle 11g, Unix, Jira, Informatica power center 9.5, XML, Jira, Agile, SoapUI, Teradata, cognos, HPALM.

Confidential, Hamilton, NJ

Manual QA Tester

Responsibilities:

  • Involved in creating Test Plan, Test Cases by analyzing Business Requirement Document.
  • Documented and executed Test plans, Test cases and Test scripts based on business requirement document.
  • Implemented agile methodology throughout the process.
  • Experienced in functionality testing, black box testing, system testing, integration testing, regression testing, backend testing, compatibility and user acceptance testing.
  • Possess good judgment skills while reporting and prioritizing software bugs in conjunction with the development and QA Managers.
  • Involved in executing the basic SQL Queries for Data Validation, Record Counting and Non-duplication Testing.
  • Developed SQL scripts, to implement business rules.
  • Manually performed integration and Regression testing, documented bugs and worked with development team to resolve issues.
  • Used JIRA to log bugs
  • Exported test cases into the Quality Center, ran manual test cases from test lab and logged defects from defect module.
  • Performed Ad-hoc, Smoke, Functional, and Regression testing by executing test cases maintained in Quality Center.
  • Performed Smoke testing in the UAT environment to ensure successful migration prior to notifying the customer to start performing UAT testing.
  • Generated Test Status Reports, Defect Reports.
  • Actively participated in the test plan review meetings, Walk through, Weekly meetings.

Environment: HP Quality Center 10.0, Microsoft office, UNIX, Windows OS, Mac OS, JIRA, Internet Explorer

We'd love your feedback!