Sasidaran S

System Engineer

Tata Consultancy Services•  July 2022 - Present•  Chennai, India

Experienced in SQL on Oracle database and MSSQL database hosted in AWS. Profound understanding of complex queries and tables in the SQL databases. Worked on various AWS services such as EC2 instances, EC2 instance connect, S3, IAM and Application load balancer. Expertised in best practices for the secure and optimal performance of the AWS components. Designed, created and updated compensation plans in Varicent ICM. Set up SFTP in AWS and Implemented connection for Varicent ICM imports. Developed Varicent ICM components in the composer and Presenter Adaptive Reports. Created and managed imports to the Varicent ICM tables from files and databases. Good understanding of the overall data pipeline between Informatica and Varicent ICM application. Utilized Pyspark to clean and transform data with basic understanding of optimization and memory management in the Spark engine and Hadoop Ecosystem.