Prashanth Dontha
Associate Softwre Engineer
Hyderabad,Telangana
Summary
Over 1.5 years of experience in Aws, Informatica PowerCenter, Informatica Cloud. Certified Microsoft Azure Data Fundamentals DP-900. Closely worked with clients over daily working sessions to investigate and finalize the requirements. Involved in multiple full life cycle implementations using Informatica Cloud and Aws. Configured S3 Bucket’s, Step functions, SNS in AWS. Experience in building Step function’s using stored procedure’s and Data integration using Informatica Cloud. Developed and generated .csv, .txt files using Informatica cloud and transferred data using Aws Redshift and S3 Bucket’s using AWS. Participated in go-live, migration, and post-production deployment support. Experience in Debugging and troubleshooting issues. Experiences in drafting Technical Specification Document, Unit Testing for all the process which i have developed. Worked on Error Messaging, and monitoring & maintained integration processes & managed processes using Process Reporting and Process Log. Outstanding analytical and problem-solving skills communicating effectively to accomplish all project deliverable in a fast-paced environment.
Overview
2
2
years of professional experience
1
1
Certification
Work History
ETL Developer, AWS Developer
OSI Digital
11.2021 - Current
- Based in Irvine, CA, Hyundai Capital America is a top 10 U.S
- Auto finco and supports Hyundai and Kia vehicle sales in the U.S through a full spectrum of financing solutions for vehicle customers and dealers
- HCA’s Enterprise Data Warehouse (EDW) allows users to retrieve data from both on-premises system (Realtime Data Warehouse –RDW) as well as Amazon Web Services (Amazon Data Warehouse –ADW)
- Involved in requirements gathering & analysis for the development
- Followed JSON approach in Designing and developing State Machine’s in AWS to accommodate current and future requirements
- Configured E-mail alerts for State machine’s using SNS topics
- Compiled Stored Procedure’s using Aws Redshift
- Have done End to End Testing of the developed State machines and Informatcia cloud jobs and drafted design Documents
- Drafted Mapping Documents
- Go-live, and post-production deployment support.
- Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users.
- Resolved production issues quickly and efficiently, minimizing downtime and maintaining high levels of user satisfaction.
- Documented technical specifications and designs, facilitating knowledge sharing among team members and supporting future development efforts.
Education
Bachelor of Technology - Electronics And Communications Engineering
Geethanjali College of Engineering And Technology
Hyderabad, India 05.2001 -
Diploma - Electronics And Communications Engineering
VNR VJIET
Hyderabad, India 05.2001 -
SSC -
St. Nissi High School
Hyderabad, India 05.2001 -
Skills
Certification
Microsoft Certifies: Azure Data Fundamentals DP-900
Timeline
Microsoft Certifies: Azure Data Fundamentals DP-900
03-2022
ETL Developer, AWS Developer
OSI Digital
11.2021 - Current
Bachelor of Technology - Electronics And Communications Engineering
Geethanjali College of Engineering And Technology
05.2001 -
Diploma - Electronics And Communications Engineering
VNR VJIET
05.2001 -
SSC -
St. Nissi High School
05.2001 -
Similar Profiles
Raghavendra ImmadisettyRaghavendra Immadisetty
DevOps Engineer at OSI DigitalDevOps Engineer at OSI Digital
SATYA KISHORE JEEDIGUNTASATYA KISHORE JEEDIGUNTA
Senior Technical Lead at OSI DigitalSenior Technical Lead at OSI Digital
Lakshmi Neelima GollapalliLakshmi Neelima Gollapalli
Software Engineer at OSI DigitalSoftware Engineer at OSI Digital
RAVINDRA SANNAPAREDDYRAVINDRA SANNAPAREDDY
Senior Salesforce Developer at OSI DigitalSenior Salesforce Developer at OSI Digital
Katamneni SrinivasaraoKatamneni Srinivasarao
Head Operations Manager at SUBWAY®RestaurantsHead Operations Manager at SUBWAY®Restaurants