We provide IT Staff Augmentation Services!

Etl Qa Tester Resume

3.00/5 (Submit Your Rating)

Milpitas, CA

SUMMARY

  • Over 7+ years of total IT experience in implementing end - to-end of various functionalities of Data Warehouse, Data Marts, Business Intelligence and Transactional applications.
  • Expert in Systems Analysis, Data Analysis, Segmentation, Data Profiling, Report Generation and Production Support to relational database application reporting
  • Expert in developing test plans, test cases (manual/Automated), test procedures, test Strategies, test scripts, test data and test chronologies
  • Extensive working experience in Black Box, Functionality, GUI, Regression, Integration, System, Smoke testing, User Acceptance Testing (UAT), ETL, Database, End to End, Performance testing
  • Experience in Water fall, V-Model, Agile, SDLC models
  • Strong knowledge on Quality standards, process, procedures and audit process
  • Expert in Manual and Automated testing, white box and black box testing.
  • Strong DB experience in SQL, Data migration, Transformation, Analysis using SQL developer, Toad, Mainframe Spufi, Platinum and Hyperion etc
  • Specialized in Quality Assurance and testing, worked as ETL Tester, BI Tester, Data Analyst and QA Analyst.
  • Expertise in developing Slowly Changing Dimensions mappings using Type1, Type2 and Type3.
  • Familiar with implementation of SSIS (SQL Server Integration Services), Database Mirroring and Service Broker concepts which are some of the new features in SQL server 2005.
  • Advanced experience in technical architecture of ETL tools, data staging techniques, source data integration and source-to-target mapping
  • Experience in Teradata V2R4/V2R5/V2R5.1 with Creating indexes, tables, views, macros and stored procedures.
  • Worked with Data Conversion projects for testing data quality after migration
  • Experienced in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes.
  • Hands on experience on testing ETL, BI, MDM, and Reference Data.
  • Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Flat Files.
  • Extensive experience in Data Analysis, Data Cleansing, Requirements gathering, Business Analysis, Data Mapping, Entity Relationship diagrams (ERD), Architectural design docs, Functional and Technical design docs, and Process Flow diagrams
  • Experience in testing and writing SQL and PL/SQL statements.
  • Strong experience in Excel and MS Access
  • Highly experienced with different RDBMS such as Oracle 9i and 10g, MS SQL Server 2000, Teradata and MySql.
  • Expertise in Erwin, TOAD and WinSQL tools.
  • Specialized in Requirements Gathering coupled with Business Analysis resulting Conceptual, Logical and Physical database solutions for Relational (OLTP) and/or Dimensional (OLAP - Star Schema) Systems.
  • Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
  • Always willing to learn new skills and technologies required, very flexible
  • Strong interpersonal skills, ability to interact with individuals at all levels, excellent communication and presentation skills.

TECHNICAL SKILLS

Operating System: Windows NT/98/2000, Windows XP, UNIX and MS DOS

Languages: PERL, HTML, XML, XSLT, VB Script, Java2.0, SQL T-SQL and PL/SQL

Database: Oracle9i, Oracle10g, 11g, SQL Server 2005, 2008, DB2, Teradata and MS-Access

Testing Tools: Quick Test Pro and Quality Center, Clear quest.

Utilities: TOAD, Citrix server, Oracle SQL Developer, Putty, VPN, Net meeting and CuteFtp

ETL: Datastage 8.0, Informatica 8.1, Ab Initio (GDE 1.14, Co>Op 2.14), SSIS

Reporting Tools: Business Objects Xi R2, Crystal Reports, Cognos 8.0 Series, SSRS

PROFESSIONAL EXPERIENCE

Confidential, Milpitas, CA

ETL QA Tester

