Professional Summary

• Over 7 years of IT experience and more than 7 years of experience in roles of ETL Tester, BI Tester, ETL Developer on Informatica using Oracle 11g/10g/9i/8i, SQL Server, DB2, Netezza, SQL, PL/SQL, Toad 8.6/7.6, Stored Procedures, SQL Loader, SQL Assistant.
• Comprehensive experience in data warehouse/data mart lifecycle involving design, development, maintenance, support, analysis and documentation, developing business intelligence and in reviewing ETL workflows.
• data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and
• dimension tables, Normalization, Physical and Logical data modeling using Erwin 4.5/4.
• Involved in Full life cycle analysis, design, networking, design, development and deployment of ETL applications.
• Highly proficient in large volume data migration to Enterprise Data Warehouse using Data pump, Oracle Export, Import, SQL Loader modules.
• Proficient in requirements gathering, systems design, user-interface design, application architecture.
• Created Mappings using various Slowly Changing Dimensions to load into dimension tables.
• Proficiency as technical consultant in providing CRM solution with excellent business domain experience.
• Working knowledge of Software methodologies Capability Maturity Model CMM .
• Was involved in setting up the test environment, created test data as per the requirement.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, Teradata, Ms Access, Flat files into a staging area
• Good working experience on testing ETL, Reference Data and BI
• Proficient experience in different Databases like Oracle, SQL Server 2008, DB2, Sybase and Teradata
• Experience in testing and writing SQL and PL/SQL statements.
• Effectively used various commands to run the Informatica mappings in the UNIX Scripts.
• Worked with different data sources like Mainframes, Flat files, XML files, and other relational and non-relational databases.
• Ability to multi-task and provide expertise for multiple development teams across concurrent project tasks.
• Dedicated to maintain high quality standards and strong domain knowledge.

Technical Skills:

Professional Experience

Confidential

ETL Tester

Responsibilities:

• Responsible for writing Test Cases, Test Plans, Test scripts and other test documents based on business requirement.
• Responsible for data validation testing using SQL and executing testing on data Warehousing projects.
• Responsible for developing detailed UAT test plans, conditions, scenarios, cases and related data and participate in UAT planning and execution activities for business and operations participants.
• Determined the level of testing required validating new or revised system capabilities.
• Developed Test Plans and developed Test Cases/Test Strategy with input from the assigned business analysts and data architect.
• Participate in weekly meeting with the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested the ETL Informatica mappings and other ETL Processes Data Warehouse Testing
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Reviewed Business Requirements, System Specs and Training Material for accuracy. Planned, developed and executed test plans, including detailed test scripts.
• Experience in testing and writing SQL and PL/SQL statements.
• Used Informatica ETL tool for Extraction, Transformation and Loading the data into target database.
• Tested ETL Packages, Scripts from development to QA environment.
• Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Developed test reports and participated in testing prioritization and archived test results and user signoff.
• Involved in extensive data validation using SQL queries and back-end testing

Environment: Informatica Power Center 8.6.1, Ultra Edit, Oracle 10g, PL/SQL, Teradata 13.0, Teradata Parallel Transporter, HP Quality Center 10, XML Files, Flat Files, VSAM Files, MVS, JCL, Copy Books.

Confidential

Role: Informatica Developer

Responsibilities:

• Identified the Business, Data requirements and converting them into conceptual and data models.
• Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular dimensions and FACT tables.
• Creating and running Sessions Batches using Work flow Manager to load the data into the Target Database.
• Using Informatica Repository Manager, maintained all the repositories of various applications, created users, user groups, security access control.
• Extensively worked on Database Triggers, Stored Procedures, Functions and Database Constraints optimized for maximum performance.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Aggregations, Expression, Joiner, Lookup, Filters, Sequence, Router and Update Strategy.
• Designed and developed Informatica Mappings, applets, Sessions, Work flows and Work lets for data loads and data cleansing.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Developed STAR Schema's including identifying FACTS and Dimensions and Designed tables.
• Written Unix Shell Scripts for getting the data from all systems to the data warehousing system. The data was standardized to store various business units in tables.
• Analyzed the sources according to Business rules and developed Validation Database.
• Managed the Meta data associated with the ETL processes to populate the Data Warehouse.
• Worked on Work flow Manager Tools Task Developer, Work flow Designer Work let Designer.
• Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica work flow manager.
• Identified and tracked the slowly changing dimensions on heterogeneous Sources.
• Tested the target data against source system tables by writing some QA Procedures.
• Functional and regression testing for deploying applications.
• Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches.

