SUMMARY

• Over 6 Years of experience as ETL Tester mainly focusing on Informatica.
• Expertise in Unit Testing, Integration Testing, System Testing (Functionality and Regression), Performance Testing and User Acceptance Testing. Performed error handling and performance tuning in Teradata queries and utilities.
• Extensive experience of Integration Testing, GUI Testing, System Testing, Sanity Testing, Database Testing and Compatibility Testing.
• Experience database testing (Oracle, SQL Server) and validating the applications against the database.
• Experience of developing complex mappings with Custom Transformations and XML Sources. Highly experienced in performing data quality test, data correctness test, data consistency test.
• Proficient in bug tracking using Bug Tracking Tools - Mercury Quality center, Test Director, and Rational Clear Quest.
• Skilled in planning, designing, developing, testing and deploying Data warehouses/Data Marts.
• Knowledge in design of Extract, Transform, Load environment using Informatica Power Center.
• Data modeling experience using Star Schema/Snowflake modeling, OLAP tools, Fact and Dimensions tables data modeling, ERWIN 4.0/3.x and Oracle Designer.
• Developed PL/SQL packages, shell scripts to execute the packages and PL/SQL blocks to debug the package in production environment and migrated bulk data.
• Used Quality Center 10.00 as Test management and Defect resolution tool, including logging defects, attaching evidence and retesting the defect.
• Strong experience in designing and developing Business Intelligence solutions in Data Warehouse / Decision Support Systems using ETL tools, Informatica Power Center, Power Mart, Power Connect and Cognos BI.

TECHNICAL SKILLS
ETL Tools: Informatica Power Center 8.X / 7.X / 6.X
Databases: Oracle 8.0 / 9i /10g/11g, MS SQL Server 2005/2008, IBM DB2, Teradata and Sybase.
Database Skills: Cursors, Stored Procedures, Functions, Views, Triggers, and Packages
Methodologies: Data Modeling Logical / Physical, Star/ Snowflake Schema, FACT & Dimension Tables, ETL, OLAP, Agile, RUP, Software Development Life Cycle (SDLC)
Tools: HP Quality Center, Test Director, Rational Rose, Rational Clear Quest, Bugzilla, Quick Runner, WinRunner, Autosys, Toad
Client Side Skills: SQL, T-SQL, PL/SQL, UNIX shell scripting
OS: Windows 2000/2003/XP/Vista/Windows 7, UNIX/Solaris, Red Hat Linux

EDUCATION

Bachelor of Engineering.

PROFESSIONAL EXPERIENCE

• Confidential,Wakefield, MA (August 2011 – PRESENT)

Position: ETL Tester

Environment:

Informatica Power Center 8.6, Oracle 9i, ODI, Teradata V2R3, UNIX (Solaris), Quality Center 9.2, Erwin 4.0/3.5.x, MS SQL Server 2000, PL/SQL, MS Access 2000, Shell Programming, SQL * Loader, Toad

Description:

Epsilon is the industry\'s leading marketing services firm, with a broad array of data-driven, multichannel marketing solutions that leverage consumer insight to help brands deepen their relationships with customers. Services include strategic consulting, acquisition and customer database technologies, loyalty management, predictive modeling along with full range of direct and digital agency services. The objective of this project was to develop a complete data warehouse so that they can analyze, do slicing, dicing, drill down on patient data. Data warehouse was designed using Erwin with different Fact and Dimension tables. We created multiple instances for redundancy.

Responsibilities:

• Worked Developed various Mappings, Mapplet and Transformations for migration of data from various existing systems to the new system using Informatica Designer.
• Review of project requirement and active involvement in all active phase of SDLC.
• Data Modeling done with multidimensional architecture.
• Reporting and tracking the defect in Quality Centre 9.2.
• Performed System Testing, Regression Testing and Integration Testing.
• Extensive Experience in SDLC and in handing large volume of data.
• Involved in data mapping, validation and Extract, Transform and load from one database to another by using Informatica and doing sql query.
• Performed data count, data quality, data consistency, process interdependency and backend tests for source and target systems.
• Performed backend testing for inserts, updates, and deletes writing complex SQL queries.
• Created, tested and validated various workflows associated with different mappings created by development team and monitored the workflows.
• Designed, created and tested reports to meet business requirements.
• Involved in peer to peer to peer reviews.
• Involved in User Acceptance Testing.
• Identifying Bugs and reporting defects.
• Maintained Test Metrics with the test results obtained and used Test Director to execute and manage tests cases and to track the Bugs.
• Effectively communicated the defects and bugs with the developer team and updated required information into the system
• Reviewed the test cases based on the Change Request document.
• Clarified issues and reviewed test plans and test scripts developed by development team and QA team to make sure all requirements have been covered in scripts and tested properly.
• Effectively communicated user acceptance test results between users and development team and provided recommendations for change control requests (CCR).
• Responsible for migration from Development to Testing and to Production.
• Responsible for Unit Test Plans and verification of functional specifications and review of deliverables.
• Extract and deploy various types of data in the target database using ODI.

• Confidential,PA (February 2010 – July 2011)

Position: ETL / QA Analyst