Responsibilities:

  • Reviewing the business requirements and working with business and requirements teams to understand the requirements.
  • Analyzing the business requirement document and reviewed the mapping and analysis documents for data migration.
  • Analyzed the source systems, source files and validated the transformation rules to load the data from source files in to reporting environment.
  • Participated in PDM, LDM review meetings for creating the data model.
  • Reviewed the PDM, LDM created for the requirements.
  • Worked with source systems technical teams to prepare and send the input data with required data fields.
  • Created the SQL, PLSQL scripts, stored procedures and triggers needed for reporting.
  • Worked on performance tuning of the mappings and scripts for optimization.
  • Created and Debugged the Informatica mappings needed for loading data from source to staging.
  • Worked with the reporting teams to create the business views needed for reporting.
  • Created the Ad-hoc reports as needed as per the cisco fiscal year.
  • Worked with deployment teams to deploy code for data transfer between source and target applications.
  • Worked with the business and deployment teams to identify the frequency of source files and to schedule the informatica workflows.
  • Worked extensively on Dollar universe tool to schedule the jobs.
  • Analyze the defects, source data and identify the cause of defect, and to close the defects.
  • Participated in Defect, weekly status meetings to review the status of testing and issues.

Environment: Informatica 9.1, Teradata TD13, Oracle 10g, SQL, PL/SQL, UNIX Shell Scripting, OBIEE, TOAD, MS Excel, HP Quality Centre, CVS, XML, MS Project, Dollar universe.

Confidential, CA

ETL QA Tester

Responsibilities:

  • Worked with Wachovia and Wellsfargo business teams to understand the requirement to migrate the customers from Wachovia to Wellsfargo.
  • Worked as Subject matter expert and point of contact between Wachovia and Wellsfargo business for migration.
  • Reviewing the business requirements and working with business and requirements teams to understand the requirements.
  • Analyzing the business requirement documents and functional specification documents and create the mapping and migration analysis documents for data migration.
  • Analyzed source and target systems and their data bases and created transformation rules to migrate the data from source to target application.
  • Lead of Statement and Notices application for multiple migration releases in a phased manner.
  • Lead offshore and onsite resources for technical direction and test design
  • Successfully designed, developed, and executed Functional and end-to-end tests and ensured high test coverage
  • Collaborated with Development, Business, Test and Architects for requirements, bug resolution and Quality analysis
  • Implemented QA guidelines which included Requirements Reviews, Design Reviews, mitigating redundant testing, documentation, Reporting and tracking test metrics
  • Involved in Data Mining and Manipulation to create test data.
  • Data Migration testing including Data Integrity, ETL Transformation logic, Target column profiling, Rejection Validation etc
  • Participated in the environment shakeout testing and provided necessary QA support for all the check point validations in the Game plan
  • Extensively worked on different source systems like Sql Server, Oracle, flat files and Main frame systems to understand the input data.
  • Worked with source systems technical teams to prepare and send the input data with required data fields to conversion team.
  • Extensively worked on using and analyzing source different source systems input files like vsam, text, .csv, excel and XML files.
  • Analyzed the target systems to understand their requirement to receive the target data and gathered the information to generate output files, oracle data dump.
  • Worked with deployment and infrastructure teams to set platform (NDM, DB link etc) for data transfer between source, conversion team and target, conversion team to receive and send data.
  • Hands on execution, creation, optimization (using explain plans) of SQL for db testing
  • Introduced new techniques for testing db by introducing Table level scripts and optimizing queries.
  • Debugged and reviewed the code for performance analysis.
  • Used Mercury Interactive tools for documenting Manual and Automation of test Scripts
  • Ensured high quality of product is delivered while meeting aggressive project timelines and budgets.
  • Ensured effective test coverage of new features, strategic test planning for early identification of bugs, coordinated follow up with ETL dev teams for faster resolution.
  • Identified dependencies that over lapped with other applications and worked closely with project management teams and ensure quality products are delivered.
  • Involved in UAT testing and Supported Business in Production verification and validation
  • Worked on Multiple platforms at same Schedules and Proven record of delivering challenging projects as a lead and team member.
  • Participated in defect review, status meetings to help the business teams to understand the defects/issues.
  • Worked with different business and implementation teams to schedule the game plan tasks for the live conversion weekend and supported the live conversion events.
  • Created the migration summary reports after the conversion event.

