Purna Chandra Rao Dondapati

Objective

Seeking a challenging position in the SnowFlake Developer| Informatica datawarehousing (ETL) domain with a reputed IT company that offers excellent growth opportunities.

Professional
Summary

• Total 6+ years hands on experience with database development using Oracle PL/SQL, application production support & enhancements and also experience in designing and implementing production grade data warehousing solutions on large scale data technologies
• Define virtual warehouse sizing for Snowflake for different type of workloads.
• Experience in building Tasks, Streams, Materialized Views and Snowpipe.
• Develop transformation logic using snowpipeline.
• Experience in using Snowflake Clone and Time Travel.
• Main areas of expertise are analyzing, developing and testing the data warehousing projects.
• Experience in Development of mappings using needed Transformations using Informatica tool.
• Experience in the Data Warehousing using Data Extraction, Data Transformation and Data Loading.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Performing the data validation and loads by writing the complex SQLs
• Preparing the Documentation for the mappings according to the Business Requirements.
• Strong knowledge in  Multi Dimensional Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables), and handling SCD’s.
• Optimizing Informatica Mappings and Sessions to improve the performance.
• Extensively worked on Session partitioning techniques using different Informatica Partitioning techniques to optimize the load times.
• Proven Experience in Complete life cycle of Design, Development, Documentation and Maintenance of the Data marts and Data warehouse.

 

Professional

Experience

 

• “Working as Informatica Developer ( Nov 2016- Dec 2022)

 

Education

M Pharmacy (Ph. Analysis), 2012 from , M.G.R University,Chennai.

 

Technical
Skills

ETL Tools:

Informatica 9.X,

Informatica Power Center 9.1,10.1.

Data Bases

Oracle 10g/11g, MySQL,

Languages:

SQL, PL/SQL

Operating System:

UNIX and Windows

Cloud data ware houses

Snowflake data warehouse

Cloud and SaaS Platforms

Amazon Web services (AWS).

Others

TOAD for Oracle.

 

Project
Experience

Project Name

JSFB FINANCE

Client

JANA SMALL FINANCE BANK, BANGALORE

Role

Snowflake  Developer

Duration

Jan' 2020 to Till now

Environment

Snowflake, Oracle, SQL.

Description

 

 JANA SMALL FINANCE BANK  is one of the leading Small Finance Banks of India in terms of assets under management and deposit size as at March 31, 2020. Jana Small Finance Bank has the second most geographically diversified portfolio with a pan-India presence among all Small Finance Banks in India as at March 31, 2020 (Source: IRR Report). As at February 28, 2021, Jana Small Finance Bank had 611 Branches, including 166 Branches in Unbanked Rural Centres, and 134 ATMs located in 229 districts in 19 states and three union territories. Jana Small Finance Bank has served over 8.00 million customers since 2008, including approximately 3.05 million active customers.

 

Roles& Responsibilities

 

• Worked on SnowSQL and Snowpipe
• Converted Talend Joblets to support the snowflake functionality.
• Creating Transformer Pipelines and Data Collector Pipelines
• Test, Validate and Deploy the Pipelines
• Created Snowpipe for continuous data load.
• Used COPY to bulk load the data.
• Created data sharing between two snowflake accounts.
• Created internal and external stage and transformed data during load.
• Redesigned the Views in snowflake to