GA4 to PostgreSQL Data Pipeline Validation & Analytics
As Middle SQA & Data Analyst: In my mid-level SQA and analyst role, I supported QA efforts for automating GA4 data ingestion into PostgreSQL. I performed schema reviews and ETL testing to verify integration with Looker Studio dashboards, helping automate monthly reporting and reduce manual data handling.
Key Impact: Reviewed data flow in requirements docs for discrepancies, assisting with team onboarding. Queried sample datasets to validate sync accuracy, completeness, and integrity during testing phases.
Skills Showcased: Database QA (PostgreSQL queries), data pipeline validation (ETL checks), analytics support (Looker/GA4), regression testing scripting.
Outcome: Ensured 99.9% data accuracy in dashboards; cut reporting errors by 70%.