On my SwiftRoute project, I architected an end-to-end AWS Medallion Lakehouse that processes 350,000+ logistics records across Bronze, Silver, and Gold zones. I built PySpark transformations on AWS Glue with schema validation, business rule checks, and automated quarantining of invalid records.
I modeled analytical Gold-layer tables in Apache Iceberg on S3 for ACID transactions and SQL querying through Amazon Athena. I also orchestrated ETL workflows with containerized Apache Airflow DAGs and automated deployment with GitHub Actions CI/CD.
At Solartis Technologies Pvt Ltd, I engineered RESTful APIs and database-driven transaction modules for enterprise insurance platforms, and optimized SQL queries and stored procedures. Earlier, at Tata Consultancy Services (TCS), I developed PL/SQL functionality for insurance claims processing and supported ETL validation and transactional data verification.
