We provide IT Staff Augmentation Services!

Etl/qa Tester Resume

Worcester, MA

SUMMARY:

  • 7+ years of IT experience in the Analysis, design, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, UNIX & OLAP
  • Good exposure to various SDLC models including Agile (Scrum), Waterfall models.
  • Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes
  • 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.
  • Proficient experience in different Databases like Oracle, SQL Server 2008, DB2, Sybase and Teradata.
  • Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica
  • Experience in QC (ALM), Jira, TFS for defect management, defect tracking and bug reporting.
  • Well Versed in GUI application testing. Database testing and Front-end testing
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
  • Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to the varied needs of the people involved
  • Ability to mentor new resources and help to get into current pace in the project.

TECHNICAL SKILLS:

Data Warehousing: Informatica 9.5/9.1/8.6.1/8.1/7.1/6/5.1.1/1.75 , Data Stage, Ab Initio, SSIS

Reporting Tools: Cognos 8.0 Suite, Business Object XI 3.1, Crystal Reports, OBIEE, SSRS, MicroStrategy 8.x

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, Fact and dimension tables, Pivot

Tables, Erwin

Testing Tools: HP ALM/QC, Jira, Win Runner, Load Runner, Test Director, Quality Center, Rational Tools

RDBMS: Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2005/2008, UDB DB2, Sybase, Teradata V2R6, MS Access 2008

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQLTOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, .NET, Java, J2EE, XML, XSD, XSLT

Environment: UNIX, MVS, IBM AIX 4.2/4.3, Hyperion, Win 3.x/95/98, NT 4.0

PROFESSIONAL EXPERIENCE:

Confidential, WORCESTER, MA

ETL/QA TESTER

RESPONSIBILITIES:

  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Testing business reports developed in Cognos.
  • Expertise in Developing SQL Packages, Stored Procedures/Functions, triggers.
  • Managed test sets and status reports for each release using ALM\HP Quality Center
  • Involved in testing of Universes from different data sources like Oracle/SQL Server
  • Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
  • Working in Agile environment attend daily stand up, sprint planning, backlog grooming refinement and retrospective meeting.
  • Extracted Data from using Informatica Power Center ETL and DTS Packages to the target including SQL Server and used the data for Reporting purposes
  • Created public folders, private folders, personalized pages and custom views on the Cognos connection portal
  • Solid Back End Testing experience by writing and executing SQL Queries.
  • Reported bugs and tracked defects using Quality Center/ALM
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata
  • Managed and executed the test process, using Agile Methodology
  • Extensively used Informatica client tools
  • Distributed the reports to the users via Cognos Connection
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.

ENVIRONMENT: INFORMATICA, COGNOS, SQL, HP/ALM QUALITY CENTER, ORACLE, TERADATA, AGILE.

Confidential, PEQUTO LAKES, MN

ROLE: ETL TESTER

RESPONSIBILITIES:

  • Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
  • Written several complex SQL queries for validating Cognos Reports
  • Tune ETL Jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center
  • Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle
  • Responsible for different Data mapping activities from Source systems to Teradata
  • Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process
  • Used various checkpoints in the Informatica designer to check the data being transformed
  • Worked with business team to test the reports developed in Cognos
  • Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
  • Used Quality Center to track and report system defects
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle
  • Queried Teradata Database and validated the data using Sql Assistant.
  • Implemented Agile (Scrum) QA methodologies
  • ENVIRONMENT: INFORMATICA, COGNOS, SQL, HP/ALM QUALITY CENTER, ORACLE, TERADATA, AGILE.

Confidential, BETHPAGE, NY

ETL/SQL TESTER

RESPONSIBILITIES:

  • Wrote complex SQL and PL SQL queries for validating Data Stage jobs loading functionalities with available requirement spec and business rules
  • Validated various MicroStrategy reports such as ad hoc, grids, graphs.
  • 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
  • Tracked the defects with application teams and assisted in closure using Jira.
  • Written complex SQL queries and queried the Oracle database to test ETL code.
  • Used SQL for Querying the DB2 database in UNIX environment
  • Implemented various builds using Agile development
  • Extensively used ETLmethodology for supporting data extraction, transformations and loading processing, in a corporate-wide- ETL Solution using ETL tool like Data Stage
  • Tested both conditional formatting and threshold level testing for several reports developed in Microstrategy
  • Worked with Unix for file manipulations, text processing, data parsing and Converted SQL queries results into Unix variable
  • Used Jira for maintaining the Test Cases and Test Scripts for the application
  • Extracted data from various sources like Oracle, flat files and SQL Server
  • Involved in extracting source data from DB2, Flat Files on different systems
  • In depth knowledge of Agile and Waterfall development methodologies.
  • Used Data Stage to move data to the using the stored Procedure thereby enabling faster Moment of data.

ENVIRONMENT: DATA STAGE, MICRO STRATEGY, SQL, JIRA, ORACLE, DB2, AGILE.

Confidential

ETL TESTER

RESPONSIBILITIES:

  • Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
  • Extensively used MicroStrategy for report generation
  • Performed back-end testing, table manipulations of relational systems by writing complex SQL queries manually
  • Involved in presentation on JIRA on how address the defects and resolve it
  • Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
  • Written Complicated SQL queries in DB2 for Update Dimension Tables, Export Data from Target tables etc
  • Reviewed the test activities through daily Agile Software development stand-up meetings.
  • Wrote complex SQL and PL SQL queries for validating Data Stage jobs loading
  • Involved in testing all the reports that were generated through MicroStrategy
  • Used JIRA for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency
  • Strong in writing complex SQL queries to profile and analyze the data in Oracle 10g
  • Involved in all phases of the STLC, with timely delivery against aggressive deadlines, with QA methodologies such as Waterfall, Agile, etc.
  • Performed extensive Database Testing by writing complex SQL Queries in DB2 to test the different scenarios in the application

ENVIRONMENT: DATA STAGE, MICRO STRATEGY, SQL, JIRA, ORACLE, DB2, AGILE.

Hire Now