Santosh Baireddy

ETL Developer

Cognizant

12.2021 - 09.2024

Informatica Power Centre uses an analysis tool to find workflow errors and solve errors within SLA time
Extraction of data from various sources such as databases, flat files- etc
Transforming the extracted data to meet business requirements, including cleansing, formatting, and aggregating
Developing and maintaining ETL processes and workflows using tools like Informatica
Service now tool using ticket creation, ticket closing, jobs holds & resume jobs as project working timings
Monitor ETL jobs and troubleshoot issues to ensure data accuracy and integrity
AWS Integration: Utilized AWS S3 and EC2 to store, manage, and process large datasets, improving the scalability and reliability of ETL processes
Extensive experience on Teradata database analyses business needs, developing effective and efficient solutions, and ensuring client's deliverables within committed timelines
Strong experience creating database objects like tables, views, stored procedures, and indexes in Teradata
Represented as a support specialist in project activities, efficiently addressing bug fixes, and resolving issues based on incident reports
Loading monthly, weekly, and daily loading updates to the business team and interacting with onsite people
Job Scheduling: Monitored and scheduled ETL jobs using Stone Branch and Where cape Red, ensuring timely execution and minimizing job failures
Developed and optimized SQL queries to support data transformation and loading processes, reducing query execution time by20%
Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
Resolved production issues quickly and efficiently, minimizing downtime and maintaining high levels of user satisfaction.
Developed custom reports for business stakeholders, providing valuable insights into key performance metrics.
Managed identification, protection and use of data assets.