We provide IT Staff Augmentation Services!

Etl Tester Resume

Chicago, IL

SUMMARY:

  • Over 8 years of experience in Software Quality Assurance and Testing with strong knowledge of Software development life cycle (SDLC) and Software Testing Life Cycle (STLC)
  • Hands on experience in analyzing Business Requirement, Functional Requirement, Design specification and developing Test plan and Test scenarios
  • Hand on experience in Functional testing, Integration testing, System testing, Regression testing and End to End testing
  • Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like JIRA, Quality Center, Test Director, Rational Clear Quest.
  • Experience in financial application testing such as Retail, Banking, Health and web applications integrated with various legacy systems
  • Extensive experience in all testing methods including Waterfall, Agile and Scrum.
  • Expertise in creating/developing Test cases, Test scenarios using standard and modular approach.
  • Experience in working as a single point of contact for all testing activities and as liaison between the different teams members and the manager.
  • Experience in testing of Data Warehouse/ETL Applications developed in Informatica, Data stage using SQL Server, Oracle, Teradata, and UNIX.
  • Expertise in writing simple and complex SQL queries using TOAD and SQL developer.
  • Comfortable in working with fixed length, delimited flat files and also worked with large volume of data in the database/data warehouse.
  • Experience in testing/validating the Source, Stage and Target (End - to-End) data systems.
  • Experience in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified.
  • Familiar in working with Quality Center/ ALM to store Business Requirements, Test Cases, Test Runs, and Test Results for every iteration and store defects and link them back to the requirements.
  • Experience in End-to-End testing of an application/process. Performed backend testing using SQL Queries and UNIX scripting.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g, DB2, Teradata 13/14, SQL Server Management Studio 08/12

Testing tools: Quality Center 10, Jira 6.4, Rational Clear Quest 7.1, Clarizen 6.0

ETL Tools: Informatica Power Center 9.1, Ab Initio 3.0, Data Stage 8.5

Operating System: Windows, UNIX (Solaris)

Reporting Tools: Business Objects 4.0, Cognos 8.2

Database Tools: TOAD, SQL Developer

Languages: SQL, T-SQL

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

ETL Test er

Responsibilities:

  • Involved in project kick-off, Strategic plan execution, and weekly and monthly client status meetings.
  • Extensively involved in writing and reviewing the test scripts and test scenarios.
  • Developed detailed Test Cases based on the Functional Requirements and Design Documents.
  • Identified the test data, created test data and execute the test cases.
  • Performed Functional, Positive/Negative, System Integration, Round Robin and Database testing.
  • Tested the entire ELT logic to enable initial load and incremental processing from different data source like SQL Server and Oracle to CDW (Teradata) landing table.
  • Compared and Tested Source data.
  • Used JIRA as a Defect tracking tool.
  • Used Clarizen as online Project management tool and Alfresco as a document Library.
  • Developed UAT test scripts and UAT test matrix.
  • Raised the bugs in JIRA and allocated them to the assigned developer.
  • Involved in Data Migration testing.
  • Used Enterprise Service Bus ( ESB ) for designing and implementing communication between mutually interacting software applications and Database.
  • Wrote complicated SQL queries for data validation and data verification based on data mapping document.
  • Wrote and executed SQL queries in SQL server Management studio 2012, Oracle 11g and Teradata SQL Assistant 14.10 to validate the source and target.
  • Clearly communicated and documented test results and defect resolution during all phases of testing.
  • Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.
  • Involved in verify and validate the data loaded from source to landing table.
  • Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
  • Involved in Defect Triage meetings with Development team.
  • Preparing and supporting the QA test environments.
  • Attend production Kick-off meetings.
  • Performed testing after go live as well post production support.

Environment: Teradata 14, Oracle 11g, SQL Server Management Studio 2012, DB2 11, SQL Developer, XML, SQL, Toad, SharePoint, Windows Office, JIRA, Clarizen, Alfresco.

Confidential, Foster City, CA

Sr. ETL/QA Test Analyst

Responsibilities:

  • Involved in meetings like project planning, weekly & monthly client status meetings.
  • Experienced in writing and reviewing the test scripts and test scenarios.
  • Developed detail Test Cases based on the Functional Requirements and Design Documents.
  • Created and identified the test data to execute the test cases.
  • Performed Functionality, Negative, Security, Integration, System and Database testing.
  • Tested the entire ETL logic using Informatica to enable initial load and incremental processing from SQL Server and Oracle, error strategy and exception handling, restart ability and recovery, data cleanup, validation and monitoring.
  • Compared and Tested Source data.
  • Used JIRA for project management and bug reporting tool.
  • Raised the bugs in JIRA and allocated them to the assigned developer.
  • Extensively used Informatica Workflow Manager to run the workflows.
  • Monitored the session logs/log files in Informatica Workflow Monitor.
  • Tested the ETL Informatica mappings and other ETL Processes (DW Testing).
  • Wrote complicated SQL queries for data validation and data verification based on data mapping document.
  • Wrote SQL queries in Toad and SQL server Management studio 2008 to validate the source and target systems
  • Extensively executed T-SQL queries in order to view successful transactions of data between sources
  • Tested the reports generated by (SSRS) SQL Server reporting services and checked as they are as per the Organization standards
  • Clearly communicated and documented test results and defect resolution during all phases of testing.
  • Used HP Quality center 10.0 as our defect tracking tool to upload test cases, track execution and defects.
  • Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.
  • Developed the Test Scripts and Test Cases in Quality Center.
  • Error handling and performance tuning in Teradata queries and utilities.
  • Data reconciliation in various source systems and in Teradata.
  • Extensively used SQL to verify and validate the data loaded into Target
  • Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
  • Preparing and supporting the QA test environments

