Gayathry Girisan
Austin,TX
Summary
Results-driven Data Engineer with 12+ years of experience in database engineering, ETL development, Quality Engineering and cloud-based data platforms. Experienced in designing, building, and optimizing scalable data pipelines using Oracle Database and Azure Databricks, with strong expertise in SQL/PLSQL, performance tuning, and data reliability in large, distributed environments. Demonstrated ability to collaborate with cross-functional teams, translate complex business requirements into robust technical solutions, and drive best practices in automation, CI/CD, and data quality. Proven leader, mentoring engineers and delivering high-impact, data-driven solutions that optimize performance and support strategic business outcomes. Seeking roles combining deep technical ownership with architectural decision-making and outcome-driven impact.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Senior Member of Technical Staff
Oracle
Austin, TX
10.2024 - Current
- Led multiple initiatives to optimize Horizon DW performance, achieving measurable improvements in query execution times and overall system stability.
- Designed and implemented automation scripts to cap TEMP space per customer/partner, significantly reducing resource usage spikes.
- Developed a robust monitoring framework to detect, remediate, and alert on underperforming jobs that exceeded failure thresholds.
- Partnered with multiple stakeholders to enhance job performance through SQL query tuning and table defragmentation.
- Managed sharding of critical partner workloads to ensure dedicated resources, minimize disruptions, and maximize system efficiency.
- Created dashboards tracking Data, TEMP, and UNDO usage, enabling on-call engineers and leadership to quickly assess tablespace health and capacity trends.
- Supported partners during Oracle Analytics Cloud (OAC) onboarding, addressing queries and ensuring smooth adoption.
- Addressed security findings and remediated vulnerabilities, strengthening platform compliance and minimizing operational risk.
- Served as an on-call engineer, regularly monitoring service health on a defined cadence, addressing customer tickets, troubleshooting issues, and ensuring minimal disruption to production systems.
ETL Engineer
TD Bank
01.2022 - 05.2024
- Led and mentored a team delivering end-to-end Azure data pipelines, partnering with stakeholders, data engineers, and business analysts to ensure scalable, high-quality data solutions aligned with business requirements.
- Designed, developed, and automated ETL pipelines using Azure Data Factory, Databricks, and Python, supporting ingestion, transformation, and validation across multiple source systems.
- Architected a regression validation framework with ADF pipelines and Python notebooks covering 140+ data sources, reducing regression effort by 90% and significantly improving release reliability.
- Established and enforced data engineering best practices including automation, CI/CD integration, version control, and standardized data quality checks.
- Drove end-to-end data validation and release readiness, coordinating with downstream consumers, tracking execution and defects via JIRA dashboards, and communicating status through daily operational reports.
Senior Engineer
Klick Health
Toronto, ON
06.2020 - 01.2022
- Progressive expertise in requirements analysis, application testing, and database testing, with strong ownership across planning, estimation, execution, and monitoring of multiple concurrent client projects.
- Experience in Salesforce Marketing Cloud, including customer journey testing, email and audience validation, and data synchronization between Marketing Cloud and Sales Cloud via Salesforce connectors; also experienced with Acoustic campaign management.
- Extensive experience in integration and reporting validation, testing inbound/outbound data flows, end-to-end system integrations, and Datorama reporting (data feeds, workflows, schedules, and report accuracy).
- Proven collaborator with strong communication skills, supporting pre- and post-production launches, defect triage, alert monitoring, task assignment, and onboarding and ramp-up of new team members.
Senior Consultant
CGI
04.2018 - 06.2020
- Partnered with business stakeholders to define data ingestion scope for EDPP, validating end-to-end ingestion from 36+ heterogeneous source systems (Mainframe, RDBMS, XML, flat files).
- Designed and enhanced a Java-based automation framework for end-to-end ingestion validation, including EBCDIC-to-CSV conversion, data quality checks.
- Executed comprehensive Hadoop ingestion and extraction testing using Hive, Sqoop, Podium Publish, and Talend, ensuring data completeness, accuracy, and applied business logic.
- Integrated automation with Jenkins CI/CD, implemented shift-left defect prevention practices, and managed defect lifecycle end-to-end using JIRA.
System Analyst
Infosys Limited
06.2011 - 11.2017
- Analyzed business requirements and source-to-target mappings to define test strategy, preparing Test Plans, RTM, and comprehensive test cases with SQL-based validations.
- Validated ETL mappings and business rules by executing ETL jobs and performing complex SQL checks on target data to ensure accuracy and completeness.
- Tested MicroStrategy reports for format and data integrity by reconciling report outputs with backend data marts; automated data mapping validation using VBA macros and Oracle SQL, reducing manual effort.
- Managed end-to-end defect lifecycle and UAT support using HP ALM, UNIX log analysis, regression testing across builds, and stakeholder reporting through status and test completion reports.
Education
Bachelor of Engineering - Electronics and Communication
Amrita VishwaVidya Peetham
India01.2011
Skills
ETL Tools: Azure Data Factory, Azure Databricks, Informatica
Databases: PostgreSQL, Oracle, SQL Server
Programming Languages: SQL, PL/SQL, Python
Cloud Platforms: Microsoft Azure, Oracle OCI
Analytics & Monitoring: Oracle Analytics Cloud (OAC), Grafana
DevOps & Collaboration: Bitbucket, Shepherd,Jenkins, JIRA, Confluence
Certification
- OCI Certified Foundation Associate
- Azure Fundamentals
- Azure Data Fundamentals
- ISTQB- Foundation Level Certified.
Timeline
Senior Member of Technical Staff
Oracle
10.2024 - Current
ETL Engineer
TD Bank
01.2022 - 05.2024
Senior Engineer
Klick Health
06.2020 - 01.2022
Senior Consultant
CGI
04.2018 - 06.2020
System Analyst
Infosys Limited
06.2011 - 11.2017
Bachelor of Engineering - Electronics and Communication
Amrita VishwaVidya Peetham