We provide IT Staff Augmentation Services!

Bigdata/etl Test Lead Resume

SUMMARY

  • 10+ years of focused experience in ETL, Informatica PowerCenter, DB, Data migration, Mainframe applications, manual testing and informatica Development with high - level proficiency in Oracle, SQL Server, Cognos, Informatica Power Center, Hive, Unix and HP ALM across domains like Insurance, Healthcare, Banking, Retail and Financial Services
  • Well acquainted with SDLC, STLC and Bug life cycle. Involved in all the phases of Software Testing Life Cycle that includes Requirement Gathering, Analysis, Test Design, Test Execution, Mapping documents creation, Defect Management, Integration Support, UAT Support and Test Closure.
  • Proficient in EDI 834, 837 files and good knowledge on provider data
  • High level Proficiency in writing & executing test cases with 100% coverage of requirements.
  • Efficient in creating mapping document from source to target to validate mapping rules and target data load.
  • Experienced in testing methodologies like Agile-SCRUM and Waterfall Model.
  • Extensive experience in ETL/Data warehouse backend testing, Web services testing using tools like SOAP UI, Postman and BI Intelligence reports testing using Cognos reports.
  • Good working knowledge on ETL transformations and mappings and Verified EDW mapping based on the mapping document.
  • Developed complex SQL queries in Oracle and tables which replicated the ETL, and compared the SQL results
  • Good experience on Data Transformations & Data Quality for various data feeds coming from source.
  • Extensively worked on HP Quality Center, HP ALM to Write Test Cases, Execute Test Cases, Log Defects, Track Defects and Prioritize Defects.
  • Hands on experience in JIRA tool for issues and defect tracking.
  • Working knowledge on Unix commands
  • Involved in design and development of keyword-driven, data driven automation framework using Selenium Web driver.
  • Good experience in Data migration testing by verifying the data integrity between the legacy software application and the advanced software application.
  • Extensive experience in reconciliation tool TLM, by comparing two sets of records to ensure they are correct and in agreement.
  • Strong working experience in OBIEE reports testing like validating oracle business intelligence report layout and data with database data.
  • Experience in Big Data Testing tools like Hive, Hadoop, Spark
  • Lead a Team of 5 testers and was responsible for their project deliverables.
  • Makes recommendation on scope, timelines and assist management with capacity planning and provide estimates for testing related work across the team.
  • Experience in Identifying test automation opportunities to improve efficiency and effectiveness of test services.
  • Extensive experience in Preparing Test Plan. Test data and Test summary reports for the Requirements and getting Test Plan and Test Cases reviewed and approved/signed-off by the relevant stakeholders.
  • Involved in Defect Reporting and Tracking.
  • Experienced in maintaining support documents, QA Sign off Documents and maintaining Daily/Weekly Status Reports.
  • Active Listener, Good communication, Leadership, Solid time management and multitasking skills which helps in conducting project meetings, reviews, walkthroughs, and customer interactions according to the various needs of the projects

TECHNICAL SKILLS

Primary Skills: QA Lead/DW/Big data/ETL/Functional Testing

Defect Management: HP ALM, HP QC and JIRA

Databases: Teradata, Oracle, MS SQL Server

ETL Tools: Informatica Power Center, Ab Initio

Big Data Tools: Hadoop 3.1.2, Hive, Spark 3.0

Reporting Tools: Congo’s and OBIEE reports

Automation Tools: Selenium Web driver and TestNG

DB Tools: Toad Data Point 3.8(PL/SQL), Data Studio 4.1.0.1

Reconciliation Tool: TLM (Transaction Life Cycle Management)

Methodology: Agile, Waterfall

Web Methodology: Core Java, JSP, Servlets, Struts, SQL

PROFESSIONAL EXPERIENCE

Confidential

Bigdata/ETL Test Lead

