SANGAYYA HIREMATH

Master's

Data Analytics

Tata Consultancy Services

Data Engineer

1) Account Name - Johnson & Johnson | Data Engineer | AWS, PostgreSQL | Sep 2021 - Oct 2023 • Led ETL development using AIIF ETL Tool, PostgreSQL, and AWS Redshift, automating data validation, ingestion, and integration workflows. • Designed and implemented data models(Star Schema) with SCD Type 2 handling, ensuring accuracy, consistency, and analytics readiness. • Built scalable ETL pipelines leveraging AWS S3, Athena, and Redshift, optimizing storage, processing, and query performance. • Developed and optimized materialized views, improving Redshift performance with distribution and sort keys to support analytics and visualization. • Managed CI/CD pipelines using Jenkins, Control-M, Bitbucket, and SLT, ensuring reliable deployments, version control, and smooth operations. 2) Account Name - Standard Chartered Bank | Data Migration Engineer | Jan 2024 - July 2024 • Led database migration from IBM DB2 to PostgreSQL, transferring critical objects including tables, views, functions, procedures, and triggers. • Ensured data consistency, integrity, and performance in the target environment through validation, optimization, and post-migration testing. • Collaborated with DBA(Database Administration) and cross-functional teams to troubleshoot migration issues and support performance tuning using advanced SQL.