We provide IT Staff Augmentation Services!

Etl Tester Resume

SUMMARY

  • 5+ years of experience in Software Testing of web based and client server applications.
  • Experience in testing on web based, Client/Server and data warehousing applications.
  • Well - versed with stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Professional experience in Integration, Functional, Regression, System Testing, UAT Testing, Black Box and GUI testing.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
  • Knowledge in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
  • Tested the ETL mappings and other ETL Processes (Data Warehouse Testing).
  • Collaborate with the business customers to define business requirements, test scenarios, and launch plans.
  • Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
  • Experience in using JIRA,and HP Quality Center for Bug Tracking and Defect Reporting.
  • Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement.
  • Solid understanding of source to target data mapping
  • Experienced with HP ALM/ HP Quality Center Administration.
  • Excellent verbal and written communication skills
  • Highly analytical with strong critical-thinking and problem-solving abilities
  • Extensively worked with Parallel Extender for splitting bulk data into subsets to distribute the data to all available processors to achieve best job performance.
  • Extensive experience and well versed with UNIX (shell) commands, Maintained and modified Shell scripts.
  • Good understanding in extracting data from different sources like AS400/DB2, data directly from various source databases and flat files.
  • Extensive experience in writing complex queries and tuning queries
  • Strong working experience in designing DataStage job scheduling outside the DataStage tool and also within the tool as required by Client/Customer company standards
  • Have hands on in stages like Lookup, Join, Merge, Lookup file set, Dataset, Row generator, Column generator, Funnel, Peek, Transformer, Change capture, Remove duplicate, External filter, Sort, Head, Tail, BASIC Transformer, ODBC/ Teradata/DB2 Connectors, Oracle Enterprise stage, Copy, etc.
  • Experience in integration of data from various data sources like DB2, Oracle, Netezza, Teradata, AS400, Universe, MS SQL server, Web Services and XML files.
  • Have hands on in all Sequence activities and DS- containers.
  • Created, updated and reviewed SDLC life cycle documents like Functional requirement specification, Software development specification, Test Strategy, Test Specification, Change Request, Impact Analysis, etc.
  • Version Control software is used to Version/release the ETL jobs from various projects to UAT, SIT and Production phases of project. UNIX scripts, documentation and exported copies of ETL jobs (dsx) are versioned.
  • Worked with data feeds from various source systems from flat files, XML files, Teradata server databases
  • Experience in creating required documentation for production support hand off, and training production support on commonly encountered problems, possible causes for problems and ways to debug them.
  • A hardworking individual with strong analytical, problem solving and excellent communication skills.

TECHNICAL SKILLS

ETL Tool: IBM Information Server (DataStage) 8.7/9.1/11.5 DesignerManager, Director, Administrator, Parallel Extender), Quality Stage/ Integrity, Metastage and Informatica Power Center 9.6.1/ 9.1.

Data Base: Teradata V2R6/V13, Oracle 11g,MS SQL Server 2000, DB2 UDB 7.0/8.0/9.7, AS400, MS Access 97/2000.x

Programming: UNIX Shell Scripting, SQL, PL/SQL, HTML.

Operating Systems: UNIX, Windows

Languages: SQL, PL/SQL, Shell Scripting, Perl Scripting

Other Tools: Toad, Win SQL, PVCS Tracker, SQL Tools 1.4, Informatica Power Exchange 8.6.1, FastLoad, MultiLoad, iSeries Navigator, DB Visualizer, DB2 AS/400, Microsoft Visio Professional 5.0/2002.

Scheduling Tools: Control- M, Autosys and Tivoli

Methodologies : Star Schema, Snowflake Schema

Operating Systems: UNIX, LINUX, WINDOWS 2008/2005/2000/ XP

PROFESSIONAL EXPERIENCE

Confidential

ETL Tester

Responsibilities:

  • Collaborate with the business customers to define business requirements, test scenarios, and launch plans.
  • Involved in detail design and development of jobs using DataStage Designer.
  • Based on the Business requirements developed DataStage jobs for transformation and cleansing of data.
  • Provide in-depth data analysis & design, creation of testing strategies, project estimation, and analysis of issues during User Acceptance Testing (UAT).
  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Analyzing requirements and creating and executing test cases
  • Involved in ETL process testing using Datastage ETL tool.
  • Performed Integration, End-to-End, system testing
  • Involving in Functional Testing & Regression Testing
  • Proficient in creating and maintaining documentation related to Technical design and specifications, Business rules, Data mappings, ETL processes and Testing.
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems.
  • Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
  • Experience assessing testing processes, creating and implementing testing strategies in UAT phase.
  • Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
  • Preparing documentation for some of the recurring defects and resolutions and business comments for those defects
  • Incorporating Agile Methodologies to showcase the changing requirements from the business and implement the design accordingly to reflect in Management Information Systems (MIS).
  • Extensive experience and well versed with UNIX, Shell commands, Maintained and modified Shell scripts.
  • Strong working experience in designing DataStage job scheduling outside the DataStage tool and also within the tool as required by Client/Customer company standard.
  • Version Control software is used to Version/release the ETL jobs from various projects to UAT, SIT and Production phases of project. UNIX scripts, documentation and exported copies of ETL jobs (dsx) are versioned.
  • Defining test cases, executing test cycles, documenting unit test&system integration test results.
  • Experience in creating required documentation for production support hand off, and training production support on commonly encountered problems, possible causes for problems and ways to debug them.

