We have 2 AWS RDS: DB1 and DB2. DB1 has some data and DB2 is initially empty. We need some kind of ETL, which can load data from DB1 and remove some columns from certain tables, then upload in the DB2. After that whenever some new data comes in the DB1 it must be reflected in DB2 automatically.
Having experience in writing complex stored procedures and functions in a optimal way. Having Good knowledge in ETL process using TALEND(open source) and SSIS.
Hello, I can help you write the ETL shell script to replicate data from DB1 to DB2 and cron(schedule) it. I need an EC2 instance. I'll write the ETL logs and email alerts if/when the job fails or records do not match in target system
Hi ,
I am senior DEvops engineer with 6 AWS certifications. I can help you with the task. I can use DMS with CDC feature to achieve this task. let me know . But the price is very less