Banashankari B S

ETL Testing Manager.

Lead the strategic direction and execution of ETL testing across multiple data pipelines and projects.

• Managed and mentored a team of 2+ years ETL testing professionals, ensuring high-quality, on-time delivery of all testing phases for data migration and integration projects.
• Collaborated with senior management and cross-functional teams (e.g., Data Engineering, Business Analysts, and Product Managers) to define project timelines, resources, and testing scope.
• Developed and implemented test strategies, covering functional, regression, performance, and data quality testing, ensuring 100% data accuracy and minimal defects post-production.
• Played a key role in implementing an agile testing framework, which reduced testing cycle time and improved overall delivery efficiency.
• Led resource allocation and budgeting for testing activities, ensuring optimal utilization of team members and achieving project goals within budget constraints.
• Established key metrics to measure testing effectiveness, quality, and team performance, driving continuous improvement.
• Managed stakeholder expectations and provided timely updates on test progress, risks, and issues to project and program managers.
• Resolved critical testing bottlenecks and escalations, ensuring minimal disruption to project timelines.

ETL Test Team Lead.

• A curious 8+ years of quality assurance Test Team Lead to work on the creative testing strategy based on the requirement, and it is a more responsible role in ensuring that software or systems are rigorously tested to meet quality standards before they are released.
• As a lead, manage and mentor a team of testers, providing guidance, support, and the right direction, followed by motivating the team with team activities to keep the energy level high and change of work. Manage conflicts and drive team performance.
• Develop a comprehensive testing strategy, including scope, objective, and methodologies.
• Prepare detailed test plans outlining test scenarios, data requirements, and testing timelines.
• Design and develop test cases and test scripts based on ETL requirements and business requirements.
• Prepare and manage test data, ensuring it covers various scenarios, including edge cases and data integrity issues.
• Oversee the execution of test cases, including functional, regression, performance, and data quality tests.
• Identify, log, and track defects or issues found during testing, working with the JIRA defect cycle to resolve them.
• Work closely with developers, data analysts, and business stakeholders to understand requirements and address issues.
• Provide regular updates and reports on test progress, test results, and quality metrics to stakeholders.
• Facilitate a feedback loop between testing and development teams to continuously improve the processes and testing strategies.
• Assess and recommend testing tools and technologies that can enhance testing efficiency and effectiveness.
• Identify, document, and track defects found during testing.
• Perform root cause analysis for recurring issues, and provide recommendations for improvements.
• Share knowledge and best practices with the team to enhance overall testing capabilities and performance.
• Recognize potential risks related to testing and data quality, and develop mitigation strategies.
• Provide training and guidance to junior testers and new team members on ETL testing processes and tools.
• Mentor team members to help them develop their skills and improve their performance.
• Ensure that data testing practices comply with relevant data security and privacy regulations.
• Ensure that the testing processes adhere to industry standards and organizational policies.
• Involved in data migration QA activities from Argus and Aris to LSMV.
• Data migration requirement analysis, including understanding mappings, transformation logic, and pre- and post-conditions of migration rules.
• Experience in creating test cases covering all the required information from end to end, including all the positive and negative scenarios.
• Worked on SQL queries for data validation after ETL operation performed using Oracle, TOAD, and Postgre (Only for Non-migrated cases).
• Excellent experience in performing data migration testing to verify 100% data migration.
• Performed database testing using PL/SQL in Oracle for data migration projects.
• Test case Preparation, Test case Execution, Test case Quality Reviews (Both Automation and Manual)
• Implemented SQL scripts to verify end-to-end DM verification through Count & MINUS functionality to verify the number of records existing in the source and the number of records migrated into the target as per the given migration logic.
• Experience in file loading to base tables through Unix and verifying data with UI.
• Experience in CSV (IQ, OQ, OQSR, VSR, and RFCs)
• Involved in executing test cases for SBX, Validation, and UAT environments.
• Production and Postproduction support till Hyper care - Completed BMS implementation (Argus-LSMV and ArisG-LSMV).
• Excellent experience in each phase of the Test Life Cycle, test strategies and test plans, and UAT.
• Excellent experience in leading the team with Scrum Agile methodology.
• Accountable for Sprint planning, effort estimation, and task allocation.
• Accountable for preparing Traceability Matrix Documents, Forecasts, daily matrix, and identifying Risks.
• Accountable for creating/reviewing test batches, executing test cases, and reporting defects.
• Experience in handling a team with Scrum planning, following the work effectively with a plan.
• Technical skills: ETL Tools Proficiency, SQL Knowledge, Database Management, Programming/Scripting Languages, Data Warehousing Concepts, Defect tracking.
• Pharmacovigilance product expertise: ARISg, LSMV, ARGUS, IRT, OST, CCM.