SUMMARY

• Over 5+ years of IT experience in teh Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design,ETL, OLAP, Client/Server applications
• Experienced in all teh phases of SDLC from Requirements, Analysis and Design, development, testing and deployment.
• Proficient in analyzing teh Business Requirements and design documents to formulate Test Strategies, Test plans and Test cases.
• Experience with Initial and Incremental load testing within ETL Testing.
• Strong working experience in teh Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Expertise in understanding Business Requirements, Functional Requirements, decomposing into HLD's and ETL Specifications into Test Cases for positive and negative test conditions.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Experience in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in gathering functional requirements from users and designing data model for ETL development.
• Strong working experience in teh Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Extensive experience in performing different types of testing including White Box, Black Box, System, Functional, Integration, Regression, Smoke, GUI, Database and User Acceptance Testing (UAT) and Unified Functional Testing (UFT).
• Experience in Data Profiling, Data Extraction, Data Integration, Data Testing and Data Cleansing.
• Adept in writing SQL scripts required for testing various ETL and backend processes.
• Experienced in running SQL queries using Toad (Oracle), Teradata SQL Assistant and SQL server.
• Experience in Performance Tuning of SQL and stored procedures.
• Passionate worker to contribute individually and as part of a team.
• Ability to learn modern technologies quickly with good analytical and problem - solving skills.
• Strong analytical, communication, problem solving, decision making and organization skills and an excellent team player.

TECHNICAL SKILLS

Testing Tools: ETL Tools

Reporting Tools: Selenium, QTP, Quality Center, TestDirector

Informatica, Datastage: Business Object, Cognos, Ab Initio

Defect/Test Management Tools: Quality Center, Jira, ALM

Languages: Java, SQL

Databases: Oracle 9i/10g, IBM DB2, MS SQL Server, MS Access

WebServer/AppServer: Tomcat, IIS, Weblogic, WebSphere

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential, NY

ETL Tester

Responsibilities:

• Prepared Execution procedure document format to prepare teh Test cases based on mapping document.
• Documented technical requirement specifications and detailed designs forETLprocesses of moderate and high complexity.
• Extensively tested several ETL Mappings developed using Informatica.
• Tested Informatica ETL mappings dat transfer data from Oracle source systems to teh Data Mart.
• Designed and developedETLprocesses to extract data from teh source systems and load into teh Data Warehouse.
• Tested a number of complex ETL Ab Initio graphs, for initial/ history and daily/weekly/monthly incremental data loads.
• Created Test cases for Data Acquisition and Data Delivery and tested teh data accuracy for all teh transformations.
• Developed various Mappings with teh collection of all Sources, Targets, and Transformations using Informatica Designer.
• Created Requirement Traceability Matrix by mapping teh requirements with test cases to ensure dat all requirements are covered in testing.
• Worked with Informatica power centre Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed Mappings using Transformations like Expression, Filter, Joiner, Lookup, Update, Sequence Generator, Router, Stored Procedure etc, for better data messaging, to migrate clean and consistent data and to implement complex logic while coding.
• Tested data migration to ensure dat integrity of data was not compromised.
• Responsible for coordinating Integration testing, UAT and Regression testing with Business Consultants and Offshore team members, as applicable.
• Tested several Data warehouse ETL Informatica Mappings to validate teh business conditions.
• Involved in web services testing using SOAP UI, validated request and response XML.
• Used Informatica power center for extraction, transformation and loading process.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Extensively used SSIS Import/Export Wizard, for performing theETLoperations.
• Writing complex SQL queries using table joins (inner and outer), temporary tables, and table variables.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Used Quality Center to state requirements, test plan, test cases, and update test run status for each iteration and to report teh defects.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports.

Environment: Informatica Power Center, Ab Initio, Manual Testing, SOAP UI, Quality Center, Oracle, SQL Server, SQL, PL/SQL, SQL*Plus, TOAD, Shell Scripting, Windows.

Confidential, Nashville, TN

ETL Tester

Responsibilities:

