Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

ShahiPriya Kadapa

Summary

  • Over 7 years of experience in data warehousing, specializing in end-to-end ETL processes using Informatica PowerCenter (v10.2, 9.6.1), and Informatica Intelligent Cloud Services (IICS).
  • Data Integration: Designed, developed, and optimized complex mappings, mapplets, tasks, and workflows to integrate data from diverse sources into staging areas. Excellent experience in ETL using Informatica PowerCenter 10.2, 9.6.1, and 9.1.1.
  • Performance Optimization: Proven ability to debug and fine-tune ETL processes, including mappings, sessions, and workflows. Achieved significant performance improvements by implementing push-down optimization and other tuning techniques, reducing execution time for large-scale data migrations.
  • Data Modeling & Warehousing: Proficient in data modeling concepts such as Star Schema and Snowflake Schema. Extensive experience with Slowly Changing Dimensions (SCD) and Change Data Capture (CDC) methodologies.
  • Database Management: Hands-on experience with a variety of databases, including Oracle, SQL Server, Teradata, MySQL, and Snowflake. Expert in writing and optimizing complex SQL queries.
  • Project & SDLC: Managed all phases of the Software Development Life Cycle (SDLC), from requirements analysis to implementation, and testing. Experienced in both Agile (JIRA) and Waterfall methodologies.
  • Testing and Documentation: Performed unit, system, and integration testing. Supported User Acceptance Testing (UAT) and prepared essential project documentation, including data mapping, ETL specifications, and test reports.
  • Cross-Functional Collaboration: Effectively collaborated with onshore, offshore, and cross-functional teams to ensure timely project delivery, and meet key commitments.
  • Domain knowledge: Specialized experience in developing and implementing data warehousing solutions for the banking, financial, and insurance sectors.

Overview

7
7
years of professional experience

Work History

ETL Developer

Anthem, Inc
Chicago
09.2023 - Current
  • Company Overview: Anthem provides health insurance services. The company offers a variety of insurance products for all segments of the population including large employer groups, small businesses, and individuals.
  • As a part of this project data is being collected from all servicing originations Application systems, databases like oracle, flat files, mainframe files.
  • Data is migrated from all various sources into ingested to Teradata staging table, and then pushed to the target system.
  • Data is cleansed, and transformed based on the business rules thru ETL tools Informatica.
  • Co-ordination from various business users’ stakeholders and SME to get Functional expertise, design, and business test scenarios review, UAT participation and validation of data from multiple sources.
  • Prepared/updated source-to-target mapping and updated logic to help ETL development work.
  • Worked on ETL Mappings and workflows in IICS using REST APIs for internal/external system integration.
  • Worked on data pipelines for transformation, aggregation, filtering, and validation using advanced features like error handling and data quality checks.
  • Worked on ETL workflows & data flow between Snowflake tables through Cloud services.
  • Developed mappings using REST V2 connectors to consume JSON/XML responses, enabling dynamic API calls with parameterization and efficient error handling in non-prod environment.
  • Developed mappings /configured REST V2 connections in Informatica IICS to integrate with external RESTful APIs for real-time data exchange and third-party system communication.
  • Worked on data pipelines using IICS features like transformation, filtering, aggregation, and implemented scheduling and workflow monitoring.
  • Developed near real-time and batch integration solutions using custom REST APIs for data ingestion, streaming, and synchronization in non-prod env.
  • Populated tables in data mart (mostly dimensional tables) and supporting API-based data access.
  • Applied data validation, error handling, and data quality rules to clean, and accurate data across DB/systems.
  • Worked with DBAs, Unix teams, and end users to support prod deployment.
  • Migrated ETL code to GitHub using CI/CD pipelines and coordinated with other teams to ensure ETL code migrations when ETL code tis going to prod release.
  • Participated in Agile ceremonies such as daily standups, sprint planning, grooming, and retrospectives.
  • Involved in team discussions, knowledge sharing sessions, and worked on ETL performance tuning and overall data quality improvement.
  • Anthem provides health insurance services. The company offers a variety of insurance products for all segments of the population including large employer groups, small businesses, and individuals.
  • Env: Informatica PowerCenter 10.5, IICS/IDMC, Oracle 18c, Snowflake, MySQL, SQL, Putty, Autosys, JSON, XML

ETL Developer

