Vinod Kumar Prasad
Bangalore
Summary
Accomplished Lead AWS Data Architect & Engineer with 16 years of IT experience, specializing in enterprise data architecture, legacy-to-cloud modernization, and serverless data platforms. AWS & Informatica Subject Matter Expert with deep expertise in legacy ETL platforms (Informatica PowerCenter, IICS, BDM, CDQ, IDMC, MDM) and leading complex end-to-end cloud migrations to AWS Glue, PySpark, Amazon S3, and MWAA (Apache Airflow), including 50+ enterprise applications. Proficient in Glue Data Catalog, VPC Glue Connections, AWS Secrets Manager, Amazon CloudWatch, and multi-database integrations (PostgreSQL, Oracle, MS SQL Server, DB2, Redshift). Proven track record in ETL design, PySpark performance tuning, distributed processing, and workflow orchestration.
Overview
1
1
Certification
16
16
years of professional experience
Work History
Technical Architect / Lead AWS Data Architect
TCS
Bengaluru
07.2022 - Current
- Spearheaded enterprise-wide ETL modernization strategy, migrating legacy Informatica BDM workloads to serverless AWS ecosystem utilizing Glue, S3, and MWAA.
- Directed architectural design, PySpark code conversion, testing, and production cutover for 50+ applications onto AWS Glue jobs and MWAA DAG workflows.
- Optimized PySpark scripts on AWS Glue by tuning DPUs, dynamic frames, memory usage, and implementing predicate pushdowns across high-volume datasets.
- Integrated AWS Secrets Manager within AWS Glue jobs and MWAA DAGs to eliminate hardcoded credentials and manage secure database connections.
- Configured VPC Glue connections using JDBC/VPC with subnets, security groups, and ENIs for reliable cross-VPC and hybrid-cloud communication.
- Architected scalable Amazon S3 data lakes with efficient partitioning strategies, lifecycle policies, and Parquet/Snappy compression formats to enhance query efficiency and reduce storage costs.
- Engineered modular Python DAGs in MWAA for complete workflow automation, failure recovery, cross-job dependencies, and notification hooks.
- Configured Amazon CloudWatch dashboards, metric filters, log groups, and SNS alarms for proactive alerts and real-time visibility across Glue and Airflow tasks.
Technical Architect
Hexaware
Bangalore
01.2022 - 07.2022
- Architected end-to-end data integration solutions with AWS Glue, AWS Redshift, Informatica IICS, and S3, enabling seamless data flow across systems.
- Engineered complex PL/SQL procedures and UNIX Shell Scripts for database transformations and task automation, streamlining data processing workflows.
- Collaborated with cross-functional teams to define technical requirements and specifications.
Technical Architect
Wipro
Bangalore
03.2021 - 01.2022
- Designed cloud data architecture using Informatica IICS, CDQ, MS Azure (ADLS Gen2, Synapse), Oracle, MS SQL Server, and Teradata to support scalable data solutions.
- Implemented Pushdown Optimization (PDO) and Elastic Mapping while integrating REST/SOAP APIs to enhance data processing efficiency.
- Managed full-stack IICS administration, configuring runtime environments and deploying Secure Agents to ensure robust data workflows.
Lead ETL Developer
Deloitte
Bangalore
03.2018 - 11.2020
- Directed technical design and delivery of ETL modules using Informatica PowerCenter (9.5/10.2), IDQ, DAC, OBIEE, and Oracle to align with project goals.
- Executed performance tuning for databases and ETL, reducing batch processing times for multi-terabyte systems.
- Developed ETL processes to efficiently extract data from diverse sources.
- Designed and implemented data integration solutions tailored for client projects.
Lead ETL Developer
Accenture
Bangalore
01.2014 - 03.2018
- Led Agile ETL development teams, delivering robust data integration solutions using Informatica PowerCenter, IDQ, Informatica MDM, DBMoto, Oracle, and Salesforce.
- Authored Technical Design Documents (TDD) and coordinated production release deployments, ensuring alignment with client user stories.
- Developed and maintained ETL processes for data integration projects.
- Collaborated with stakeholders to gather data requirements and specifications.
Senior Software Engineer
GATE Global Solution Ltd.
Chennai
06.2010 - 01.2014
- Created data integration and reporting workflows with Informatica 9.1, Oracle, Salesforce (Veeva), Cognos, and Autosys to streamline data processing and reporting.
Education
Bachelor of Engineering (B.E.) -
Sathyabama University
Chennai04-2010
Skills
- AWS Cloud Services: AWS Glue (ETL, Studio, Data Catalog, VPC Connections), Amazon S3, MWAA (Apache Airflow), Amazon CloudWatch, AWS Redshift, AWS Secrets Manager, IAM
- ETL & Informatica Suite: Informatica BDM, Informatica IICS (CDI, CAI, CDQ), Informatica PowerCenter, IDMC, Informatica MDM, IDQ, Pushdown Optimization (PDO), Elastic Mapping
- Big Data & Scripting: PySpark, Apache Spark, Python, PL/SQL, UNIX Shell Scripting, YAML
- Databases & Integration: PostgreSQL, Oracle, MS SQL Server, IBM DB2, Teradata, Hive Metastore, REST/SOAP APIs
- DevOps & Architecture: Git, Jenkins, Data Modeling, Enterprise Data Warehousing
Certification
- AWS Certified: Cloud Practitioner
- Microsoft Certified: Azure Data Fundamentals
Timeline
Technical Architect / Lead AWS Data Architect
TCS
07.2022 - Current
Technical Architect
Hexaware
01.2022 - 07.2022
Technical Architect
Wipro
03.2021 - 01.2022
Lead ETL Developer
Deloitte
03.2018 - 11.2020
Lead ETL Developer
Accenture
01.2014 - 03.2018
Senior Software Engineer
GATE Global Solution Ltd.
06.2010 - 01.2014
Bachelor of Engineering (B.E.) -
Sathyabama University