Lokeswararao G.

About Lokeswararao G.

Experienced Software Testing Professional with over 4+ years in ETL and Data Warehouse…

Experience

1. Senior Quality Engineer

   LTIMindtree

   Jun 2024 — Present · Chennai, IN

   Received Spot Award for displaying exemplary team work.Collaborate with BAs, developers, and data architects to understand ETL workflows.Create ETL test strategy and test plan.Identify test objectives, data requirements, and testing scope.Write test cases for source-to-target mapping validation.Design SQL queries to verify transformations, aggregations, joins, filters, and lookups, and written complex SQL queries for business rule regression testing.Identify positive, negative, boundary, and reconciliation test scenarios.Prepare or request test data in staging/landing/source systems.Mask sensitive data if needed.Run SQL queries to validate data at each ETL stage.Compare source and target data for completeness and accuracy.Perform data profiling and data quality checks.Log defects in tools like JIRA or Azure DevOps.Re-test after fixes and track defect closure, reducing 50% of manual effort in regression testing through automation.Use ETL testing tools like Informatica DVO, Talend, or custom Python/SQL scripts for automation.Maintain test case documents, data validation logs, test result reports, and sign-off reports.Attend daily stand-ups, report progress, and coordinate with developers and business users.

Education

• Sri Venkateswara University

  Bachelor's degree

  2014 — 2017

• Dravidian University

  Master of Computer Applications - MCA

  2017 — 2020