Prathyusha Kapisetty

About Prathyusha Kapisetty

I am an ETL Informatica Developer with over 5 years of experience working on end-to-end data integration, data migration, and data warehousing projects. I focus on building stable and efficient ETL pipelines using Informatica PowerCenter, IICS, Oracle, SQL, and UNIX to support day-to-day business operations and analytical needs.My experience includes developing mappings, designing workflows, handling large data loads, and working with multiple source systems across Healthcare, Banking, and Insurance domains. I have worked on both new development and production support, ensuring that data loads run smoothly and issues are resolved quickly. I am also familiar with dimensional modeling, SCD Type 1 & Type 2 logic, and data quality checks.In healthcare projects, I have handled claims, eligibility, provider, and clinical datasets, ensuring accuracy and compliance with HIPAA standards. I work closely with analysts, data modelers, QA teams, and business users to understand requirements and deliver reliable solutions.I enjoy improving ETL processes, optimizing performance, and contributing to projects that bring clarity, accuracy, and value to the organization’s data. I aim to continue growing in the data engineering and ETL space while delivering high-quality work in every project.

Experience

1. Etl Developer

   AT&T

   Oct 2023 — Present · Atlanta, GA, US

   Gathered business requirements and translated high-level design into detailed ETL specifications.Designed source-to-target mappings, dimensional models (Star Schema), and ETL architecture for data warehouse builds.Developed Informatica mappings using Filter, Expression, Sequence Generator, Joiner, Update Strategy, Stored Procedure, and other transformations.Created mapping parameters/variables, reusable mapplets, and dynamic workflows for scalable ETL processing.Loaded staging, dimension, and fact tables; implemented SCD Type 1 and Type 2 logic.Built and scheduled workflows using sessions, events, decisions, worklets, timers, and email notifications.Used SQL*Loader for high-volume data loading from flat files into Oracle databases.Performed performance tuning across sources, mappings, workflows, and sessions.Wrote UNIX shell scripts for file automation, repository backup, and PMCMD workflow triggers.Supported production loads, migration across environments, and troubleshooting data inconsistencies.

Education

• DRK College of Engineering & Technology

  Btech, Ece

• Robert Morris University

  Masters, Management Information Systems