Blue Cross and Blue Shield of North Carolina
Durham
06.2021 - 08.2023
  • Company Overview: BCBSNC provides managed care services targeted to government-sponsored health care programs, focusing on Medicaid and Medicare.
  • The project is aimed at developing multiple dashboards for internal user and stakeholder for Government segment business; as a part of integration data mart for Medicare and Medicaid data sources like Facets, EZCAP, LEON and QNXT for short-term and long-term decision-making, strategic plans, support, and solutions giving stakeholders ability to access, analyze and help stakeholder to automate extract process for down-line applications.
  • Utilized Informatica IICS to design, develop, and deploy end-to-end data integration workflows between cloud, APIs, and on-premises systems.
  • Actively involved in interacting with business users to record user requirements and Business Analysis.
  • Documented Data Mappings/ Transformations as per the business requirement.
  • Prepared Technical Design documents and Test cases.
  • Creating and maintaining source-target mapping documents for ETL development team.
  • Created mappings /Workflow extracted data from various sources, transformed data according to requirement.
  • Developed Informatica Mappings & Reusable Transformations to facilitate timely Loading of Data of a star schema.
  • Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
  • Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse tables.
  • Developed several reusable transformations and mapplets that were used in other mappings.
  • Developed transformation logic as per requirement, created mappings and loaded data into respective targets.
  • Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
  • Migrated Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
  • Wrote hundreds of SQL query for data analysis to validate the input data against business rules.
  • Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
  • Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.
  • Used PMCMD command to start, stop and ping server from UNIX.
  • Improved performance testing in Mapping and the session level.
  • Coordinated with scheduling team to run Informatica jobs for loading historical data in production.
  • Maintaining bug, status using JIRA tool.
  • BCBSNC provides managed care services targeted to government-sponsored health care programs, focusing on Medicaid and Medicare.
  • Environment: Informatica PowerCenter 10.2, Tableau 2020.3, SQL, Oracle 12c, SQL Server 2017, Oracle SQL Developer, TOAD, Control M

ETL Developer

Lowe's
Mooresville
01.2020 - 06.2021
  • Company Overview: Lowe's, is an American retail company specializing in home improvement. Headquartered in Mooresville, North Carolina.
  • This Project collects sales data from various store and internal sources from its business into data mart for Sales and performance analytics.
  • Tableau helped users identify actionable item and get insight on sales performance.
  • Worked with business users to get the requirement and to involve in complete SDLC of this project.
  • Analyzed source data and gathered business requirements from the business users and source data team.
  • Created Technical Design Document from business requirements document (BRD).
  • Created Detail Technical Design documents which have ETL technical specifications for given functionality.
  • Prepared source to target mapping and understand data / transformation logic.
  • Analyzed the existing mapping logic to determine the reusability of the code.
  • Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
  • Done the extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions, or system.
  • This led to better session performance.
  • Created Unit test plans and did unit testing using different scenarios separately for every process and Involved in System test, Regression test and supported the UAT for the client.
  • Performing ETL and database code migrations across environments using deployment groups.
  • Populating the business rules using mappings into the target tables.
  • Involved in end-to-end system testing, performance and regression testing and data validations.
  • Used prewritten scripts to run informatica workflow.
  • Created batch scripts for automated database build deployment.
  • Managed performance and tuning of SQL queries and fixed the slow running queries in production.
  • Lowe's, is an American retail company specializing in home improvement. Headquartered in Mooresville, North Carolina.
  • Environment: Informatica PowerCenter 9.6.1, SQL Server 2017, ORACLE 12c, SQL, UNIX, SQL Developer, Control M, JIRA

ETL Developer

MetLife, Inc.
Longwood
09.2018 - 01.2020
  • Company Overview: MetLife, Inc. is the holding corporation for the Metropolitan Life Insurance Company, better known as MetLife.
  • The objective this data marts is to enable improved decision-making, strategic plans, support and solutions that favorably impact costs, quality of care, outcomes, and customer satisfaction through an information-driven environment that leverages their integrated data assets for competitive advantage.
  • Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation.
  • Used Debugger to test the data flow between source and target and to troubleshoot invalid mappings.
  • Created Mappings using Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, Filter, and Sorter.
  • Used SQL to analyze source data, performed data analysis and validate the data.
  • Scheduled Informatica Jobs through scheduling tool.
  • Studying the existing system and conducting reviews to provide a unified view of the program.
  • Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
  • Involved in creating Informatica mappings, Mapplets, worklets and workflows to populate the data from different sources to warehouse.
  • Responsible to facilitate load testing and benchmarking the developed code to set performance standards.
  • Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
  • MetLife, Inc. is the holding corporation for the Metropolitan Life Insurance Company, better known as MetLife.
  • Environment: Informatica Power Center 9.6, Oracle 11g, SQL, SQL Server 2014, Autosys, Cognos, JIRA

Education

Bachelors - computer Science

JNTU
India
01.2016

Skills

  • IICS
  • IDMC
  • Informatica PowerCenter 105
  • Informatica PowerCenter 9x
  • Star Schema
  • Snowflake schema
  • EDW
  • Data Mart
  • Oracle 18c
  • Oracle 12c
  • MS SQL Server 2017
  • MySQL
  • MS Office
  • Toad
  • TOAD
  • SQL
  • WinSCP
  • Putty

Timeline

ETL Developer

Anthem, Inc
09.2023 - Current

ETL Developer

Blue Cross and Blue Shield of North Carolina
06.2021 - 08.2023

ETL Developer

Lowe's
01.2020 - 06.2021

ETL Developer

MetLife, Inc.
09.2018 - 01.2020

Bachelors - computer Science

JNTU

Similar Profiles

CREATE PROFILE
ShahiPriya Kadapa