We provide IT Staff Augmentation Services!

Sr Etl Test Lead Resume

Syracuse, NY

SUMMARY

  • Over 7 years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Datawarehouse/ Data Mart Design, ETL, BI, SAS, UNIX & OLAP.
  • Strong working experience on DSS (Decision Support Systems) applications and Extraction, Transformation and Load (ETL) of data from Legacy systems.
  • Extensive experience in SDLC using Agile and Waterfall methodologies.
  • Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica, Ab Initio
  • Worked with databases such as Oracle, SQL Server, DB2 and Teradata and used ETL tools such as Informatica, SSIS, DTS and many different BI tools such as Cognos, Crystal Reports and Business Objects.
  • Worked on different versions of Cognos for Report testingExtensive experience in all phases of STLC.
  • Extensive experience in writing numerous Test Plans, Test Cases, Test Matrix, Traceability Matrix and Test Scripts.
  • Effectively involved in Defect tracking, reporting reviewing and analyzing test result using Quality Center.
  • Experience in using Oracle Databases, DB2 UDB, Sybase, SQL Server, Redbrick, Netezza, and Teradata.
  • Extensive experience in writing SQL to validate the database systems and for backend database testing.
  • Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.
  • Performed ETL (Informatica, Data Stage) testing on DWH and Data Migration projects.
  • Extensive testing experience using Informatica 8.6/8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
  • Involved in Business Intelligence (BI) data/reports validation on Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence) and Cognos.
  • Involved in XML data verification and validations.
  • Highly proactive and able to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame...
  • Excellent Communication, Analytical and Interpersonal skills.
  • Experienced in co-coordinating resources within Onsite-Offshore model

TECHNICAL SKILLS

Mercury Interactive: TestDirector9.0/8.0/7.5, Quality Center10.0/9.2

ETL Tools: Ab Initio CO>Op 2.15, GDE 1.15, Informatica 9/8.6/8.1/7.1/6.1 , SSIS, Data Stage 8.x

IBM Rational Suite: RationalRobot 2003/7.0.2/6.0.0 , Rational Functional Tester 8.0/7.0, Rational Performance Tester 8.0/7.0, Rational Clear Quest 7.1/7.0.1, Rational Clear Case 7.1/7.0.1/7.0.0

Bug Reporting: Rational Clear Quest, Test Director, PVCS tracker, Remedy Tool, MS Access, Bugzilla, Siebel Service Request

Version Control: PVCS Tracker, Rational Clear Case 7.1/7.0.1/7.0.0 , Visual Source Safe 2005, Control Version System CVS

Programming/Scripting Languages: SQL, PL/SQL, XSLT, JCL, HTML, XML

Operating Systems: Windows XP/NT/2000, DOS, Mac 10.4, AIX UNIX, LINUX

Databases: Oracle 10g/9i/8i/7.x, MS SQL Server 2008, UDB DB2 9.xSybase12.5, Teradata V2R6, MS Access 7.0

Reporting Tools: Business Objects6.5, XIR3, Cognos 8 Suite

PROFESSIONAL EXPERIENCE

Confidential, Syracuse, NY

Sr ETL Test Lead

Responsibilities:

  • Tested multiple LOB data feeds for ETL and BI group.
  • Understanding of requirements from the business Analysts for the testing activities.
  • Tested the SQL queries on data staging tables and data warehouse tables to validate the data results.
  • Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants..
  • Responsible for leading team and co-coordinating with offshore team.
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
  • Testing on number of SQL queries to validate the data between sources and targets.
  • Executed number of sessions and batches in Informatica and tracked the log file for failed sessions.
  • Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants..
  • Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
  • Check the naming standards, data integrity and referential integrity.
  • Experience in writing SQL queries, generating reports to ensure data integrity and validating business rules for testing activities
  • Checked the reports for any naming inconsistencies and to improve user readability.
  • Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization.
  • Compared the actual result with expected results. Validated the data by reverse engineering methodology ie backward navigation from target to source.
  • Used Quality Center for defect tracking, test cases, test plan, updating the bug status and discussed with developers to resolve the bugs.
  • Validating the reporting objects in the reporter against the design specification document.
  • Validating the data files from source to make sure correct data has been captured to be loaded to target tables
  • Tested Cognos reports and written test cases using HP Quality Center
  • Validating the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules.
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
  • Initiated the bi-weekly QA-Stat-Meet to discuss the intricacies involved in the application(s) being tested
  • Involved in validating the aggregate table based on the rollup process documented in the data mapping.
  • Functioned as the Onsite / Offshore coordinator and Team Lead
  • Written several complex SQL queries for validating Cognos Reports.
  • Involved in testing the Cognos reports by writing complex SQL queries.
  • Assisted in creating test data and test cases and execute function system tests as needed.
  • Performed Black box Testing, Regression and end-to-end testing.
  • Developed/revised training documentation and procedure manuals.
  • Responsible for running and analyzing quality check reports to ensure system is functioning properly
  • Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.

