Professional Summary:

• Over 7 years of IT experience in the Analysis, design, development, testing and Implementation of ETL Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle SDLC with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Worked with different SDLC and STLC as Waterfall, RUP, Agile and V-Model
• Strong working experience on DSS Decision Support Systems applications, and Extraction, Transformation and Load ETL of data from Legacy systems using Data Stage, SSIS, Ab Initio Informatica
• Extensively worked on databases including Oracle 11g/10g/9i/8i, Teradata, SQL Server, Sybase and DB2.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Developed Informatica, SSIS, and Data Stage and Ab Initio test environment for UAT testing and used all ETL components/transformations while testing the ETL flow and ran the jobs on back ground.
• Strong skills in database programming using SQL, PL/SQL, T-SQL, Stored Procedures
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL process based on mapping document.
• Tested the ETL flow and other ETL Processes Data Warehouse Testing
• Expert in writing SQL queries and has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron-jobs for ETL Loads
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Data Stage
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Experience in testing XML files and validating the data loaded to staging tables.

• Extensive knowledge in regression testing and design documentation.
• Experience with Autosys job scheduler including jil scripting, virtual machines and custom calendars
• Hands on experience in writing test scripts, preparing test data, testing Informatica Mappings and creating SQL scripts using stored procedures, functions, PL/SQL
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center

TECHNICAL SKILLS:

Professional Experience:

Confidential

ETL Tester/QA

Responsibilities:

• Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Responsible for Mini specifications document that describe the functionality of each subject area.
• Implemented Database Checkpoints for Back-end Testing Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Experience in ETL Data Warehousing, database testing using Informatica for Workflow process.
• TOAD is used to perform manual test in regular basis.
• UNIX and Oracle are using in this project to write Shell Scripts and SQL queries Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Tested several business reports developed using Business Objects including dashboard, drill-down, summarized, master-detail Pivot reports.
• Prepared extensive set of validation test cases to verify the data
• Tested different detail, summary reports and on demand reports.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Processed a query to update a field in an Oracle database, to ensure that debt payments are allocated.
• Performed Functional Testing and Back-end Testing using the database comparable results
• Manually Worked on Informatica Power Center 7.1.4 tool - source analyzer, warehouse designer, mapping designer, workflow manager, mapplets, and Reusable Transformations.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Extensively used SQL Navigator to check the results of Unit test.
• Scheduled the ETL jobs using Maestro and loaded the data into target tables from staging area using dynamic load process.
• Responsible for migrating the code changes from development environment to SIT, UAT and Production environments.
• Extensively worked in the Unix Environment using Shell Scripts.
• Created test plans and performed unit testing for the Informatica mappings.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Involved in functional, exploratory and Integration testing.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Validated format of the reports and feeds.
• Created an induction manual for the ETL process.

Environment: Informatica Power Center 7.1, Teradata V2R5/V2R6, PL/SQL, Oracle 9i, TOAD, Maestro Scheduler, Test Director 7.0, ERWIN , IBM AIX 5.1, Shell Scripting, XML, XSLT, XSD, XML Spy 2008, UNIX, Windows NT/2000, SQL Navigator, Business Objects 6.0, Windows NT/2000/XP.

Confidential

Datawarehouse Tester/QA Analyst

Responsibilities:

• Analysis of Business requirements Design Specification Document to determine the functionality of the ETL Processes.
• Involved in the entire software development Life Cycle of the projects from Initiation to Implementation.
• Created test plan and test cases from the business requirements to match the projects initiatives in Quality Center.
• Work with source system personnel on source data delivery issues .Interacted with DBA for setting up test environment.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Performed database validation according to the business logic by comparing the source to the target in Spreadsheet. Validated Business Analytical Reports created in Business Objects.
• Interacted with developers various members of team to discuss and resolve defects and their priorities. Extensively developed and deployed Unix Shell scripts as wrappers that build runtime parameters to Data Stage jobs. Attended Bi-Weekly Defect Review and Defect Status meeting. Provide update to management on testing status and some other issues.
• Worked with Users to develop Test cases for user acceptance testing.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Involved in preparation of Requirement Traceability Metrics RTM , Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Quality Center Perform Data Quality integrity testing completeness, conformity, consistency, accuracy, duplicates .
• Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
• Understand business /transformation rules which are involved in developing the source to target mappings, write Complex SQL queries to reflect those rules and be able to validate the mappings by running these test scripts and checking if the data in target table populates correctly by writing complex SQL queries.
• Fine-tuned for performance and incorporate changes to complex PL/SQL procedure / Packages for updating the existing dimension tables using PL/SQL Developer on Oracle 10g RDBMS

