Prashanth Dontha

OSI Digital

Hyderabad

11.2021 - Current

Implemented proactive monitoring for ETL processes, identifying bottlenecks before user impact.
Optimized complex SQL queries and streamlined data extraction to enhance ETL processes.
Resolved production issues quickly, minimizing downtime and sustaining user satisfaction.
Automated scripts using SQL programming to improve operational efficiency.
Conducted end-to-end testing of state machines in AWS and Informatica cloud jobs, drafting design documents.
Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
Implemented best practices while developing ETL packages like error handling, logging.
Managed end-to-end operations of ETL data pipelines, maintaining uptime.
Developed and maintained data pipelines to ingest, store, process and analyze large datasets in AWS S3 buckets.
Integrated third party APIs with existing systems using SQS queues and SNS topics.
Optimized query performance by creating indexes and materialized views in Amazon Redshift clusters.
Implemented automated monitoring of data flows using Cloudwatch and Lambda functions.
Utilized Python to handle debugging and automation scripting tasks.Search by job title