We provide IT Staff Augmentation Services!

Sr. Etl/qa Tester Resume

SUMMARY

  • 7+ Years of Professional Experience in Software Quality Assurance (QA) and Testing in different environments and platforms including Data Warehousing, Business Intelligence, Client/Server and Web based applications.
  • Experience in Data Warehouse applications testing using Informatica, Ab Initio, DataStage and SSIS on multiple platforms.
  • Involved in all phases of the QA Life Cycle and SDLC, with timely delivery against aggressive deadlines, with QA methodologies such as Waterfall, Agile, etc.
  • Extensive experience in writing SQL and PL/SQL scripts to validate the databases systems and for backend database testing.
  • Experienced in working with Pig, Hive, Sqoop and Map Reduce.
  • Experienced in using test management and bug reporting tools including HP Quality Center and JIRA, Pivotal Tracker, Bug herd tool.
  • Extensive working knowledge in UNIX/Linux operating systems.
  • Experience in User Acceptance Testing, Performance Testing, GUI Testing, System & Functional Testing, Integration Testing, Regression Testing, Data Driven, Keyword driven Testing and both Manual as well as using automated testing tools including Win Runner, Load Runner and QTP.
  • Experience in testing Business Intelligence reports generated by various BI Tools like MicroStrategy, Cognos and Business Objects.
  • Experience in using Oracle Databases, DB2 UDB, Sybase, SQL Server, Netezza, and Teradata.
  • Experience in UNIX shell scripting and configuring cron - jobs, Autosys for scheduling.
  • Involved in front-end and back-end testing. Strong knowledge of RDBMS concepts
  • Having good knowledge on Oracle Data Integrator. Worked on Data files & label parameter of data file, strong in writing UNIX Korn shell scripting.
  • Worked with XML feeds from multiple sources systems and loaded the same into EDW.
  • Solid experience in Black box & White box Testing techniques.
  • Excellent understanding of the System Development Life Cycle. Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
  • Performed Manual and Automated Testing on Client-Server and Web-based Applications.
  • Extensive experience in drafting Test Flows, Test Plans, Test Strategies, Test Scenarios, Test Scripts, Test Specifications, Test Summaries, Test Procedures, Test cases & Test Status Reports.
  • Strong knowledge of test methodologies: Object Oriented test methodology, Service Oriented Architecture, Top to bottom and Bottom to top test methodology, QA Validations &QA Compliances to ensure the Quality Assurance Control.

TECHNICAL SKILLS

ETL Tools: Informatica, SSIS, DataStage, Ab Initio (GDE 1.14, Co>Operating System)

Programming: SQL, PL/SQL, UNIX Shell Scripting, PERL, XML, XSLT

Operating Systems: Windows 95/98/NT/2000, UNIX (Sun Solaris2.6/2.8, Linux 2.4, HP-Unix, IBM AIX 5.5)

Databases: Oracle 11g, 9i/10g, IBM DB2 9.x, Sybase 12.5, SQL Server 2008, TeradataV2R6 and Informix.

Testing Tools: HP Quality Center 10, 11, Rational ClearQuest

Version Control Tools: ClearCase, Ab Initio EME, CVS, PVCS 7.0

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL/QA Tester

Responsibilities:

  • Responsible for Gathering test requirements and scoping out the test plan.
  • Written complex SQL queries.
  • Reported bugs and tracked defects using HP/ALM Quality Center
  • Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Involved in data warehouse testing by checking ETL procedures/mappings.
  • Involved in the Agile Scrum Process
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
  • Point person for any/all facilities/safety dept. work being conducted at toad areas.
  • Used Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Functions and Master Detail etc.
  • Extensively testing Web Services using SOAPUI (SOAP/REST).
  • Participated in Integration, System, Smoke and User Acceptance Testing and production testing using QTP/UFT.
  • Workflow Purchasing integrates with Oracle Workflow technology to create standard purchase orders or blanket releases automatically from Approved requisition lines.
  • Managed and executed the test process, using Agile Methodology.
  • Queried Teradata Database and validated the data using Sql Assistant.
  • Validated data moving from different sources to target using Informatica.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources
  • Importing the budget values from CSV to Oracle apps tested the same.
  • Generated automated scripts using QTP and documented them. Created and maintained functional & regression test suites.
  • Reports were formatted according to the user requirements using Business Objects functionalities like Breaks, Calculations, Slice and Dice, Drill Down and Variables.
  • Tested request and response XML's based web services interfaces using Soap UI.
  • Expertise in Bug Tracking system and Process using Quality Center/ALM.
  • Importing and exporting data into HDFS and Hive using Sqoop.
  • Extraction of test data from tables and loading of data into SQL tables.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Tested the data load process using the Informatica Power Center ETL tool.
  • Validated the reports to make sure all the data is populated as per requirements.