Environment: Informatica Power Center 9.1, Oracle 11g, Quality Center 11, SQL Server 2008, SQL Developer, Teradata 13, OBIEE, XML, PL/SQL, SQL, Putty, TFS, UNIX, Toad, SharePoint, Windows, MS Office, JIRA.

Confidential, RI

ETL/QA Test Analyst

Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Extensively involved in Application testing like Smoke, Black box, negative and positive, Integration testing.
  • Tested Ab Initio graphs for various ETL data mapping requirements.
  • Worked in clinical Decision Support System.
  • Written SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Extensively involved in testing the ETL process of data sources, SAP, PeopleSoft, Teradata, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.
  • Experienced using database query and integration tools such as SSIS, TOAD, SQL plus etc.
  • Involved in testing SSIS Packages, and in Data Migration.
  • Tested SSIS packages according to business requirements and data mapping requirement documents.
  • Obtained detailed understanding of data sources, Flat files & Complex Data Schemas in order to write the best test scripts.
  • Extensively ran the Ab Initio graphs, monitored the log files and involved in find the root cause of the failures.
  • Responsible in testing Initial and daily loads of ETL jobs.
  • Interacted with design team to decide on the various dimensions and facts to test the application.
  • Tested & developed the mapping for extracting, cleansing, transforming, integrating & loading data using Autosys.
  • Updates the status of old defects and log any new defects in Rational Clear Quest.
  • Experienced in data analysis using SQL, TSQL, PL/SQL and many other queries based applications.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Reported bugs and tracked defects using Clear Quest.
  • Extensively used SQL to verify and validate the data loaded into Target.
  • Validated the front end reporting components created using OBIEE Reports as well as performed back end testing, making sure that the correct data for a specific report are being pulled out from the Data Warehouse.
  • Performed the tests in both the SIT, QA and contingency/backup environments
  • Used SQL for Querying the database for data validation, data verification and data conditioning.
  • Writing the test scripts, test cases & test plan for multiple ETL Feeds.
  • Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
  • Involving in Functional testing, Backend Testing, End to End testing and Regression Testing
  • Involved in Preparing and supporting the QA test environments
  • Load new or modified data into back-end database.
  • Defect Triage with Development team.
  • Involved in peer review of test cases.

Environment: Ab initio 2.14, SQL Server 2008, Oracle 11g,OBIEE, Teradata V2R6/V2R5, XML, XSLT, XSLD, Flat Files, MS Excel, SQL, TSQL, PL/SQL, SSIS, SSRS, SSAS, Toad, Clear Quest, Windows, UNIX, Clear Case, Quality Center 10, Remedy, Rational Clear Quest, Business Object XI R2

Confidential, Charlotte, NC

ETL Tester / Reports Tester

Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC).
  • Validating the data passed to downstream systems.
  • Used data stage director to run the jobs and check the log files.
  • Involved in validating SSIS and SSRS packages according to data mapping specifications.
  • Involved in validating SSAS cubes according to functional specifications.
  • Validated SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
  • Performed data driven testing using QTP and created automated test script in business process environment.
  • Involved in Testing SSIS Packages, and also involved in Data Migration.
  • Reported periodic project status and updates to the QA Lead and QA Manager
  • Performed Integration Testing of different modules.
  • Exclusively used Analysis Studio and Report Studio to test the Cognos Reports.
  • Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down
  • Validated Query Prompts, Cascading Prompts, Calculations, Conditions & Filters
  • Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection
  • Developed and successfully executed test scripts using Win runner.
  • Analyzed Business Requirements and Developed the Test Scripts and Test Cases
  • Used Quality Center for Bug Reports and Defect Tracking.
  • Performed Risk Analysis based on Defect Severity and Priority.
  • Tested User Interface inconsistency and application functionality.
  • Worked on issues with migration from development to testing.
  • Tested application in various browsers.

Environment: Data Stage, DB2, Oracle 10g, XML, Cognos 8, Flat Files, MS Excel, SQL, TSQL, PL/SQL, SQL Server 2008/2005, SSIS, SSRS, Toad, Clear Quest, .Net, C#, Windows, UNIX, Win runner 7.6, QTP 6.5, Load runner 7.6

Hire Now