SUMMARY:

• Over 7+ years of IT experience in the field of ETL, Data Warehouse, Informatica and Master data management.
• Experienced in White Box testing and Black Box testing with a complete QA process - from requirement Analysis, Preparing Business Assurance strategy document, Creating Test cases, Executing test cases, Logging defects, verification of fixed bugs and preparing test reports.
• Experienced in both Manual Software testing, Automated testing and Mobile testing
• Extensive experience in using Quality Center (QC) and HP Service manager.
• Familiarity with Master Data Management (MDM) concepts and Informatica MDM tool -Informatica MDM Hub Console, Hierarchy Manager (HM) and Informatica Data Director (IDD).
• Written several complex T-SQL queries for data validation and data verification for verifying the business Mapping Rules.
• Used Informatica Power Center Workflow Manager to run the workflows and review the session logs.
• Analyzed data flows and data conflicts between legacy systems and reconcile conflicting or ambiguous information, designed DFDs (Data Flow Diagrams) using Microsoft Visio.
• In depth knowledge of creating Logical/Physical data models by identifying facts and dimensions for the dimensional data models (Star and Snow Flake Schemas).
• Experienced in documenting source to target mappings for Data Extraction, Transformation and Loading(ETL) from disparate Data Source databases like Oracle, Teradata, SQL Server, MS Access, flat files, CSV files and XML files to load target warehouse.
• Good experience on testing Business Objects reports.
• Experience in implementing SDLC Methodologies like Agile, RAD, Waterfall and V Model
• Experience in UNIX shell scripting and configuring cron-jobs and Control-M jobs for ETL Loads
• Proficient in SQL and Oracle PL/SQL (Procedures, Functions, Packages, Triggers, views)
• Strong understanding reference data and its integrity
• Experienced with ETL processes using Ab Initio and Informatica Power Center
• Strong understanding on SDLC, RDBMS, OLTP, ETL Processing, OLAP, and DW Concepts.

TECHNICAL SKILLS:

Operating System: MS-DOS, Windows (2000/03/07 server, XP Professional), Linux/Unix

Database: Oracle9i, Oracle10g, 11g, 12c, SQL Server 2005, 2008, 2012, 2014, DB2, Teradata and MS-Access

ETL: Datastage 8.0, Informatica 8.1, Ab Initio (GDE 1.14, Co>Op 2.14), SSIS

Languages: PERL, HTML, XML, XSLT, VB Script, Java2.0, SQL T-SQL and PL/SQL

Testing Tools: Quick Test Pro and Quality Center, Clear quest.

Master Data Management: Informatica MDM/Teradata MDM

Utilities: TOAD, Citrix server, Oracle SQL Developer, Putty, VPN, Net meeting and CuteFtp

Reporting Tools: Business Objects Xi R2, Crystal Reports, Cognos 8.0 Series, SSRS

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Sr. Ab Initio ETL Tester

Responsibilities:

• Involved in Design Review and Code Review meetings to collect the changed requirements.
• Used Check Points, Phases, for Debugging and Integration testing.
• Created Test Plans and Test Requirements, which detailed the testing scope.
• Executed the Test Cases using Quality Center.
• Involved in End-to-End testing, System Testing and UAT testing.
• Involved in ETL processes using Ab Initio and Informatica Power Center.
• Developed RTM document to map S2T and requirement document.
• Developed test cases for one time load and incremental data to meet business requirements.
• Managed Control-M scheduling on Production.
• Analyzed the data across different systems to make sure that the data that is extracted is complete.
• Worked on HP ALM for defect management.
• Involved in Testing of complicated graphs with various Ab Initio components such as Join, Join with DB, Validate.
• Involved in testing Unix shell scripts to run stored procedures and functions.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica.
• Converting the Oracle table components to Teradata Table Components in Ab Initio Graphs.
• Validated tables to check whether normalization/Denormalization is done properly for all the fact tables
• Created Testing requirements from the functional requirements, system specification and design specification.
• Extracted and reformatted data form different heterogeneous data sources like Oracle, using Ab Initio.
• Involved in preparation of test data to test the functionality of the Ab Initio graphs.
• Experience in testing Business Objects Universes to support the reporting requirements of business users.
• Worked on Informatica to resolve production issues perform testing and debugging of mappings and reports Extraction of test data from tables and loading of data into SQL tables
• Used SQL queries to extract data from the target tables to validate the data mappings.
• Created AUTOSYS Jobs to run daily, weekly and monthly basis to process ETL Jobs.
• Created the Control-M jobs by using Control-m tool and run jobs through Control-M enterprise manager tool.
• Used Rational Clearquest to log defects and track resolution till the closing of defect after retesting.
• Wrote and modified required UNIX scripts and other SQL validation scripts to perform backend testing.
• Involved in User Acceptance Testing.

