Susnata Saha

About Susnata Saha

Results-driven software engineer with 8 years of experience in designing scalable backend…

Experience

1. Senior Software Engineer

   Informatica

   Nov 2021 — Present · Bangalore Urban, IN

   I am part of Cloud Integration team (IDMC) in Informatica. Currently I am key contributor in the Oracle cloud infrastructure (OCI) ecosystem and responsible for developing Oracle ADB, Object Storage connectors.I have also hands on experience in developing relational connectors such as Oracle, SqlServer, DB2, Postgres, JDBCV2 and other Databases that provide ODBC/JDBC connectivity. Some of my key contributions are : • Designed and delivered a high-performance Oracle Autonomous Database connector from scratch,enabling seamless authentication using TLS, mTLS Auth. Used Oracle Cloud ObjectStorage as a staging medium for faster data loading from cloud-to-local. • Built a multi-threaded, high-speed uploader & downloader, optimizing cloud-to-local data transfer very efficient.• Implemented CRUD operations by bulk batch processing of data which resulted in 4x performanceimprovement in multiple connectors.• Leveraged Test-Driven Development (TDD) with JUnit testing framework by adding comprehensiveJUnit tests for each component.• Implemented an EXACT PATH methodology to significantly reduce map generation time forbillion-scale records by 50%.• Implemented Kerberos authentication for PostgreSQL, ensuring secure, enterprise-grade connectivitykey enabler for global client acquisitions, including Morgan Stanley J.P. Morgan.• Responsible for handling variety of connectors from generic connectors (via JDBC/ODBC) to relational connectors (SQL Server, Oracle, PostgreSQL etc)

Education

• Jadavpur University

  Bachelor's degree

  2013 — 2017