Environment: Informatica 9, SQL,PL/SQL, HP Quality Center 10, Rational Clear Quest, MS Excel, Cognos 8.0 Series, Teradata 12.0 (Multi-LOAD, Fast-LOAD, FAST EXPORT, TPUMP

Confidential, Jersey City

Sr ETL Test Lead

Responsibilities:

  • Participated in analysis of Business and functional requirements.
  • Developed Test Plan and overall Test Strategy for the Application.
  • Interacted with clients to determine User requirements and goals.
  • Performed functional testing using QTP for end to end application testing.
  • Written SQL scripts to test the mappings.
  • Functioned as the Onsite / Offshore coordinator for a team.
  • Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
  • Tested Ab Initio graphs for data loading
  • Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers
  • Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel.
  • Developed Test Cases and Test Scripts for System and UAT Testing.
  • Performed Positive and Negative Testing for this application.
  • Written complex SQL queries for validating the data stored in different database tables.
  • Performed basic testing of security features using manual testing.
  • Responsible for creating Test Strategy for the Data Warehouse.
  • Involved in creating the design and technical specifications for the ETL process of the project.
  • Tested jobs and used Ab Initio as an ETL tool to load the final loads.
  • Conducted regression testing on the application under test and Debugging the SQL-Statements and stored procedures.
  • Testing the source and target databases for conformance to specifications.
  • Conditional testing of constraints based on the business rules.
  • Identify and request test resources like QA engineers, Software (SW) and Hardware (HW).
  • Tested the Oracle PL/SQL testing programs.
  • Conducted review sessions on test case and regression test scripts in quality center.
  • Used Inner and Outer Joins in order to retrieve and validate the Various Transaction Details from multiple tables.
  • Developed TSL (Test Script Language) for automated Testing using Win Runner. Worked with business team to test the reports developed in Cognos
  • Extensively tested UNIX shell scripts as part of the ETL process, automated the process of loading, pulling the data.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs
  • Tested different detail, summary reports and on demand reports using Report Studio.
  • Reported bugs and tracked defects using Quality Center 9.2
  • 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 ETL Ab Initio graphs and other ETL Processes (Data Warehouse 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.
  • Written several UNIX scripts for invoking data reconciliation.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Used SQL for Querying the DB2 database in UNIX environment.
  • Worked with business team to test the reports developed in Cognos.
  • Tested the Oracle Applications and Portals like Executive Dashboard, Credit Card Online Portal built on Oracle. Used TOAD Software for Querying ORACLE.

Environment: Ab Initio (GDE 1.15, Co>Op 2.15),,Actimize Risk Case Manager 4.7 HP Quality Center 9.2, Oracle 10g, Cognos 7 Series, XML, XSD, Test Cases, Test Scripts, Test Plan, Test Matrix, MS SQL Server 2005/2008, AIX UNIX, Shell Scripting, TOAD, MVS, COBOL II, VSAM, JCL, PERL

Confidential, East Hanover, NJ

ETL/BI/SQL/Data Warehouse Test Engineer

Responsibilities:

  • Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
  • Involved in Business analysis and requirements gathering.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
  • 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.
  • Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
  • Identify the primary key (logical / physical) and put update or insert logic.
  • Deleting the target data before processing based on logical or physical primary key.
  • Design and execute the test cases on the application as per company standards.
  • Preventing occurrences of multiple runs by flagging processed dates.
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Testing of records with logical delete using flags.
  • Interacting with senior peers or subject matter experts to learn more about the data.
  • Identifying duplicate records in the staging area before data gets processed.
  • Extensively written test scripts for back-end validations.
  • Ensured that the mappings are correct and effectively communicate testing activities and findings in oral and written formats.
  • Reported bugs and tracked defects using Test Director 6.5.
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Designing and creation of complex mappings using SCD Type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
  • 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.
  • Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.

Environment: Data stage 7.5, Mercury Test Director 6.5, XML, XSLT, XML Spy, SQL *Loader, Cognos 7.0,Oracle8i, Quality Center,SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7.

Confidential, Tampa FL

ETL/Data Warehouse QA Analyst

Responsibilities:

  • Tested mappings as per the technical specifications approved by the client.
  • Tested various fact and dimension tables which were implemented on Star and Snowflake schema.
  • Extensively used Informatica power center for ETL testing process.
  • Deleting the target data before processing based on logical or physical primary key.
  • Design and execute the test cases on the application as per company standards.
  • Preventing occurrences of multiple runs by flagging processed dates.
  • Test Cases have been written for ETL to compare Source and Target database systems.
  • Worked with all components of Informatica: Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
  • Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings.
  • Also tested for performance of the mappings and SQL performance.
  • Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools. Developed test cases to accomplish ETL data migration.
  • Involved in integration testing of Informatica mappings and entire application.
  • Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Extensively used Cognos for testing the reports generated.
  • Testing of records with logical delete using flags for slow changing type 2.
  • Created reusable transformations and mapplets to use in multiple mappings.

Environment: Informatica Power Center 6.2 (Power Center Designer, workflow manager, workflow monitor, SAS/Macros, SAS/Stat, SAS/Graph, SAS/ODS, SAS/SQL, SAS/Connect, SAS/Access, SAS/ETL, UNIX, Korn, Shell Scripting, Oracle8, Cognos 6.0,SQL Server, Windows 2000

Confidential, Columbus, OH

Test Engineer

Responsibilities:

  • Reviewed the Business Requirement specification Document and the Specification of the application.
  • Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
  • Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
  • Document and publish test results, troubleshoot and escalate issues.
  • Inserted rendezvous points to generate peak load on the server to ensure that the transactions are performed accurately under the scenario.
  • Created test requirements hierarchy to represent the features and functionality that needs to be tested in the application.
  • Performed Manual Testing of the application which involves accounting of various customer accounts using numerous test scripts.
  • Modified and tracked defects using Test Director.
  • Developed Test Objectives, Test Plans, Testing Strategy and Test Procedures.
  • Created manual Test Cases.
  • Worked with developers to test the fixed defects.
  • Defects were tracked, reviewed, analyzed and compared using Test Manager.
  • Assisted the Business in the User Acceptance Test (UAT) testing.
  • Attended weekly status meetings showing progress and future testing efforts to the project manager.

Environment: Windows 2000, ASP, HTML, SQL, PL/SQL, Oracle 8i, MS SQL Server 2000, DTS, Load Runner, and Test Director

Hire Now