Arockia Nirmal Amala DossinPlumbers Of Data ScienceFortifying Your Database Migration: A Journey Towards Secure Transitions!As a database developer/architect, one of my most critical challenges is ensuring data security during database migrations. These…3 min read·Mar 21, 2024----
Arockia Nirmal Amala DossFrom On-Prem Microsoft SQL Server to AWS Serverless — Migrating Business Intelligence, Application…Introduction4 min read·Apr 10, 2023----
Arockia Nirmal Amala DossGuide to Creating a Secure and Efficient Personal AWS Account in 2023: Best Practices for…Content7 min read·Apr 4, 2023----
Arockia Nirmal Amala DossData Engineering Project-AWS Stream and Batch Processing Pipelines for Credit Card TransactionsSome weeks ago I started to build a data engineering project in AWS Cloud. As a Datawarehouse/ETL professional with more than 6+ years of…2 min read·Sep 14, 2021--1--1
Arockia Nirmal Amala DossPopulating Amazon Redshift DWH from S3 & QuickSight ReportingIn one of previous blog posts here in medium I modeled an OLAP system (Star Schema)for credit card transactions kaggle dataset as below. In…3 min read·Sep 12, 2021----
Arockia Nirmal Amala DossAmazon QuickSight Dashboard for S3 CSV Data using Redshift Spectrum / Glue CrawlerIn this article I would like to write about creating a Amazon QuickSight Dashboard for the data in a csv file located in Amazon S3 sing…2 min read·Sep 11, 2021----
Arockia Nirmal Amala DossAmazon QuickSight Dashboard for S3 CSV Data Using Amazon Athena / Glue CrawlerIn this article I would like to write about creating a Amazon QuickSight Dashboard for the data in a csv file located in Amazon S3.3 min read·Sep 11, 2021----
Arockia Nirmal Amala DossBuilding a Grafana Dashboard in AWS on Serverless Aurora RDSIn my previous article here in Medium, I built a simple stream processing pipeline in AWS which writes credit card transactions data into…4 min read·Aug 16, 2021----
Arockia Nirmal Amala DossBulk Import from AWS S3 Bucket into RDS Aurora Serverless using AWS Cloud9In this article, I am writing about loading the .CSV file data in bulk from AWS S3 bucket into RDS Aurora Serverless using AWS Cloud9. At…4 min read·Aug 7, 2021----
Arockia Nirmal Amala DossBuilding a Stream Processing Pipeline in AWSIn my earlier article here in Medium, I took a kaggle credit card transaction dataset and modeled it for the OLTP and OLAP databases as…3 min read·Aug 1, 2021--1--1