We provide IT Staff Augmentation Services!

Etl Test Lead Resume

Chicago, IL

SUMMARY:

  • Over 8+ years of experience in Functional testing on web based, Client/Server and data warehousing applications across business domains of Banking and Retail.
  • Good experience in Testing as ETL/Functional Test Lead, UAT Coordinator, Sr. Test Analyst, Data Analyst and created test deliverables like Test Plan, Test Strategy, Defect Reporting, Project Metrics and Test Closure .
  • Extensive experience in ETL/ Data warehouse backend testing and BI reports testing.
  • Extensive expérience in Functional, Régression, Intégration, Reports, UAT, Black Box and GUI Testing .
  • Extensive experience with ETL tools (Ab - Initio/Datasatge), Databases (Teradata, Oracle, SQL Server)
  • Knowledge in Big Data Hadoop ( Hive, Sqoop ).
  • Good knowledge of Data warehousing concepts. Created ETL mapping rules and test data to test the functionality.
  • Experience in creating Regression environment (prod-like) to meet the needs of baseline testing. Manage the test environments, Database to support SIT/UAT testing.
  • Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Experience in testing web services using SAOP UI tool.
  • Strong understanding of Agile Scrum and Waterfall SDLC methodologies.
  • Experienced in analysing Business Specifications and estimating the testing effort by analysing the requirements.
  • Client Engagements, Contract Negotiations and Resource Augmentation for Project Management.
  • Planning, scheduling, and monitoring projects.
  • Extensive Experience in using HP Quality Centre/ALM/JIRA for Bug Tracking and Defect Reporting.
  • Participating in Reviews for External Design Document and Functional Spec.
  • Co-ordinate with multiple teams for End-End or System Integration testing.
  • Inter-group co ordinations between Testing and Solutions delivery.
  • Conducting Project-Based Milestone Reviews.
  • Mentoring team members and reviewing their work.
  • Team building and mentoring - Training and retraining.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center, Clear Quest, HP ALM,JIRA

Databases: Oracle, SQL Server, DB2, Teradata, Netezza

Utility Tools: TOAD 8.5, Teradata SQL Assistant 14.1, DB2 client, SQL Developer

ETL Tools: Data Stage, Ab Initio 3.0.4,SOAP-UI

Operating Systems: Windows Vista, 7, Linux and UNIX. Microsoft Office Excel, Access, Outlook and Power Point, MS Visio, Word, Lotus Notes

Programming Languages: SQL, PL/SQL, Unix Scripting

PROFESSIONAL EXPERIENCE:

ETL Test Lead

Confidential - Chicago IL

Responsibilities:

  • Identified and analysed all the source systems pushing the card data into EDW. Had discussions with source teams and documented the complete understating of the system.
  • Participated in BRD, FRD discussions. Raised static defects on the requirements.
  • Analysed the existing business and created Test Scenarios that ensure the existing functional behaviour is intact with the changes to the system. Ensured the new encrypted values are not misleading the end users.
  • Involved in preparing Test Strategy, Test Estimation, and test completion report for the projects. Prepared & Reviewed TOM, Test cases, Business scenarios for all the code releases. Conducted walkthrough sessions with business, Project management, Design and development team for the Test plan & Business scenarios.
  • Ensured the new encrypted values co exists with the existing values until all the end users are ready to accept the new ones and not impacting any other projects.
  • Co-ordinated with source teams to generate the test data and verify the end-to-end flow of the data.
  • Created the Regression environment to perform base line testing.
  • Loaded the data using Ab initio and Data stage jobs and validated the performance on job execution times.
  • Created Ab-initio graphs for Data creation and validations and performed end-to-end data validations.
  • Ensured the data at rest is properly converted to the new encrypted values.
  • Loaded data into HDFS from external source system and Oracle DB, Teradata using Sqoop and exported the summarized data to the relational databases to perform visualization and report generation jobs.
  • Involved and supported validations for Data Ingestion - Historical, Incremental logic validation with complex business scenarios. Validation of data movement from Source files to Teradata databases for end to end business logic validation.
  • Supported SIT and UAT teams executing the batches and validated the data from source to EDW for historic and incremental loads .

Environment: Ab-initio, Datastage,HP ALM,JIRA,Teradata 14.1,Oracle 9.1,SQL,Unix,Hive,sqoop

ETL Test Lead

Confidentia

