ETL Testing and Data Validation Specialist

PROFESSIONAL SUMMARY

IT Professional with *.* years of experience specializing in testing for product and project-based companies. Seeking to work in a challenging work environment where I can utilize my expertise in resolving the problems, analyzing the business needs and advocate my analytical skills towards the growth of the organization. EXPERIENCE

Associate Consultant Jun 2025 — Jul 2026

Capgemini · Bangalore, India

Project 1: HR Recuritment

Client: Morgan Stanley

Domain: HR Domain

HR Technologies: Snowflake, SSIS, SQL, UNIX, PowerBI Role: ETL Tester

ROLES & RESPONSIBILITY:

• Manage enterprise HR ELT pipelines in Snowflake across HR_RAW, HR_STAGE, and HR_CORE layers, supporting recruitment lifecycle analytics from requisition through onboarding.

• Develop SQL-based reconciliation and validation queries that detect transformation mismatches, duplicate records, and missing data, strengthening pipeline data integrity.

• Validate API-extracted JSON data parsing, flattening, and transformation logic feeding downstream Power BI recruitment dashboards.

• Perform regression and impact analysis on ETL and transformation logic changes, safeguarding data quality across releases.

• Improve deployment efficiency and reporting accuracy by partnering with ETL developers and BI analysts to align validation practices with enterprise data governance standards. Data Processing Analyst Dec 2021 — Mar 2025

NielsenIQ · Chennai, India

Project 1: Banking

Client: Jefferies

Domain: Investment

Banking Technologies: Oracle, SSIS, SQL, UNIX

Role: ETL Tester

ROLES & RESPONSIBILITY:

• Developed ETL test Scripts based on technical specifications/Data design documents and source to Target mappings.

• Carry out project testing according to test plan.

• Used JIRA for storing, maintaining the test repository, bug tracking and reporting.

• Perform database validation using SQL according to the business rules and specifications.

• Extensively used tMap component which does lookup & Joiner Functions, tOracle,txml, tdelimtedfiles, tlogrow, tlogback components for the end-to-end flow of the ETL Pipelines.

• Developed complex Talend ETL jobs to migrate the data from flat files to database.

• Implemented custom error handling in Talend jobs and also worked on different methods of logging. Created ETL/Talend jobs both design and code to process data to target databases.

• Implemented tLogCatcher to capture any errors or warnings during ETL job execution.

• The tLogCatcher was used to monitor job-level failures, database errors, or

• transformation issues.

• Defects identified in testing environment are communicated to the developers. LAKSHMI A G

ETL TESTER

***********@*****.*** +91-702******* Bangalore, India EDUCATION

Bachelor of Computer Applications (BCA) in Computer Science & Applications Jan 2018 — Jan 2021 KLE Society's Degree College

SKILLS

SQL MySQL PostgreSQL MS SQL Server Snowflake SQL CTEs Window Functions Joins Stored Procedures Query Optimization Statistical Analysis Hypothesis Testing Data Validation & Reconciliation Data Quality Assurance Data Cleansing Power BI Tableau DAX Power Query (M Language) Power BI Dataflows Semantic Data Models Star Schema Design Row-Level Security (RLS) KPI Scorecards Dashboard Development Advanced Excel Snowflake ETL/ELT Development & Testing JSON Parsing & Flattening API Data Extraction Databricks Python Pandas NumPy Process Automation Root Cause Analysis Regression & Impact Analysis Jira Confluence Agile/Scrum Data Governance SLA-Driven Delivery

Contact this candidate