• Gatheird teh requirements and preparing teh test case generation.
• Worked withETLSource System and Target System (ETLMapping Document) for writing test cases and test scripts.
• CreatedETL test data for allETLmapping rules to test teh functionality of teh Informatica packages.
• CreatedETLexecution scripts for automating jobs.
• Tested several Data warehouseETL Informatica Mappings to validate teh business conditions.
• Involved in ETL process testing using Abinitio ETL tool.
• Created ETL test data for all ETL mapping rules to test teh functionality of teh Abinitio graphs.
• TunedETLjobs/procedures/scripts, SQL queries, PL/SQL procedures to improve teh system performance
• Worked with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Informatica.
• Perform User Acceptance Testing with UAT test scenarios.
• Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
• Verifying teh Business Objects Report functionality and Layout specifications based on report requirement document.
• Created ETL test data for all ETL mapping rules to test teh functionality of teh Informatica packages.
• Performed Data Centric testing to validate teh data dat is loaded in to teh data warehouse is correct as per teh defined business rules.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Involved in checking teh status ofETLjobs in UNIX and tailing teh log files while teh loading is under processing.
• Involved in data warehouse testing by checkingETLprocedures/mappings.
• Responsible for teh business requirements,ETLAnalysis,ETLtest and design of teh flow and teh logic for teh Data warehouse project.
• Performed end-to- end testing of applications and coordinated with other teams.
• Closely worked with Clients during User Acceptance Testing to validate their findings, and report defects for resolution.

Environment: Quality Center, Manual Testing, Informatics Power Center, Oracle, MS SQL Server, UNIX Shell Scripting, PL/SQL, Rational Clear Quest, Windows.

Confidential, Boca Raton, FL

ETL Tester

Responsibilities:

• Interacted with teh Business users to identify teh process metrics and various keys dimensions and measures.
• Analyzed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, Test Cases, Expected Results and Prioritized tests for teh applications for various modules using Quality Center.
• Created complex SQL queries for querying data against different data bases for data verification process.
• Involved in teh error checking and testing of theETLprocedures and programs Informatica session log.
• Executed test cases for web-based MicroStrategy reporting application.
• Tested new Data migration tool used in teh mapping of data to new system.
• Data migration of raw data to excel documents for clients.
• Participated in defining and executing test strategies using agile methodology.
• Tested several complex reports generated by MicroStrategy including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Tested theETLInformatica mappings and otherETLProcesses (Data Warehouse Testing).
• Tested ComplexETLMappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created Test cases for Data Acquisition and Data Delivery and tested teh data accuracy for all teh transformations.
• Written extensive UNIX Shell scripting for error logging, clean-up, data archiving and job scheduling
• Conducted backend testing by querying databases to synchronize testing databases and checked for data integrity and proper routing based on workflow rules at each step.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Involved in meetings to discuss teh findings in teh executed tests and decide teh next steps.
• Validated dat application meets requirements and functioning as per teh technical and functional specifications.
• Created Requirement Traceability Matrix (RTM) by mapping teh requirements with test cases to ensure dat all requirements are covered in testing.
• Involved in testing teh MicroStrategy reports by writing complex SQL queries.

Environment: Informatica Power Center, Manual Testing, Oracle, SQL, PL/SQL, UNIX, Teradata, ALM/HP Quality Center TOAD, Windows.

Confidential

ETL Tester

Responsibilities:

• Analyzed system requirements specifications, developed test plans, test cases, and test data for testing teh functionality, GUI, usability, user acceptance tests with both Positive and Negative Scenarios, especially focused on logical scenarios of teh application.
• Designed Test cases from Requirements, Functional Specifications and Design Documents.
• Created and updated test cases in Excel sheets and generate Traceability Matrix.
• Executed teh test cases manually and automation as necessary and worked on XML.
• Responsible for Traceability matrix preparation to make sure all teh requirements are covered in teh test cases.
• Performed Manual Testing to check flow of teh application.
• During testing life cycle, performed different types of testing like System Testing, Integration Testing and Regression Testing.
• Created Test Execution Matrices during teh test cycle.
• Used Quality Center to define requirements, design test steps, run as test set, report, track and close bugs.
• Executed test cases compared with expected values and pass/fail reports updated through Quality Center.
• Performed database testing by passing PL/SQL queries and also executed teh regression test cases before handed over to UAT.
• Worked with development teams investigated and corrected software bugs and deficiencies based on teh testing results.
• Prepared Test report at teh end of testing phase for business stakeholders for their weekly meetings.
• Actively participated in status reporting meetings and interacted with development to discuss teh technical issues.

Environment: ETL, Informatica Power Center, Manual Testing, Quality Center, HTML, Excel, Oracle, SQL Server, Windows XP, UNIX, MS Outlook.