Etl Tester Resume
SUMMARY
- Over9+ years ofexperience inmanual testingonweb based, Client/Server and data warehousing applications.
- Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
- Professional experience inIntegration, Functional, Regression, System Testing, Load Testing, Black BoxandGUItesting.
- Experience with Creating test plan, test cases and executed test cases and reported defects using in HP QC/ALM.
- Experience inSQLandPL/SQL scripting
- Created ETL test data for all ETL mapping rules to test the functionality of theAbinitiographs.
- Sound Knowledge and experience inMetadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
- Tested the ETLAbinitioGraphs and Informatica mappings other ETL Processes (Data Warehouse Testing)
- Experience in creatingTest Readiness Review(TRR), Requirement Traceability Matrix(RTM) documents.
- Experience in preparingTest Strategy, developingTest Plan, Detailed Test Cases, writingTest Scriptsby decomposing Business Requirements, and developingTest Scenariosto support quality deliverables.
- Experience in usingTest DirectorandHP Quality Centerfor by Browse to Save">Bug Tracking and Defect Reporting.
- Experience in working with Software Development team in resolvingDefects,presenting theDefect Status reports, resolving requirement, and observed design inconsistencies.
- Expertise in querying and testingRDBMSsuch asOracle,MS SQL ServerusingSQL,PL/SQLfor data integrity.
- Strong working experience inWindows NT/2000/XPandUNIXenvironments
- Clear understanding of business procedures and ability to work as an individual and as a part of a team.
TECHNICAL SKILLS
Operating Systems: Windows 95/98/00/XP, NT, MVS, IBMMAINFRAMES MS-DOS, UNIX (Solaris 2.8), Linux, Lotus Notes
Software Languages: JAVA,J2EE, C, C++, XML, HTML, SOA, MQ Series, VB Script, .NET technologies (C#, ASP.NET, VB.NET)
Databases: Oracle 8.x/9.x/10.x, SQL SERVER 6.0/7.0/2000 , My SQL..Teradata
GUI: MS FrontPage, Visio, SharePoint Designer, Visual Studio
Bug Tracking Tools: Quality Centre, Test Director
Packages: MS Word, MS Excel, MS Power Point, MS Visio 2003.
Web Server: Apache Server, IIS 7.0 and Tomcat, Web Sphere Customer Centre, Web Server IIS
Reporting Tools: Business Objects 5.1/ 6.1/XI R2, Crystal Reports, Cognos.
ETL Tools: Informatica, Data Stage, AbInitio
Data Modeling Tools: Erwin 3.5.1/4.x
DB Tools: TOAD, SQL*PLUS, SQL*Loader, SQL Navigator, AQT
Protocol: HTTP and FTP, SOA
Other Tools: LotusNotes, SQL *Loader, TOAD, CVS, PVCS, Clear Case, Web methods, EAI, FTP,DVO,WebMethods
PROFESSIONAL EXPERIENCE
Confidential
ETL Tester
Responsibilities:
- Responsible for creating completetest cases,test plans,test data, andreporting status ensuring accurate coverage of requirements and business processes.
- Analyzing requirements and creating and executing test cases
- Performingmanualtesting 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 theSQLto identify the ETL processes
- Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
- Extensively worked onProject Variables, Project Parametersto extract only the additional data added during that period.
- Involved in writingShell Scriptsto load and extract information from files and Wrotecomplex queriesto compare the counts and data from source to target.
- Performingdatabasetesting to verify backend database transactions.
- Coordinating user acceptance testing activities for business groups and IT.
- Participates in application release planning and status sessions.
- Involving in formulating the test plan, procedures and Wrote test cases.
- Involved with the automation team for automating the web application using selenium
- Developed automation test plans, high-level test cases based on business requirement specifications and design documents.
Environment: Oracle10g, SQL, PL/SQL, DB2, SQL*Plus, UNIX, shell scripting, Ab initio
Confidential
ETL Tester
Responsibilities:
- Responsible for creating completetest cases,test plans,test data, andreporting status ensuring accurate coverage of requirements and business processes.
- Created, maintained and executed test scripts from Quality Center.
- Maintained requirements and created traceability between requirements and test cases.
- Performingmanualtesting by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
- Defects were tracked and prioritized using the HP Quality Center (QC) and analyzed variation between Expected and Actual results.
- Analyzed application data using theSQLto identify the ETL processes
- Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
- Worked with data analysts to implementAbinitio graphsandshell scriptsand stored proceduresto meet business requirements.
- Performing backend testing of the DB by writingPL/SQL queriesto test the integrity of the application and Oracle databases.
- Wrote and modifiedSQL validation scripts, and writing scripts in SQL to validate the outputs.
- Extensively worked onProject Variables, Project Parameters to extract only the additional data added during that period.
- Wrotecomplex queriesto compare the counts and data from source to target.
- Performingdatabasetesting to verify backend database transactions. 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: HP Quality Center, Abinitio,Teradata R6, Oracle10g, QTP, SQL, PL/SQL, DB2, SQL*Plus, UNIX, shell scripting
Confidential, Chandler, AZ
Sr. QA Analyst
Responsibilities:
- Acted as Test Lead devising test strategies to be used and providing status reports and ensuring quality output is delivered within product timeline.
- Prepared test cases, test plan which defines the testing strategies used for the projects worked on and documented test results for review and tracking purpose.
- Performed mapping of files in different formats (ANSI, EDI, XML and text) as per business rules in custom and standard format detailed Specifications Document.
- Developed shell scripts for reviewing output, logs, etc. on the UNIX platform, for mocking up files, processing incoming files through PM application.
- Performed regression testing by monitoring regression results from daily regression runs for the different customer files.
- Performed E2E testing from the time sample file is received until WF signs off and the end to end test files are generated from the different systems of record using the chosen communication method and customer signs off and code moves to production. Afterwards, customer care takes care of ongoing support of application.
- Led performance/stress testing to mimic situations/volume in production such as large file handling, duplicate testing.
- Ensured test data that reflect production environment as closely as possible is created and available for testing.
- Coordinated with external systems and cross functional teams through meetings and discussions to ensure requirements are met and proper output is fed into the PM application.
- Used Quality Centre for tracking version control of tests and requirements, defining requirements, defining releases and cycles, test planning, test execution and defect tracking.
Environment: UNIX Shell scripting, Web Methods 7.1, HP Quality Centre 9.2, HP Quality Centre 10.0
Confidential, AZ
ETL Tester
Responsibilities:
- Responsible for creating completetest cases,test plans,test data, andreporting status ensuring accurate coverage of requirements and business processes.
- Analyzing requirements and creating and executing test cases
- Involved in ETL process testing usingInformaticaETL tool.
- Test Case Execution andAdhoctesting
- Performed Integration, End-to-End, system testing
- Involving inFunctional Testing & Regression Testing
- Developing AutomatedTest Scriptsto perform Functional Testing, Performance Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing, Regression Testingand Volume testing of the application using Load Runner
- Involving in writingSQL queriesandDatabase Checkpointsto verify data quality and calculations, reviews
- Performed data validation testing writingSQL queries.
- Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
- Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
- Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems usingInformatica
- Working onQuality Centerfor creating and documentingTest Plans and Test Casesand register the expected results
- Experience assessing testing processes, creating and implementing testing strategies inUATphase.
- UsingHP Quality Centerfor storing, maintaining the test repository, bug tracking and reporting
- Preparing documentation for some of the recurring defects and resolutions and business comments for those defects
- Developed UNIX scripts to validate the flat files and to automate the manual test cases.
- DevelopingTest Matrixto give a better view of testing effort
Environment: - Informatica, Teradata R12, SQL, DB2, Oracle, HP Quality Center, Rational Clear Case, Rational Clear Quest, Remedy, Microsoft Office, Internet Explorer7.0, WindowsNT4.0/2000, HP/Unix.
Confidential, AZ
ETL Developer
Responsibilities:
- Developed the different interfaces for different SORS using ODI
- Design the ODI interfaces and generate the scenarios
- Migrate the scenarios in to UAT and Prod environment
- Involved in modeling This project is designed and developed for Project Intelligence Center (PIC)datawarehouse.PIC .This include dimension modeling
- Developed packages and procedures
- Used different knowledge modules for different load process
- Used different ODI procedures to improve the performance
- Scheduled the ODI jobs Using CRON.
- Used the different ORACLE utilities like SQL Loader and External Tables to load the data
- Involved in implementing the installation plan
- Created objects and classes in Business Objects
Environment: ODI 10.3, UNIX, PL/SQL, Oracle 8i/9i/10g, Business Objects, NT/2000/XP
Confidential, AZ
ETL Developer
Responsibilities:
- Experience with business users to prepare Functional Specification and Technical design documents for ETL process.
- Involved in the creation of Ab Initio Graphs from Functional Specification by extract, transform and load the data from multiple databases like DB2, Oracle.
- Involved in loading test data in to DB2 tables for testing
- Created AbInitio multi file systems on different nodes, which can process multiple partitions of data at the same time using AbInitio's Partition and Departition Components.
- Extensively used Ab Initio Components like Join, Rollup, Reformat etc as well as Partition and Departition extensively and functions like is valid, is defined, string substring, srting concat and other string functions etc.
- Worked with initial phases of the software development life cycle by analyzing the business requirements
- Analyzed and reviewed the Detailed Design schema with the Designers so as to have proper understanding of the requirements
- Configured Ab Initio environment to connect to database using db config, Input Table, Output Table, and Update table Components.
- Created numerous Ab Initio graphs, utilizing Rollups and parallel processing to speed up loads.
- Used checkpoints and phases to improve reliability of the application.
- Deployed and performed test runs the graph as executable Korn shell scripts in the application system.
- Created and performed reviews of all ETL designs, graphs, and test plans.
- Used PL/SQL programming in functions, procedures, and packages to implement business rules.
- Analyzed and reviewed the data from the output database.
- Worked with Onsite and Offshore teams.
Environment: Ab Initio (GDE 1.14, Co>Op 2.14), UNIX, EME, Business Objects, OS/390, Windows NT, DB2.
Confidential, VA
ETL Tester
Responsibilities:
- Responsible for creating completetest cases,test plans,test data, andreporting status ensuring accurate coverage of requirements and business processes.
- Analyzing requirements and creating and executing test cases
- Performingmanualtesting 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 theSQLto identify the ETL processes
- Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
- Worked with data analysts to implementAbinitio graphsandshell scriptsand stored proceduresto meet business requirements.
- Performing backend testing of the DB by writingPL/SQL queriesto test the integrity of the application and Oracle databases.
- Wrote and modifiedSQL validation scripts, and writing scripts in SQL to validate the outputs.
- Extensively worked onProject Variables, Project Parameters to extract only the additional data added during that period.
- Wrotecomplex queriesto compare the counts and data from source to target.
- Performingdatabasetesting to verify backend database transactions.
- Wrote complex queries inTeradata SQL assistantto analyze the data
- Coordinating user acceptance testing activities for business groups and IT.
- Created, maintained and updatedregression suitesupon receiving new build.
- Modifying and executingtest scriptsfor web based environment-usingQuality Center.
- Creatingtraceabilityrelationship 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: HP Quality Center, Abinitio, Oracle10g, QTP, SQL, PL/SQL, DB2, SQL*Plus, UNIX, shell scripting
Confidential
ETL tester
Responsibilities:
- WroteTest Plans,which detailed the testing scope,testing requirements, success criteria, milestones, and necessary resources.
- Manually performedAd-Hoctesting, end-to-end testing, and system testing.
- Performed manual testing by entering positive values, negative values, and boundary values to the application.
- PerformedBlack box,Integration, Regression, Systems,andBackendtesting
- Created, maintained and updatedregression suitesupon receiving new build.
- Performeddata validation testing writing SQL queries. TestedETL batch processes using UNIX shell scripting.
- Involved inwriting SQL statementsto create test data for test cases and datavalidation tests to extract data from the tables.
- UsedTeradata utilities to load the sample test datain to target tables.
- Used to play with thequeries in the Teradata Sqlassistant
- ComparedSQL resultswith application results by writingSQL queries.
- UsedSQL queriesto test themigrated database for Back End Testing.
- Wrote and modified requiredUNIX scriptsand otherSQL validationscripts, andwriting scriptsin SQL to validate the outputs.
- Backend testing of the DB by writingPL/SQL queriesto test the integrity of the application and Oracle databases usingTOAD.
- Involved in writingShell Scriptsto load and extract information from files and tested the back-end fordata integrity in UNIX.
- Involved in exporting the test cases form Microsoft Excel toTest Directorand running the cases remotely in different hosts.
- For tracking theDefectsused the toolTest Director. Performed Black Box, Integration, and Regression Testing. Investigated and reported bugs to the developers.
Environment: SQL, PL/SQL, Ab Initio, WinSQL, Quick Test Pro 8.0, Test Director, Unix (Solaris), Unix Shell Scripting, Windows NT/2000