Summary
Overview
Work History
Education
Skills
Accomplishments
Skills
Certification
Languages
Timeline
Generic

Ravichandra HB

Milwaukee,WI

Summary

Career with Strong leadership, Problem solving, Planning and team building skills.

Results-driven ETL Test Lead with deep expertise in data integration, validation, and quality assurance. Adept at leading cross-functional teams to deliver high-quality outcomes. Strong focus on problem-solving and continuous improvement in fast-paced environments. Skilled in SQL, data warehousing, automation, and performance tuning. Known for adaptability and effective communication, ensuring alignment with evolving project requirements.

Overview

14
14
years of professional experience
1
1
Certification

Work History

ETL Test Lead

Northwestern Mutual Insurance
Milwaukee, Wisconsin
01.2025 - Current
  • Company Overview: Organization - LTI Mindtree, USA
  • As a Test Engineer, analyze the Requirement, walkthrough, BRS Document and Mapping document and create a test design for assigned stories.
  • Create a test plan and test strategy and get a sign off by having a Test Strategy review to check if we are in sync with the development team as well as Client.
  • Created data automation frame work using python
  • As a team lead review test cases and test results for the story.
  • Creating TCR for the weekly releases
  • Organization - LTI Mindtree, USA
  • Developed and executed comprehensive test plans for ETL processes, enhancing overall efficiency.
  • Collaborated with cross-functional teams to identify requirements and validate data transformations.
  • Implemented automated testing frameworks, reducing manual effort and increasing accuracy of results.
  • Analyzed test results to provide actionable insights for continuous improvement in ETL workflows.
  • Coordinated defect management processes, ensuring timely resolution of issues identified during testing phases.
  • Developed comprehensive test plans, addressing all aspects of ETL processes to ensure thorough coverage and minimal risk.
  • Reviewed requirements documents thoroughly, identifying potential gaps or inconsistencies requiring clarification before initiating test efforts.
  • Evaluated new ETL testing tools and technologies, recommending appropriate solutions to drive process improvements.
  • Identified critical defects early in the development process, significantly reducing rework costs and saving time.
  • Implemented performance testing strategies for ETL applications, ensuring optimal system functionality under high load conditions.
  • Strengthened data quality assurance by designing robust test cases that effectively validated source-to-target mappings.
  • Documented testing procedures for developers and future testing use.
  • Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.

ETL Tester

CT Corporation
New York, New York
12.2021 - 12.2024
  • Company Overview: Organization - LTI Mindtree, Bangalore
  • Effectively Carried out ETL testing by Validating packages and writing SQL queries to validate business logics, Validating Stored Procedures and batch files, and updated the same in ALM with precision.
  • Defect life cycle has been handled effectively in the testing phase
  • Participated in Daily stand-up call and defect Triage call and provided clarifications if any.
  • Reports have been generated on time meeting the deadlines in both the phases of testing without compromising on the quality.
  • Organization - LTI Mindtree, Bangalore
  • Led cross-functional teams in troubleshooting ETL failures, improving overall system reliability.
  • Streamlined testing processes through automation tools, reducing manual effort and increasing efficiency.
  • Optimized ETL processes for faster data extraction, transformation, and loading.
  • Contributed to successful project outcomes by effectively communicating test results and recommendations to stakeholders.
  • Utilized SQL queries to validate data extraction, transformation, and loading activities effectively.

Tester

Southwest Airlines
Dallas, Oregon
05.2018 - 11.2021
  • Company Overview: Organization - LTI Mindtree
  • Written test cases for testing by understanding requirements.
  • Written Simple to complex queries to execute the test cases using sub-queries, joins, grouping etc.
  • Tested the reports by using SQL queries.
  • Organization - LTI Mindtree
  • Led testing efforts for software applications, ensuring quality and functionality met industry standards.
  • Developed and executed comprehensive test plans to identify defects and enhance product performance.
  • Implemented automated testing tools to streamline processes and increase efficiency in test cycles.
  • Conducted root cause analysis on system failures, driving corrective actions to prevent recurrence.

ETL Tester

ATLAS Data Lake
01.2017 - 01.2018
  • Company Overview: Organization - Persistent systems
  • Involved in Test case execution.
  • Preparing Review Reports based on review of Test Cases, Scenarios and Test Data.
  • Involved Integration Testing, Regression Testing and System Testing.
  • Prepared Test Summary Report and Defect report.
  • Organization - Persistent systems
  • Developed and executed comprehensive test plans for ETL processes to ensure data integrity.
  • Collaborated with developers to identify and resolve data discrepancies during ETL cycles.
  • Utilized SQL queries to validate data extraction, transformation, and loading activities effectively.
  • Analyzed test results and documented findings to enhance future testing strategies.

ETL Tester

Cardtronics
12.2015 - 12.2016
  • Company Overview: Organization – ATTRA Infotech
  • Involved in Test case execution.
  • Preparing Review Reports based on review of Test Cases, Scenarios and Test Data.
  • Involved Integration Testing, Regression Testing and System Testing.
  • Prepared Test Summary Report and Defect report.
  • Organization – ATTRA Infotech
  • Contributed to successful project outcomes by effectively communicating test results and recommendations to stakeholders.
  • Boosted project efficiency by collaborating with cross-functional teams to define test cases and test plans.
  • Established a robust framework for regression testing, ensuring consistent results across multiple releases of the software application suite.
  • Analyzed test results and documented findings to enhance future testing strategies.
  • Led cross-functional teams in troubleshooting ETL failures, improving overall system reliability.
  • Streamlined testing processes through automation tools, reducing manual effort and increasing efficiency.

