We provide IT Staff Augmentation Services!

Etl Tester Resume

4.00/5 (Submit Your Rating)

Chicago, IL

SUMMARY: -

  • Over 7+ years of IT experience in Data warehousing testing with extensive usage of SQL, PL/SQL, UNIX, Shell Scripting & HP QC.
  • Good understanding of SDLC and STLC methodologies including Waterfall, Iterative, Agile and Scrum methodologies.
  • Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations using Datastage, Informatica, and Ab Initio and Autosys tools were.
  • Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
  • Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
  • Strong testing Quality Assurance experience within agile environment.
  • Experienced working with SQL Server 2008, Netezza, Oracle 10g/11g, Teradata, Sybase & DB2.
  • Experienced in testing different source feeds of data for ETL and prepared mock data for ETL.
  • Experience in testing Business Report developed in Business Objects XIR2 & Cognos 8 series, OBIEE, Hyperion reports.
  • Skills in back end testing using SQL queries on SQL Server, oracle, Teradata and DB2 tables and generating reports to ensure data integrity and validate business rules.
  • Good exposure in working various test management and defect management tools like Quality Center, Jira and HP ALM.
  • Extensive experience in Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL. Efficiently used Oracle utilities like SQL Loader.
  • Experienced in Writing UNIX Korn Shell Scripting for job scheduling and sequencing.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
  • Well versed in SQL 2008, Oracle, Teradata and DB2 database concepts and usage.
  • Extensive experience in UNIX Shell Scripting, AWK and file manipulation techniques.
  • Experience with QA Methodology and QA Validations to ensure the Quality.
  • Solid Back-end testing experience in writing and executing SQL Queries.
  • Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL.
  • Ability to interact with all levels of personnel from technical to high level executive management within the information technology and business communities.

TECHNICAL SKILLS

Skill Matrix:

Quality Assurance/ Test Management: DOORS, Requisite Pro, HP ALM 11/Quality Center 10, IBM ClearQuest 9.0, IBM Clear Case 9, Test Director 7.5, BugZilla, JIRA 4.0/4.4/5.0.

SDLC/STLC: Agile, SCRUM, Water Fall, RAPID, Spiral, V- Model

RDBMS Technologies & Data Sources: Oracle 11g/10g/9i, Teradata 13.0/12.0, SQL Server 2012/2008R2, IBM DB2, SYBASE, MS Access, MS EXCEL, FLAT Files, XML

RDBMS Query Tools/GUI Tools: TOAD 10.6, SQL* Loader, Oracle SQL Developer, Teradata SQL Assistant 13.0, WinSQL

ETL/Datawarehouse: Informatica 9, SSIS, Ab Initio 2.15, IBM DataStage 8.1

BI/Reporting Tools: Business Objects XIR4, Cognos 8.4, OBIEE 10, Hyperion 11.1.2

Operating System: MS - Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Sun Solaris 5.8)

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

ETL Tester

Responsibilities:

  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Analyzing requirements and creating and executing test cases.
  • Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
  • Working with the Development team for process improvement and release planning.
  • Analyzed application data using the SQL to identify the ETL processes.
  • Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
  • Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
  • Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
  • Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
  • Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
  • Wrote complex queries to compare the counts and data from source to target.
  • Created some macros in Teradata to load the test data in to Target tables.
  • Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
  • Performing database testing to verify backend database transactions.
  • Wrote complex queries in Teradata SQL assistant to analyze the data
  • Coordinating user acceptance testing activities for business groups and IT.
  • Involving in communication between UAT team members, business leaders, and IT.
  • Participates in application release planning and status sessions.
  • Used Agile testing methodology for achieving deadlines in UAT testing.
  • Working on conversion of manual tests into automated test scripts
  • Created, maintained and updated regression suites upon receiving new build.
  • Modifying and executing test scripts for web based environment-using Quality Center.
  • Extensively used Load Runner for generating the automated test scripts.
  • Created and executed goal oriented and manual scenarios using Load Runner Controller.
  • Creating traceability relationship between requirements in the same module and also between different modules.
  • Extensively used Quality Center for documenting, organizing and tracking requirements.
  • Involving in formulating the test plan, procedures and Wrote test cases.

Environment: Oracle 10g, TOAD, SQL Server 2008R2, SSIS,SSRS, SQL Server Management studio 2008, Business Objects Enterprise XI R3.1, Business Objects Designer, HP Quality Center 10.

Confidential, Port Washington, NY

Data warehouse QA Engineer