Environment: Informatica Power Center, Business objects, SQL, Agile, Teradata, Visio, Teradata SQL Assistant, Web Services, ALM/HP Quality Center 11, QTP/UFT, Oracle, TOAD, T-SQL, XML Files, XSD, XML Spy, Flat Files

Confidential

ETL/QA Tester

Responsibilities:

  • Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
  • Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
  • Worked on Unix, Hadoop, Hive, Impala and shell scripting for big data testing. Leading the team for the same.
  • Extensively used HP ALM to upload requirements and write test cases
  • Working in Agile environment, attended daily stand up meeting, SCRUM meetings.
  • Provided support to offshore QA team by knowledge transfer and helping them with closure of the defects.
  • Part of on-call support for issues relating to the internal application, Autosys and Informatica.
  • Produced ETL detailed designs and documentation for Informatica PowerCenter.
  • Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
  • Involved in loading data from UNIX file system to HDFS, configuring Hive and writing Hive UDFs
  • Used Flume-ng to move data from individual data sources to Hadoop system.
  • Ran UNIX shell scripts to count the records for EDW source to staging tables.
  • Reported defects using HP ALM, verified fixes and closed bugs during regression testing.
  • Tested the XML feeds received from another source which was a third party for data consistency.
  • Tested the ETL with XML as source and tables in the Data Warehouse as target.
  • Tracked defects to closure by coordinating with the dev team.
  • Implemented automated processes and scheduling using Autosys. Created Autosys Scripts for installing Autosys Jobs for peculiar scheduling and alerting scenarios.
  • Defined testing criteria, planned, created and executed test plans in a mainframe environment.
  • Tested source data for data completeness, data correctness and data integrity.
  • Performed End to End testing starting from the source to the report.
  • Written Hive jobs to parse the logs and structure them in tabular format to facilitate effective querying on the log data.
  • Conducted and coordinated integration testing and regression testing.
  • Participated in business requirements gathering and in modifications of the requirements based on scope.
  • Prepared test data to cover all the test scenarios.
  • Validated the Map reduce, Pig, Hive Scripts by pulling the data from the Hadoop and validating it with the data in the files and reports
  • Coordinated with Release Management team in getting jobs executed in Test environment (Autosys)
  • Prepared UNIX scripts to run the Informatica ETL jobs from command line.
  • Maintained all the test cases in HP Quality Center and logged all the defects into the defect’s module.
  • Tested the migration of reports from Business Objects XIR2 to XIR3.

Environment: Agile, SQL, PL/SQL, HP ALM/Quality Center, XML, Java, Oracle 10g, Informatica, Business Objects XIR3, Toad for Oracle

Confidential

ETL QA Tester

Responsibilities:

  • Translated business-reporting requirements into Data Warehouse architectural designs and analyzed source and target data models and made necessary changes.
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from the legacy systems using Informatica and provided technical support and hands-on mentoring in the use of Informatica for testing.
  • Identified the primary key (logical / physical) and put update or insert logic.
  • Deleted the target data before processing based on logical or physical primary key.
  • Designed and executed the test cases on the application based on company standards.
  • Prevented occurrences of multiple runs by flagging processed dates.
  • Wrote Test Cases for ETL to compare Source and Target database systems.
  • Testing of records with logical delete using flags.
  • Interacting with senior peers or subject matter experts to learn more about the data.
  • Identifying duplicate records in the staging area before data gets processed.
  • Extensively wrote test scripts for back-end validations.
  • Ensured that the mappings were correct.
  • Extensively used Toad to verify records that has been populated by ETL process.
  • Responsible for de-duping and consolidating customer records from various sources to create master customer list.
  • Prepared and implemented data verification and testing methods for the Data Warehouse; designed and implemented data staging methods and stress testing of ETL routines to make sure that they don’t break on heavy loads.
  • Involved in performing Functionality testing, Validation testing and System testing, testing manually on the first release of the application.
  • Extensively used QTP as automation tool for automating the scripts for regression testing
  • Used Test Director as a defect-tracking tool to keep track of defects during the testing process.
  • Performed End-to-End testing after bug fixes and modifications.
  • Used Tivoli as a scheduling software to schedule the Informatica jobs.

Environment: Informatica, Big Data/Hadoop, Hive, SQL, XML Files, XSD, DTD, XSLT, PL/SQL, SQL*Plus, UNIX Scripts, Toad, ClearQuest, ClearCase, QTP.

Hire Now