Environment: Informatica 7.1.3, Business Objects 6.1,web intelligence 2.6, web intelligent SDK, ZABO, JSP, Oracle 9i,Teradata Bteq, SQL Loader, Unix Shell Scripts, SUN Solaris, PL/SQL, SQL Server, Tera data V2R5, Toad

Confidential

DWH/ETL/SQL Test Analyst

Responsibilities:

• Developed data quality test plans and manually executed ETL and BI test cases.
• Understood the business functionality in detail.
• Tested entire ETL flow from source 2 target.
• Developed FTP for use by testing team during their testing process.
• Understood the various process plans, business processes, and functionality in detail.
• Initiated knowledge sharing sessions to help circulate the existing knowledge better among the teams.
• Prepared the Integration Plan used by functional and development teams.
• Tested Slowly Changing Dimensions SCD Type 2.
• Created tested reports using Business Objects functionality like Queries, Slice and Dice.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Tested several data migration application for security, data protection and data corruption during transfer
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Responsible for different Data mapping activities from Source systems to Teradata
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Worked with the DW Architecture team in Testing complex Delta processing Loads
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Involved in creating source target mappings based on the Technical Design requirements.
• Used different sources for Input.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
• Performed a detailed testing on the business application.
• Discussed with the team members while Unit/System Integrity Testing.
• Interacted with the Business Analyst while integrity checks and UAT.
• Functional and regression testing for deploying applications.
• Testing of Universe and Reports, which includes Database connectivity

Environment: Sun Solaris, Oracle 9x, Erwin, Informatica power center 8.x, UNIX, DOS, Netezza, HP Quality Center, Test Director, SQL, PL/SQL, XML Files, VSAM Files, MVS, TOAD, Putty, Autosys, Teradata V2R5

Confidential

DWH Tester

Responsibilities:

• Developed data quality test plans and manually executed ETL and BI test cases.
• Designed and kept track of Requirement Traceability Matrix
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Worked with the co-testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Used Quality Center for defect tracking.
• Performed data quality analysis using advanced SQL skills.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading ETL .
• Involved in testing data mapping and conversion in a server based data warehouse.
• Tested the Data Completeness, Data Transformation, Data Quality, UAT, And Integration Regression Testing for ETL and BI applications.
• Tested several Micro Strategy Reports.
• Extensively used the Report Inspector tool to change, multiple reports database schemas, scheduling multiple reports, deploying and publishing.
• Testing the reports and maintenance of daily, monthly and yearly.
• Responsible for writing Test Cases, Test Plans, Test scripts and other test documents based on business requirement.
• Responsible for data validation testing using SQL and executing testing on data Warehousing projects.
• Responsible for developing detailed UAT test plans, conditions, scenarios, cases and related data and participate in UAT planning and execution activities for business and operations participants.

Environment: Informatica Power Center 8.1, Oracle 10g, PL/SQL, Erwin 3.5, Sun Solaris, TOAD, SQL Navigator, CRM, UNIX. MicroStrategy 8.0, HP Quality Center 9.2, SQL, IBM AIX, Shell Scripting, Autosys, putty, IBM AIX 5.5, IBM DB2, WinSQL

Confidential

Responsibilities:

• Identified the Business, Data requirements and converting them into conceptual and data models.
• Interacted with the end users for gathering requirements and for business specification.
• Analyzed existing OLTP systems.
• Worked with Business Analysts and the DBA for requirements gathering, business analysis, designing BRD documents and designing of the data ware house using agile methodology.
• Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin
• Loaded data from oracle to Netezza using Informatica power exchange for Netezza and flat files using NZload utility.
• Extensively used NZadmin for checking the SPU small units failures, viewing the SQL plan and current statistics and generating statistics for the table.
• Created complex queries, views and Materialized views in Netezza.
• Performed DBA activities like managing workload, migrating data from one database to other.
• Also created stored procedures in Netezza using NZsql.
• Made effective use of utilities such as NZmigrate, NZreclaim and NZload.
• Involved in tuning NZ queries.
• Extensive expertise in Extracting and Loading data to various databases including Oracle, Netezza,Flat files and XML files.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Performed DBA activities like managing workload, migrating data from one database to other.
• Assist clients in managing project scope, risk, resources and budget.
• Performed Unit/System, Stress, and Integration testing with user groups.
• Involved in promoting universes to UAT and Production Support.
• Participated in the preparation of project plan.
• Functional and regression testing for deploying applications.