Harsha Koppurapu

About Harsha Koppurapu

Ten plus years of working experience in all the phases of data warehousing involving design, development, testing and maintenance.• Strong experience in data integration using ETL tool Informatica Power Center 10.x/9.x/8.x (Repository Manager, Designer, Workflow Manager and Workflow Monitor). • Experience in building dashboards in Tableau using calculated fields, hierarchies, interactive action filters, bins and parameters.• Designed complex ETL mappings to load facts, bridges and slowly changing dimensions. • Experience in building data marts with dimensional data modeling methodologies Star and Snowflake schema.• Experience in building operational data store (ODS) near real time integrating with MDM to give 360-degree view of the customer. • Experience in profiling and cleansing using IDE and data cleansing functions in power center.• Implemented incremental load strategy for batch loads and dynamic cache lookup for change data captures.• Expertise in performance tuning on sources, targets, mappings and sessions. Used hints, indexes, temp tables, partitions, bulk load option, merge statements as part of tuning techniques.• Hands on experience in writing and tuning SQL queries. Exposure to PL/SQL concepts such as stored procedures, functions, cursors and oracle analytical functions.• Used SVN and GitHub tools for code check-in and version controlling.• Experience in writing shell and python scripts for file validations and data loads.• Experience in creating, managing and scheduling ETL workflows through Autosys tool. • Exposure to architecture of Amazon redshift. Performed data loads using amazon S3 into redshift and tested the performance using various distribution styles as part of (PoC).• Worked in production support projects involving code migration, deploying database objects, batch load monitoring, defect fixes and enhancements.

Experience

1. Sr Staff Software Engineer

   CSAA Insurance Group

   Aug 2022 — Present · Glendale, AZ, US

Education

• San José State University

  Master's degree, Computer Engineering

  2008 — 2010

• Jawaharlal Nehru Technological University

  Bachelor of Technology (BTech), Electronics and Communication Engineering

  2004 — 2008

Skills

• Data Warehousing
• Informatica
• Sql
• Pl/Sql
• Microsoft Sql Server
• Business Intelligence
• Oracle
• Shell Scripting
• Unix
• Requirements Analysis
• Etl
• Data Migration
• Data Modeling
• Obiee
• Tortoise Svn
• Ide
• Hadoop
• Mapreduce
• Hive
• Apache Pig
• Agile & Waterfall Methodologies
• Scrum