Professional Experience:

• 7 years of solid IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Experience using query tools for Oracle, Teradata, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• 3 years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center 7.1/6.2/5.1 and Power Mart 6.2/5.1 using Designer Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer , Repository Manager, Workflow Manager Workflow Monitor
• Extensive testing ETL experience using AbInitio 2.14, Informatica 8.6/8.1/7.1/6.2/5.1 Power Center/ Power Mart Designer, Workflow Manager, Workflow Monitor and Server Manager
• 5 years of database experience using Oracle 10g/9i/8i, SQL, PL/SQL, SQL Loader, Stored Procedures, Functions, TOAD, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, , Inline Views, IBM DB2 UDB 8.0/7.0 MS Access.
• Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, VSAM Files, Flat files and XML.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos 7.3 Series and Business Objects XI R3
• Solid knowledge and experience in SQL database and writing SQL Queries for backend/database testing.
• Involved in writing and executing test cases, enhancing test scripts, reporting, finding defects and documentation.
• Having excellent understanding of Functional and non-Functional testing.
• Performed Functional, and Regression testing.
• Experienced in ETL Testing, BI Testing, and Data Quality Issues Data Reconciliation process.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in all phases of Software Development life cycle.
• Excellent written and verbal communication skills including experience in proposal and presentation creation.

Technical Skills:

ETL QA Tester

Responsibilities:

• Data quality checking and interacting with the business analysts.
• Good experience in communicating with offshore team
• Communication with the client for weekly status report
• Created test data that includes all scenarios and created several scenarios to test the referential integrity between tables.
• Prepared Test Plan and Testing Strategy for the project.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Tested different detail, summary reports and on demand reports developed by Report Studio.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL Test loads.
• Written several shell scripts using UNIX Korn shell for file transfers and clean up process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Executed SQL statements for data validation to check data integrity, error handling, data redundancy, and data consistency.
• Conducted review sessions on test case and regression test scripts in quality center.
• Promoted Unix/Data Stage application releases from development to QA and to UAT environments
• Written complex SQL statements for data reconciliation including comparing record counts between source data, data loaded to the warehouse and rejected records.
• Reported bugs and tracked defects using Quality Center
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in data warehouse testing by checking ETL procedures/graphs.
• 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

• Tested the messages published by data stage and data loaded into various databases
• Strong ability in developing advanced and complex 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
• Tested various Mappings using Aggregator, Joiners, Lookups, Filters, Router and Update strategy
• Unit testing performed on Mappings.
• Tested the ETL process for both before data validation and after data validation process.
• Tested with Front-end functionality for the entire application
• Involved in validating both functional and automated business processes using HP Quality center.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance

Environment: Data stage, UNIX, Shell Scripting, Teradata 12.0, T-SQL, Teradata SQL Assistant 12.0, MLOAD, FLOAD, FEXPORT, TPUMP, BTEQ, SAS/Base 9.1, SQL, PL/SQL, Quality Center 10.0, Oracle 10g, Cognos Series 8.0, Report Net, Impromptu, Report Studio, SQL Server 2008, CA Erwin 7.x, UNIX, Windows 2000, TOAD, WinSQL, Ultra Editor, XML Spy 2010, XSD, XML

Confidential

ETL QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2
• Tested/Found the defects in universes and reports. Used Mercury Quality Centre for tracking the defects.
• Extensively used Data Stage for extraction, transformation and loading process.
• Validated parent-to-child relationships in the data. Set up data scenarios that test how orphaned child records are handled.
• Validated and corrected the dependency fields and check the same values against lookup tables.
• Tested all data reports published to Web including dashboards, summarized, master-detailed and KPI's.
• 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.
• Extracted Data from Teradata using Data Stage ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
• Responsible for testing the reports according to client's requirement using Business Objects 6.5.1.
• Created Short-cut joins, aliases and contexts to make the universe loops free.
• A test reporting environment was established to combine Distribution Work Management and PeopleSoft information into a consolidated place to allow combined reports to be generated.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Tested and worked on creating open document reports for business.
• Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Used various Functions like Prompt for user defined queries , Where For creating conditional filters , and Select for testing Business Reports with various boundary conditions.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Used Quality center to manage the requirements, test cases and also log defects and generate defect reports and graphs
• Performed Data validity testing for reports and feeds based on client's requirement.
• Validated format of the reports and feeds.
• Effectively communicate testing activities and findings in oral and written formats.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Used Quality Center to create manual and automated tests, build test cases, Test cycles, run tests, report and track defects.
• 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.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Defects tracking, review, analyze and compare results using Quality Center.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Data Stage, SQL Loader, Quality Center, Business Objects XIR2, PL/SQL, SQL, Stored Procedures, Test Cases, Test Scripts, Test Plan, XML, XSLT, XML Spy 2008, Oracle 10g/9i, SQL Server 2005, Erwin 3.5/4.1, Windows 2000, TOAD 7

Confidential

ETL Test Engineer

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.

• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Lead team of 6 people in Quality Assurance Team.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested complex mappings using mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
• Conducted back to back meetings with developers and discussed about all open issues.
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System ETL Mapping Document for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Environment: Informatica Power Center 6.1, Quality Center ,Windows NT, Micro Strategy, Oracle 8i, SQL Server, SQL, PL/SQL, SQL Plus, Toad, VSAM Files, XML, XSD

Confidential

DW Developer

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Implemented Materialized Views using P/SQL for loading extended tables
• Tested logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Tested Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Used shell scripts for automating the execution of maps.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Created and tested various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Designed and Deployed UNIX Shell Scripts.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.

Environment: Informatica 7.1.1, DB2, Teradata, Toad, Erwin 3.0, SSRS, SSAS, XML Files, Oracle 8i and Toad