Created the cloud-based data warehousing solution for commercial analytics for Australia based client.

Primarily worked as ETL developer creating Postgresql queries on AWS cloud databases such as redshift, rds.

Built the different layers of data warehousing for almost 10 data sources.

Loaded data from s3 into ec2 machines, orchestrated level 0/1/2 to perform the ETL process by cleaning data, loading into base/stage tables, generating required surrogate keys for dimensions/fact tables and finally generating reporting tables/views for the dashboard which was created using Microstratedy.

Was involved in the whole software development lifecycle (requirement gathering -> developing -> testing -> deploying) with the other 8 core team members.