Environment: Ab initio (GDE 1.15 Co > Op 2.15), Informatica 8.6, HP Quality center 10,Teradata studio 15,UNIX, Windows XP, Oracle 10g, SQL Server 2014/2012, PL/SQL, Unix Shell Scripting, Control-M, Clearquest, Autosys, Business objects 11.

Confidential, Wilmington, CA

Sr. ETL Ab Initio Tester

Reponsibilities:

• Developed detailed Test Plans and Test Cases in H.P Quality Center and executed them.
• Participated in Business Analysis, Requirement Analysis and Data Analysis.
• Extensively used SQL for data integrity testing at the backend.
• Used Ab Initio components like Reformat, Rollup, Join, Sort, Partition by Key, Normalize, Input Table, Output Table, Update Table, Gather Logs and Run SQL for developing graphs.
• Developed SQL Scripts for data testing and data validation.
• Used Control-M Enterprise Manager and Control-m Desktop Manager.
• Executed Integration testing and Regression testing for all critical transactions.
• Extracted and reformatted data from different heterogeneous data sources like Oracle, using Ab Initio.
• Developed & maintained the traceability matrix between requirements and test cases.
• Tested transaction for ETL using Informatica and SSIS and OLAP Reporting using SSRS and COGNOS.
• Involved in analysis and study of functional specifications for the enhancement of existing functionality.
• Experience in testing reports with Parameters, Sub-Reports, Cross-tabs and Charts based on Stored Procedures and Queries by using Crystal Reports.
• Tested several Ab Initio graphs, Wrapper Script, PSet’s based on the transformations rules that were applied.
• Responsible for System Testing, Regression Testing and Acceptance Testing.
• Tested User Interface inconsistency and application functionality.
• Wrote UNIX shell scripts to perform batch tests.
• Tracked the issues using Quality Center.
• Automation of Ab Initio graphs using Autosys Jobs.
• Tested mappings for populating the data.

Environment: Oracle 11g, SQL Server 2012, Informatica 8.6, Teradata V2R5, Control-M, Ab Initio (GDE 1.14, Co>Operating System 2.14), Erwin 4.2, Unix Shell Scripts, Clear Case, Crystal Reports.

Confidential, Downers Grove, IL

ETL Test Lead tester

Reponsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in ALM 11.0.
• Created test data for testing specific ETL flow.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica.
• Worked on Informatica to resolve production issues perform testing and debugging of mappings and reports Extraction of test data from tables and loading of data into SQL tables.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Worked with data validation, constraints, source to target row counts.
• Cleansing the data from source systems using Ab Initio components such as Join, Dedup Sorted, Denormalize, Normalize, Reformat, Filter-by-Expression, and Rollup.
• Automation of functional testing framework for all modules using Selenium.
• Formulate methods to perform Positive and Negative testing against requirements.
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Uploading the Test cases in HP ALM.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
• Worked with EME / sandbox for version control and did impact analysis for various Ab Initio projects across the organization.
• Monitored the Informatica workflows using Power Center monitor.
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
• Created Control-M jobs and ran manual loads.
• Used Ab Initio components like Reformat, Rollup, Join, Sort, Partition by Key, Normalize, Input Table, Output Table, Update Table, Gather Logs and Run SQL for developing graphs.
• Involved in testing Unix Korn Shell wrappers to run various ETL Scripts to load the data into Target Database (Oracle).
• Worked on Clear Quest to log defects and track resolution till the closing of defect after retesting.
• Created test cases and executed test scripts using Quality Center.
• Performed consistency and quality checks on data centric testing processes.
• Used Quality Center to track and report system defects.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica 8.6, DB2, Ab Initio GDE 1.12, HP Quality Center 11, Java, Business Objects XIR2/6.5, SQL Server 2005/2008, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Control-M, HP ALM 11.0, IBM AIX 5.3, UNIX Shell Scripting, MDM HUB, Oracle DRM, Data Modeling, Rumba UNIX Display, TOAD.

Confidential, Indianapolis, IN

