POORNIMA K
Summary
- Overall 10 years of seasoned IT professional with 7 years of ETL testing experience in various roles such as Software Tester, Test Analyst, Functional Analyst and QA Lead.
- Expert in Functional, Integration, Regression, End-to-End Testing, UAT Testing.
- Basic knowledge on Pandas Framework.
- Very good knowledge in snowflake data warehousing tool. Good knowledge on SAS and HIVE/IMPALA.
- Strong knowledge in Healthcare, Banking and Retail domains.
- Experience in working with the client for requirement analysis and issue resolution.
- Exclusively worked on Microstrategy, Cognos and Qlikview Reports.
- Experience in testing of Data Warehousing systems using ETL tools like Informatica, Abinitio, Talend, SAS.
- Expert in preparing test scripts based on ETL mapping document.
- Experience in preparing Test Strategy, Test Plan, Test scenarios, Test cases, traceability matrix and Testing effort estimation.
- Skilled in gathering business requirements and transforming them using DWH model in data warehouse environment.
- Strong knowledge in SQL to write test scripts involving joins, temporary tables and sub-Queries with complex logic based on business requirements.
- Experience in testing the tables that are having Slowly Changing Dimension Types.
- Good understanding in GitHub, Bit bucket for CI / CD Flow.
- Experience in file level and table level test data preparation and data manipulation for QA validation.
- Experience in HP ALM and JIRA for task assignment, test case preparation, execution, and defect tracking.
- Worked in masked data copy from production server to QA server by coordinating with production support team.
- Strong knowledge and experience in all phases on Software Testing Life Cycle(STLC), Defect Life Cycle and Software Development Life Cycle (SDLC).
- Experience in working on projects with Waterfall and Agile development methodologies.
- Strong knowledge in Daily, Weekly and Monthly status reports preparation.
- Frequently working with Onshore and Offshore team members to prioritize and finish the tasks on time.
- Experience in project management activities like status tracking for closure, reporting, escalating, coordination, team management and quality deliverable within timelines.
Overview
14
14
years of professional experience
Work History
ETL ManualTester
Atlantis IT Consulting
05.2024 - 05.2025
- Validated the data at back end systems merge between the 2 railroad CP and KCS.
- Validate the functional flow between the different value streams CSD, EME and TSD.
- Performed Regression testing for already existing CP and KCS applications
- Have validated the ETL data flow using Oracle SQL and SQL Server Management studio
- Good hands on experience in writing simple to complex sql queries to validate the data quality,data integrity ,data accuracy and transformation logics in Oracle SQL and SQL Server Management Studio.
Senior Consultant
NTTDATA Consulting Services
06.2023 - 04.2024
- Company Overview: Chennai
- Analyzing the Business requirement and identifying the in scope and out of scope requirements.
- Exclusively worked on HIVE/IMPALA, Teradata and SAS. Good understanding on SAS code.
- Working on EDL/EDW with SAS as downstream.
- Analyzing the Source to Target Data Mapping and detailed design document.
- Involved in E2E testing from ST, SIT and UAT phases.
- Managing a team of 3 members and allocating the work appropriately.
- Supported on drafting UKM Test strategy, test plan. Review the work of team members in QA aspects.
- Involved in weekly scrum calls and daily defect calls.
Lead Consultant
Virtusa Consulting Services
09.2018 - 11.2021
- Analyzing the Business requirement and identifying the in scope and out of scope requirements.
- Develop and execute comprehensive test plans, test cases, and test scripts for Talend ETL processes.
- Setting up frequent knowledge sharing session with testing team members to Bridge any gaps in understanding the detailed design document and data mapping document.
- Involved in writing complex SQL queries to validate the data from source to target
- Review the test scripts prepared by team members. Automate test cases for ETL processes to improve testing efficiency and coverage.
- Conduct data validation, reconciliation, and report validation to ensure data consistency between source and target systems and the accuracy of generated reports.
- Perform load testing to validate ETL performance and report generation, identifying bottlenecks, if any.
- Involved in integration, regression, and performance testing of ETL workflows, data transformations, and report generation processes.
- Chennai
Senior Software Tester
Maveric Systems
06.2017 - 08.2018
- Company Overview: Chennai
- Preparing test Strategy, Test plan, Test Scripts, Test Closure Reports, RTM and Defects Reports.
- Interacting with multiple stakeholders to understand the existing functionality.
- Lead the team throughout the project and bridge the gaps in requirements and the understanding of the functionality.
- Analyze DataStage jobs to understand the existing functionality.
- Involve in Source to Target data validation based on the existing functionalities.
- Perform Target to Target data validation to ensure data integrity.
- Monitoring and Reporting Autosys Jobs status and configurations.
- Performing Performance Testing to ensure the performance is retained or improved post migration.
- Conduct Defect triage and track down defects for each release.
- Chennai
IT Analyst
Talent Capital India
05.2015 - 01.2017
- Company Overview: Chennai
- Understanding the Requirements from the BRD.
- Involved in functional study of the application.
- Knowledge on the Abinitio Tool used as Front end as source.
- Knowledge on Abinitio components.
- Verifying the data in target database by ETL process as Teradata.
- Verified column mapping between source and target.
- Prepared test data for functional & Integration testing.
- Interactions with BA & Dev teams to resolve the issues.
- Reporting daily testing status.
- Designed, Reviewed & Executed Test cases.
- Identified Test cases for Regression testing.
- Defect Analyzing and Reporting in QC.
- Status reporting, project tracking, documentation, and reporting.
- Chennai
Associate Consultant
HCL Technologies
01.2011 - 11.2014
- Company Overview: Chennai
- Understanding the ETL Specification Documents for mapping requirements.
- Extract Data from multiple sources like Flat files, Oracle into staging database.
- Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Joiner, Union, Sequence Generator, and Update Strategy.
- All errors encountered were documented using an Issue Log.
- Interacted with team members to resolve the errors encountered.
- Involved in performance tuning of mappings, identifying source and target bottlenecks and worked with the sessions and workflow properties to improve performance.
- Performed Unit tests on all the mappings developed and documented the test cases and test results.
- Chennai
Education
Some College (No Degree) - Information Technology
Crescent University
Skills
- Data Analysis
- ETL Testing
- DataWarehousing
- Functional Testing
- BI Reports
Languages
Tamil
English
Personal Information
Title: SENIOR ETL QA LEAD
Timeline
ETL ManualTester
Atlantis IT Consulting
05.2024 - 05.2025
Senior Consultant
NTTDATA Consulting Services
06.2023 - 04.2024
Lead Consultant
Virtusa Consulting Services
09.2018 - 11.2021
Senior Software Tester
Maveric Systems
06.2017 - 08.2018
IT Analyst
Talent Capital India
05.2015 - 01.2017
Associate Consultant
HCL Technologies
01.2011 - 11.2014
Some College (No Degree) - Information Technology
Crescent University
Similar Profiles
Margret NansikombiMargret Nansikombi
CALL CENTER AGENT at Atlantis The Palm & Atlantis The RoyalCALL CENTER AGENT at Atlantis The Palm & Atlantis The Royal
AMEEZA ZIAAMEEZA ZIA
Senior Content Writer at Atlantis Tech/Atlantis RCMSenior Content Writer at Atlantis Tech/Atlantis RCM
Locksley BrownLocksley Brown
Spa Host at Atlantis BahamasSpa Host at Atlantis Bahamas
Maggie RuizMaggie Ruiz
Principal Agent at RedfinPrincipal Agent at Redfin
FELECIA GARCIAFELECIA GARCIA
Medical Practice Manager at National Health FundMedical Practice Manager at National Health Fund