We provide IT Staff Augmentation Services!

Etl Qa Lead Resume

SUMMARY

  • Experienced ETL Test lead, with 10+ years of rich global experience in managing and executing ETL testing projects in multiple platforms
  • Excellent experience in development and testing of End to End, Upgrade and Migration of Data Warehouse and Data Management implementations
  • Experience working with huge volumes of data, analysing record sets for Data Quality, Data Validation, Data Cleansing, and Data Comparison
  • Hands on Experience in analysing ETL Transformation mappings and writing complex SQL Queries for data validation and data reconciliation through manual and automation
  • Extensive Experience in developing and testing Oracle Databases for data warehouse, data mart or decision support systems
  • Expert in ETL and BI testing and worked with ETL tools like Talend, SAP BODI & Informatica and BI tools like Business Objects & Tableau
  • Experience in Big Data testing using Apache Drill, Hive & Spark SQL
  • Excellent in managing project related responsibilities such as Requirement Analysis, Coding, Unit Testing, System Testing, Test Automation, UAT, Test data preparation, defects logging and Production move of the components.
  • Strong Customer facing experience with long term onsite roles in Germany & USA
  • Experience in Planning and executing the Functional, Regression and System Integration testing for a large data warehouse and Enterprise Reporting projects
  • Strong knowledge of agile development practices (particularly Scrum), methodologies & hands on experience authoring and refining user stories, grooming product backlogs and prioritizing conflicting requirements in addition to conducting daily Scrum, Retrospective meetings.
  • Experience in coordinating with Business users for user acceptance testing UAT
  • Strong communicator and excellent interpersonal skills to communicate with globally separated Testing Teams, Project Stakeholders, Senior Management and Leadership Teams with clarity in both written and verbal formats. Also, good in articulating technical issues in a non - technical way.
  • Extensive exposure over Test Leadership activities like Test Strategy designing, Test Planning, Test Estimation, Test Process improvement, Traceability Matrix & WBS creation, Conducting Defect Triage meetings, arranging Go-no-Go meeting and forecasting test resources.
  • Proven ability to coordinate medium sized project from initial conceptualization through implementation
  • Quick learner with ability to develop sound understanding of the existing systems

TECHNICAL SKILLS

Query Languages: SQL, PL/SQL, HQL

Database: Oracle 11g, DB2, Teradata, MS SQL,Netezza,Snowflake

Bigdata Technologies: MapR, Hive, Hadoop(HFS), Spark

Database Tools: SQL Developer, PL/SQL Developer, Toad, Apex

ETL Tools: SAP BODI, Informatica, Oracle Warehouse Builder, Data Stage, Talend

Reports: Business Objects, SSRS, Cognos, Tableau

Test Management Tools: HP Quality Centre, HP ALM

Automation tools: Tricenties TOSCA, iCEDQ, QTP, WipDAV

Web Scripting Language: HTML, JavaScript, Python

Source Code Management Tool: SVN, Git Bitbucket

Process Methodology: Agile (using JIRA tool), Waterfall, Data warehousing/ETL, DevOps

Job Scheduler: ESP, Control-M, Autosys Batch processing.

Operating Systems: Unix, Linux (Red Hat), Windows server 2000, Windows 7, Windows 8, Windows 10.

QA Methodologies: Data warehousing (OLAP), OLTP, SDLC/STLC (Waterfall), Agile(SCRUM), Unit testing (Black Box & White Box), User Acceptance testing (Alpha & Beta), Functional testing (Integration, Interface and System Testing), Non-Functional testing (Smoke, Stress, Localization, Compatibility, Security, Performance, GUI and Usability testing), Regression testing, Test Automation(QTP), Cloud testing, Client-On-Boarding, Traceability Matrix Create, Test/Cost Estimation, Designing, Proposal Planning, Defect Management

PROFESSIONAL EXPERIENCE

Confidential

ETL QA Lead

Responsibilities:

  • Responsible for handling QA activities of Vendor Reporting project and managing the ETL Offshore and onsite QA teams
  • Analysed Source to Target Mapping (S2TM) and Technical design (TDD) documents to produce Test Strategy, Test Plan, Test Completion reports
  • Executed Data stage ETL workflows and validated the reporting data for correctness and completeness in the target Netezza tables
  • Developed & executed several complex SQL queries for data verification and data quality checks.
  • Performed extensive testing on Extracted, Transformed and Loaded (ETL) data from source to target data base tables.
  • Automated ETL data validation using Tricenties Tosca BI and iCEDQ tool.
  • Verified the implemented ETL logic against the corresponding mapping document;
  • Working collaboratively with the Development team to ensure all defects are resolved prior to the release of code to the UAT environment.
  • Tracking and reporting upon testing activities including testing results, test case coverage etc.
  • Worked closely with Business Analysts & solution Design Architect to understand the New Requirements and provided guidance to Offshore Team.
  • Reviewed Test cases created by offshore Team with Business & Development teams and provided the feedback/Suggestions.
  • Supporting & Coordinating User Acceptance Testing (UAT).
  • Coordinated the testing activities with remote teams based in US, UK and India.
  • Testing status reporting with key metrics defining health of the project (Weekly Status Reports & Daily Status Reports).

Confidential

ETL Test Lead

Responsibilities:

  • Managing Confidential Test team deliverables, by providing Testing solutions, identifying potential Data quality and data processing issues and maintaining the overall quality of the reporting data.
  • Understanding business processes, analysing the functional requirements & Technical Specifications and accordingly designing the Testing solutions and directing the test team for ensuring complete test coverage.
  • Introduced automated solutions for Master Data Refresh and Environment Baselines.
  • Developed Interfaces to downstream applications using oracle PL/SQL and SAP BODS work flows;
  • Developed and Maintained SQL scripts and complex queries for data analysis and extraction
  • Developed Parameterized SQL scripts for running multiple sets of data for validation
  • Created Test plan and Test Cases to cover overall functionality of the application;
  • Preparing test data according to the testing and business scenarios;
  • Developed sql scripts for ETL validation to compare Source and Target database systems;
  • Performed white Box testing for testing all the business requirements and the System functionality
  • In charge of test execution and defect tracking management;
  • Creation of Traceability Matrix and Test Completion Reports;
  • Co-ordinated sprint releases to push enhanced/new code to production
  • Close collaboration and interaction with Project stakeholders, PMO, Development team and testing team;
  • Conducting User Acceptance Testing and getting UAT signoff;
  • Testing status reporting with key metrics defining health of the project (Weekly Status Reports & Daily Status Reports).

Confidential

Support & Test Consultant

Responsibilities:

  • Responsible for the quality of master data that is set up in MDM;
  • MDM Data Administration, which includes (MDM access management & new master data setup)
  • Master Data bulk uploads and setting up mappings for corresponding downstream systems;
  • Monitored MDM Data & Web services ensuring smooth master data confirmation;
  • In charge of test preparation and execution;
  • Client communication (verbal & written) & T-Cons;
  • Provided technical guidance, mentoring, knowledge sharing and trainings to team members.

Hire Now