Shruthi Bathuka

- Led production support operations with zero SLA breaches by conducting detailed root cause analysis, implementing long-term fixes, and driving continuous improvement across Informatica, Oracle, and UNIX environments.
- Resolved incidents and service requests within SLAs, collaborating with cross-functional teams to maintain high availability and system performance.
- Designed, developed, and deployed end-to-end ETL solutions in Informatica PowerCenter (9.x, 10.x) and Oracle, with a strong focus on scalability, performance tuning, and data quality.
- Streamlined and optimized HSBC HK job workflows, reducing manual intervention and recovery tickets.
- Improved performance by eliminating unused downstream jobs and redundant replications in AMFS and AFI, significantly reducing offline completion time and enhancing DBMOTO efficiency.
- Automated MCS application reprocessing and housekeeping, converting a multi-step, manual workflow into a single-step process and improving performance and processing time.
- Collaborated with onshore clients to gather requirements and produce HLD/LLD design deliverables.
- Applied performance tuning techniques across databases and ETL objects.
- Built robust data integration pipelines ingesting from SAP, Oracle, PostgreSQL, and flat files into target systems such as Salesforce, Oracle, and AWS S3.
- Developed data warehouse models across physical, business, and presentation layers using star and snowflake schemas to support business reporting.