Ab Initio ETL Tester (SAP BODS)

Reponsibilities:

• Work with project teams to identify test requirements and design testing phases to meet system needs.
• Design and document test plan based on risks involved in data movement across systems.
• Prepared Requirement traceability matrix (RTM) based on the requirement document and S2T.
• Reported periodic project status and updates to the QA Lead and QA Manager.
• Developed Test Cases for ETL Data Validation History load and incremental load using business rule mapping document and business requirements.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Used UNIX environment variables in All the Ab Initio Graphs.
• Implemented test automation using tools from HP (QTP and Test Director/Quality Center).
• Validating the data thru various stages of data movement from staging to Data Warehouse tables.
• Involved in UNIX shell scripting and configuring cron-jobs and Control-M jobs for ETL Loads
• Analyzed the log file for an ETL job in SAP BODS and reported to developer.
• Written complex SQL queries and queried the Oracle database to test SAP BODS ETL code.
• Responsible for setting up Repository projects using Ab Initio EME for creating a common development environment that can be used by the team for source code control.
• Performed data centric backend testing of applications using UNIX and SQL scripts.
• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA.
• Testing of records with logical delete and physical delete using flags
• Tested transaction for ETL using Informatica and SSIS and OLAP Reporting using SSRS and COGNOS.
• Create a transform and load code in Ab Initio and Shell scripts & schedule those using Autosys.
• Performed integration and performance testing on SAP BODS ETL jobs.
• Attended daily project status meetings and weekly QA status meetings and performed documentation reviews under supervision.
• Tuning of Ab Initio graphs for better performance.
• Tested data in fact and dimension tables in data mart which involves complex logic.
• Performed Formal run for all modules and documented accordingly to meet the data compliance.

Environment: Oracle 11g, SAP BODS 4.1, HP Quality Center 11, Clear Quest, SQL, Ab Initio GDE 1.12, PLSQL, HP ALM, Cognos 10, UNIX Shell Scripting, Oracle DRM, MDM HUB, Control-M, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Business Objects, UNIX, Oracle EBS 11i, Data Modeling, Windows 7.

Confidential, Los Angeles, CA

ETL Tester (Informatica/Ab initio)

Responsibilities:

• Involved in entire SDLC process.
• Analyzed FED requirement document & Design Specification Document to determine the functionality of the ETL Processes.
• Involved in creating data flow diagrams using MS VISIO to analyze the sources for each portfolio to make the source data complete.
• Created test cases for all three portfolios based on the information available in MDR.
• Worked on MDR (Meta data repository) to analyze source to target mapping for each data element that is provided in the repository.
• Involved in preparation of test data to test the functionality of the AB Initio graphs.
• Involved in writing Sql scripts in Toad based on joins (INNER and OUTER) and rules provided in MDR.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings
• Validated the mappings in Informatica to analyze the Transformation logic is applied correctly.
• Executing and monitoring jobs through Control-M.
• Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA, Pre-Prod and Prod Environments.
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Tested several complex reports generated by Cognos including Dashboard, Drill Down and Pivot.
• Testing WebSphere applications and Web Services using SOAP.
• Performed ETL validation for all three portfolios from source to staging and from staging to target based on the business rules provided in MDR.
• Involved in daily status meetings to update the status of testing to client.
• Worked on Quality center to assign and to keep track of the defects.
• Used Data stage Director to run and monitor the jobs for performance statistics.
• Worked on MS ACCESS to connect to the different data bases to perform joins.
• Involved in Data modeling, E/R diagrams, normalization and de-normalization as per business requirements.
• Performed System testing of Data Migration using Target Statistics Reports.
• Optimizing/Tuning several complex SQL queries for better performance.
• Functionality testing of email notification in ETL job failures, abort or data issue problems.

Environment: Informatica 8.1,Oracle 10g,TOAD, HP Quality Center 11, BTEQ, DataStage 8.0, HP/Mercury QC9.x, AB Initio, QTP 10, Ultra Editor, SOAP UI, Teradata 14, Data Modeling, IBM WebSphere, Control-M, Cognos 10, UNIX Shell Scripting, MDM HUB, HP ALM, MDR, MS VISIO, OBIEE.

Confidential, Plano, TX

ETL Test Lead (Abinitio)(Onshore/Offshore)

Responsibilities:

