ETL and Data Migration QA Engineer

SAHLA V A

ETL Tester Data Warehouse Tester Data Analyst

Bengaluru, India +91-984******* *****.****@*****.*** PROFESSIONAL SUMMARY

Quality Engineering Analyst with 5 years of experience in ETL testing, data warehouse testing, data migration testing and data analysis across Intel, CSX and PepsiCo engagements. Skilled in source-to-target data validation, data reconciliation and data quality testing using SQL, IceDQ, Python, Profisee MDM and Power BI. Experienced in Teradata to Azure Databricks migration testing, Tableau to Power BI report migration with Oracle to Microsoft Fabric data validation, and the full STLC in Agile teams using Azure DevOps (ADO) and Jira.

CORE SKILLS

Testing: ETL Testing, Data Warehouse Testing, Data Migration Testing, Data Validation, Data Reconciliation, Source-to-Target Mapping (STM) Validation, Data Quality Testing, Regression Testing, API Testing, BI Report Testing, STLC, Test Planning, Test Case Design, Defect Management

Tools: IceDQ, Azure DevOps (ADO), Jira, ServiceNow, Postman, Profisee MDM, Tamr, Power BI, Tableau, Excel Databases and Platforms: Teradata, Oracle, Azure Databricks, Delta Lake / Delta Tables, PySpark, Microsoft Fabric, Microsoft SQL Server (MSSQL), Salesforce data

Languages: SQL, Python

Data Analysis: Data Cleansing, Data Profiling, Data Transformation, Master Data Management (MDM), Reference Data Management, Data Visualization

Methodology: Agile, Scrum, STLC

PROFESSIONAL EXPERIENCE

Quality Engineering Analyst 2021 – Present

Infosys Bengaluru, India

PepsiCo – Teradata to Azure Databricks Migration Testing Client: PepsiCo (Current) Environment: Teradata, Azure Databricks, Delta Tables, IceDQ, SQL, Azure DevOps (ADO)

• Performed ETL and data warehouse testing for data migrated from Teradata to Azure Databricks, validating completeness, accuracy and consistency of migrated data in Delta tables.

• Designed and executed IceDQ rules for source-to-target reconciliation, including row count, column-level and data type checks between Teradata and Databricks.

• Wrote complex SQL queries to validate transformations, aggregations, duplicates, nulls and business rules against source-to- target mapping documents.

• Logged and tracked the complete STLC in Azure DevOps (ADO): test plans, test cases, test execution, defects and retesting.

• Raised, triaged and followed up defects with data engineers and business teams to closure. Data Visualization Migration (Tableau to Power BI) Client: CSX Environment: Power BI, Tableau, Microsoft Fabric, Oracle, PySpark, Delta Tables, SQL, Jira

• Tested migration of Tableau reports to Power BI, ensuring data accuracy and consistency across dashboards.

• Validated underlying tables transferred from Oracle to Microsoft Fabric, verifying data integrity between source and target.

• Performed end-to-end dashboard testing, including data layer validation using Microsoft Fabric pipelines, PySpark and Delta tables.

• Validated report data and compared visualizations between Tableau and Power BI for functional and data accuracy.

• Managed test cases and defects in Jira and collaborated with developers and business teams to align requirements. CoreDataSquad – Data Migration and Data Quality Client: Intel Environment: Profisee MDM, SQL Server, SQL, Jira

• Led data migration testing from legacy systems to Profisee MDM, ensuring seamless and accurate data transfer.

• Implemented data cleansing and data quality validation to identify and resolve inaccuracies.

• Maintained reference data management and validation processes in Profisee.

• Analyzed large datasets using SQL; followed Agile practices with Jira-based requirement and task tracking. UCD Data Transformers – Data Cleaning and API Testing Client: Intel Environment: Python, SQL Server, Postman, Tamr, Excel, Salesforce

• Performed API testing using Postman and extracted and analyzed large data volumes using APIs and Python scripts.

• Extracted JSON data and automated the Tamr tool for data grouping.

• Transformed and cleaned data per business needs using SQL Server and Excel from Salesforce. EDUCATION

B.Tech (Hons.) in Information Technology Engineering University College of Engineering, Karivattom Sep 2021

Contact this candidate