Responsibilities:

  • Followed Agile methodology, reported status to scrum master on daily basis, attended daily basis scrum meeting, planning of QA in sprint planning meeting.
  • Worked closely with developers and Datawarehouse team.
  • Prepared Test data of every story before started testing.
  • Worked on snowflake schema and followed Kimball approach.
  • Developed Test Cases ETL Data Validation, Cube Testing and Report testing.
  • Tested whole Datawarehouse when migrating from sql server2005 to sql server 2008.
  • Test planning of QA before whole rebuilt.
  • Tested all the areas of company involved for datawarehouse like lotto, games, search and win, member identity, coreg, direct track, entries, survey.
  • Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Prepared test strategy for testing each user story.
  • Tested source files, source testing, staging testing, dimension testing, fact testing, incremental testing.
  • Experienced in writing complex SQL queries for extracting data from multiple tables.
  • Reported bugs to the developer and maintained in Quality center and version one.
  • Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
  • Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
  • Developed ETL Test Plan and Test Strategies for the entire Line of businesses.
  • Extensively used SQL queries for Database testing and Validation.
  • Involved in extensive backend testing.
  • Gathered requirements from system architect, developers, and business people.
  • Debugging the SQL-Statements and stored procedures.
  • Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
  • Developed regression test scripts for the application
  • Tested the data and data integrity among various sources and targets.

Environment: SSIS 2008, PL/SQL, SQL, SQL Server Analytical Server, SQL Server Reporting Server, 9.2, HP Quality Centre 9.2, Metal (Meta Data Driven ETL), BI Reports, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point,, Windows NT/XP//2003, Version One.

Confidential, Madison, WI

QA Analyst

Responsibilities:

  • Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
  • Formulate methods to perform Positive and Negative testing against requirements.
  • Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing(UAT) and Data validation Testing.
  • Used Agile testing methodology for achieving deadlines in UAT.
  • Developed automated Test scripts using QTP to perform Functional and Regression testing.
  • Executed and managed test cases and reported bugs in Quality Center.
  • Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
  • Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
  • Validated data in between source and target after running Mappings by the Informatica developer team.
  • Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
  • Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
  • Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis for Caliber data mart.
  • Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.

Environment: Informatica Power Center 9.1, TOAD, PL/SQL, Oracle 10 G,11G, Crystal Reports 4,Erwin 8.

Confidential, Houston, TX

QA/Software Tester

Responsibilities:

  • As part of QA team was involved in implementation of ETL best practices.
  • Involved in all phases of (Unit, Integrated and UAT) testing Informatica mappings.
  • Maintain, back up and restore the Informatica ETL repositories for the QA team.
  • Tested data marts; tested the security levels and granting of appropriate roles.
  • Tested Informatica folders, global sources, global targets, global ODBC connections, global FTP connections workflows, data profiling and manage metadata.
  • Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the datamarts and feeder systems in the aggregation effort.
  • Compared the output ASCII files and directories to confirm and test the data replication.
  • Participated in walkthroughs and reviewed the business requirements and followed with the Business Analysts and worked towards the resolution of the specification issues.
  • Created test cases and executed test scripts using Test Director.
  • Involved in performing various levels of testing like Unit Testing, System testing, Integration testing and Regression testing.
  • Performed Manual Testing of the application as well as identified the critical test scripts to be automated.
  • Supported Performance tester with the Performance and Load testing using Load Runner.
  • Created scenario to check the response time using Load Runner.
  • Performed Data driven testing using multiple test data inputs with QTP and spreadsheets.
  • Used Test Director to track and manage bug life cycle.
  • Conducted various management activities by analyzing and verifying test results, providing status reports.
  • Responsible to oversee day-to-day activities, provide support, and facilitate problem resolution for a team of Software Quality Assurance Engineers.
  • Assisted Business team with planning, coordinate and execution of User Acceptance Testing.

Environment: Informatica Power Center 8.6/ 8.1, TOAD, PL/SQL, Oracle 10G, Crystal Reports 14, Erwin

Confidential, NY

ETL/Backend Tester

Responsibilities:

  • Created test cases and test plans for testing the ETL process and reports.
  • Tested all the ETL processes developed for fetching data from OLTP systems to the target Data warehouse using complex SQL queries.
  • Tested the entire reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
  • Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
  • Provided support to offshore QA team by giving them knowledge transfer and helping them in closing the defects by coordinating with the dev team.
  • Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
  • Tested source data for data completeness, data correctness and data integrity.
  • Performed End to end testing starting from the source to the report.
  • Conducted and co-ordinated with integration testing and regression testing.
  • Participated in business requirements gathering and in modifications of the requirements based on the scope.
  • Worked with the team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
  • Prepared test data to cover all the test scenarios.
  • Prepared UNIX scripts to run the Informatica ETL jobs from command line.
  • Tested several business reports developed using Business Objects including dashboard, drill-down, summarized, master-detail & Pivot reports.
  • Maintained all the test cases in Quality Center and logged all the defects into the defects module.

Environment: Oracle 8i+9i, SQL, PL/SQL, Quality Center 8.0, XML, Informatica 7.1, Business Objects 6.5, TOAD for Oracle

We'd love your feedback!