Summary
Overview
Work History
Education
Skills
Academicscertifications
Profile
Timeline
Generic
Prudhvi Baratam

Prudhvi Baratam

ETL Developer
Parvathipuram

Summary

With over 3 years of ETL development experience within a Data Warehouse and a strong background in Informatica and SQL, I am eager to contribute to development projects that enable data to serve as a strategic asset. I have played a key role in large-scale data migration and have led efforts to optimize data handling, ultimately achieving significant improvements in data processing efficiency.

Overview

3
3
years of professional experience

Work History

Systems Engineer

Tata Consultancy Services
Hyderabad
05.2023 - 06.2024
  • SFDC Account Sourcing using incremental model, SQL explosion using informatica, Analyze and create ETL jobs in Informatica power center, IICS and write Database scripts.

Systems Engineer

Infosys Limited
Hyderabad
07.2021 - 04.2023
  • Data migration of an LMS (Learning Management System).

Systems Engineer Trainee

Infosys Ltd
Hyderabad
02.2021 - 07.2021
  • Trained in business intelligence platforms, including tools like MS SQL Server, SSIS, SSAS, and MongoDB.

Education

Bachelor Of Technology - Information Technology

Gayatri Vidya Parshid College Of Engineering
Vishakapatnam
07.2021

Skills

Informatica PowerCenter

Academicscertifications

  • Infosys Internship Certificate [June , 2021]

Profile

● Analyzed the source system and involved in designing the ETL data load.

● Developed/designed Informatica mappings by translating the business requirements.

● Responsible for building Mappings, Workflows & Sessions using Informatica Power Center and IICS.

● Experience in Tools like Informatica, TOAD

● Responsible for Client communication and regular updates to clients

● Worked on large projects using Agile methodologies.

● Understanding of Business and IT processes with excellent communication skills.

● Good understanding of MYSQL, Database Integration and Database Management.

● Good knowledge on SQL Queries.

● Having strong hands on experience in extraction of the data from various source systems ranging from Mainframes like DB2, Flat Files, VSAM files, etc. to RDBMS like Oracle, SQL Server, Teradata etc.

● Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.

● Performed data cleaning and transformation during ETL processes to ensure data accuracy and integrity.

● Resourceful, goal oriented, possess strong Business Intelligence skills with the ability to work under pressure and multitask in a fast-paced environment.

● Possess strong Analytical Skills.

● Good knowledge of Unix.

● Led a team of 4 members and trained 3 team members in Informatica.

Timeline

Systems Engineer

Tata Consultancy Services
05.2023 - 06.2024

Systems Engineer

Infosys Limited
07.2021 - 04.2023

Systems Engineer Trainee

Infosys Ltd
02.2021 - 07.2021

Bachelor Of Technology - Information Technology

Gayatri Vidya Parshid College Of Engineering
Prudhvi BaratamETL Developer