Desmond Sambath

Infosys

05.2003 - Current

Designed databases in a modernized environment (Aurora PostgreSQL) based on microservices architecture and developed mapping to aid in migrating the data from the legacy environment (DB2) to the modernized environment.
Worked on ingesting data from a wide variety of sources (files in AWS S3 buckets, Kafka queues) to the enterprise analytical platforms in Oracle (on-premises) and in Snowflake (cloud).
Performed data analysis and data profiling using complex SQL on various source systems and answered complex business questions by providing data to business users.
Worked with data scientists on evaluating and integrating data from complex and high velocity transaction databases.
Used a systematic approach to plan, create, and maintain data architectures while also keeping it aligned with business requirements.
Developed complex queries involving analytic functions and stored procedures to perform data aggregations.
Fulfilled a wide variety of responsibilities as a database modeler and played critical role in various client POC engagements.
Gathered business requirements, working closely with business users, project leaders and developers.
Analyzed the business requirements and designed Conceptual and Logical data models.
Designed, developed and maintained dimensional models for Financial Services, Telecommunication, Publishing and Transportation domains
Led by example, mentored and provided technical guidance to the junior members of the team.

Similar Profiles