Responsibilities:

  • Participated in BRD, FRD discussions. Involved in preparing Test Strategy, Test Estimation, and test completion report for the projects. Prepared & Reviewed TOM, Test cases, Business scenarios for all the code releases. Conducted walkthrough sessions with business, Project management, Design and development team for the Test plan & Business scenarios.
  • Created the Regression environment, helped the team members in executing the jobs and comparing the data
  • Identified the jobs at source level and executed using Datasatge as well as Ab-initio with the same set of data.
  • Performed the validations of count and Data integrity.
  • Analysed and compared the job execution time, warnings, frequency, source data, ease of use etc.
  • Provided the recommendations for performing query tuning based on the above factors.
  • Recommended the upgrade as per the metrics analysed.
  • Participated in all BRD, FRD requirements. Involved in preparing Test Strategy, Test Estimation, and test completion report for the projects. Prepared & Reviewed TOM, Test cases, Business scenarios for all the code releases. Conducted walkthrough sessions with business, Project management, Design and development team for the Test plan & Business scenarios.
  • Identified all the jobs that load the data into tables.
  • Created the Regression and System Testing environment pointing to 12 and 14.1 versions respectively.
  • Used the same set of source files and loaded the both version of tables.
  • Compared the jobs execution times and provided the detailed analysis on execution times w.r.t multiload, bteq, fast load, api functionalities.

Environment: Ab-initio, Datasatge, HP ALM, JIRA, Teradata, SQL, UNIX

UAT Coordinator

Confidential

Responsibilities:

  • Meet with Business Clients to Begin User Acceptance Test Case development.
  • Analyzed the Test Scenarios created by business user for UAT and identify the test data requirements, investigate dependencies of key upstream systems, and communicating to the corresponding teams for test data requirements.
  • Reviewed and mapped Test Cases to Requirements and to ensure all Test Cases are mapped to Requirements (QC) and test data is requested for all the scenarios.
  • Verify UAT environment availability / overlapping with other parallel projects - Communication with PM / Verification of potential overlap.
  • Execute the jobs in UAT environment in UNIX and Prepare Test Result Report.
  • Performed the Data count and Data Integrity validations.
  • Supported the business users in composing the SQLqueries to retrieve the data from the backend.
  • Created and managed all defects at program level in HP Quality Center.
  • Conducted Defect Triage meetings with Developers and Business users on daily basis, and created defect management reports using Quality Center for Executive Management and Steering Committee.
  • Responsible for creating testing status reports and summary reports for Go/No-go decision making and supported application deployments.

Test Analyst

Confidential

Responsibilities:

  • Involved in review of all documentation (BRD, SRS) relating to the given Project.
  • Prepared the Test Plan, Test Scenarios and Test cases.
  • Reviewed with the businesses for Signoff.
  • Defining and conditioning test data.
  • Writing and executing Unix Commands, composed the SQL queries to validate the data from source to target and capture the Test Results.
  • Prepared Daily & Weekly Status reports for the entire project.
  • Prepared & Maintained Risk Response tracker, Query Tracker.
  • Documentation and validation of problems and defects found during testing.
  • Reporting all defects and issues to development team via HP QC.
  • Review the Test Results with business for sign-off.
  • Prepare the Test Summary report and publish.

Test Analyst

Confidential

Responsibilities:

  • Involved in review of all documentation (BRD, SRS) relating to the given Project.
  • Prepared the Test Plan, Test Scenarios and Test cases.
  • Reviewed with the businesses for Signoff.
  • Defining and conditioning test data.
  • Writing and executing Unix Commands, composed the SQL queries to validate the data from source to target and capture the Test Results Prepared Daily & Weekly Status reports for the entire project.
  • Prepared & Maintained Risk Response tracker, Query Tracker.
  • Documentation and validation of problems and defects found during testing.
  • Prepared test data for web services validation.
  • Performed API testing/web services using SOAP-UI tool.
  • Reporting all defects and issues to development team via HP QC.
  • Review the Test Results with business for sign-off.
  • Prepare the Test Summary report and publish.

Tester

Confidential

Responsibilities:

  • Analyzing requirements and creating and executing test cases
  • Test Case Execution.
  • Performed Functional Testing & Regression Testing.
  • Used Quality Centre for creating and documenting Test Plans and Test Cases and register the expected results.
  • Involved in Functionality Testing, Integration Testing, System Testing, Regression Testing.
  • Using HP Quality Centre for storing, maintaining the test repository, bug tracking and reporting.

Hire Now