We provide IT Staff Augmentation Services!

Senior Etl Tester Resume

3.00/5 (Submit Your Rating)

Charlotte, UsA

SUMMARY:

  • Highly competent, dynamic and organized Senior QA Engineer with over 10 years of experience in software development life cycle, test methodologies and handling end - user communication and coordination with 5 years in leading the project delivery. A versatile Professional possesses a high awareness of practical issues and trends, particularly in regard to accessibility, usability and emerging technologies in the IT industry. Results oriented professional with proven ability of excellence to get results, conduct research, ensure adequate supervision and efficiency. Motivated Individual Seeking Senior QA Engineer Position in this prestigious organization where I can utilize my skills and offer opportunities for personal and professional growth.
  • Implemented ETL Validator tool from datagaps to automate the regression testing.
  • Extensive experience in Requirement Analysis, Design, Development and Testing life-cycle.
  • Strong experience in ETL ( Informatica Power Center 7.1.4, 8.1.x, 8.6.x, 9.1, 9.5, Business Objects), Manual Functional testing and testing of data warehouse / data marts for business applications.
  • In depth knowledge in designing and building of data warehousing components and providing support for User Acceptance Testing and deployment of application.
  • Good analytical, communication and interpersonal skills.
  • Hands on experience in performing Defect triage and doing root Cause Analysis.
  • Expertise in preparing Test Strategy, Test Plan, Test Cases, Test scripts, Test Conditions, Test Data and Test Reports and Traceability Matrix.
  • Ability to learn and support new technologies to adjust the Working environment.
  • Exceptional leadership, management and problem solving skills; able to prioritize and work within tight deadlines and in a fast pace work environment.

TECHNICAL SKILLS:

Tools: Informatica Power Center, Business Objects, HP ALM,SQL Developer

Programming Languages: PL/SQL

Secondary Skills: IBM Tivoli Identity Manager

System Design & Development: Requirements Gathering and Analysis, Data Analysis, ETL Design, Development and Testing, UAT Implementation, Regression Testing/System Testing

Automation Tool: ETL Validator (Datagaps)

Domain: Insurance, Investment Banking

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, USA

Senior ETL Tester

Responsibilities:

  • Regular use of ETL Validator tool from datagaps to automate the regression testing.
  • Troubleshoot, resolve and escalate data related issues and validate data to improve data quality.
  • Gainful interaction with senior peers or subject matter experts to learn more about the data - Ensured that the mappings were correct and conducted data validation testing.
  • Champion the validation of the load process of ETL to ensure the target tables are populated according to the data mapping provided that satisfies the transformation rules.
  • Oversee the writing of complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views and Union in Oracle.
  • Adequately prepared test plans/test schedules with inputs from Project manager and development team.
  • Responsible for testing application by writing SQL Queries.
  • Carefully reviewed the ETL mappings to ensure the transformation rules were applied correctly.
  • Competently tested the entire data reconciliation process for multiple source and target systems.
  • Identified defects in testing environment were communicated to the developers using Quality Center - Defects module.
  • Maintenance of Traceability Matrix for tracking the requirements to the test cases to ensure complete test coverage.
  • Played an active role in designing and preparing Test Scenarios, Test Plans, Test Cases and Test Data.

Environment: Oracle 12, Datastage, ETL Validator, SQL Developer, HP ALM.

Confidential, New York, USA

ETL Test Lead

Responsibilities:

  • Led and managed the overall testing delivery for a project with a team size of eight including two team leads.
  • Preparation of Test Plan/Test Strategy.
  • Gainful interaction with senior peers or subject matter experts to learn more about the data - Ensured that the mappings were correct and conducted data validation testing.
  • Validated the load process of ETL to ensure the target tables were populated according to the data mapping provided that satisfied the transformation rules.
  • Wrote complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views and Union in Oracle.
  • Preparation of test plans/test schedules with inputs from Project manager and development team.
  • Effectively tested the application by writing SQL Queries.
  • Carefully reviewed the ETL mappings to ensure the transformation rules are applied correctly.
  • Masterminded the testing of the entire data reconciliation process for multiple source and target systems.
  • Identified defects in testing environment were communicated to the developers using Quality Center - Defects module.
  • Proper maintenance of Traceability Matrix to track the requirements to the test cases to ensure complete test coverage.

Environment: Informatica 9.1/9.5,Oracle/HP ALM, UNIX, Windows.

Confidential

Application Support Lead

Responsibilities:

  • Successfully designed and built the data warehousing components and provided support for User Acceptance Testing and deployment of application.
  • Prepared WSR, MSR, SDR and other project related documents.
  • Coordination of monthly production runs from offshore.
  • Presented the project matrix to the business stakeholders.
  • Ensured Incidents were resolved within the SLA.
  • Led and managed a team of 8 engineers.
  • Oversaw UAT support for the business.
  • Analyzed data for the identification of root cause for the incidents.

Environment: Informatica, Oracle, UNIX, Windows.

Confidential

Module Lead

Responsibilities:

  • Worked on installation and configuration of ITIM 5.1, 4.6 IBM Directory Server. Test Cases and unit testing of the application.
  • Worked on scenarios for the creation of Identity Policy, Custom Person, Service Selection Policy and Adoption policy.
  • Competently worked on configuration of Life Cycle Rules for password expiration notification.
  • Provided adequate support for production deployments.

Environment: IBM Tivoli Identity Manager 5.1 deployment and customization, Script/Workflow extensions, ITIM workflows, AIX Servers.

Confidential

Team Member

Responsibilities:

  • Coding in J2EE, Oracle and MS SQL for adding new features to the Heartbeat application.
  • Wrote codes in J2EE, Oracle and MS SQL for adding new features to the Heartbeat application.
  • Wrote Test Cases and unit testing of the application.
  • Provided Support for production deployments.
  • Rendered support for UAT.

Environment: SQL Server, Oracle - PL/SQL, J2EE, Windows XP.

Confidential

Team Member

Responsibilities:

  • Spearheaded Effort Estimations for Change Requests/ new enhancements.
  • Played an integral role in the requirements discussion with the Clients/users to understand the Business Logic for specific requests.
  • Charged with the responsibility of Development/Modifications of ETL mappings.
  • Review Design, Deliverables against Business, User Requirements.
  • Effectively designed and built the data warehousing components and provided support for User Acceptance Testing and deployment of application.
  • Responsible for Informatica Administration which involved Informatica migration from 8.1 to 8.6.

Environment: Oracle 9i/10g, Informatica 8.1.1, 8.6.1; PL -SQL Developer, UNIX, Clarify, Windows XP.

Confidential

Team Member

Responsibilities:

  • Active participation in the Requirements Gatherings from the Business.
  • Designed the Informatica Mappings based on the Business requirements.
  • Built New Mappings/Enhancements in the Mappings.
  • Successfully designed and built of data warehousing components and providing support for User Acceptance
  • Ensured proper planning and execution of the Project.
  • Review Design, Deliverables against Business, User Requirements.

Environment: Oracle 9i, Informatica 7.1.4; PL -SQL Developer, UNIX, Windows XP.

We'd love your feedback!