• As part of this project, we assist our customer in monitoring the status of their policies, including renewal, unpaid premiums, paid premiums, and deceased policies for beneficiaries.
• Established an ETL data pipeline using AWS services like S3, Lambda, Glue, Redshift and cloud watch.
• Applied transformation on raw data using Python (Pandas) and loaded this clean data into Data warehouse like AWS Redshift.
Technical Stack: AWS S3 -- Stores raw data, AWS glue -- ETL tool, Python Libraries, AWS Redshift -- Data warehouse.