We provide IT Staff Augmentation Services!

Sr. Etl Tester Resume

Boston, MA

SUMMARY:

  • I have over 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.
  • Extensive testing ETL experience using Ab Initio 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.
  • Extensive knowledge and experience in producing tables, reports, graphs and listings using various SAS procedures and handling large databases to perform complex data manipulations.
  • Experience in testing and writing SQL and PL/SQL statements.
  • Experience in designing the database and data elements associated with the database
  • Worked on managing large and complex data sets, extracts, clean and format data for Data Analysis using MS Excel, MS SQL etc.
  • Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
  • Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects.
  • Strong with Mercury Test Director & Quality Center for Planning, Maintaining, Executing Test Cases, Defect Management, Bug Tracking and QTP 9.2 for 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 analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
  • Extensively worked on MS Access, MS Excel, Power Design, MS Visio, MS PowerPoint, MS Project, and SQL.
  • Excellent written and verbal communication skills including experience in proposal and presentation creation.

TECHNICAL SKILLS:

ETL Tools: Ab Initio, (GDE 1.15, Co>Op 2.15), EME, Data Profiler, Informatica 8.6.1/8.1/7.1/6.2/5.1, SSIS, Data Stage 7.5

Data Modeling: Erwin 7.3, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 10g/9i/8i, MS SQL Server 2008/2005, DB2 8.x, Teradata 12.0, Sybase 12.5, MySQL

BI/OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XI R3/R2/6.x/5.x

Languages: SQL, PL/SQL, Unix Shell Script, Visual Basic, XML, PERL

Tools: Toad, SQL* Loader, WinSQL, Teradata SQL Assistant

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: QTP, WinRunner, LoadRunner, Quality Center 9.2, Test Director, Rational Clear Quest

Version Control: Rational Clear Case, CVS, VSS, PVCS

WORK EXPERIENCE:

Confidential, Boston, MA

Sr. ETL Tester

Responsibilities:

  • Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
  • Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
  • Managed multiple OLAP and ETL projects for various testing needs.
  • Debugging the SQL-Statements and stored procedures for various business scenarios.
  • Written extensive PERL and UNIX Shell scripting for data parsing and text parsing needs including archiving the old data, running backend jobs & setting up of job dependencies.
  • Performed extensive Data Validation, Data Verification against Data Warehouse
  • Loading Flat file Data into Teradata tables using Unix Shell scripts.
  • As a ETL Tester responsible for the business requirements, ETL Analysis, MVS, ETL test and design of the flow and the logic for the Data warehouse project using Informatica, Shell Scripting & PERL
  • Used Mercury Quality Center tool to store and maintain the Test cases
  • Tested several Cognos Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s and Web Reports.
  • Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
  • Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages.
  • Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
  • Tested several Informatica Mappings to validate the business conditions.
  • Testing the source and target databases for conformance to specifications
  • Conditional testing of constraints based on the business rules
  • Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center.
  • Created public folders, private folders, personalized pages and custom views on the Cognos connection portal.
  • Used Quality Center for writing and executing Test Scripts.
  • Distributed the reports to the users via Cognos Connection.
  • Compared query result sets from different database systems using UNIX diff command.
  • Designed and prepared scripts to monitor uptime/downtime of different system components
  • Preventing occurrences of multiple runs by flagging processed dates.
  • Preparation of various test documents for QA process in Quality Center
  • 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

Environment: Informatica 8.6.1/8.1, XML, XSLT, PERL, WinSQL, SQL Server 2008, QTP, Quality Center 10.0, DTS, T-SQL, SQL, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 9i/10g, PL/SQL, MVS, IBM DB2, SAS, Cognos ReportNet8.0, MS Access/Excel/Visio, UNIX Shell Scripting

Confidential, Charlotte NC

ETL/SQL Tester

Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Tested/Found the defects in universes and reports. Used Mercury Quality Centre for tracking the defects.
  • 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 graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
  • 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.
  • Created Short-cut joins, aliases and contexts to make the universe loops free.
  • Involved in installation of Business Objects XI R2 and assisted in creating users and assigning them appropriate access rights
  • Report defects using Quality Center and interact with developers to resolve any defects/issues.
  • 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.
  • 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.
  • Written complex joins to validate query performance on large database volumes and worked with business users for acceptable performance criteria for each query.
  • Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing
  • Performed Data validity testing for reports and feeds based on client's requirement.
  • Validated format of the reports and feeds.
  • Planned, coordinate and execute Business Objects deployment for End-users and documented the entire project.
  • Responsible for testing the reports according to client’s requirement using Business Objects.
  • Effectively communicate testing activities and findings in oral and written formats.
  • Worked with ETL group for understanding Ab Initio graphs for dimensions and facts.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • 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.
  • Validated cube and query data from the reporting system back to the source system.
  • Tested analytical reports using Analysis Studio

Environment: Ab Initio (GDE 1.14, Co>Op 2.14), EME, SQL *Loader, Business Objects XIR2, Quality Center, PL/SQL, SQL, Stored Procedures, Test Cases, Test Scripts, Test Plan, XML, XSLT, XML Spy 2008, Oracle 10g/9i, Quality Center, SQL Server 2008, Erwin 3.5/4.1, Windows 2000

Confidential, Jersey City, New Jersey

ETL/QA Tester

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.
  • 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.
  • Performed defect tracking and test case management by Mercury Quality Center 8.2.
  • 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 7.1, Quality Center 8.2, Windows NT, Micro Strategy, Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, Toad, VSAM Files, XML, XSD

Confidential, California

ETL/QA SQL Tester

Responsibilities:

  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
  • Written complex SQL queries for querying data against different data bases for data verification process.
  • Designed the data flow diagrams using MS VISIO.
  • Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
  • 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
  • Worked with SSIS system variable, passing variables between packages.
  • Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
  • Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
  • Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
  • Written Test Plans and Test Cases on Mercury’s Test Director Tool.
  • Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
  • Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
  • Designed and supported SQL 2000 Reporting services, Integration services and Analysis services.
  • Creating test cases for ETL mappings and design documents for production support.
  • Scheduling and automating jobs to be run in a batch process.
  • 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.
  • Worked on issues with migration from development to testing.
  • Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
  • Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

Environment: Informatica Power Center 6.1 (Power Center Designer, workflow manager, workflow monitor), PERL, UNIX Shell Scripting, Hyperion, Mercury Test Director 6.5, QTP 7.2, SQL *Loader, Cognos 7.0, Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, Teradata V2R4

Confidential, Bethpage, NY

ETL Test Analyst

Responsibilities:

  • Writing test plans and test scripts
  • Written complex SQL queries.
  • Coordinating with user to gather the new requirements and working with existing issues.
  • Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications
  • Performed testing in mainframe environment
  • Recorded Testable and Non Testable requirements in spreadsheet.
  • High Level Test Case Design and writing detailed test cases
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Involved in functional, system, integration and performance testing.
  • Assigned defects to developers through Test Director.
  • Updated the defects status in Test Director.
  • Reported periodic project status and updates to the QA Lead and QA Manager
  • Heavily involved in interacting with UNIX Shell scripts

Environment: Windows NT/2000, Oracle 8i, SQL, PL/SQL, XML, PERL, UNIX, Manual Testing, Test Director 8.0.

Hire Now