Environment: DataStage 8.0/7.5.2, Quality Stage 7.1, Meta Stage, Oracle 10g/9i, SQL Server 2005/2000, SVN, HP Quality Center 9.2, SQL, PL/SQL, Business Objects XIR2, TOAD, XML, XSLT, XML Spy 2008, Korn Shell Scripts, UNIX, Windows XP.

Confidential

ETL Data Warehouse Tester

Responsibilities:

• Used Quest Software's Toad application to set up data, create, and execute SQL script on Oracle 9i database. Completely involved in Database Testing.
• Design and development of ETL processes using Data Stage ETL tool for dimension and fact file creation. Coordinating offshore team and making the offshore team work smoothly and getting the quality work from offshore on time.
• Validating the complete source to target mappings along with transformation rules.
• Created and executed detailed test cases with step by step procedure and expected result Experience in ETL Data Warehousing, database testing using Data Stage for Workflow process.
• Profound insight to determine priorities, schedule work, and meet critical deadlines within budget guidelines.
• Experience in working independently and multi task without negative impact to timelines or quality.
• Strong Knowledge on the phases of Software Development Life Cycle SDLC Methodology.
• Experience in preparing the traceability matrix, test scenarios and test cases.
• Involved in preparation of Requirement Traceability Metrics RTM , Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Test Director.
• Perform black box testing by designing and constructing test cases, test data and test execution. Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document. Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Experienced in writing UNIX script.
• Extensively used PL/SQL features such as procedures, functions, packages database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Tested data migration to ensure that integrity of data was not compromised. Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document. Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution. Created database objects such as tables, views, synonyms, indexes and sequences as well as custom packages tailored to business requirements.
• Created Indexes and partitioned the tables to improve the performance of the queries.
• Designed and Developed partition exchange process to minimize user access downtime to the warehouse. Developed SQL loader scripts to load the data into the custom tables.
• Involved in debugging and tuning the PL/SQL code, tuning queries, optimization for the Oracle database and wrote Unix Korn Shell Scripts to schedule the business process.

Environment: Ascential DataStage 7.x/6.x, Designer, Director, Manager , Erwin, Oracle 9i, TOAD, XML, XSLT, XML Spy 2008, SQL Server 2000, DB2, MS-Access, XML files, PL/SQL, UNIX, Shell, Windows NT

Confidential

ETL Tester/SQL

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
• Worked with different sources such as relational databases, flat files for extraction using Source Qualifier and joiner.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system.
• The data was standardized to store various Business Units in tables.
• Summaries for Scripts Status and Daily Transaction were stored in Summary Tables for Analysis
• Involved in Developing Data Marts for specific Business aspects like Marketing Finance
• Created the mappings using the transformations like Source Qualifier, Joiner, Lookup, Filter, and Update strategy.
• Responsible to design, develop and test the software Informatica, PL SQL, UNIX shell scripts to maintain the data marts Load data, Analyze using OLAP tools .
• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer and Mapping Designer, Mapplet Designer, Transformation Developer.
• Created reusable transformations and mapplets to use in multiple mappings
• Implemented performance issues on mappings to increase the efficiency of loading the data from various metrics to the target database.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Developed schedules to automate the update processes and Informatica Sessions/Batches Used workflow manager for session management, database connection management and scheduling of jobs.
• Used Silk Test Suit for regression and functionality testing.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

Environment: Informatica Power Mart/Power Center 7.1 Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer , Oracle 9i, Sybase, SQL Server, Tera data, DB2, Erwin 4.0, Business Objects 5, Silk test Suite, HP-UX, Windows

Confidential

Quality Test Engineer

Responsibilities:

• Involved in writing Test plan and developing Test cases from Business Requirements.
• Participated in Requirements and Design discussions with project stakeholders Developed UAT test plans, created RTMs, and created test cases/test scripts, defects
• Involved in preparing the Test plan and implemented SDLC with Waterfall model
• Solid Knowledge of test methodologies.
• Prepared Test Cases as per requirements and Involved in Execution against the Application.
• Performed various
• Manual tests: Smoke testing, Functional Testing, User Interface Testing, System Testing, Regression Testing and Integration Testing.
• Wrote SQL queries for retrieving the data from tables for manual testing. Parameterized the variables with the test data for multi user test.
• Involved in meetings with development team for Knowledge Transfer.
• Defect tracking was done very efficiently with Defect profile template.
• Tested Different versions against the Test Cases.

Environment: Manual Testing, Java, Oracle and Windows NT, HTML, J2EE, Web logic, Web Methods, SQL, XSLT, XSD, XML, DB2 and Sybase