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.