Environment: Sql Server 2005, Oracle 10g, SQL, PL/SQL, UNIX Shell Scripting, TOAD, MS Excel, HP Quality Centre, CVS, XML, MS Project, Main Frame, COBOL II, VSAM, Copy Books, Informatica 8.1.

Confidential, Basking Ridge, NJ

Sr. ETL QA analyst

Responsibilities:

  • Extensively involved in Business Analysis and Requirements Gathering
  • Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
  • Analyzed data sources, prepared data conversion approach to load the data.
  • Developed Test Plan and overall Test Strategy for the program.
  • Developed Test Cases and Test Scripts for System and UAT testing.
  • Developed Test cases for Reports and System Integration testing.
  • Created Test cases for end to end scenarios.
  • Tested all applications End-End Manually.
  • Involved in testing various Bridges interfaces manually.
  • Involved in Requirements gathering from the End users.
  • Participated in Business Analysis, Requirement Analysis and Data Analysis.
  • Maintains all requirements systematic manner when I get requirements form users.
  • Extensively used track record as Bug Tracking tool to report the defects and Conducted Bug-Review meetings.
  • Performed Block box testing, Regression testing, Functional testing, Smoke testing and UAT testing.
  • Created VBA Macros to convert the Excel Input files in to correct format and loaded them to SQL Server.
  • Very Strong in writing complex Sql Stored Procedures and Functions in SQL
  • Strong in writing sql queries and makes table queries to profile and analyze the data in MS Access/Excel.
  • Developed and publish periodic reports from data stored in an SQL database
  • Created macros to automate the process of refreshing the data in MS Excel.
  • Write SQL queries to validate that actual test results match with expected results
  • Extensively worked on Backend using SQL Queries to validate the data in the database.
  • Analyzed the Stored procedures and Sql Queries to improve the performance of queries and speed up the process.
  • Wrote Stored Procedures for executing the SSIS packages remotely.
  • Created/Tested the mapping rules according to the requirements in the ETL Packages.
  • Implemented SDLC, QA methodologies and concepts in the Project
  • Tested the ETL packages comparing the input source files and Target Table data in SQL Server.
  • Validated the ETL transformed data for data completeness, Data correctness and for according to mapping rules.
  • Executed Complex SQL queries within UNIX shell scripts in the UNIX environment.
  • Wrote UNIX scripts for automating the process.
  • Developed Test Summary Reports and participated in GO / NO-GO meetings.
  • Completed knowledge transfer to employees enabling them to understand the complete data conversion process.

Environment: SSIS, SQL SERVER 2005, SQL, PL/SQL, UNIX Shell Scripting, TOAD, Clear Quest, MS Excel

Confidential, CA

QA Analyst

