Skip to main content
M

mamatha

ETL Testing Professional

Bengaluru, Karnataka, India

I am an ETL Testing professional with more than six years of experience validating data, ETL pipelines, data warehouses, databases, APIs, and reporting tools. I have strong expertise in Oracle, Microsoft SQL Server, Redshift, BigQuery, Snowflake, Teradata, Informatica, SQL, and cloud data environments. I design, prepare, execute, and maintain test cases across functional, integration, and system testing. My experience includes data integrity and accuracy validation, count, null, duplicate, truncation, schema, filter, calculation, and mismatch checks, as well as testing shell scripts, Airflow DAG workflows, Power BI reports, Spotfire tools, and API implementations. I work effectively with development teams, customers, offshore teams, and Agile Scrum teams. I also contribute to sprint planning, daily status reporting, knowledge transfer, and training new team members, while bringing a sincere, enthusiastic, hardworking, and committed approach to every project.

Experience

CT

Consultant

Capgemini Technology Services India limited

Sep 2022 – Present

Bangalore, IndiaFull time

I perform ETL and data validation testing across databases, reporting tools, and migration workflows. For the Unilever project, I compare PDS and Teradata data, validate counts and mismatches, check Power BI filters, create Excel pivots, run macros, and participate in Agile ceremonies. For GE Aviation, I compare Oracle and Redshift data with Spotfire and UI tools, test user stories, perform sanity testing, and prepare knowledge-transfer materials.

ETL TestingData ValidationPDSTeradataOracleAmazon RedshiftPower BISpotfireSQLMicrosoft ExcelData WarehousingAgileScrumSanity Testing
VT

Software Test Engineer

Virtuent Technologies Pvt Ltd

Jan 2019 – Jan 2022

Bangalore, IndiaFull time

I tested data, web applications, APIs, and ETL migration workflows for the HUL-I CUBE project. I validated data integrity and accuracy during Redshift-to-BigQuery migration, including counts, nulls, duplicates, extra records, truncation, calculations, filters, categorizations, and schema changes. I also verified API behavior, shell-script and SQL logic, DAG configurations, ETL workflow sequencing, and database updates.

ETL TestingData WarehousingAmazon RedshiftGoogle BigQueryAPI TestingData Integrity TestingSQLShell ScriptingApache AirflowDAG WorkflowsDatabase TestingMigration Testing

Education

AP
Annamacharya Pg College of Management Studies, Rajampet

MBA

Skills

ETL testingData warehouse testingSQLOracleMicrosoft SQL ServerSnowflakeAmazon RedshiftGoogle BigQueryTeradataInformaticaInformatica DesignerInformatica Workflow ManagerInformatica Workflow MonitorApache AirflowPythonAmazon Web ServicesGoogle Cloud PlatformPower BISpotfireAPI testingFunctional testingIntegration testingSystem testingData validationData integrity testingData accuracy testingDatabase testingSchema validationCount validationNull validationDuplicate validationData migration testingShell scriptingDAG workflow testingTest case designTest case executionSoftware Testing Life CycleAgile methodologyScrumTest planningDefect managementKnowledge transferTeam coordinationCommunicationInterpersonal skills

Languages

English
Full professional proficiency
Telugu
Native or bilingual proficiency
Kannada
Professional working proficiency