Environment: : IBM InfoSphere Datastage 9.1, 11.5 (Administrator, Director, Designer, Quality Stage, Parallel Extender), Informatica, HP Quality Center, Rational Clear Case, Teradata, SQL Server, DB2, Oracle, AS400, Winscp, AccuRev, Putty, Autosys, Share Point.

Confidential

ETL Tester

Responsibilities:

  • Created, updated and reviewed SDLC life cycle documents like Functional requirement specification, Software development specification, Test Strategy, Test Specification, Change Request, Impact Analysis, etc
  • Design and development of Extract, Transform, and Load (ETL) processes for extracting data from a various legacy systems and loading into target tables using SQL, DataStage Enterprise Edition.
  • Analyzed application data using the SQL to identify the ETL processes
  • Worked with data analysts to implement Informatica mappings and workflows and stored procedures to meet business requirements.
  • Performing backend testing of the DB by writing SQL queries to test the integrity of the application and Oracle databases.
  • Coordinating user acceptance testing activities for business groups and IT.
  • Monitor process and software changes that impact production support, communicate project.
  • Information to the production support staff and raise production support issues to the project team.
  • Prioritize workload, providing timely and accurate resolutions.
  • Provide daily support with resolution of escalated tickets and act as liaison to business and technical leads to ensure issues are resolved in timely manner.
  • Participate in knowledge transfer to ensure better grasp of the product and domain.
  • Suggest fixes to complex issues by doing a thorough analysis of root cause and impact of the defect.
  • Coordinate with Application Development Team to successfully deploy software releases in both User Acceptance Testing and Production environments
  • Extensively used File set stage like Sequential file for extracting and reading data.
  • Using the advanced techniques in the jobs to improve the performance.
  • Involved in analyzing and modifying the existing scripts
  • Coordinated the code and data movement to production in production implementation activities. Also involved in the effort of integration testing of Datastage and shell code with scheduler.
  • Defined test cases as a part of user testing and drove testing cycle execution of both SIT and UAT. Also documented the results for test cycles.
  • Identified, resolved source file format issues for production loading & data quality.
  • Enhancements are made to jobs as per the requirements and Unit testing of the jobs. Fix the QA defects within the time lines.

Environment: Teradata, InfoSphere Datastage 8.7 (Administrator, Director, Designer, Quality Stage, Parallel Extender), Informatica, HP Quality Center, SQL, Unix, Oracle 11g, Putty, Tivoli scheduler, Subversion.

Confidential

ETL Tester

Responsibilities:

  • Created, updated and reviewed SDLC life cycle documents like Functional requirement specification, Software development specification, Test Strategy, Test Specification, Change Request, Impact Analysis, etc
  • Understanding the entire business flow of the project form beginning to ending.
  • Having adequate knowledge on quality stages that are used in the existing jobs. Using Sequential file, DB2, Join, Lookup, transformer, datasets, filter, Merge, Sort, remove duplicate stage for designing the jobs in the Data Stage Designer.
  • Creating connection to databases like SQL Server, oracle and application connections
  • Extensively used File set stage like Sequential file for extracting and reading data.
  • Using the advanced techniques in the jobs to improve the performance.
  • Involved in analyzing and modifying the existing scripts
  • Coordinated the code and data movement to production in production implementation activities. Also involved in the effort of integration testing of Datastage and shell code with scheduler.
  • Job properties and environment variables were edited for performance tuning and ease of implementation.
  • Defined test cases as a part of user testing and drove testing cycle execution of both SIT and UAT. Also documented the results for test cycles.
  • Uploaded test cases executed test cases and logged defects in Quality Center.
  • Documented and tracked test scripts, test results, test analysis and reported the defects using Quality Center.
  • Identified, resolved source file format issues for production loading & data quality.
  • Enhancements are made to jobs as per the requirements and Unit testing of the jobs.
  • Fix the QA defects within the time lines.
  • Involved in production support activities.

Hire Now