We provide IT Staff Augmentation Services!

Etl/qa Tester Resume

Atlanta, GA

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, Data Stage and SSIS on multiple platforms.
  • Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
  • Extensive experience in writing SQL and PL/SQL scripts to validate the databases systems and for backend database testing.
  • Having good knowledge on Oracle Data Integrator. Worked on Data files & label parameter of data file, strong in writing UNIX Korn shell scripting.
  • Experience in DBMS Utilities such as SQL, PL/SQL, TOAD, SQL Server, SQL*Loader, Teradata SQL Assistant.
  • Extensive working knowledge in UNIX/Linux operating systems.
  • 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.
  • Worked with XML feeds from multiple sources systems and loaded the same into EDWH.
  • Having good knowledge on Oracle Data Integrator. Worked on Data files & label parameter of data file, strong in writing UNIX Korn shell scripting.
  • 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 Micro Strategy, Cognos and Business Objects.
  • Involved in front - end and back-end testing. Strong knowledge of RDBMS concepts Solid experience in Black box & White box Testing techniques.
  • Experience in UNIX shell scripting and configuring cron-jobs, Autosys for scheduling.
  • Excellent understanding of the System Development Life Cycle. Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
  • 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.
  • 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.

TECHNICAL SKILLS

ETL Tools: SSIS, Data Stage, 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 Clear Quest

Version Control Tools: Clear Case, Ab Initio EME, CVS, PVCS 7.0

Tools: XML Spy 2010, TOAD, Putty, WinSCP3, Scorex,AppEdit v8.2, Ultra Editor, Control - M, TWS, FileZilla

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

ETL/QA Tester

Responsibilities:

  • Created Test Plan for System Testing.
  • Responsible for performing various types of process evaluations during each phase of the Software Development Life Cycle, including Review, Walk Through and hands on system testing.
  • Wrote complex SQL Joins, Unions and Nested Queries on various data tables for Data validation using DB2.
  • Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports.
  • Made recommendations on potential functional and technical improvements to planned or existing system components and applications.
  • Configured and deployed SSRS reports to Share point.
  • Used HP Quality Center for writing the test cases and logging the defects.
  • Used Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping and created various dynamic reports using SSRS.
  • Added new features for compliance with and maintenance of quality standards.
  • Implemented SDLC, QA methodologies and concepts in the Project
  • Involved in testing of Universes from different data sources like Oracle/SQL Server.
  • Worked with Data Extraction, Transformation and Loading (ETL).
  • Worked on HP ALM for defect management.
  • Extracted and reformatted data form different heterogeneous data sources like Oracle, using Ab Initio. Responsible for Data mapping testing by writing complex SQL Queries using TOAD.

Environment: Ab initio, HP ALM, DB2, TOAD, SQL, PL/SQL, SQL Server 2008, Oracle 10g, SSRS SQL Server Reporting Services, XML, XSLT.

Confidential, Charlotte, NC

ETL/QA Tester

Responsibilities:

  • Created SSIS Packages for migration of data between SQL Server and other databases like MS Access, MS Excel and Flat Files.
  • Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.
  • Worked with the DSO 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.
  • Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
  • Defined testing criteria, planned, created and executed test plans in a mainframe environment.
  • Performed End to end testing starting from the source to the report.
  • Participated in business requirements gathering and in modifications of the requirements based on the scope.
  • Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
  • Developed UNIX scripts and AUTOSYS scripts to load extract files in to staging tables using sqlldr.
  • Excel, MS Access and Flat Files.
  • Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse.
  • Prepared test data to cover all the test scenarios.
  • Created User Prompts, Conditions and Filters to improve the quality of report generation.
  • Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
  • Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts & material and cost specialists.
  • Enhancing and deploying the SSIS Packages from development server to production server.

Environment: SQL, PL/SQL, HP ALM, XML, Oracle 10g, Tibco, Mainframes, Control-M, SSIS, Business Objects XIR3, TOAD for Oracle.

Confidential, Alpharetta, GA

ETL/QA Tester

Responsibilities:

  • Responsible for Business analysis and requirements gathering.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Performing transformations of source data with Transform components like Join, Match Sorted, Dedup Sorted, Denormalize, Reformat, Filter-by- Expression.
  • Performed complex defect reports in various environments like UAT, SIT, and QA etc to ensure the proper delivery of the application into the production environment.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
  • Used Ab Initio to extract, transform and load data from multiple input sources like flat files, Oracle 10g database to the Teradata database.
  • Involved in ETL processes using Ab Initio and Informatica Power Center.
  • Involved in Unit testing and UAT testing after coding the Ab Initio objects Involved in prepare the documentation and manuals for User Acceptance testing.
  • Objects.
  • Used SQL for Querying the DB2 database in UNIX environment.
  • Performing transformations of source data with Transform components like Join, Match Sorted, Dedup Sorted, Denormalize, Reformat, Filter-by- Expression.
  • Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica.
  • Worked as a production support to run the jobs from Control-M and execute the daily, weekly, monthly Worked on Actuate reporting tool console to schedule and monitor reports.
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
  • Created and executed low level Control- M cyclic jobs for Ab Initio Objects developed.
  • Created SQL Queries using SQL*Plus for dropping indexes prior to the load graph execution to be able to perform direct loads on the database tables.

Environment: Informatica, Oracle 10g, BEA Web Logic 8.1, UNIX, Shell Scripting, XML Files, XSD, XML Spy 2010,Toad, Tivoli, QTP.

Hire Now