AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
QA Automation Engineer with 4+ years in data pipeline validation and test automation using Python, S
Experienced ETL Automation Tester with 4 years of expertise in designing test cases, executing test scripts, validating data quality, and reporting. Experience specializing in data pipeline validation, DWH Testing and test automation using Python, Pandas, Advanced SQL, PLSQL and Unix on Informatica PowerCentre and diverse databases. Designs maintainable validation frameworks, automates source-to-target reconciliation, and enforces transformation rule coverage with robust SQL/Python utilities and PyTest. Adept at defect lifecycle ownership in Jira, Agile delivery, and data-quality reporting that supports reliable, data-driven releases at scale. Strong analytical and communication skills, capable of working effectively both independently and within a team to deliver optimal testing solutions. Interpreted business rules into testable validation logic; authored comprehensive test plans for ETL jobs across landing, staging, and warehouse layers. Built Python + PyTest-based validation harnesses to run parameterized SQL packs, compare expected vs. actual datasets, and generate CSV/HTML evidence artifacts. Wrote advanced SQL for SCD handling, aggregations, joins, window functions, and exception sampling; optimized queries with distribution/sort keys awareness. Automated Unix shell runners for sequencing validations, capturing exit codes, rotating logs, and notifying on failures; integrated artifacts for audit readiness. Validated Informatica PowerCentre mappings and sessions: transformation logic, filter/lookup rules, parameterization, dependencies, and post-load checks. Implemented reconciliation suites: counts, sums, min/max, null checks, PK/FK integrity, duplicate detection, domain constraints, and balancing across partitions.
JNTUK University, Kakinada
B.Tech · Electrical and Electronics Engineering
N/A – June 30, 2021
Tata consultancy services
Associate
December 1, 2021 – Present
India
USAA (BFSI Banking and Insurance)
December 1, 2021 – June 1, 2026
People and their Vehicle Policy and Claims in USA states information getting captured and stored in multiple systems. The objective of this project is to perform the validation of various source system for Policy Model (PC), Claims Model (CC), Customer Model (MDM), Service Ops (SRM) and Telephony Model (VOC) in EODS to verify that Stage tables and Base tables are loaded as expected from Source, based on the Fix/enhancement applied.
Informatica PowerCenter - Beginner to Expert Level Udemy certified
Udemy
June 1, 2026 – Present
Udemy Certified AWS S3+ Redshift with AWS glue ETL tool
Udemy
June 1, 2026 – Present
Pl-300-Microsoft Power BI Data Analyst Associate
Microsoft
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's experience across Banking, Insurance, and Manufacturing domains, coupled with a diverse skill set in databases, ETL tools, and programming languages, suggests adaptability and a broad technical foundation. The project experience at USAA (BFSI) aligns well with enterprise-level environments. The certifications in Informatica, AWS ETL, and Power BI indicate a proactive approach to learning and skill development, which is a positive cultural trait. The role at Tata Consultancy Services also implies experience in a large, diverse organizational culture.
Soft Skills & Operational Fit
The candidate demonstrates strong analytical and communication skills, as stated in the resume, which are crucial for collaborating with development teams and stakeholders. The ability to work independently and in tight deadlines suggests good operational fit for dynamic project environments. Experience with Agile delivery and defect lifecycle management using Jira indicates a structured approach to QA.