Responsibilities:

  • Analyzed client requirements, working with business and vendors to understand the requirements
  • Prepared Test Approach and test case documents based on the requirements and get approval from Business and Project manager
  • Requested Test data from different sources based on SRS and mapping document and loaded the test data into specific environment by creating an ALM ticket where the testing need to be carried out.
  • Lead a team of 5 Testers and was responsible for their project deliverables
  • Conducted several brainstorming sessions with Business Analyst and testers to understand the scope of each feature, impact areas and technical complications that need to be considered while writing test cases.
  • Developed complex SQL queries for data validation and for verifying the ETL Mapping Rules.
  • Tested several complex ETL mappings and reusable transformations for daily data loads.
  • Used Informatica Power Center as an ETL Tool for extraction, transformation, and loading (ETL) of data into the Data Warehouse.
  • Monitored the workflow transformations in Informatica workflow monitor.
  • Testing of email notification if there are any ETL job failures, or data issues in the source tables.
  • Used SQL for Querying the database in the UNIX environment.
  • Analysis of test requirement and automation feasibility.
  • Developed and executed automation test scripts using Selenium WebDriver for extract connect project .
  • A ctively involved in implementing testing frameworks Keyword Driven, Data Driven, using Selenium.
  • Involved in the Continuous Integration of the automation framework with Jenkins and integrated the test suites to Jenkins to execute them automatically.
  • Performed end to end testing by coordinating with various teams to make sure that the data flow was smooth starting from the source to the ultimate target.
  • Responsible for sending Daily status and Defect report for the projects Team is working on.
  • Trained Entry level testers to write SQl’s and to use Informatica Power Center.
  • Created reports and send it to business on extract stats.
  • Prepare the project-deliverables (Daily, weekly and Test Summary Reports).
  • Test management and Defect tracking using ALM
  • Tested EDI 834 files based on the mapping document

Confidential

Bigdata/ETL Test Lead

Responsibilities:

  • Analyzed client requirements, working with business and vendors to understand the requirements
  • Prepared Test Approach and test case documents based on the requirements and get approval from Business and Project manager
  • Requested Test data from different sources based on SRS and mapping document and loaded the test data into specific environment by creating an ALM ticket where the testing need to be carried out.
  • Lead a team of 5 Testers and was responsible for their project deliverables
  • Conducted several brainstorming sessions with Business Analyst and testers to understand the scope of each feature, impact areas and technical complications that need to be considered while writing test cases.
  • Developed complex SQL queries for data validation and for verifying the ETL Mapping Rules.
  • Tested several complex ETL mappings and reusable transformations for daily data loads.
  • Used Informatica Power Center as an ETL Tool for extraction, transformation, and loading (ETL) of data into the Data Warehouse.
  • Monitored the workflow transformations in Informatica workflow monitor.
  • Testing of email notification if there are any ETL job failures, or data issues in the source tables.
  • Used SQL for Querying the database in the UNIX environment.
  • Analysis of test requirement and automation feasibility.
  • Developed and executed automation test scripts using Selenium WebDriver for extract connect project .
  • A ctively involved in implementing testing frameworks Keyword Driven, Data Driven, using Selenium.
  • Involved in the Continuous Integration of the automation framework with Jenkins and integrated the test suites to Jenkins to execute them automatically.
  • Performed end to end testing by coordinating with various teams to make sure that the data flow was smooth starting from the source to the ultimate target.
  • Responsible for sending Daily status and Defect report for the projects Team is working on.
  • Trained Entry level testers to write SQl’s and to use Informatica Power Center.
  • Created reports and send it to business on extract stats.
  • Prepare the project-deliverables (Daily, weekly and Test Summary Reports).
  • Test management and Defect tracking using ALM
  • Tested EDI 834 files based ion the mapping document
  • Participating in weekly core Team meetings to discuss the issues.

Confidential

ETL/BI Test Lead

Responsibilities:

  • Identify Scope and Extent of testing based on the business requirements
  • Prepare Test plan and strategy based on the requirements
  • Prepare complete set of test cases and scenarios in ALM
  • Validate Pillar3 and Other Reporting reports as per the business requirements
  • Validate OBIEE Report schedules related to all Asset classes as per the business requirements
  • Helping UAT team in test preparation and environment readiness and execution.
  • Execute Test cases and scenarios and uncover issues in ALM
  • Developing the SQL Queries for test Execution.
  • Preparing daily and weekly status report
  • Log and track anomalies/defects within change control in ALM
  • Preparing Test summary report
  • Participating in daily and weekly status calls

Hire Now