Taniya Ghosh

With 3+ years of experience in the IT industry, I have contributed to four major data/ETL projects across healthcare and pharmaceutical domains. I specialize in ETL Testing, Data Validation, SQL Testing, DWH pipelines, functional testing, and defect management, and currently serve as the sole ETL Test Lead for the Humana MRA project. Recognized with Wipro’s ‘Bright Beginner’ Award and praised by clients for high-quality delivery and ownership.

Key Projects & Responsibilities

1. Humana – MRA ETL Testing (Current Project)
Role: ETL Test Lead
Tech: Oracle SQL, Databricks SQL, Azure SQL, QTest
Lead the complete ETL Testing lifecycle as the only QA/ETL tester on the project.
Review source-to-target mappings and validate ETL pipelines across Oracle, Databricks, and Azure SQL layers.
Execute complex SQL queries to validate transformations, aggregations, business rules, and incremental loads.
Design test plans, test scenarios, and test cases in qTest, ensuring 100% requirement coverage.
Perform data profiling, data reconciliation, metadata checks, schema validations, and pipeline audits.
Own defect management—log, track, and validate fixes—ensuring timely closure.
Work closely with Dev, Data Engineering, and Business teams to resolve data issues and improve data accuracy.

2. Cardinal Health – STIBO
Role: QA Analyst (ETL & Functional Testing)
Tech: SQL Server, Oracle SQL, Jira
Designed and executed functional, integration, regression, and ETL test cases to ensure accurate data migration and quality across systems.
Conducted data validation on product, vendor, and item master data flowing through STIBO (MDM).
Identified, addressed, and resolved over 150 enhancement issues, contributing to improved system reliability.
Performed ETL data checks on transformed master data to ensure consistency across downstream applications.

3. CAH-CHIME
Role: Data QA & Automation Tester
Tech: BigQuery, SQL, Python Automation, Jira, XRay
Worked on ETL pipelines validating healthcare datasets migrated to BigQuery.
Automated execution of BigQuery SQL scripts using Python, improving test cycle efficiency.
Participated in requirement gathering; documented testable requirements.
Performed impact analysis for schema changes and identified SQL queries/data impacted.
Developed and maintained SQL validation test cases and automated scripts.
Executed ETL validations, reconciled datasets, and analyzed discrepancies.
Managed defects in Jira and ensured timely closure.

4. VillageMD
Role: QA Analyst (Data & ETL Testing)
Tech: PostgreSQL, MySQL, Oracle SQL, Power BI
Designed and implemented QA checks for EMR, Payer, and ADT data implementations across multiple SQL databases.
Performed in-depth data validations, ETL data quality checks, and multi-layer reconciliation.
Resolved 200+ QA tickets by validating data quality, integrity, pipeline logic, and transformations.
Built and analyzed Power BI dashboards to support data-driven QA reporting.
Received client appreciation for ownership and delivery quality.