ETL Tester

Synchrony Financial
04.2015 - 12.2015
  • Company Overview: Organization – ATTRA Infotech
  • Involved in Test case execution.
  • Preparing Review Reports based on review of Test Cases, Scenarios and Test Data.
  • Involved Integration Testing, Regression Testing and System Testing.
  • Prepared Test Summary Report and Defect report.
  • Organization – ATTRA Infotech
  • Contributed to successful project outcomes by effectively communicating test results and recommendations to stakeholders.
  • Established a robust framework for regression testing, ensuring consistent results across multiple releases of the software application suite.
  • Ensured data integrity by validating end-to-end data flows in complex, multi-tier systems.
  • Streamlined the testing process by developing reusable SQL queries for various ETL components.

ETL Tester

ICHG
04.2013 - 03.2015
  • Company Overview: Organization – Tech Mahindra
  • Involved in writing test cases
  • Involved in preparing test plan
  • Execution of test cases
  • Effort estimation, mentoring team members
  • Involved with interactions with client.
  • Perform ETL testing for all the warehouse tables associated. This testing includes data check between the source and target tables, referential integrity check, duplicate check, CDC logic check
  • Provide a mechanism to address application and cross-LOB performance impacts.
  • Perform in pod testing for all the columns, raise necessary defects in ALM tool and capture relevant screen shots and upload the same in ALM.
  • Organization – Tech Mahindra
  • Utilized SQL queries to validate data extraction, transformation, and loading activities effectively.
  • Optimized ETL processes for faster data extraction, transformation, and loading.
  • Contributed to successful project outcomes by effectively communicating test results and recommendations to stakeholders.
  • Improved system performance by analyzing bottlenecks and implementing effective solutions.

Database Tester

Dept of E-Governance
09.2011 - 12.2012
  • Company Overview: Organization – Ram Informatics ltd
  • Involved in writing test cases
  • Involved in preparing test plan
  • Execution of test cases
  • Effort estimation, mentoring team members
  • Involved with interactions with clients.
  • Perform ETL testing for all the warehouse tables associated. This test includes data check between the source and target tables, referential integrity check, duplicate check, CDC logic check
  • Organization – Ram Informatics ltd
  • Established a strong record of defect detection in database systems, ultimately contributing to higher quality products for end users.
  • Collaborated with developers to refine database designs, ensuring improved functionality.
  • Assisted in the development of test plans, aligning objectives with overall project goals.

Education

Bachelor of Science - Computer Science & Engineering

Bapuji Institute of Engineering & Technology
06.2009

Skills

  • Python
  • Unix
  • VMware
  • Informatica
  • Abinitio
  • Oracle
  • SQL Server
  • Snowflake
  • HP Quality Centre
  • Rational ClearQuest
  • JIRA
  • Power BI
  • SSRS
  • Tableau
  • Toad
  • Oracle SQL Developer
  • Azure Data Bricks
  • DB-solo
  • Beyond Compare
  • Putty
  • WinSCP
  • Postman
  • Salesforce
  • Test case design
  • Defect tracking management
  • Test process improvement
  • Test automation frameworks
  • Test environment setup
  • Test plan creation
  • Regression testing
  • SQL proficiency
  • Agile methodology
  • Test strategy development
  • Stakeholder communication
  • Data quality assessment
  • Continuous integration tools
  • Business intelligence testing
  • Data transformation testing
  • Data warehouse testing
  • Test metrics reporting
  • Data integration testing
  • Test script execution
  • Data validation testing
  • Data migration testing
  • Data mapping verification
  • ETL tool expertise
  • ETL modeling
  • Teamwork
  • Teamwork and collaboration
  • Customer service
  • Problem-solving
  • Time management
  • Problem-solving abilities
  • Multitasking Abilities
  • Reliability
  • Excellent communication
  • Organizational skills
  • Effective communication
  • Defect tracking and reporting
  • Bug tracking and resolution
  • Automation
  • Automated testing frameworks
  • Software development tools: JIRA, confluence
  • Playwright automation

Accomplishments

  • Achieved [Result] by completing [Task] with accuracy and efficiency.
  • Collaborated with team of [Number] in the development of [Project name].

Skills

12+ years, Windows – 2000/NT/XP, Unix, VM ware, Informatica8.6.1/9.1, Abinitio, Oracle 10g, 11g, 12c, SQL Server, snowflake, HP Quality Centre, Rational clear quest, JIRA, Power BI, SSRS, Tableau, Toad 11g, Oracle SQL developer, Azure data bricks, DB-solo, beyond compare, Putty, WinSCP, Post man, salesforce, Currently working in LTI Mindtree, Milwaukee, USA. Around 12 + years of relevant experience in Quality Assurance and Software Testing.

Certification

  • CSQA - Certified Software Quality Analyst
  • CQT - Certified Quality Technician

Languages

English
Native or Bilingual
Hindi
Native or Bilingual

Timeline

ETL Test Lead

Northwestern Mutual Insurance
01.2025 - Current

ETL Tester

CT Corporation
12.2021 - 12.2024

Tester

Southwest Airlines
05.2018 - 11.2021

ETL Tester

ATLAS Data Lake
01.2017 - 01.2018

ETL Tester

Cardtronics
12.2015 - 12.2016

ETL Tester

Synchrony Financial
04.2015 - 12.2015

ETL Tester

ICHG
04.2013 - 03.2015

Database Tester

Dept of E-Governance
09.2011 - 12.2012

Bachelor of Science - Computer Science & Engineering

Bapuji Institute of Engineering & Technology

Similar Profiles

CREATE PROFILE