Environment:

Power Center 8.5 / 8.1 (Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations), Relational Manual Tester, Power Exchange Tool, Oracle 10g, SQL Developer, SQL plus, PL/SQL (Stored Procedure, Trigger, Packages), ODI, Teradata.

Description:

Orthovita is a leading company engaged in offering advanced bone regeneration and soft tissue healing technologies. Orthovita is a spine and orthopedic surgical biomaterials company involved in the development and marketing of novel, high-tech, synthetic-based biomaterial products.

Responsibilities:

• Preparing the SQL script to verify data and validating data from
  source and target Through Toad 9.0.1
• Developed and Implemented Informatica parameter files to filter the daily data from the source system.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Validated reports based on Functional Requirements.
• Created Test Cases using Rational Manual Tester (RMT).
• Involved in System Testing, Regression Testing and Integration Testing.
• Used ClearQuest for change tracking during software development life cycle.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Did error handling and performance tuning in Teradata queries and utilities.
• End to End support in the Oracle data integration (ODI).
• Solved the complex logic in the ODI.
• Creating Test Case Documents for Unit Test, Integration Test to check the data and Mapping documents.
• Created Tasks, Workflows and Worklets using Workflow Manager. Monitoring of Workflows and Worklets using Workflow Monitor.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and, sequence buffer length.
• Confidential,FL (October 2008 – January 2010)

Position: - ETL / DWH Tester

Environment:

SQL Server 2005, Sybase, SQL, Toad, Informatica Power Center 8.1, Unix Shell Scripting, Windows XP/2000, Erwin, Business Object

Responsibilities:

• Tested the database schema with help of data architects using ERWIN.
• Involved in the testing of Data Marts using Power Center
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Tested Business Objects reports migration and created Business Objects reports for defect tracking.
• Reports created in Business Objects were tested by running SQL statements.
• Coordinated the test data, Business Objects environment and UAT of reports
• Performed User Acceptance Testing and Regression Testing.
• Participated in discussions with the business owners regarding rating test cases/results.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Wrote several UNIX scripts for invoking data reconciliation.
• Created UNIX shell scripts for file transfer and file manipulation
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Involved in functional testing the Web application using Quick Test Pro.
• Processed a query to update a field in an Oracle database, to ensure that debt payments are allocated.
• Performed User Acceptance Testing and Regression testing.
• Involved in System Analysis, Design and Development of the OLAP application
• Extensively used Informatica client tools to extract data stored in database and for testing purposes.
• Confidential,CO (January 2008 – September 2008)

Position: - ETL Tester

Environment:
Informatica Power Center 8.1.4, Oracle 7g, Unix, DB2, Sybase 12.x, MS SQL Server 2005, Business Object 6.x, TIBCO, TOAD, Erwin, WINCVS, XML, HP - Unix
Description:
TIC Holdings, Inc. (TICH) is heavy industrial contractor providing world-class construction expertise in the areas of Power, Mining/Minerals Processing, Oil/Gas/Chemical.
Responsibilities:

• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Designed and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup and filter.
• Maintained and tracked the defects.
• Prepared the shell script to verify the data.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Reviewed Test cases and scripts based on client requirements
• Prepared the SQL script to verify data and validating data from
• source and target
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Extracted the JMS text messages from the Oracle Advance Queue (JMS Provider) through the JMS Adapters installed on Informatica PowerCenter Server.
• Worked with JMS text messages as a source system, which arrive in the form of XML payload and also implemented Mid-stream transformations such as XML parser transformation to parse the XML string.
• Formatted Reports as per the user requirements using extensive functionalities in Business Objects, which allows the users to analyze the data.
• Involved in the Production support and also transferred knowledge to the other team members.
• Confidential,WA (October 2006 – December 2007)

Position: - ETL Tester

Environment:
Informatica Power Center, SQL Server, Windows XP and UNIX.
Description:

Russell\'sInvestmentsis a subsidiary .The services include retirement plans, endowments, foundations and investment plans of all types. Investors have access to Russell\'s services through a network that includes many of the world\'s top banks, brokers, insurance companies and independent investment advisors

Responsibilities:

• Documented all the mappings and sessions in accordance with unit test results
• Handled responsibilities of identifying and preparing defect reports gathered from testing
• Performed the tasks of preparing test reports as well as developed formal acceptance test procedures
• Assigned responsibilities of conducting verification and certification of software products
• Performed the tasks of enhancing product solutions testing concepts by coordinating with senior information QA testers
• Responsible for planning testing strategy and provide comprehensive end-end product solutions
• Performed research and provided modifications recommendations as required
• Using the debugger in Informatica, tested the data in the warehouse and performed unit testing of Informatica mappings.
• Involved in adding Sources and Target databases to Mapping Designer of Informatica
• Extensively involved in production support, testing the data and day to day aspects of the data warehouse including deploying new code and loading history data into the data warehouse
• Debugged and implemented the best practices in mappings, sessions, and workflows for data extraction and loading from source to target databases.
• Responded to help desk calls from customers and coordinated solutions with the rest of the developer\'s team. Took care of any process failures, easily identified cause of the problem and resolved issues.