Prashanth Akundi
Senior Data Architect
Hyderabad
Summary
Seasoned Cloud Data Engineer & Architect with 8 years of experience in architecting, developing, and managing data solutions in AWS and GCP. Proficient in ETL, data warehousing, and automation using Python. Skilled in designing robust data architectures and leading successful data migration projects. Experienced in leading teams, mentoring, and collaborating with stakeholders to meet business objectives.
Overview
10
10
years of professional experience
15
15
years of post-secondary education
3
3
Certifications
Work History
Tech Lead / AWS Senior Data Engineer / Architect
Mresult Pvt Ltd ( Pharma Client)
01.2023 - Current
- Designed and implemented robust data architectures in AWS, ensuring high availability, scalability, and optimal performance
- Utilized AWS Glue for data ingestion, transformation, and orchestration, streamlining data workflows and improving data quality
- Managed complex ETL processes, integrating various data sources using AWS Glue and ensuring the delivery of clean, reliable data to downstream applications
- Leveraged AWS Database Migration Service (DMS) & HVR to seamlessly migrate on-premises databases to AWS, minimizing downtime and reducing migration complexities
- Oversaw the entire IICS ecosystem to ensure seamless data flow, high performance, and reliability
- Led a team of Data Engineers to cater to end-to-end data requirements for Intelligence teams
- Managed project timelines, resources, and deliverables to ensure on-time and within-budget project completion
- Collaborated with stakeholders to align data architecture and solutions with business objectives
- Ensured continuous integration and deployment practices for efficient project delivery.
Senior Data Engineer / Informatica Engineer
Incepta Solutions (Client :Hudsons Bay, Pernod Ricard)
02.2022 - 01.2023
- Designed and developed ETL pipelines using Databricks, extracting data from diverse sources, performing transformations, and loading it into target destinations
- Employed Databricks to transform and preprocess raw data into structured formats, ensuring data quality and integrity
- Managed the migration of MDS system into Profisee software
- Strategized, designed, developed, and migrated ETL DAGs from Airflow 1.0 to Airflow 2.0
- Worked extensively with Informatica to isolate the central Snowflake Data warehouse into several Data marts
- Coordinated with business stakeholders to translate requirements and develop OBI reports for business intelligence
- Led the migration campaign from Airflow 1.0 to Airflow 2.0, ensuring the seamless transition of approximately 500 DAGs
- Managed project scopes and timelines, ensuring alignment with business goals
- Conducted regular project reviews and communicated progress to stakeholders.
Senior Data Engineer / Informatica Engineer
Dataformix LLC, Superlogix, TechMahindra ( Client: XPO Logistics )
04.2018 - 02.2022
- Spearheaded the migration of Netezza DB (2000+ tables) to Google BigQuery Cloud
- Led the integration of 40+ source systems to Google BigQuery for direct-data ingestion
- Developed Python automation for ETL processes, including generation, enhancements, and maintenance
- Performed Informatica maintenance admin activities, ensuring repository standards and automating best practices
- Led a team of data engineers in the migration project, ensuring minimal downtime and successful data integration
- Developed strategies for Python automation to enhance ETL processes and maintained repository standards
- Managed project milestones, deliverables, and resource allocation
- Ensured compliance with project requirements and timelines.
ETL Developer
BlueCross BlueShield, Superlogix INC
07.2017 - 12.2017
- Designed ETL processes for data extraction, transformation, and loading into Data Warehouses
- Developed complex mappings and transformations using Informatica Power Centre
- Implemented performance tuning at the mapping and session levels for optimal performance
- Collaborated with Business Analysts for requirements gathering, analysis, and ETL design
- Managed project delivery to meet business requirements and ensure timely completion
- Conducted regular status meetings with stakeholders to provide updates on project progress.
Data and Risk Assessment Engineer
Amazon, Hyderabad-India
11.2014 - 05.2015
- Utilized Informatica Power Centre for ETL processes, extracting and transforming data from relational and non-relational sources
- Developed Informatica mappings, reusable transformations, and Mapplets for data load to data warehouse
- Handled slowly changing dimensions of Type 2 to populate current and historical data
- Managed data and risk assessment projects to ensure accurate and timely delivery
- Coordinated with cross-functional teams to meet project objectives and deadlines
- Provided regular project updates to senior management and stakeholders.
Education
M.S. in Computer Science and Engineering -
Texas A&M University
Texas , USA 08.2014 - 12.2024
Bachelors Of Computer Science And Engineering -
VBIT
Hyderabad-India 04.2010 - 11.2014
Skills
ETL Tools: Informatica Power Centre (9x/10x), Power Exchange, HVR, IICS
Cloud Platforms: AWS (Glue, Redshift, S3, DMS), GCP (BigQuery, Dataflow)
Databases: Oracle, DB2, Netezza, Exadata, Snowflake
Programming: Python (Advanced), Java (Intermediate)
Data Modeling: ER modeling, Dimensional modeling (Star/Snowflake schemas)
Automation: Apache Airflow, Python frameworks for ETL and data extraction
Soft Skills: Team leadership, mentorship, excellent communication
Delivery Management
Certification
Modernizing Data Lakes and Data Warehouses with GCP
Timeline
Tech Lead / AWS Senior Data Engineer / Architect
Mresult Pvt Ltd ( Pharma Client)
01.2023 - Current
Senior Data Engineer / Informatica Engineer
Incepta Solutions (Client :Hudsons Bay, Pernod Ricard)
02.2022 - 01.2023
Senior Data Engineer / Informatica Engineer
Dataformix LLC, Superlogix, TechMahindra ( Client: XPO Logistics )
04.2018 - 02.2022
ETL Developer
BlueCross BlueShield, Superlogix INC
07.2017 - 12.2017
Data and Risk Assessment Engineer
Amazon, Hyderabad-India
11.2014 - 05.2015
M.S. in Computer Science and Engineering -
Texas A&M University
08.2014 - 12.2024
Bachelors Of Computer Science And Engineering -
VBIT
04.2010 - 11.2014
Similar Profiles
Neville VazNeville Vaz
Trainee Technical Data Analyst at MResult Services Pvt LtdTrainee Technical Data Analyst at MResult Services Pvt Ltd
Vasudev NeeliVasudev Neeli
Sr Software Engineer at Votary Softech Solutions Pvt Ltd - Client: OPLUS R&D India Pvt LtdSr Software Engineer at Votary Softech Solutions Pvt Ltd - Client: OPLUS R&D India Pvt Ltd
Ganesh GoudaGanesh Gouda
Associate ETL Developer at MResultAssociate ETL Developer at MResult
Saikrishna B V GadwalaSaikrishna B V Gadwala
Senior Software Engineer at ATMECS Technologies PVT LTDSenior Software Engineer at ATMECS Technologies PVT LTD
Harikrishna MungaraHarikrishna Mungara
IT Consultant at MSRCOSMOS IT LLPIT Consultant at MSRCOSMOS IT LLP