Responsibilities:

  • Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
  • Wrote MACROS in Teradata to generate less channel traffic and easy execution of frequently used SQL operations and improves the performance
  • Identify issues, information and behaviors during the adoption of a proprietary information management system.
  • Designed and supported SQL 2008 Reporting services, Integration services and Analysis services.
  • Created various reports with different functionalities like drilldown, Charts, Crosstabs using Crystal Reports
  • Involved in testing data mapping and data conversion in a server based data warehouse
  • Expertise in data quality, data organization, metadata and data profiling
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
  • Conceptualized, designed and implemented an enterprise data integration platform based on scalable search,
  • Created Batch processes using Fast Load, BTEQ, Unix Shell and Teradata SQL to transfer, cleanup and summarize data.
  • Created Jobs to Schedule multiple reports in Cognos Connection
  • Worked with Development team to create necessary operational documents and transition daily support activities with Tier1 team
  • Created ETL documents detailing the ETL (database navigation and data transformation) logic used by developers as coding specifications.
  • Scrubbed data to accurately generate customer pull. Provide output files in various file format based on customer request.
  • Accelerate the rate of adoption of the system, improve the quality of the data being input and generated, and promote accountability amongst the staff and users.
  • Made recommendations on potential functional and technical improvements to planned or existing system components and applications.
  • Supported Customer Data Integration projects through Business Intelligence and Data Warehouse system integration
  • Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
  • Translated written Business Requirements Documents into Conceptual Data Model
  • Created Conceptual and Logical Data Models using Erwin targeted for Oracle
  • Created thorough documentation of the Data Models
  • Loaded the data into the Teradata database using Load utilities like (Fast Export, Fast Load, and MultiLoad).
  • Duties include database creation, administration, data mining, data conversion and report creation from multiple databases using Crystal Reports, Excel and Access
  • Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
  • Verify data movement occurs correctly between each step (data storage) in the ODS. Data Mapping performs as defined in Mapping Specs / Use Case
  • Prepare and present solutions for Enterprise Data Integration (ETL) Platform
  • Worked with data flux for data integration.
  • Good experience in analyzing data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
  • Worked with fixing the production issues for multiple projects and supported night ETL jobs/mappings/batches/procedures.

Environment: Sybase 12.3, Windows XP,Oracle10G,TOAD, UNIX, XML, XSD, XML Spy 2008, Mercury Quality Center, PVCS (Dimensions), Oracle, SQL Server 2008, SQL Server Integration Services (SSIS),, MS Project, Main Frame, MVS, JCL, COBOL II, VSAM, Copy Books, ISPF, OS/390, Control-M, SQL, PL/SQL, XSLT, XQuery, UNIX Shell Scripting, Business Objects XIR2, Crystal Reports, Autosys, MQ Series, Java, JMS

Confidential, Pleasanton, CA

ETL/ QA Analyst

Responsibilities:

  • Reviewing the business requirements and working with business and requirements team for gaps found during the review
  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
  • Involved in Data mapping specifications to create and execute detailed system test plans.
  • The data mapping specifies what data will be extracted from SSIMS source, transformed and sent to an external entity.
  • Responsible for Initial data migration testing (Initial Load) from different sources to MDM Database.
  • Responsible for Periodical data synchronization (Delta Load) between the source systems and the MDM DB for ensuring proper data synchronization.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning
  • Worked with Mainframe CIC screen environment in creating test data for all the MDM services.
  • Performed Independent MDM Service testing by preparing xml transactions.
  • Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
  • Extraction of test data from tables and loading of data into SQL tables.
  • Worked with various data sources with Multiple Relational Databases like DB2 UDB and Oracle to perform data validation.
  • Extensively used Oracle Pl\Sql developer to query oracle database.
  • Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Tested XML’s part of MDM SOA architecture.
  • Compared and Tested Source data with XML Output flow.
  • Worked on Teradata, DB2 databases using queryman and qmf.
  • Reviewed Datastage Mappings and test cases before delivering to Client
  • Created ETL test data for all ETL graphs based on transformation rules to test the functionality of the application.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Reported bugs and tracked defects using Quality Center 8.0 (Test Director)
  • Written test scripts to compare OLTP vs OLAP for ETL testing.
  • Worked as a POS tester for Java upgrade QVS uplift and IBM OS installation.

Environment: SQL, PL/SQL, IBM Datastage,DB2 UDB v8,QMF, Oracle,IBM Web Sphere MQ, PL/SQL Developer, Teradata Sql assistant 7.2,IBM DB2 v9,Attachmate Extra, Putty, HP Quality Center 9.0,CDBS 6.0,QMF 8.1,firstobject XML 2.4,XML,IB M AIX, UNIX, FileZilla 2.2,WinSCP 4.0, Ultra Edit 15.0,Secure FX, Secure CRT.

We'd love your feedback!