Aditya Upadhyay

Cloud & Data Engineer with 3+ years of experience building and modernizing ETL pipelines and cloud data platforms for a Fortune 500 financial services client (Prudential Financial Inc., USA) at Tata Consultancy Services. Hands-on experience migrating legacy on-premises data warehouses to AWS (S3, Redshift, Glue, Lambda, Step Functions) and building scalable Informatica IICS pipelines across Oracle, DB2, and flat-file sources. Currently pursuing an M.Tech in Cloud Computing at BITS Pilani, applying LLM and RAG architectures (LangChain, HuggingFace, FAISS) in independent AI engineering projects.

System Engineer – Cloud Data Migration & Modernization - Tata Consultancy Services Ltd. - Hinjewadi, Pune

(2024-05)

Leading migration of legacy on-premises ETL workflows and data warehousing infrastructure to AWS for a Fortune 500 financial services client, modernizing pipelines that support regulatory and analytics reporting.

• Architected core AWS infrastructure (VPC, IAM roles/policies, Security Groups), establishing a secure, compliant foundation for the cloud data platform.
• Migrated structured and unstructured data at petabyte scale into a centralized Amazon S3 data lake, configuring lifecycle policies and cross-region replication for high availability.
• Orchestrated migration of the enterprise data warehouse to Amazon Redshift, tuning cluster configuration and Workload Management (WLM) to improve query performance.
• Re-engineered legacy ETL jobs into serverless AWS Glue (Spark-based) pipelines, reducing dependence on on-premises infrastructure and operational overhead.
• Automated end-to-end pipeline orchestration with AWS Step Functions and Lambda for event-driven processing and failure handling.
• Implemented real-time monitoring and encryption (CloudWatch, KMS) to strengthen observability and data governance.
• Executed zero-downtime migrations of operational databases (Oracle/DB2 to Amazon RDS) using AWS DMS.

Assistant System Engineer – Data Integration & BI Platform - Tata Consultancy Services Ltd. - Hinjewadi, Pune

(2022-07 - 2024-04)

Built and supported scalable ETL workflows on Informatica IICS for a data integration and BI platform serving Prudential Financial (USA).

• Extracted and integrated data from Oracle, DB2, and flat-file sources, applying complex mapping logic to load enterprise data warehouse and data lake targets.
• Integrated REST and SOAP APIs to enable real-time data ingestion and synchronization for business-critical reporting.
• Designed parameterized mappings, taskflows, and reusable components that improved ETL job performance and reduced maintenance overhead.
• Wrote and tuned complex SQL queries and stored procedures for data validation, reconciliation, and integrity troubleshooting across production environments.
• Partnered with cross-functional teams on data quality and error-handling standards; monitored and tuned job performance using IICS Operational Insights.

M.Tech - Cloud Computing - BITS Pilani

B.E. - Computer Science & Engineering - ITM SLS Baroda University (2022)

Diploma - Computer Science & Engineering - Shri K.J. Polytechnic (2019)