• Interacted with clients to create Business Assurance strategy (BAS) document as per User requirement.
• Participated in analysis of Business and functional requirements and developed Traceability Matrix of Business Requirements mapped to Test Scripts based on the risks involved in the ETL process.
• Ran complex SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Tested several Ab Initio graphs, Wrapper Script, PSet’s based on the transformations rules that were applied.
• Involved in testing the metadata to test the integrity of the Business Objects Universe (SAS).
• Involved in Testing Business Objects reports.
• Involved in Testing of complicated graphs with various AB Initio components such as Join, Join with DB, Validate, Generate Records, Rollup, Partition by Key, Filter by Expression, Gather, Reformat, Merge, Dedup sorted and Scan to validate Business requirements.
• Used agile systems and strategies to provide quick and feasible solutions, based on agile system, to the organization.
• Provide Informatica MDM HUB development.
• Analysis of application requirements and entering of requirements into HP ALM.
• Used HP/Mercury Quality Control (QC) to create and execute test cases/scripts, maintain and track requirements, and Generated standard and customized reports.
• Executed regression test scripts along with testing new enhancements by using QTP and analyzed results
• Moved data from one database to other database, Used SQL*Loader for data migration.
• Creation of job processing definitions using the companion product Control-M/Desktop.
• Worked with IBM WebSphere Application Server and WebSphere Process Server.
• Involved in UNIX shell scripting and configuring cron-jobs.
• Coordinated execution of User Acceptance Testing, regression, System Testing (positive and negative scenarios) and integration testing with multiple departments.
• Used Quality Center as test management tool for storing the automated test scripts from where Scripts can be executed directly by manual testers
• Used SQL and PL/SQL scripts to perform backend database testing.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings
• Write complex SQL queries to validate that actual test results match with expected results
• Check the naming standards, data integrity and referential integrity.
• Responsible for monitoring data for porting to current versions.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).

Environment: HP Quality Center 10, QTP 9.0, Ab Initio, Teradata, SQL Server Enterprise manager, SQL Server query Analyzer, DataStage7.1, SQL Server Management studio PL/SQL, Oracle Database 10g, BM WebSphere Application Server, Informatica Data Director (IDD), Data Modeling, Oracle EBS 11, Control-M, SQL Server, HP ALM, UNIX Shell Scripting, Cognos 8, Windows 2003/2007, Business intelligence (BI), UNIX, SAS.

Confidential, WARREN, NJ

DWH/ ETL Tester

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for ETL Data Validation and Report testing.
• Developed validation steps and SQL using business requirements and rules.
• Identified Test Cases for Automation for repeatable test steps.
• Analyzed the log file for an ETL job in Data Stage Director and reported to developer.
• Interacted with DBA for setting up test environment in Oracle database.
• Executed complex SQL queries using Advanced Query Tool to validate ETL jobs.
• Written complex SQL queries and queried the Oracle database to test Data Stage ETL code.
• Involved in Regression, Functional, Integration and User Acceptance Testing.
• Used Ab Initio components like Reformat, Rollup, Join, Sort, Partition by Key, Normalize, Input Table, Output Table, Update Table, Gather Logs and Run SQL for developing graphs.
• Performed database validation using SQL according to the business rules and specifications.
• Created test data to test the functionality of the DataStage jobs.
• Written complex SQL queries to query DB2 database.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• Enter test script and enter defect into HP quality center.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
• Configuring Informatica MDM platform including IDD.
• Used HP ALM for Test management/Defect Tracking.
• Standardization of rules in Trillium for profiling, matching and cleansing logic.
• Configured messages to be sent to MDM (Master Data Management) in XML format.
• Experienced with UNIX commands like GREP, PS, LS and CHMOD etc.
• Worked with Users to develop Test cases for user acceptance testing.
• Validating the data thru various stages of data movement from staging to Data Warehouse tables.
• Validated business reports like Drill down and Cross Tab reports developed by Cognos.
• Maintained the test logs, test reports, test issues, defect tracking using Clear Quest.
• Involved in preparation of Defect Report using Clear Quest.
• Performed integration and performance testing on DataStage ETL jobs.
• Used Database links in SQL for Querying the Oracle database.
• Attended daily project status meetings and weekly QA status meetings.

Environment: Oracle 10g, DataStage 7.0, HP Quality Center 10, Ab Initio, Informatica, WebSphere, AQT, HP ALM, DB2, UNIX Shell Scripting, Clear Quest, SQL, PLSQL, Cognos 8.0, Business intelligence (BI), Data Modeling, UNIX, Windows XP.