Designed and maintained data infrastructure across on-prem and cloud environments (FreeBSD bhyve platform with ZFS-backed storage) to support high-availability daily data processing; developed production ETL pipelines using Apache Airflow and Python-based DAGs that process millions of records; built and operated cloud-based data transformation workflows leveraging AWS Glue, S3, RDS PostgreSQL, and GCP BigQuery; optimized PySpark transformations and designed time-series oriented data models for efficient querying; implemented data quality checks, automated alerts, and data lineage tracking; established CI/CD for ML models using Docker, Kubernetes, and Azure DevOps.

Software Developer at Mahantech

July 1, 2023 - July 1, 2025

Integrated cloud services for hosting and supporting the multiclient Rx Data Exchange project; built and optimized AWS Redshift data warehouse with star schema, including distribution keys, sort keys, and compression encoding to improve query performance; developed enterprise ETL pipelines using SSIS, AWS Glue, and Azure Data Factory to process high-volume daily prescription records with CDC and incremental loads for near real-time data synchronization; built and supported real-time/streaming data pipelines and integrated Hive tables with distributed processing frameworks; created reusable SSIS components with automated validation, error handling, and reconciliation mechanisms to ensure data integrity across sources.

Data Analyst at Accenture

August 1, 2020 - December 1, 2021

Worked with Informatica PowerCenter on core components to design and manage enterprise ETL solutions; designed scalable data warehouse architectures using Star and Snowflake schemas; implemented Slowly Changing Dimensions (SCD Type 1/2/3) for accurate historical tracking; built end-to-end ETL mappings and workflows; performed data transformations, validations, and aggregations to ensure high data quality for downstream analytics; developed complex SQL queries across Oracle, SQL Server, and DB2; collaborated with DBAs and data architects; prepared ETL documentation.