PROFESSIONAL SUMMARY:

• About 7 years of experience in Software Testing, IT support, Test Automation development and testing ETL, Data warehouse, Client/Server and web applications.
• Skilled professional experience in ETL &Manual Testing, developing Test Plans, Test Cases, RTM’s, Test Report documents.
• Complete working knowledge of SDLC and STLC lifecycle models in Agile and Waterfall methodologies.
• Expertise lies in Functional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing, End to End testing, Performance and Black Box Testing.
• Professional experience working in UNIX environments, writing SQL and DB validations. Experience in ETL testing for Data completeness and Data accuracy.
• Good experience in UAT which includes preparing the Test Plan, Coordinating with multiple users in assigning the UAT tasks on day to day basis, collecting and computing the results and reporting them to the customer.
• Strong experienceintesting Banking, Insurance, Recruiting, Health care, benefits and leaves process.
• Extensively used HP Quality Center and Mercury Test Director for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Experience in ETL methodology for supporting Data Extraction, Transformations and Loading Process in a corporate - wide-ETL solution using Power Center(9.x,8.x,7.X/6.X (Manager, Designer, Director, Administrator), OLTP, OLAP
• Extensive experience in reviewing and understanding of Business & Testing requirements and writing detailed Use Cases, User Stories, Test Plans, Test Cases, and Test Scripts
• Good experience in performing planning and development of Test Plans, Test Strategies, Test Cases and Test Scenario to meet product’s business requirements.
• Proficient in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center(QC )11,/ALM, Test Director
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS utility and experience in ETL processes involving migrations and in sync processes between two databases.
• Experienced in back-end testing using SQL queries, generating reports to ensure Data Integrity and validate business rules.
• Experienced in dealing with clients to gather requirements, understanding the Business Requirements, product demonstrations and providing product support.
• Conduct technical code and test case reviews, provide project related status reporting, coordinate all release planning and lead the development team through all project phases
• Having excellent problem solving and analytical skills and experience of test plans, strategy and Procedures throughout the life cycle of a project from specification reviews through to user Acceptance

TECHNICAL SKILLS:

ETL Tools: InformaticaPowerCenter 9.5/8.x/7.x,Ab Initio GDE 1.15/1.14 / 1.13 / 1.12 , DataStage9.1/8.0/ 7.x/6.x, Operating System 2.15/2.14 / 2.12 / 2.11 , EME

Data bases: Oracle11i/ 10g / 9i / 8i / 7.x, Mainframe via web3270, DB2 UDB, MS SQL Server 2008, MS-Access, Teradata v2r6

Operating System: Unix, Windows NT, Windows2007, Windows XP.

Methodologies: Ralph Kimball’s Data modeling, Star and Snowflake Schema Modeling

Testing Tools: Mercury Quality Center 9.0 / 8.0, Test Director 7.6 / 7.0,, HP,ALM,OBIEE

Other: SQL,UNIX commands,HTML,Control-M and STAT PeopleSoftData Mover, Process Scheduler,SQR

PROFESSIONAL EXPERIENCE:

Confidential

ETL Tester

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes and attending user review meetings and documenting User Acceptance Criteria.
• Used agile methodology and was involved in the entire software development Life Cycle of the project from Initiation to Implementation.
• Performed Structural and Functional Back-End testing so as to check validity of data on the databases. Setting up the Back-End Testing environment and strategies for the project.
• Worked as a consultant in delivering quality data centric solutions for various business domains
• Experience in ETL Data Warehousing, database testing using Data Stage for Workflow process.
• Planned, designed and executed test cases based on Requirement Specifications Document and developed manual test cases for Positive, Negative, Functional and Performance testing.
• Expertise in creating reports, dashboards, Balanced score cards using micro strategy
• Performed Full Regression testing on all BIC Data Marts when needed.
• Tested Complex ETL Mappings and Sessions based on business user requirements to load data from various source systems like flat files, Mainframe DB2 tables and XML files to target tables.
• Wrote SQL Queries to check data integrity and consistency.
• Performed Validation of ETL processes from various source systems to Target database.
• Provided proactive daily status on issues and, progress made during test execution and general application testing.
• Conduct walk through meetings with various teams in understanding the QA processes, bug life cycles, QA documentation 
• Supporting presales activity for Data centric warehouse testing projects
• Tested loading of data into Data Warehouse, which is in Star schema model.
• Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.
• Used Quality Center to create defects based on the information obtained from session logs in case of errors, Data Validation issues (on Data warehouse) and requirements mismatch.
• Interacted with developers & various members of team to discuss and resolve defects and their priorities.
• Create various test Batch jobs to run and monitor group of jobs with Data Stage Director.
• Worked with Business Users to develop Test cases for user acceptance testing.
• Performed Data Quality integrity testing (completeness, conformity, consistency, accuracy, duplicates).
• Tested SQL queries and Stored Procedures used in Informatica Transformations PL/SQL scripts to validate the data.
• Involved in understanding business/transformation rules which are involved in developing the source to target mappings, wrote Complex SQL queries to reflect those rules and validated the mappings by running these test scripts and checked if the data in the target table populates correctly by writing complex SQL queries.

Environment: Informatica 9.1 (Power Center, Power Exchange), Oracle 10g, SQL Server, DB2, Quality Center 9.2, UNIX, Windows 7

Confidential

ETL Tester

Responsibilities:

• Verified the Online Services application to ensure that the requirements, artifact from each phase, and the final products are complete and correct.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
• Monitor security batch processing jobs in multi-platform shop via Control-M & Tidal Schedulers.
• Create Data Stage Parallel Jobs to extract, transformation and loading of the data using Data Stage Design toll in the parallel processing mode.
• Used Data Stage to move data to the warehouse using the stored Procedure thereby enabling faster Moment of data.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Performed the Unit and functional testing which validate the data is mapped correctly which Provides a qualitative check of overall data flow up and deposited correctly in Target Tables
• Tested the application for web functionality, and verified the online modules for broken links.
• Performed SQL validation to verify the data extracts and record counts in the database tables.
• Designed policies, standards and procedures for testing life cycle for the data warehouse and data marts.
• Created complicated reports using SSRS, SSAS to display key performance indicators and upload to Teradata tables using Teradata utilities FASTLOAD. Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Writing SQL Queries to retrieve data from data base.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data Transformation, data quality, integration testing, UAT & regression testing.
• Divided the graphs into various phases and used checkpoints to avoid Dead locks.
• Extensively worked on debugging ETL process graphs.
• Developed and tested transformation functions and record formats for various input data files.
• Tested all formats of SSRS reports including Excel, CSV, XML
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects
• Performed Data validation to verify the data extracts and record counts in the database tables.
• Conducted weekly batch testing to incorporate changes in new builds.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: HP Quality center9.2,Oracle 9i/10g, MYSQL, OBIEE 10.1.3, SQL, UNIX,DB2, MVS, Flat Files, XML Files, Shell Scripting.

Confidential

ETL Tester

 Responsibilities:

• Projects were in different methodologies like Waterfall and AGILE, well versed with both Methodologies of SDLC.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Involved in Gathering and Analyzing Business Requirements, High Level Designing and Detail Technical Design of ETL application.
• Involved in unit testing and integration testing of the developed work Analyzed production support Issues.
• Designed detailed test plans, test case and executed test scripts and diagnose problems in Informatica mappings based on Business Requirements.
• Gathered UI specifications and analyzed business process and established test strategies.
• Tested the values for test, Component parameters in Quality Center.
• Performed Backend Testing, Database validations, patient claims validations by writing complex SQL minus queries
• Extracted data from various sources like Oracle, flat files and SQL Server. 
• Wrote scripts to perform basic Sanity Testing and uploaded Test Scripts in Test Director.
• Logged issues in Test Director and tracked them to see whether the bug is fixed in the next Version.
• Communicated with Developers regarding technical issues.
• Used Remedy in trouble ticketing and moving projects from testing to pre-production Environments. VSS to upload track and manage scripts and documents.

Environment: Informaticapower center 9.x, Quality center9.2, SQL, UNIX, DB2, MVS, VSAM Files, Flat Files, XML Files, and Shell Scripting.

Confidential

ETL Tester

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested complex mappings using Mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Tested various Informatica Mappings using various Transformations and MYSQL Packages to extract, transformation and loading of data.
• Extensively Used HP Quality Centeras test management tool and Created and maintained the defects in HP Quality Center.
• Extensively used Informatics power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Involved in testing data reports
• Written several SQL queries for validating the front-end data with backend.
• Conducted back to back meetings with developers and discussed about all open issues.
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.

Environment: Informatica Power Center 9.1, MYSQL Server, SQL, HP Quality center.

Confidential

ETL tester

Responsibilities:

• Wrote Test Plans, which detailed the testing scope, testing requirements, success criteria, milestones, and necessary resources.
• Manually performed Ad-Hoc testing, end-to-end testing, and system testing.
• Performed manual testing by entering positive values, negative values, and boundary values to the application.
• Performed Black box, Integration, Regression, Systems, and Backend testing
• Created, maintained and updated regression suites upon receiving new build.
• Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX shell scripting.
• Involved in writing SQL statements to create test data for test cases and data validation tests to extract data from the tables.
• Used to play with the queries in the Teradata sql assistant
• Compared SQL results with application results by writing SQL queries.
• Used SQL queries to test the migrated database for Back End Testing.
• Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Backend testing of the DB by writing SQL queries to test the integrity of the application and Oracle databases using TOAD.
• Involved in writing Shell Scripts to load and extract information from files and tested the back-end for data integrity in UNIX.
• Involved in exporting the test cases form Microsoft Excel to Test Director and running the cases remotely in different hosts.
• For tracking the Defects used the tool Test Director. Performed Black Box, Integration, and Regression Testing. Investigated and reported bugs to the developers.

Environment: SQL, DB2, Oracle, HP Quality Center, Remedy, Microsoft Office, UNIX.